View Full Version : SQL Error on Add Module of Type Template

05-21-2007, 12:35 AM
I've just completed the upgrade which wen t fine. Now I am trying to add some bits in and when I do I get the following:

Database error in vBulletin 3.6.7:

Invalid SQL:

FROM template
WHERE title = 'adv_portal_report'
AND styleid IN();

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 ')' at line 4
Error Number : 1064
Date : Sunday, May 20th 2007 @ 11:30:21 PM
Script : http://www.rpgnation.org/forum/admincp/vba_cmps_admin.php
Referrer : http://www.rpgnation.org/forum/admincp/vba_cmps_admin.php?do=addmodule&type=template

05-21-2007, 08:18 AM
It looks like you could get that error if you add a new template module with content, but don't select a style to install the template to. I'll be sure to add a check in the next version so it will print out a normal error message instead of the SQL error. In the mean time, just be sure to select a style to install the templates to when adding new template modules.

Our Sponsors

05-21-2007, 08:50 AM
That's it.