SEO ultimage url SQL error

[jeanmichel]

I am using mysql 5.0.24a-standard log. Precisely.

Actually, i have another mysql error message generated when i try to upload the sql patch (from the admin panel) for that goggle sitemap mod, this time. Here it is:

Code:

1064 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 'true', 'false'),')' at line 1 in: [INSERT INTO devi_configuration values ('', 'Compress XML File', 'GOOGLE_SITEMAP_COMPRESS', 'false', 'Compress Google XML Sitemap file', @t1, 3, NULL, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),');] If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Maybe there's a way to relate those 2 errors,who knows?

Thanks

[DrByte]

Those are unrelated.

Generally speaking, if there are a lot of \ marks in the SQL you paste into the SQLPatch window, you'll end up with failures. Sometimes loading it from a file works better. Sometimes you have to use phpMyAdmin instead, and manually add your table-prefix to each tablename.

[jeanmichel]

Thanks for the tip but the SEO module package came with an .sql patch written exclusively to upload it via the admin panel.

No need to copy and paste, just have to upload the .sql file.

And those .sql files arent looking the same as the simple syntaxed CREATE TABLE or INSERT or other mysql statements. Those files have some coding in the heading part that i didnt know of.