
11-14-2009, 05:26 AM
|
|
|
Join Date: Dec 2007
Posts: 116
Благодарил(а): 0 раз(а)
Поблагодарили:
0 раз(а) в 0 сообщениях
|
|
Quote:
Originally Posted by logicSix
this product worked great until i went to clear off all the users from the paypal list in VB and now, every person who has donated gets this error when they go to see who is online:
HTML Code:
Database error in vBulletin 3.8.1:
Invalid SQL:
SELECT calendarpermission.usergroupid, calendarpermission.calendarpermissions,calendar.calendarid,calendar.title, displayorder
FROM logicSix_uodcalendar AS calendar
LEFT JOIN logicSix_uodcalendarpermission AS calendarpermission ON
(calendarpermission.calendarid = calendar.calendarid AND usergroupid IN (ForumSupporter, 6))
ORDER BY displayorder ASC;
MySQL Error : Unknown column 'ForumSupporter' in 'on clause'
Error Number : 1054
Request Date : Friday, March 20th 2009 @ 11:06:18 PM
Error Date : Friday, March 20th 2009 @ 11:06:18 PM
Script : http://www.xxxxx.org/forum/online.php
Referrer : http://www.xxxxx.org/forum/index.php
IP Address : xx.xxx.xx.xxx
Username : tragedy
Classname : vB_Database
MySQL Version : 5.0.45
i've done everything i could...i cannot even remove the "ForumSupporter" secondary group from their usernames. any ideas?
|
I had this problem. Mine was caused because I entered the name of the Donor Group (ie Donors) instead of the number of the usergroupid . Hope that helps
|