The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
Database error in vBulletin 3.8.3 . MySQL Error : Unknown column 'Array' in 'on cla
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" |
#2
|
|||
|
|||
I get this also... can anyone help?
|
#3
|
|||
|
|||
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:
|
#4
|
|||
|
|||
Before you ran the upgrade script, are you positive that you uploaded and over wrote all the vbulletin files on your FTP?
|
#5
|
||||
|
||||
Can we see your exact error since I'm sure it isn't *exactly* the same as the OPs.
|
#6
|
|||
|
|||
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. |
#7
|
|||
|
|||
Quote:
Thanks. |
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|