Creating new forum Database Error

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Co$kun
    Member
    • Sep 2005
    • 36
    • 3.8.x

    Creating new forum Database Error

    Database error in vBulletin 3.6.8:

    Invalid SQL:

    REPLACE INTO datastore
    (title, data, unserialize)
    VALUES
    ('forumcache', 'a:867:{i:221;a:34:{s:7:\"forumid\";i:221;s:7:\"styleid\";i:0;s:5:\"title\";s:13:\"Yönetim Odası\";s:11:\"title_clean\options\";i:97991;s:11:\"showprivate\";i:0;s:12:\"displayorder\ ";i:2;s:10:\"lastpostid\";i:518352;s:9:\"daysprune\";i:-1;s:12:\"newpostemail\";s:0:\"\";s:14:\"newthreademail\";s:0:\"\";s:8:\"parentid\";i:35;s: 10:\"parentlist\";s:9:\"548,35,-1\";s:8:\"password\";s:0:\"\";s:4:\"link\";s:0:\"\";s:9:\"childlist\";s:6:\"548,-1\";s:16:\"defaultsortfield\";s:8:\"lastpost\";s:16:\"defaultsortorder\";s:4:\"desc\";s:12 :\"metakeywords\";s:0:\"\";s:15:\"metadescription\";s:0:\"\";s:17:\"dynguestmsg_title\";s: 0:\"\";s:11:\"dynguestmsg\";s:0:\"\";s:13:\"permmsg_title\";s:0:\"\";s:7:\"permmsg\";s:0:\ "\";s:10:\"accessf_nb\";i:0;s:10:\"accesst_nb\";i:0;s:9:\"create_nb\";i:0;s:8:\"reply_nb\" ;i:0;s:12:\"nuseo_domain\";s:0:\"\";s:7:\"podcast\";i:0;s:5:\"depth\";i:1;s:11:\"permissio ns\";a:19:{i:4;i:655375;i:9;i:1045887;i:16;i:782591;i:8;i:0;i:10;i:1048567;i:12;i:782847;i :3;i:655615;i:34;i:786431;i:36;i:1044599;i:14;i:1048575;i:2;i:782591;i:1;i:655367;i:7;i:78 2847;i:13;i:782591;i:6;i:1048575;i:11;i:1048063;i:5;i:1048063;i:17;i:1048063;i:37;i:104805 5;}}i:21;a:34:{s:7:\"forumid\";i:21;s:7:\"styleid\";i:0;s:5:\"title\";s:25:\"Düşünce Grubumuza Katılın\";s:11:\"title_clean\";s:25:\"Düşünce Grubumuza Katılın\";s:11:\"description\";s:41:\"Oluşturacağımız Düşünce Grubumuza Katılın\";s:17:\"description_clean\";s:41:\"Oluşturacağımız Düşünce Grubumuza Katılın\";s:7:\"options\";i:97991;s:11:\"showprivate\";i:0;s:12:\"displayorder\";i:3;s:10: \"lastpostid\";i:515983;s:9:\"daysprune\";i:-1;s:12:\"newpostemail\";s:0:\"\";s:14:\"newthreademail\";s:0:\"\";s:8:\"parentid\";i:35;s: 10:\"parentlist\";s:8:\"21,35,-1\";s:8:\"password\";s:0:\"\";s:4:\"link\";s:0:\"\";s:9:\"childlist\";s:21:\"21,182,183,18 4,185,-1\";s:16:\"defaultsortfield\";s:8:\"lastpost\";s:16:\"defaultsortorder\";s:4:\"desc\";s:12 :\"metakeywords\";s:0:\"\";s:15:\"metadescription\";s:0:\"\";s:17:\"dynguestmsg_title\";s: 0:\"\";s:11:\"dynguestmsg\";s:0:\"\";s:13:\"permmsg_title\";s:0:\"\";s:7:\"permmsg\";s:0:\ "\";s:10:\"accessf_nb\";i:0;s:10:\"accesst_nb\";i:0;s:9:\"create_nb\";i:0;s:8:\"reply_nb\" ;i:0;s:12:\"nuseo_domain\";s:0:\"\";s:7:\"podcast\";i:0;s:5:\"depth\";i:1;s:11:\"permissio ns\";a:19:{i:4;i:655375;i:9;i:1045887;i:16;i:782591;i:8;i:0;i:10;i:1048567;i:12;i:782847;i :3;i:655615;i:34;i:786431;i:36;i:1044599;i:14;i:1048575;i:2;i:782591;i:1;i:655367;i:7;i:78 2847;i:13;i:782591;i:6;i:1048575;i:11;i:1048063;i:5;i:1048063;i:17;i:1048063;i:37;i:104805 5;}}i:182;a:34:{s:7:\"forumid\";i:182;s:7:\"styleid\";i:0;s:5:\"title\";s:13:\"Köşe Yazıları\";s:11:\"title_clean\";s:13:\"Köşe Yazıları\";s:11:\"description\";s:0:\"\";s:17:\"description_clean\";s:0:\"\";s:7:\"options \";i:97991;s:11:\"showprivate\";i:0;s:12:\"displayorder\";i:1;s:10:\"lastpostid\";i:506964 ;s:9:\"daysprune\";i:-1;s:12:\"newpostemail\";s:0:\"\";s:14:\"newthreademail\";s:0:\"\";s:8:\"parentid\";i:21;s: 10:\"parentlist\";s:12:\"182,21,35,-1\";s:8:\"password\";s:0:\"\";s:4:\"link\";s:0:\"\";s:9:\"childlist\";s:6:\"182,-1\";s:16:\"defaultsortfield\";s:8:\"lastpost\";s:16:\"defaultsortorder\";s:4:\"desc\";s:12 :\"metakeywords\";s:0:\"\";s:15:\"metadescription\";s:0:\"\";s:17:\"dynguestmsg_title\";s: 0:\"\";s:11:\"dynguestmsg\";s:0:\"\";s:13:\"permmsg_title\";s:0:\"\";s:7:\"permmsg\";s:0:\ "\";s:10:\"accessf_nb\";i:0;s:10:\"accesst_nb\";i:0;s:9:\"create_nb\";i:0;s:8:\"reply_nb\" ;i:0;s:12:\"nuseo_domain\";s:0:\"\";s:7:\"podcast\";i:0;s:5:\"depth\";i:2;s:11:\"permissio ns\";a:19:{i:4;i:655375;i:9;i:1045887;i:16;i:782591;i:8;i:0;i:10;i:1048567;i:12;i:782847;i :3;i:655615;i:34;i:786431;i:36;i:1044599;i:14;i:1048575;i:2;i:782591;i:1;i:655367;i:7;i:78 2847;i:13;i:782591;i:6;i:1048575;i:11;i:1048063;i:5;i:1048063;i:17;i:1048063;i:37;i:104805 5;}}i:183;a:34:{s:7:\"forumid\";i:183;s:7:\"styleid\";i:0;s:5:\"title\";s:11:\"Acil Yardım\";s:11:\"title_clean\";s:11:\"Acil Yardım\";s:11:\"description\";s:0:\"\";s:17:\"description_clean\";s:0:\"\";s:7:\"options\" ;i:97991;s:11:\"showprivate\";i:0;s:12:\"displayorder\";i:1;s:10:\"lastpostid\";i:428113;s :9:\"daysprune\";i:-1;s:12:\"newpostemail\";s:0:\"\";s:14:\"newthreademail\";s:0:\"\";s:8:\"parentid\";i:21;s: 10:\"parentlist\";s:12:\"183,21,35,-1\";s:8:\"password\";s:0:\"\";s:4:\"link\";s:0:\"\";s:9:\"childlist\";s:6:\"183,-1\";s:16:\"defaultsortfield\";s:8:\"lastpost\";s:16:\"defaultsortorder\";s:4:\"desc\";s:12 :\"metakeywords\";s:0:\"\";s:15:\"metadescription\";s:0:\"\";s:17:\"dynguestmsg_title\";s: 0:\"\";s:11:\"dynguestmsg\";s:0:\"\";s:13:\"permmsg_title\";s:0:\"\";s:7:\"permmsg\";s:0:\ "\";s:10:\"accessf_nb\";i:0;s:10:\"accesst_nb\";i:0;s:9:\"create_nb\";i:0;s:8:\"reply_nb\" ;i:0;s:12:\"nuseo_domain\";s:0:\"\";s:7:\"podcast\";i:0;s:5:\"depth\";i:2;s:11:\"permissio ns\";a:19:{i:4;i:655375;i:9;i:1045887;i:16;i:782591;i:8;i:0;i:10;i:1048567;i:12;i:782847;i :3;i:655615;i:34;i:786431;i:36;i:1044599;i:14;i:1048575;i:2;i:782591;i:1;i:655367;i:7;i:78 2847;i:13;i:782591;i:6;i:1048575;i:11;i:1048063;i:5;i:1048063;i:17;i:1048063;i:37;i:104805 5;}}i:184;a:34:{s:7:\"forumid\";i:184;s:7:\"styleid\";i:0;s:5:\"title\";s:11:\"Renklerimiz \";s:11:\"title_clean\";s:11:\"Renklerimiz\";s:11:\"description\";s:0:\"\";s:17:\"descript ion_clean\";s:0:\"\";s:7:\"options\";i:97991;s:11:\"showprivate\";i:0;s:12:\"displayorder\ ";i:1;s:10:\"lastpostid\";i:490165;s:9:\"daysprune\";i:-1;s:12:\"newpostemail\";s:0:\"\";s:14:\"newthreademail\";s:0:\"\";s:8:\"parentid\";i:21;s: 10:\"parentlist\";s:12:\"184,21,35,-1\";s:8:\"password\";s:0:\"\";s:4:\"link\";s:0:\"\";s:9:\"childlist\";s:6:\"184,-1\";s:16:\"defaultsortfield\";s:8:\"lastpost\";s:16:\"defaultsortorder\";s:4:\"desc\";s:12 :\"metakeywords\";s:0:\"\";s:15:\"metadescription\";s:0:\"\";s:17:\"dynguestmsg_title\";s: 0:\"\";s:11:\"dynguestmsg\";s:0:\"\";s:13:\"permmsg_title\";s:0:\"\";s:7:\"permmsg\";s:0:\ "\";s:10:\"accessf_nb\";i:0;s:10:\"accesst_nb\";i:0;s:9:\"create_nb\";i:0;s:8:\"reply_nb\" ;i:0;s:12:\"nuseo_domain\";s:0:\"\";s:7:\"podcast\";i:0;s:5:\"depth\";i:2;s:11:\"permissio ns\";a:19:{i:4;i:655375;i:9;i:1045887;i:16;i:782591;i:8;i:0;i:10;i:1048567;i:12;i:782847;i :3;i:655615;i:34;i:786431;i:36;i:1044599;i:14;i:1048575;i:2;i:782591;i:1;i:655367;i:7;i:78 2847;i:13;i:782591;i:6;i:1048575;i:11;i:1048063;i:5;i:1048063;i:17;i:1048063;i:37;i:104805 5;}}i:185;a:34:{s:7:\"forumid\";i:185;s:7:\"styleid\";i:0;s:5:\"title\";s:13:\"Fikir Sofrası\";s:11:\"title_clean\";s:13:\"Fikir Sofrası\";s:11:\"description\";s:0:\"\";s:17:\"description_clean\";s:0:\"\";s:7:\"options\ ";i:97991;s:11:\"showprivate\";i:0;s:12:\"displayorder\";i:1;s:10:\"lastpostid\";i:524206; s:9:\"daysprune\";i:-1;s:12:\"newpostemail\";s:0:\"\";s:14:\"newthreademail\";s:0:\"\";s:8:\"parentid\";i:21;s: 10:\"parentlist\";s:12:\"185,21,35,-1\";s:8:\"password\";s:0:\"\";s:4:\"link\";s:0:\"\";s:9:\"childlist\";s:6:\"185,-1\";s:16:\"defaultsortfield\";s:8:\"lastpost\";s:16:\"defaultsortorder\";s:4:\"desc\";s:12 :\"metakeywords\";s:0:\"\";s:15:\"metadescription\";s:0:\"\";s:17:\"dynguestmsg_title\";s: 0:\"\";s:11:\"dynguestmsg\";s:0:\"\";s:13:\"permmsg_title\";s:0:\"\";s:7:\"permmsg\";s:0:\ "\";s:10:\"accessf_nb\";i:0;s:10:\"accesst_nb\";i:0;s:9:\"create_nb\";i:0;s:8:\"reply_nb\" ;i:0;s:12:\"nuseo_domain\";s:0:\"\";s:7:\"podcast\";i:0;s:5:\"depth\";i:2;s:11:\"permissio ns\";a:19:{i:4;i:655375;i:9;i:1045887;i:16;i:782591;i:8;i:0;i:10;i:1048567;i:12;i:782847;i :3;i:655615;i:34;i:786431;i:36;i:1044599;i:14;i:1048575;i:2;i:782591;i:1;i:655367;i:7;i:78 2847;i:13;i:782591;i:6;i:1048575;i:11;i:1048063;i:5;i:1048063;i:17;i:1048063;i:37;i:104805 5;}}i:22;a:34:{s:7:\"forumid\";i:22;s:7:\"styleid\";i:0;s:5:\"title\";s:18:\"Uzay ve Bilinmeyen\";s:11:\"title_clean\";s:18:\"Uzay ve Bilinmeyen\";s:11:\"description\";s:72:\"uzay ve biLinmeyen hakkında herşeyi burda buLabiLir ve payLaşabiLirsiniz\";s:17:\"description_clean\";s:72:\"uzay ve biLinmeyen hakkında herşeyi burda buLabiLir ve payLaşabiLirsiniz\";s:7:\"options\"Burada forumumuz hakkındaki önerilerinizi, düşüncelerinizi belirtebilir ve şikayetlerinizi bildirebilirsiniz.\";s:17:\"description_clean\";s:109:\"Burada forumumuz hakkındaki önerilerinizi, düşüncelerinizi belirtebilir ve şikayetlerinizi bildirebilirsiniz.\";s:7:\"options\";i:97991;s:11:\"showprivate\";i:0;s:12:\"displayorder\ ";i:7;s:10:\"lastpostid\";i:523227;s:9:\"daysprune\";i:-1;s:12:\"newpostemail\";s:0:\"\";s:14:\"newthreademail\";s:0:\"\";s:8:\"parentid\";i:33;s: 10:\"parentlist\";s:9:\"217,33,-1\";s:8:\"password\";s:0:\"\";s:4:\"link\";s:0:\"\";s:9:\"childlist\";s:6:\"217,-1\";s:16:\"defaultsortfield\";s:8:\"lastpost\";s:16:\"defaultsortorder\";s:4:\"desc\";s:12 :\"metakeywords\";s:0:\"\";s:15:\"metadescription\";s:0:\"\";s:17:\"dynguestmsg_title\";s: 0:\"\";s:11:\"dynguestmsg\";s:0:\"\";s:13:\"permmsg_title\";s:0:\"\";s:7:\"permmsg\";s:0:\ "\";s:10:\"accessf_nb\";i:0;s:10:\"accesst_nb\";i:0;s:9:\"create_nb\";i:0;s:8:\"reply_nb\" ;i:0;s:12:\"nuseo_domain\";s:0:\"\";s:7:\"podcast\";i:0;s:5:\"depth\";i:1;s:11:\"permissio ns\";a:19:{i:4;i:655375;i:9;i:1045887;i:16;i:782591;i:8;i:0;i:10;i:1048567;i:12;i:782847;i :3;i:655615;i:34;i:786431;i:36;i:1044599;i:14;i:1048575;i:2;i:782591;i:1;i:655367;i:7;i:78 2847;i:13;i:782591;i:6;i:1048575;i:11;i:1048063;i:5;i:1048063;i:17;i:1048063;i:37;i:104805 5;}}i:919;a:34:{s:7:\"forumid\";i:919;s:7:\"styleid\";i:0;s:5:\"title\";s:10:\"Çöp Kutusu\";s:11:\"title_clean\";s:10:\"Çöp Kutusu\";s:11:\"description\";s:0:\"\";s:17:\"description_clean\";s:0:\"\";s:7:\"options\" ;i:97987;s:11:\"showprivate\";i:0;s:12:\"displayorder\";i:99;s:10:\"lastpostid\";i:0;s:9:\ "daysprune\";i:-1;s:12:\"newpostemail\";s:0:\"\";s:14:\"newthreademail\";s:0:\"\";s:8:\"parentid\";i:-1;s:10:\"parentlist\";s:6:\"919,-1\";s:8:\"password\";s:0:\"\";s:4:\"link\";s:0:\"\";s:9:\"childlist\";s:10:\"919,920,-1\";s:16:\"defaultsortfield\";s:8:\"lastpost\";s:16:\"defaultsortorder\";s:4:\"desc\";s:12 :\"metakeywords\";s:0:\"\";s:15:\"metadescription\";s:0:\"\";s:17:\"dynguestmsg_title\";s: 0:\"\";s:11:\"dynguestmsg\";s:0:\"\";s:13:\"permmsg_title\";s:0:\"\";s:7:\"permmsg\";s:0:\ "\";s:10:\"accessf_nb\";i:0;s:10:\"accesst_nb\";i:0;s:9:\"create_nb\";i:0;s:8:\"reply_nb\" ;i:0;s:12:\"nuseo_domain\";s:0:\"\";s:7:\"podcast\";i:0;s:5:\"depth\";i:0;s:11:\"permissio ns\";a:19:{i:4;i:0;i:9;i:1045887;i:16;i:0;i:8;i:0;i:10;i:1048567;i:12;i:782847;i:3;i:0;i:3 4;i:786431;i:36;i:1044599;i:14;i:1048575;i:2;i:0;i:1;i:0;i:7;i:782847;i:13;i:0;i:6;i:10485 75;i:11;i:1048063;i:5;i:1048063;i:17;i:1048063;i:37;i:1048055;}}i:920;a:34:{s:7:\"forumid\ ";i:920;s:7:\"styleid\";i:0;s:5:\"title\";s:10:\"Çöp Kutusu\";s:11:\"title_clean\";s:10:\"Çöp Kutusu\";s:11:\"description\";s:0:\"\";s:17:\"description_clean\";s:0:\"\";s:7:\"options\" ;i:97991;s:11:\"showprivate\";i:0;s:12:\"displayorder\";i:1;s:10:\"lastpostid\";i:524011;s :9:\"daysprune\";i:-1;s:12:\"newpostemail\";s:0:\"\";s:14:\"newthreademail\";s:0:\"\";s:8:\"parentid\";i:919;s :10:\"parentlist\";s:10:\"920,919,-1\";s:8:\"password\";s:0:\"\";s:4:\"link\";s:0:\"\";s:9:\"childlist\";s:6:\"920,-1\";s:16:\"defaultsortfield\";s:8:\"lastpost\";s:16:\"defaultsortorder\";s:4:\"desc\";s:12 :\"metakeywords\";s:0:\"\";s:15:\"metadescription\";s:0:\"\";s:17:\"dynguestmsg_title\";s: 0:\"\";s:11:\"dynguestmsg\";s:0:\"\";s:13:\"permmsg_title\";s:0:\"\";s:7:\"permmsg\";s:0:\ "\";s:10:\"accessf_nb\";i:0;s:10:\"accesst_nb\";i:0;s:9:\"create_nb\";i:0;s:8:\"reply_nb\" ;i:0;s:12:\"nuseo_domain\";s:0:\"\";s:7:\"podcast\";i:0;s:5:\"depth\";i:1;s:11:\"permissio ns\";a:19:{i:4;i:0;i:9;i:1045887;i:16;i:0;i:8;i:0;i:10;i:1048567;i:12;i:782847;i:3;i:0;i:3 4;i:786431;i:36;i:1044599;i:14;i:1048575;i:2;i:0;i:1;i:0;i:7;i:782847;i:13;i:0;i:6;i:10485 75;i:11;i:1048063;i:5;i:1048063;i:17;i:1048063;i:37;i:1048055;}}}', 1);

    MySQL Error : Got a packet bigger than 'max_allowed_packet' bytes
    Error Number : 1153
    Date : Tuesday, May 6th 2008 @ 09:17:06 AM
    Script : http://www.hanemiz.com/admincp/forum.php?do=update
    Referrer : http://www.hanemiz.com/admincp/forum.php?do=add
    IP Address : 88.242.190.179
    Username : ArchiTecT
    Classname : vB_Database




    Not : dont max_allowed_packet problem

    tryed 128M 512M
  • Jake Bunce
    Senior Member
    • Dec 2000
    • 46598
    • 3.6.x

    #2
    > MySQL Error : Got a packet bigger than 'max_allowed_packet' bytes

    The error is clear. The max_allowed_packet setting in MySQL is being exceeded. You need to increase that setting in your MySQL configuration. If it didn't work when you increased it then maybe the change didn't take effect. Try restarting the MySQL server.

    Comment

    • Steve Machol
      Former Customer Support Manager
      • Jul 2000
      • 154488

      #3
      This is a server issue. You or your host will need to increase the 'max_allowed_packet' in my.cnf, then restart MySQL. I recommend at least 32M for this setting. If that doesn't work, try 64M.
      Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
      Change CKEditor Colors to Match Style (for 4.1.4 and above)

      Steve Machol Photography


      Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


      Comment

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