Results 1 to 10 of 10

Thread: How could I solve this problem

  1. #1

    Post How could I solve this problem

    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.

  2. #2
    Administrator Brian's Avatar
    Join Date
    Jan 2004
    Location
    Georgia, USA
    Posts
    34,434

    Default Re: How could I solve this problem

    Just look in your includes/vba_cmps_include_bottom.php file for this code and remove it:
    PHP Code:
    $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.

  3. #3

    Default Re: How could I solve this problem

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

  4. #4

    Default Re: How could I solve this problem

    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!

  5. #5
    Junior Member
    Join Date
    Aug 2006
    Posts
    1

    Default Re: How could I solve this problem

    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

  6. #6
    Administrator Brian's Avatar
    Join Date
    Jan 2004
    Location
    Georgia, USA
    Posts
    34,434

    Default Re: How could I solve this problem

    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).

  7. #7
    Junior Member
    Join Date
    Jan 2006
    Posts
    1

    Default Re: How could I solve this problem

    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
    Last edited by CanuckDave; 03-30-2008 at 07:13 PM.

  8. #8
    Administrator Brian's Avatar
    Join Date
    Jan 2004
    Location
    Georgia, USA
    Posts
    34,434

    Default Re: How could I solve this problem

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

    PHP Code:
    define('DISABLE_HOOKS'true); 

  9. #9

    Default Re: How could I solve this problem

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

    along with this

    Code:
    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

  10. #10
    Administrator Brian's Avatar
    Join Date
    Jan 2004
    Location
    Georgia, USA
    Posts
    34,434

    Default Re: How could I solve this problem


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Solve This Problem
    By Dan Kenitz in forum Troubleshooting & Problems
    Replies: 14
    Last Post: 06-29-2006, 10:55 AM
  2. $50 to solve. I'm desperate!
    By noah977 in forum Troubleshooting & Problems
    Replies: 3
    Last Post: 04-26-2006, 07:43 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •