[Forum] MySQL Database Error When Updating Template

[TruthElixirX]

I just upgraded from 4.0.4 to 4.07 and I receive this error:

Database error in vBulletin 4.0.7:

Invalid SQL:

		SELECT templateid
		FROM vbftemplate
		WHERE styleid =  AND title = 'footer';

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 title = 'footer'' at line 3
Error Number  : 1064
Request Date  : Saturday, October 2nd 2010 @ 12:13:44 AM
Error Date    : Saturday, October 2nd 2010 @ 12:13:44 AM
Script        : http://www.neohioatvriders.com/admincp/template.php?do=updatetemplate
Referrer      : http://www.neohioatvriders.com/admincp/template.php?do=edit&templateid=946
IP Address    : 12.177.169.227
Username      : Mike-
Classname     : vB_Database
MySQL Version : 5.0.91-log

When trying to make changes to my footer template. Why? So far it only happens when trying to update the footer template.

[SecondV]

Odd, it looks like the styleid isn't being sent to the query, and it's just the footer template? Is it the default vB style or a custom one?

I just upgraded from 4.0.4 to 4.07 and I receive this error:

Database error in vBulletin 4.0.7:

Invalid SQL:

		SELECT templateid
		FROM vbftemplate
		WHERE styleid =  AND title = 'footer';

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 title = 'footer'' at line 3
Error Number  : 1064
Request Date  : Saturday, October 2nd 2010 @ 12:13:44 AM
Error Date    : Saturday, October 2nd 2010 @ 12:13:44 AM
Script        : http://www.neohioatvriders.com/admincp/template.php?do=updatetemplate
Referrer      : http://www.neohioatvriders.com/admincp/template.php?do=edit&templateid=946
IP Address    : 12.177.169.227
Username      : Mike-
Classname     : vB_Database
MySQL Version : 5.0.91-log

When trying to make changes to my footer template. Why? So far it only happens when trying to update the footer template.

[TruthElixirX]

Just the footer template, yes. Updating any other template within this style works fine. And it is a custom style. Style ID #2.

I just left the forum, and went back an hour later and it works.

EDIT:: It saved the template, but now when I go o the forum home page I get "500 Internal Server Error". Forum completely down. This is urgent now.

I've ha to revert back to the back up of 4.0.4 until I figure out what problem is happening.

[TruthElixirX]

Bump.

[reefland]

500 server error typically is not caused by vbulletin. Did you ask your host to investigate? Did any file permissions get changed?