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 = = = = = = = = = = = = = = = = = =
Do you use latest plugin as well? Please contact us in helpdesk and request latest vBulletin plugin, then check issue on it.
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
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.
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?