Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Error in SQL Syntax #1

Open
AresSec opened this issue Mar 8, 2023 · 0 comments
Open

Error in SQL Syntax #1

AresSec opened this issue Mar 8, 2023 · 0 comments

Comments

@AresSec
Copy link

AresSec commented Mar 8, 2023

Hey,
I've executed the plain script with the following command to receive the newest version:
./secrat_asvs_importer.sh

When trying to import it into my db I get the following syntax error:
mysql -u root -p'*****.' test < secrat_asvs_final_4.0.3_en.sql ERROR 1064 (42000) at line 518: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Architecture, - Design","Design",4,_binary '', 1); -- Link ASVS Chapter INSERT ' at line 1

By investigating the corresponding sql line I saw that one quote was missing: after the String V1:
INSERT INTO COLLECTIONINSTANCE VALUES (4,"V1,"Architecture, - Design","Design",4,_binary '^A', 1);

So I fixed that and tried to import it again. Fixed sql string:
INSERT INTO COLLECTIONINSTANCE VALUES (4,"V1","Architecture, - Design","Design",4,_binary '^A', 1);

New try to import it:
mysql -u root -p'*****.' test < secrat_asvs_final_4.0.3_en.sql ERROR 1136 (21S01) at line 518: Column count doesn't match value count at row 1

Any idea?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant