No announcement yet.

Error loading forum.php

  • Filter
  • Time
  • Show
Clear All
new posts

  • [Forum] Error loading forum.php


    Today i got that error msg on mine forum

    Database error in vBulletin 4.2.0:
    Invalid SQL:
                REPLACE INTO datastore
                    (title, data, unserialize)
                    ('birthdaycache', 'a:4:{s:4:\"day1\";s:10:\"2013-01-01\";s:4:\"day2\";s:10:\"2013-01-02\";s:6:\"users1\";a:18807:{i:0;a:3:{s:6:\"userid\";s:1:\"4\";s:8:\"username\";s:13:\
    MySQL Error   : Got a packet bigger than 'max_allowed_packet' bytes
    Error Number  : 1153
    Request Date  : Tuesday, January 1st 2013 @ 02:41:58 PM
    Error Date    : Tuesday, January 1st 2013 @ 02:41:58 PM
    Script        :
    Referrer      : 
    IP Address    : *
    Username      : silverfox
    Classname     : vB_Database
    MySQL Version : 5.1.63-cll
    i tried to edit max_allowed_packet on my.cnf whitout success and now i can't see that error msg...

    many other areas from forum are working, like admincp/ blogs.php userprofile
    Last edited by AliMadkour; Tue 1 Jan '13, 7:21am. Reason: Removing user IP

  • #2
    You getting that error because there are a lot of today's birthday members
    here are some solutions :

    Edit max_allowed_packet value in my.cnf file and restart mysql server.
    AdminCP-Settings->Forum Home: Options->Display Today's Birthdays? temporarily set it to no. ( return it to yes tomorrow maybe because a lot of members register with 1/1 date )

    Former vBulletin Support Staff
    Need Help?, Or P.M. Me


    • #3
      Hello AliMadkour,

      Yes, there are a lot of members with 1/1 birthdays date, cuz when we changed from SMF to Vbulletin we did it to import all users...
      I tried max_allowed_packet with 500M whitout success, how much memory u suggest to use?

      Actualy i'm using today's birth off, to get board working at least.


      • #4
        I think 500MB is too big
        Check if your new value applied AdminCP->Maintenance->Diagnostics->System Information ->Select MySQL Variables and submit

        Former vBulletin Support Staff
        Need Help?, Or P.M. Me


        widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.