How could I solve this problem

[aouni_tahech]

Dear Sir,

I am using vBadvanced CMPS v2.0.0 for vbulletin version 3.5.0

A message appeared suddenly at the top of the page of the forum that says the following:

Warning: unserialize() expects parameter 1 to be string, array given in /includes/vba_cmps_include_bottom.php on line 219

Warning: unserialize() expects parameter 1 to be string, array given in /includes/vba_cmps_include_bottom.php on line 220

How could I solve that ?
Note that I didn't change anything in the settings of the forum. The message just appeared suddenly.

Thank You.

[Brian]

Just look in your includes/vba_cmps_include_bottom.php file for this code and remove it:
$iconcache = unserialize($vbulletin->iconcache);
$attachmentcache = unserialize($vbulletin->attachmentcache);


That was kind of left over from some older versions, and is no longer used. Normally that wouldn't create a problem, but it sounds like your host just upgraded you to PHP5 since that function would not print an error with older versions of PHP.

[aouni_tahech]

Thank you very much.
I really thought about that.
The problem was solved.
:)

[Quarterbore]

Funny, I found this almost a year and a half later but my host just upgraded to PHP 5.x and this was what I needed... Cheers!

[adambloch]

I have the same problem but I have removed those two line and the problem remains. Yes the server has just been up graded. Any Ideas

Many thanks

[Brian]

Which version of vBulletin are you running? If you're running vB 3.6+ then your best bet would be to upgrade to the latest version of the CMPS (3.0.0).

[CanuckDave]

I'm having the same problem here, though when I delete both lines from the file it just displays a blank page with a "(" at the top.

I can remove one line at a time and it removes the error for one from the top of the page, but I can't seem to figure out how to make it work with both lines removed, any ideas?

Anything? I'm desperate to at least temporarily fix this so I can do a backup with the most recent posts and upgrade everything if necessary.

Is there any way to at least disable or remove vBadvanced without accessing the admin panel? I'd like to at very least get the forum back up for my users

[Brian]

You can disable all plugins by adding this line to your includes/config.php file.

define('DISABLE_HOOKS', true);

[cdoyle]

My host just upgraded to PHP 5 and I'm getting this error.

along with this


Database error in vBulletin 3.5.0:

Invalid SQL:

SELECT IF(votenum >= 1, votenum, 0) AS numbvote, IF(votenum >= 1 AND votenum != 0, votetotal / votenum, 0) AS voteavg,
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, forum.title AS forumtitle

,thread.iconid AS threadiconid, iconpath AS threadiconpath
, avatarpath, NOT ISNULL(filedata) AS hascustom, customavatar.dateline AS avatardateline, avatarrevision
, NOT ISNULL(subscribethread.subscribethreadid) AS subscribed
FROM thread AS thread
LEFT JOIN forum AS forum USING (forumid)
LEFT JOIN post AS post ON (post.postid = thread.firstpostid)
LEFT JOIN icon USING (iconid)
LEFT JOIN user AS user ON (user.userid = post.userid)



LEFT JOIN avatar as avatar ON (avatar.avatarid = user.avatarid)
LEFT JOIN customavatar as customavatar ON (customavatar.userid = user.userid)

LEFT JOIN subscribethread AS subscribethread ON (subscribethread.threadid = thread.threadid AND subscribethread.userid = '1')
LEFT JOIN deletionlog AS deletionlog ON (thread.threadid = deletionlog.primaryid AND type = 'thread')
WHERE thread.threadid IN(7019,6215)

GROUP BY post.postid
ORDER BY sticky DESC,thread.dateline DESC
LIMIT 2;

MySQL Error : Column 'iconid' in from clause is ambiguous
Error Number : 1052
Date : Wednesday, July 16th 2008 @ 04:46:47 PM
Script : http://www.caraudiocentral.net/?
Referrer : http://www.caraudiocentral.net/forums/
IP Address : 216.39.144.78
Username : Chris from Washington
Classname : vB_Database


I removed the bit of code from my include file and the Warning: unserialize error went away, but the other part is still there.

The rest of the forum works fine, just the portal doesn't work.

any ideas?
I'm running VB 3.5

[Brian]

http://www.vbadvanced.com/forum/showthread.php?t=12197&highlight=iconid+ambiguous