I created a new guild the other night and then changed out the guild name in gwowroster options to reflect a new guild. Now when I run the gwowroster guild info update from the scheduled tasks I get the following. It worked before I changed the guild name btw.
Code:
Database error in vBulletin 3.7.3:
Invalid SQL:
DELETE FROM gwowroster_rosterinfo WHERE NOT (
locale IN('US') AND
realm IN('Blackhand') AND
charname 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
Request Date : Friday, October 10th 2008 @ 09:52:10 AM
Error Date : Friday, October 10th 2008 @ 09:52:15 AM
Script : http://realmgfx.com/forum/admin_cp/cronadmin.php?do=runcron&cronid=30
Referrer : http://realmgfx.com/forum/admin_cp/index.php
IP Address : 24.219.216.156
Username : Hunted
Classname : vb_database
MySQL Version : 5.0.51a-log