array_keys(), foreach() errors when switching database server

deadhobo · 08-08-2006, 12:16 AM

Hi there, I am hoping that someone can help me with the below errors...

Quote:

Warning: array_keys(): The first argument should be an array in /includes/functions.php on line 3277

Warning: Invalid argument supplied for foreach() in /includes/functions.php on line 3277

Warning: Invalid argument supplied for foreach() in /includes/vba_cmps_include_bottom.php on line 281

My forum has been running happily for a few months now and my host switched database servers today and the above three errors popped up. Any help would be greatly appriciated!

deadhobo · 08-08-2006, 08:45 AM

:paranoid: I woke up this morning to more errors...

EDIT: My host says they were having some issues when this error occured... the database server is currently offline so I don't know which errors will be produced when it is back online, but most likley not the following one (according to them). Ugh this is a nightmare.

Quote:

Database error in vBulletin 3.5.4:
Invalid SQL:
SELECT
thread.threadid, post.title, thread.replycount, postusername, postuserid, thread.dateline AS postdateline, thread.lastposter, thread.lastpost, IF(views<=thread.replycount, thread.replycount+1, views) AS views, thread.forumid, post.postid, pagetext, allowsmilie

FROM thread AS thread
LEFT JOIN post AS post ON (post.postid = thread.firstpostid)
LEFT JOIN 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 thread.threadid IN(33,32)

GROUP BY post.postid
ORDER BY sticky DESC,thread.dateline DESC
LIMIT 4;
MySQL Error : Can't create/write to file '/tmp/#sql_7c4f_0.MYI' (Errcode: 30)
Error Number : 1

bairy · 08-08-2006, 10:43 AM

The simplest answer to the first error (the line 3277 one) is:
Download vBulletin 3.5.4 from the members area. You can do the no images/xml if you want to save a bit of download time.
Upload vbulletin.zip/do_not_upload/tools.php to your boards admincp/ and run it. Then rebuild the forum cache. Delete tools.php from your server.

However looking at the sql error, it might not work. Give it a try though.

As for being unable to write to the .MYI file, pass. If it persists, you might need to talk to your host.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
User Cp Critical Error	Nick R	Site Feedback	6	08-03-2006 09:39 AM

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)