PDA

View Full Version : Error 1054 Database error in vBulletin 3.7.1



TTZ-Mike
Thu 4th Sep '08, 9:12am
The forum has been working great in the past but lately we are getting this error and it prevents us from using our forum. Any assistance is greatly appreciated.

Database error in vBulletin 3.7.1:

Invalid SQL:

SELECT calendarpermission.usergroupid, calendarpermission.calendarpermissions,calendar.ca lendarid,calendar.title, displayorder
FROM calendar AS calendar
LEFT JOIN calendarpermission AS calendarpermission ON
(calendarpermission.calendarid = calendar.calendarid AND usergroupid IN (5, 6, Array, 2))
ORDER BY displayorder ASC;

MySQL Error : Unknown column 'Array' in 'on clause'
Error Number : 1054
Request Date : Thursday, September 4th 2008 @ 08:08:25 AM
Error Date : Thursday, September 4th 2008 @ 08:08:25 AM
Script : http://thetradingzone.com/ (http://thetradingzone.com/forum/)
Referrer : http://thetradingzone.com/amember/member.php
IP Address : xxxxxx
Username : xxxxx
Classname : vB_Database
MySQL Version : 5.0.51a-community

Lynne
Thu 4th Sep '08, 10:01am
Try disabling your plugins and then see if you still have this problem.
Note: To temporarily disable the plugin system, edit config.php and add this line right under <?php


define('DISABLE_HOOKS', true);

TTZ-Mike
Thu 4th Sep '08, 11:56am
I will give that a try.

How do I disable the plug system? In admincp of vB?

Lynne
Thu 4th Sep '08, 11:57am
I know. It isn't there, I said you should *add* that line in order to disable all your plugins.