Anyone seen a sql error like this before.

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • jonsidneyb
    Senior Member
    • Mar 2006
    • 1008

    [Forum] Anyone seen a sql error like this before.

    [IMG]file:///C:/Users/John/AppData/Local/Temp/moz-screenshot.png[/IMG][IMG]file:///C:/Users/John/AppData/Local/Temp/moz-screenshot-1.png[/IMG]Database error in vBulletin 4.0.6:

    Invalid SQL:

    REPLACE INTO vb4_datastore
    (title, data, unserialize)
    VALUES
    ('birthdaycache', 'a:4:{s:4:\"day1\";s:10:\"2010-12-31\";s:4:\"day2\";s:10:\"2011-01-01\";s:6:\"users1\";a:5:{i:0;a:3:{s:6:\"userid\";s:5:\"17696\";s:8:\"username\";s:8:\"Floa ting\";s:3:\"age\";i:36;}i:1;a:3:{s:6:\"userid\";s:5:\"16423\";s:8:\"username\";s:8:\"Artb east\";s:3:\"age\";i:54;}i:2;a:3:{s:6:\"userid\";s:5:\"14280\";s:8:\"username\";s:8:\"RatH oler\";s:3:\"age\";i:43;}i:3;a:3:{s:6:\"userid\";s:4:\"9901\";s:8:\"username\";s:10:\"pipe dreams\";s:3:\"age\";i:39;}i:4;a:3:{s:6:\"userid\";s:5:\"25593\";s:8:\"username\";s:5:\"Mi keN\";s:3:\"age\";N;}}s:6:\"users2\";a:15862:{i:0;a:3:{s:6:\"userid\";s:5:\"18247\";s:8:\" username\";s:9:\"MildSalsa\";s:3:\"age\";i:2009;}i:1;a:3:{s:6:\"userid\";s:5:\"18246\";s:8 :\"username\";s:7:\"lamepro\";s:3:\"age\";i:2009;}i:2;a:3:{s:6:\"userid\";s:5:\"18245\";s: 8:\"username\";s:8:\"johnbtes\";s:3:\"age\";i:2009;}i:3;a:3:{s:6:\"userid\";s:5:\"18242\"; s:8:\"username\";s:4:\"mdao\";s:3:\"age\";i:2009;}i:4;a:3:{s:6:\"userid\";s:5:\"18240\";s: 8:\"username\";s:7:\"goraidh\";s:3:\"age\";i:2009;}i:5;a:3:{s:6:\"userid\";s:5:\"18241\";s :8:\"username\";s:6:\"jdl357\";s:3:\"age\";i:2009;}i:6;a:3:{s:6:\"userid\";s:5:\"18239\";s :8:\"username\";s:4:\"dreg\";s:3:\"age\";i:2009;}i:7;a:3:{s:6:\"userid\";s:5:\"18238\";s:8 :\"username\";s:7:\"Isildur\";s:3:\"age\";i:2009;}i:8;a:3:{s:6:\"userid\";s:5:\"18237\";s: 8:\"username\";s:4:\"deon\";s:3:\"age\";i:2009;}i:9;a:3:{s:6:\"userid\";s:5:\"18236\";s:8: \"username\";s:6:\"cadjak\";s:3:\"age\";i:2009;}i:10;a:3:{s:6:\"userid\";s:5:\"18235\";s:8 :\"username\";s:11:\"fedemartini\";s:3:\"age\";i:2009;}i:11;a:3:{s:6:\"userid\";s:5:\"1823 4\";s:8:\"username\";s:8:\"spitlynx\";s:3:\"age\";i:2009;}i:12;a:3:{s:6:\"userid\";s:5:\"1 8233\";s:8:\"username\";s:10:\"davidwholt\";s:3:\"age\";i:2009;}i:13;a:3:{s:6:\"userid\";s :5:\"18232\";s:8:\"username\";s:8:\"msweeney\";s:3:\"age\";i:2009;}i:14;a:3:{s:6:\"userid\ ";s:5:\"18231\";s:8:\"username\";s:7:\"holdenX\";s:3:\"age\";i:2009;}i:15;a:3:{s:6:\"useri d\";s:5:\"18230\";s:8:\"username\";s:8:\"texasboy\";s:3:\"age\";i:2009;}i:16;a:3:{s:6:\"us erid\";s:5:\"18229\";s:8:\"username\";s:5:\"rtrwv\";s:3:\"age\";i:2009;}i:17;a:3:{s:6:\"us erid\";s:5:\"18228\";s:8:\"username\";s:7:\"Rich219\";s:3:\"age\";i:2009;}i:18;a:3:{s:6:\" userid\";s:5:\"18227\";s:8:\"username\";s:9:\"rnolletti\";s:3:\"age\";i:2009;}i:19;a:3:{s: 6:\"userid\";s:5:\"18226\";s:8:\"username\";s:9:\"brian2554\";s:3:\"age\";i:2009;}i:20;a:3 :{s:6:\"userid\";s:5:\"18225\";s:8:\"username\";s:6:\"sn1p3r\";s:3:\"age\";i:2009;}i:21;a: 3:{s:6:\"userid\";s:5:\"18224\";s:8:\"username\";s:3:\"HGB\";s:3:\"age\";i:2009;}i:22;a:3: {s:6:\"userid\";s:5:\"18223\";s:8:\"username\";s:3:\"jjp\";s:3:\"age\";i:2009;}i:23;a:3:{s :6:\"userid\";s:5:\"18222\";s:8:\"username\";s:5:\"Crowe\";s:3:\"age\";i:2009;}i:24;a:3:{s :6:\"userid\";s:5:\"18221\";s:8:\"username\";s:6:\"Andres\";s:3:\"age\";i:2009;}i:25;a:3:{ s:6:\"userid\";s:5:\"18220\";s:8:\"username\";s:5:\"s0nny\";s:3:\"age\";i:2009;}i:26;a:3:{ s:6:\"userid\";s:5:\"18218\";s:8:\"username\";s:3:\"AMS\";s:3:\"age\";i:2009;}i:27;a:3:{s: 6:\"userid\";s:5:\"18217\";s:8:\"username\";s:6:\"edwinl\";s:3:\"age\";i:2009;}i:28;a:3:{s :6:\"userid\";s:5:\"18216\";s:8:\"username\";s:6:\"Elanth\";s:3:\"age\";i:2009;}i:29;a:3:{ s:6:\"userid\";s:5:\"18215\";s:8:\"username\";s:8:\"stautshi\";s:3:\"age\";i:2009;}i:30;a: 3:{s:6:\"userid\";s:5:\"18214\";s:8:\"username\";s:6:\"grzybb\";s:3:\"age\";i:2009;}i:31;a :3:{s:6:\"userid\";s:5:\"18213\";s:8:\"username\";s:3:\"Oak\";s:3:\"age\";i:2009;}i:32;a:3 :{s:6:\"userid\";s:5:\"18212\";s:8:\"username\";s:12:\"dispatch 510\";s:3:\"age\";i:2009;}i:33;a:3:{s:6:\"userid\";s:5:\"18211\";s:8:\"username\";s:6:\"ma ttyb\";s:3:\"age\";i:2009;}i:34;a:3:{s:6:\"userid\";s:5:\"18210\";s:8:\"username\";s:7:\"t ommy49\";s:3:\"age\";i:2009;}i:35;a:3:{s:6:\"userid\";s:5:\"18209\";s:8:\"username\";s:14: \"gatoradefierce\";s:3:\"age\";i:2009;}i:36;a:3:{s:6:\"userid\";s:5:\"18208\";s:8:\"userna me\";s:7:\"Jesseri\";s:3:\"age\";i:2009;}i:37;a:3:{s:6:\"userid\";s:5:\"18207\";s:8:\"user name\";s:7:\"Manfred\";s:3:\"age\";i:2009;}i:38;a:3:{s:6:\"userid\";s:5:\"18206\";s:8:\"us ername\";s:8:\"rdsfd513\";s:3:\"age\";i:2009;}i:39;a:3:{s:6:\"userid\";s:5:\"18203\";s:8:\ "username\";s:8:\"grnsouth\";s:3:\"age\";i:2009;}i:40;a:3:{s:6:\"userid\";s:5:\"18202\";s: 8:\"username\";s:13:\"WoodenChicken\";s:3:\"age\";i:2009;}i:41;a:3:{s:6:\"userid\";s:5:\"1 8201\";s:8:\"username\";s:7:\"Hagen22\";s:3:\"age\";i:2009;}i:42;a:3:{s:6:\"userid\";s:5:\ "18200\";s:8:\"username\";s:10:\"mactab1950\";s:3:\"age\";i:2009;}i:43;a:3:{s:6:\"userid\" ;s:5:\"18199\";s:8:\"username\";s:10:\"Randolph20\";s:3:\"age\";i:2009;}i:44;a:3:{s:6:\"us erid\";s:5:\"18198\";s:8:\"username\";s:7:\"Howaido\";s:3:\"age\";i:2009;}i:45;a:3:{s:6:\" userid\";s:5:\"18197\";s:8:\"username\";s:8:\"trailmix\";s:3:\"age\";i:2009;}i:46;a:3:{s:6 :\"userid\";s:5:\"18196\";s:8:\"username\";s:4:\"1203\";s:3:\"age\";i:2009;}i:47;a:3:{s:6: \"userid\";s:5:\"18195\";s:8:\"username\";s:5:\"ruff4\";s:3:\"age\";i:2009;}i:48;a:3:{s:6: \"userid\";s:5:\"18194\";s:8:\"username\";s:10:\"TexCaboCat\";s:3:\"age\";i:2009;}i:49;a:3 :{s:6:\"userid\";s:5:\"18193\";s:8:\"username\";s:8:\"AlexNode\";s:3:\"age\";i:2009;}i:50; a:3:{s:6:\"userid\";s:5:\"18192\";s:8:\"username\";s:10:\"kadabujack\";s:3:\"age\";i:2009; }i:51;a:3:{s:6:\"userid\";s:5:\"18191\";s:8:\"username\";s:9:\"R.Neville\";s:3:\"age\";i:2 009;}i:52;a:3:{s:6:\"userid\";s:5:\"18190\";s:8:\"username\";s:12:\"naturehunter\";s:3:\"a ge\";i:2009;}i:53;a:3:{s:6:\"userid\";s:5:\"18188\";s:8:\"username\";s:10:\"rhthompson\";s :3:\"age\";i:2009;}i:54;a:3:{s:6:\"userid\";s:5:\"18187\";s:8:\"username\";s:17:\"Foreveru nstopable\";s:3:\"age\";i:2009;}i:55;a:3:{s:6:\"userid\";s:5:\"18185\";s:8:\"username\";s: 8:\"Electrix\";s:3:\"age\";i:2009;}i:56;a:3:{s:6:\"userid\";s:5:\"18184\";s:8:\"username\" ;s:6:\"nukdae\";s:3:\"age\";i:2009;}i:57;a:3:{s:6:\"userid\";s:5:\"18183\";s:8:\"username\ ";s:8:\"bennyG19\";s:3:\"age\";i:2009;}i:58;a:3:{s:6:\"userid\";s:5:\"18182\";s:8:\"userna me\";s:14:\"Jeffersonpaine\";s:3:\"age\";i:2009;}i:59;a:3:{s:6:\"userid\";s:5:\"18181\";s: 8:\"username\";s:3:\"smc\";s:3:\"age\";i:2009;}i:60;a:3:{s:6:\"userid\";s:5:\"18180\";s:8: \"username\";s:12:\"greenerlines\";s:3:\"age\";i:2009;}i:61;a:3:{s:6:\"userid\";s:5:\"1817 8\";s:8:\"username\";s:13:\"BLADERUNNER25\";s:3:\"age\";i:2009;}i:62;a:3:{s:6:\"userid\";s :5:\"18177\";s:8:\"username\";s:5:\"wpick\";s:3:\"age\";i:2009;}i:63;a:3:{s:6:\"userid\";s :5:\"18175\";s:8:\"username\";s:15:\"Twodollarpistol\";s:3:\"age\";i:2009;}i:64;a:3:{s:6:\ "userid\";s:5:\"18174\";s:8:\"username\";s:8:\"larrymz3\";s:3:\"age\";i:2009;}i:65;a:3:{s: 6:\"userid\";s:5:\"18173\";s:8:\"username\";s:6:\"sb00by\";s:3:\"age\";i:2009;}i:66;a:3:{s :6:\"userid\";s:5:\"18172\";s:8:\"username\";s:8:\"CityHall\";s:3:\"age\";i:2009;}i:67;a:3 :{s:6:\"userid\";s:5:\"18171\";s:8:\"username\";s:6:\"TACMED\";s:3:\"age\";i:2009;}i:68;a: 3:{s:6:\"userid\";s:5:\"18170\";s:8:\"username\";s:7:\"Aera 15\";s:3:\"age\";i:2009;}i:69;a:3:{s:6:\"userid\";s:5:\"18169\";s:8:\"username\";s:5:\"Sim ek\";s:3:\"age\";i:2009;}i:70;a:3:{s:6:\"userid\";s:5:\"18168\";s:8:\"username\";s:12:\"pa vementends\";s:3:\"age\";i:2009;}i:71;a:3:{s:6:\"userid\";s:5:\"18166\";s:8:\"username\";s :4:\"degg\";s:3:\"age\";i:2009;}i:72;a:3:{s:6:\"userid\";s:5:\"18165\";s:8:\"username\";s: 8:\"kingcole\";s:3:\"age\";i:2009;}i:73;a:3:{s:6:\"userid\";s:5:\"18163\";s:8:\"username\" ;s:8:\"hallmars\";s:3:\"age\";i:2009;}i:74;a:3:{s:6:\"userid\";s:5:\"18162\";s:8:\"usernam e\";s:13:\"mangrove jack\";s:3:\"age\";i:2009;}i:75;a:3:{s:6:\"userid\"

  • jonsidneyb
    Senior Member
    • Mar 2006
    • 1008

    #2
    it ends like this.

    s:3:\"age\";i:2009;}i:15857;a:3:{s:6:\"userid\";s:5:\"27899\";s:8:\"username\";s:8:\"Kowbo y83\";s:3:\"age\";i:2009;}i:15858;a:3:{s:6:\"userid\";s:5:\"27900\";s:8:\"username\";s:9:\ "Lawyerman\";s:3:\"age\";i:2009;}i:15859;a:3:{s:6:\"userid\";s:5:\"27901\";s:8:\"username\ ";s:3:\"320\";s:3:\"age\";i:2009;}i:15860;a:3:{s:6:\"userid\";s:5:\"27902\";s:8:\"username \";s:12:\"MilsimJunkie\";s:3:\"age\";i:2009;}i:15861;a:3:{s:6:\"userid\";s:5:\"27903\";s:8 :\"username\";s:10:\"Nikeflyr88\";s:3:\"age\";i:2009;}}}', 1);

    MySQL Error : Got a packet bigger than 'max_allowed_packet' bytes
    Error Number : 1153
    Request Date : Friday, December 31st 2010 @ 06:05:51 PM
    Error Date : Friday, December 31st 2010 @ 06:05:52 PM
    Script : http://edcforums.com/forum.php
    Referrer : http://edcforums.com/
    IP Address : 209.117.235.190
    Username : roadrunner
    Classname : vB_Database
    MySQL Version :

    Comment

    • Zachery
      Former vBulletin Support
      • Jul 2002
      • 59097

      #3
      You sent more data than mysql can handle in a single query. You either need to up the max packet size in mysql or you need to move attachments to the filesystem.

      Comment

      • jonsidneyb
        Senior Member
        • Mar 2006
        • 1008

        #4
        we don't allow attachments.

        It is a listing of more then 20k users that is coming up.

        Comment

        • Zachery
          Former vBulletin Support
          • Jul 2002
          • 59097

          #5
          its your birthday cache.
          You have a bunch of jan 1st birthdays

          Comment

          • jonsidneyb
            Senior Member
            • Mar 2006
            • 1008

            #6
            hmmm,

            something must be way wrong. It is many many many pages long.

            Comment

            • Zachery
              Former vBulletin Support
              • Jul 2002
              • 59097

              #7
              You have a lot of jan first birthdays since it is the default date

              Comment

              • jonsidneyb
                Senior Member
                • Mar 2006
                • 1008

                #8
                Well, I guess I am stuck until the day passes. I can't get into the admin areas due to all the errors still coming out.

                Comment

                • jonsidneyb
                  Senior Member
                  • Mar 2006
                  • 1008

                  #9
                  Well, got in finally and turned off all the birthday stuff. Then the next shoe drops.


                  vb4_post Check Warning: Table is marked as crashed and last repair failed
                  vb4_post Check Error: Found key at page -1 that points to record outside datafile
                  vb4_post Check Error: Corrupt

                  Comment

                  • Zachery
                    Former vBulletin Support
                    • Jul 2002
                    • 59097

                    #10
                    you'll need to repair the table, but that sounds bad.

                    Comment

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