PDA

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



rfelice
05-21-2007, 01: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:

SELECT *
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

Brian
05-21-2007, 09: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
 

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

Thanks!