Database error in vBulletin 3.8.3 . MySQL Error : Unknown column 'Array' in 'on cla

[Mushabab]

Hi; Kindly help me to solve this error in my vb. Inspite of uploading the scripts few times. dissable all hacks , I continued to have it . I checked with my server IT and they told me it is a problem in vb scripts!

Cheers!


"Database error in vBulletin 3.8.3:

Invalid SQL:

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

MySQL Error : Unknown column 'Array' in 'on clause'
Error Number : 1054
Request Date : Monday, June 29th 2009 @ 08:04:13 PM
Error Date : Monday, June 29th 2009 @ 08:04:13 PM
Script : http://www.xxxxxxxx/calendar.php
Referrer : http://www.xxxxxxx/forums/index.php
IP Address : xx.x5.x6.162
Username :
Classname : vB_Database
MySQL Version : 5.0.77-community"

[grey_goose]

I get this also... can anyone help?

[James Birkett]

the actual error is: MySQL Error : Unknown column 'Array' in 'on clause'
Which means (I think) that the column "Array" isn't in the "on clause" table.
Which modifications do you have installed (relating to calendars possibly).

I'd recommend disabling the plugin system and finding the cause of the problem.

Note: To globally disable plugins put the following code right under <?php in the includes/config.php file:

PHP Code:

define('DISABLE_HOOKS', true) 


[snakes1100]

Before you ran the upgrade script, are you positive that you uploaded and over wrote all the vbulletin files on your FTP?

[Lynne]

Can we see your exact error since I'm sure it isn't *exactly* the same as the OPs.

[grey_goose]

I've solved my problem.

Basically, that 'Array' is set as a usergroup, using the name of the group rather than the group number in the table.

[jc10002]

Basically, that 'Array' is set as a usergroup, using the name of the group rather than the group number in the table.

So how do you adjust things so that the column does not continue to use the name, and properly use the group number?

Thanks.