vbulletin: Unknown column 'Array' in 'on clause' error 1054

Discussion in 'Integration' started by jcary, Jan 31, 2011.

  1. jcary

    jcary Member

    Joined:
    Aug 29, 2006
    Messages:
    87
    I've been receiving this vbulletin databse error for some time now and wonder if it may be caused by the aMember / vbulletin integration plugin:

    I'm running vbulletin 4.0.5 and the current version of aMember. Basically, what's happening is the word 'Array' is making its way into that column in the db and causing blank screens for my members.

    = = = = = = = = = = = = = = = = = =

    Database error in vBulletin 4.0.5:

    Invalid SQL:

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

    MySQL Error : Unknown column 'Array' in 'on clause'
    Error Number : 1054
    Request Date : Monday, January 31st 2011 @ 06:05:06 PM
    Error Date : Monday, January 31st 2011 @ 06:05:06 PM
    Script : http://www.mysite.com/members/forums/forum.php
    Referrer : http://www.mysite.com/members/index.php
    Username : JoshC
    Classname : vB_Database
    MySQL Version : 5.0.91-community


    = = = = = = = = = = = = = = = = = =
  2. alexander

    alexander Administrator Staff Member

    Joined:
    Jan 8, 2003
    Messages:
    6,279
    Do you use latest plugin as well?
    Please contact us in helpdesk and request latest vBulletin plugin, then check issue on it.
  3. jcary

    jcary Member

    Joined:
    Aug 29, 2006
    Messages:
    87
    Hi Alex,

    Still receiving same error after upgrading to latest vbulletin plugin.

    Do I need to manually remove the 'array' clause in the mysql table to prevent it from happening again, or what?

    Also, my members have been getting blank, white screens after hitting 'post reply' on vbulletin.

    Not sure if this is an issue with amember, vbulletin or something else.

    -Josh
  4. alexander

    alexander Administrator Staff Member

    Joined:
    Jan 8, 2003
    Messages:
    6,279
    Ok. Try to resave all products and vBulletin plugin setup aMember CP -> Setup -> Plugins -> vBulletin3
    Do not change anything, just resave these pages(this will update config settings for plugin)
    I believe there is wrong value stored somewhere in amember database for vBulletin level.
  5. jcary

    jcary Member

    Joined:
    Aug 29, 2006
    Messages:
    87
    Sadly, this did not solve the problem :(

    Also, after upgrading to the latest vbulletin plugin, a few of my members are receiving a "You are banned" notice in vbulletin, seemingly after trying to change their avatar.

    Can you help out on this one?
  6. alexander

    alexander Administrator Staff Member

    Joined:
    Jan 8, 2003
    Messages:
    6,279
    Please contact me in helpdesk and provide examples for both situations I will check.

Share This Page