Error when running the "valueset_and_log.sql" script.

[jxfish2]

Per your instructions, after getting the basic database installed, we need to run the provided SQL scripts against the new database.

The first SQL script ran without errors.

But, the second SQL script is throwing the following error:

mysql -h localhost -p -u root < valueset_and_log.sql
Enter password:
ERROR 1064 (42000) at line 23: 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 'SET character_set_client = @saved_cs_client */' at line 8

Any ideas on what the syntax issue might be?

[aniskand]

That's odd, you can just try deleting that line, while keeping the semicolon.

[jxfish2]

I found 2 issues with syntax.

1. You were missing the ";" at the end of the "ENGINE=MyISAM DEFAULT CHARSET=latin1;" line.

2. You were missing the "," at the end of the "response mediumtext NULL," line.

After adding this punctuation, the script ran without errors.

All of the remaining scripts ran without errors.