Help! Help! Help! Urgent!

[Rob B]

I have to get my forum back my morning and its 12.45am, and I want to sleep as well, and I have had some problems when upgrading!

I have this at the top of every page:

Warning: array_key_exists() [function.array-key-exists]: The second argument should be either an array or an object in /global.php(334) : eval()'d code on line 69

When trying to view a thread, this:

Database error in vBulletin 3.6.1:

Invalid SQL:

SELECT
post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS isdeleted,
user.*, userfield.*, usertextfield.*,
icon.title as icontitle, icon.iconpath,
avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight,

deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason,
editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,
editlog.reason AS edit_reason,
post_parsed.pagetext_html, post_parsed.hasimages,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid


FROM vb_post AS post
LEFT JOIN vb_user AS user ON(user.userid = post.userid)
LEFT JOIN vb_userfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN vb_usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
LEFT JOIN vb_icon AS icon ON(icon.iconid = post.iconid)
LEFT JOIN vb_avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN vb_customavatar AS customavatar ON(customavatar.userid = user.userid)
LEFT JOIN vb_deletionlog AS deletionlog ON(post.postid = deletionlog.primaryid AND type = 'post')
LEFT JOIN vb_editlog AS editlog ON(editlog.postid = post.postid)
LEFT JOIN vb_post_parsed AS post_parsed ON(post_parsed.postid = post.postid AND post_parsed.styleid_code = -1 AND post_parsed.styleid_html = -1 AND post_parsed.styleid_php = -1 AND post_parsed.styleid_quote = -1)

WHERE post.postid IN (0,42504,42506,42508,42513,42517,42519,42520,42523 ,42545,42569,42572,42576,42585,42610,42612,42624,4 2629,42635,42642,43331)
ORDER BY post.dateline;

MySQL Error : Table 'cric247_vbforum.vb_post_parsed' doesn't exist
Error Number : 1146
Date : Thursday, September 21st 2006 @ 07:46:18 PM
Script : http://www.cricket247.net/forum/showthread.php?t=2154
Referrer : http://www.cricket247.net/forum/forumdisplay.php?f=52
IP Address : 90.193.233.174
Username : Rob
Classname : vb_database

:( :( :( :( :( :( :( :(

[Rob B]

Someone please help soon, this is an absolute nightmare.

[Rob B]

I have solved this errorL
Warning: array_key_exists() [function.array-key-exists]: The second argument should be either an array or an object in /global.php(334) : eval()'d code on line 69

Just still having problems with the other, and also, when on the Members List I get this:

Database error in vBulletin 3.6.1:

Invalid SQL:

SELECT profilefieldid, type, data, optional, title, memberlist, searchable
FROM vb_profilefield
WHERE form = 0
ORDER BY displayorder;

MySQL Error : Unknown column 'title' in 'field list'
Error Number : 1054
Date : Thursday, September 21st 2006 @ 08:20:49 PM
Script : http://www.cricket247.net/forum/memberlist.php
Referrer : http://www.cricket247.net/forum/calendar.php
IP Address : 90.193.233.174
Username : Rob
Classname : vb_database

[ManagerJosh]

I'm not sure what happened, but someone or something botched up that query.

'vb_post_parsed' doesn't exist of course because it should be 'vb_postparsed'


Try disabling all plugins in config.php

Place in includes/config.php; immediately after <?php

define('DISABLE_HOOKS', true);


UPDATE: I'm going to guess that array_key_exists() is a result of a poorly coded plugin. Try disabling all plugins and see if that corrects the problem.


The unknown column error you are seeing is not part of a stock vBulletin 3.6.1 installation. There is no such column, title, for table profilefield in a stock installation. Again, try disabling all plugins.

[Rob B]

Hi everybody.

I diagnosed the files, and it appears that when I was updating the files, SmartFTP, for whatever reason, did not update the files in the forum root, therefore the showthread.php and memberlist.php etc. were for 3.5.4, not 3.6.1

Panic over, and I apologise for any inconvienience