MySQL Error

[Robert Fogt]

I have received several errors while modifying the styles. I successfully made several changes, then checked the box to revert back to default but it refused to work and gave me the error message below. I tried it several times and I get the same error each time.

Database error in vBulletin 3.5.1:

Invalid SQL:

SELECT templateid, title, template, template_un, styleid, templatetype
FROM template
WHERE templateid IN()
AND (templatetype <> 'template' OR title IN ('header', 'footer', 'headinclude', 'editor_jsoptions_font', 'editor_jsoptions_size', 'editor_styles_button_normal', 'editor_styles_button_hover', 'editor_styles_button_down', 'editor_styles_button_selected', 'editor_styles_menu_normal', 'editor_styles_menu_hover', 'editor_styles_menu_down', 'editor_styles_popup_down'));

MySQL Error : 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 ')
AND (templatetype <> 'template' OR title IN ('header', 'fo
Error Number : 1064
Date : Friday, December 2nd 2005 @ 07:58:14 AM
Script : http://forum.lostjungle.com/snip/css.php
Referrer : http://forum.lostjungle.com/snip/css.php?s=&do=edit&dowhat=all&group=&dostyleid=1
IP Address : 71.212.27.49
Username : Robert Fogt
Classname : vb_database

[Steve Machol]

SQL Syntax errors are almost always related to modified code. To troubleshoot this, the first thing you need to do is remove any hacks or plugins, then see if you still have this problem.

If so, reupload all the original vB non-image files (except install.php). Make sure you upload these in ASCII format and overwrite the ones on the server.

Next, create a new style and choose no parent style. This will force it to use the default templates. Finally empty your browser cache, close all browser windows then try again. Make sure you change to the new style and view your forums with it. Do you have the same problem?

[Robert Fogt]

This is a brand new install. I just bought the software a couple days ago and there have been no changes, or additions, or modifications to it at all.

The only thing I have been doing is changing the various permissions in the admin area.

[Robert Fogt]

It seems to be working OK now. I tried again and it works.

The only thing I can think of is it took a minute to load the color picker for the Main CSS settings page and I may have been clicking too soon. Once the page fully loaded and I submitted, it no longer showed errors.

[Robert Fogt]

BTW, is that valid SQL? Or is there an error in the SQL statement?