Thread: Top Urgent , MySQL Error
View Single Post
  #1  
Old 08-06-2009, 08:34 PM
fadiodeh's Avatar
fadiodeh fadiodeh is offline
 
Join Date: May 2008
Posts: 25
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Top Urgent , MySQL Error
Hi there,

my issue ,, when i tried move any thread from forum to another i got this error

Invalid SQL:

REPLACE INTO genfdatastore
(title, data, unserialize)
VALUES
('forumcache', 'a:700:{i:142;a:28:{s:7:\"forumid\";i:142;s:7:\"st yleid\";i:0;s:5:\"title\";s:79:\"<img class=\"inlineimg\" border=\"0\" src=\"images/thread_bst.gif\">.............................
.................................................. .................................................. .............................
.................................................. .................................................. .............................
MySQL Error : Got a packet bigger than 'max_allowed_packet' bytes
Error Number : 1153
Request Date : Friday, August 7th 2009 @ 04:24:24 AM
Error Date : Friday, August 7th 2009 @ 04:24:27 AM
Script : http://www.airssforum.com/inlinemod....&threadids=475
Referrer : http://www.airssforum.com/login.php?do=login
IP Address : 86.108.105.107
Username : Admin
Classname : vB_Database
MySQL Version : 5.0.45-log

---------------------------

please note replace ...................................... lines ,, very huge data , its about thousands of lines its just about data about forums like this..

\";s:8:\"password\";s:0:\"\";s:4:\"link\";s:0:\"\" ;s:9:\"childlist\";s:5:\"34,-1\";s:10:\"lastpostid\";i:292395;s:11:\"showprivat e\";i:0;s:16:\"defaultsortfield\";s:8:\"lastpost\" ;s:16:\"defaultsortorder\";s:4:\"desc\";s:11:\"ima geprefix\";s:0:\"\";s:19:\"cyb_lpienhancements\";i :1;s:23:\"vbseo_moderatepingbacks\";i:1;s:24:\"vbs eo_moderatetrackbacks\";i:1;s:22:\"vbseo_moderater efbacks\";i:1;s:7:\"podcast\";i:0;s:5:\"depth\";i: 3;s:11:\"permissions\";a:42:{i:4;i:0;i:51;i:131072 ;i:10;i:131072;i:30;i:131072;i:50;i:3932159;i:29;i :4193791;i:9;i:3928319;i:27;i:131080;i:8;i:0;i:14; i:131072;i:20;i:131072;i:19;i:131072;i:18;i:131072 ;i:24;i:131072;i:16;i:131072;i:26;i:131072;i:21;i: 131072;i:25;i:131072;i:22;i:131072;i:15;i:131072;i :17;i:131072;i:23;i:131072;i:6;i:8388607;i:48;i:0; i:45;i:651271;i:44;i:1044719;i:7;i:3932159;i:42;i: 131072;i:12;i:131072;i:11;i:131072;i:2;i:131072;i: 33;i:131072;i:5;i:8388607;i:47;i:131080;i:1;i:1310 72;i:49;i:0;i:3;i:131072;i:31;i:131072;i:32;i:1310 72;i:52;i:651271;i:46;i:131080;i:13;i:131072;}}i:3 2;a:28:{s:7:\"forumid\";i:32;s:7:\"styleid\";i:0;s :5:\"title\";s:26:\"دوحــة الإقتراحات والشكاوي\";s:11:\"title_clean\";s:26:\"دوحــة الإقتراحات والشكاوي\";s:11:\"description\";s:0:\"\";s:17:\"de scription_clean\";s:0:\"\";s:7:\"options\";i:11027 9;s:12:\"displayorder\";i:555;s:9:\"daysprune\";i:-1;s:12:\"newpostemail\";s:0:\"\";s:14:\"newthreade mail\";s:0:\"\";s:8:\"parentid\";i:790;s:10:\"pare ntlist\";s:16:\"32,790,791,31,-1\";s:8:\"password\";s:0:\"\";s:4:\"link\";s:0:\"\ ";s:9:\"childlist\";s:5:\"32,-1\";s:10:\"lastpostid\";i:297803;s:11:\"showprivat e\";i:0;s:16:\"defaultsortfield\";s:8:\"lastpost\" ;s:16:\"defaultsortorder\";s:4:\"desc\";s:11:\"ima geprefix\";s:0:\"\";s:19:\"cyb_lpienhancements\";i :1;s:23:\"vbseo_moderatepingbacks\";i:1;s:24:\"vbs eo_moderatetrackbacks\";i:1;s:22:\"vbseo_moderater efbacks\";i:1;s:7:\"podcast\";i:0;s:5:\"depth\";i: 3;s:11:\"permissions\";a:42:{i:4;i:0;i:51;i:171217 7;i:10;i:1703985;i:30;i:1708081;i:50;i:3932159;i:2 9;i:4193791;i:9;i:3928319;i:27;i:1761341;i:8;i:0;i :14;i:1712177;i:20;i:1712177;i:19;i:1712177;i:18;i :1712177;i:24;i:1712177;i:16;i:1712177;i:26;i:1712 177;i:21;i:1712177;i:25;i:1712177;i:22;i:1712177;i :15;i:1703985;i:17;i:1712177;i:23;i:1712177;i:6;i: 8388607;i:48;i:0;i:45;i:651271;i:44;i:1044719;i:7; i:3928319;i:42;i:1831989;i:12;i:1703985;i:11;i:171 6273;i:2;i:1831989;i:33;i:131072;i:5;i:8388607;i:4 7;i:1761341;i:1;i:655374;i:49;i:0;i:3;i:131072;i:3 1;i:131072;i:32;i:131072;i:52;i:651271;i:46;i:1761 341;i:13;i:1708081;}}i:48;a:28:{s:7:\"forumid\";i: 48;s:7:\"styleid\";i:0;s:5:\"title\";s:12:\"منتدى الزوار\";s:11:\"title_clean\";s:12:\"منتدى الزوار\";s:11:\"description\";s:44:\"يمكن للزوار غير المسجلين من عرض مواضيعهم هنا\";s:17:\"description_clean\";s:44:\"يمكن للزوار غير المسجلين من عرض مواضيعهم هنا\";s:7:\"options\";i:141055;s:12:\"displayorder \";i:666;s:9:\"daysprune\";i:-1;s:12:\"newpostemail\";s:0:\"\";s:14:\"newthreade mail\";s:0:\"\";s:8:\"parentid\";i:790;s:10:\"pare ntlist\";s:16:\"48,790,791,31,-1\";s:8:\"password\";s:0:\"\";s:4:\"link\";s:0:\"\ ";s:9:\"childlist\";s:5:\"48,-1\";s:10:\"lastpostid\";i:0;s:11:\"showprivate\";i :0;s:16:\"defaultsortfield\";s:8:\"lastpost\";s:16 :\"defaultsortorder\";s:4:\"desc\";s:11:\"imagepre fix\";s:0:\"\";s:19:\"cyb_lpienhancements\";i:1;s: 23:\"vbseo_moderatepingbacks\";i:1;s:24:\"vbseo_mo deratetrackbacks\";i:1;s:22:\"vbseo_moderaterefbac ks\";i:1;s:7:\"podcast\";i:0;s:5:\"depth\";i:3;s:1 1:\"permissions\";a:42:{i:4;i:655374;i:51;i:131072 ;i:10;i:0;i:30;i:0;i:50;i:0;i:29;i:0;i:9;i:131072; i:27;i:131072;i:8;i:0;i:14;i:131072;i:20;i:131072; i:19;i:131072;i:18;i:131072;i:24;i:131072;i:16;i:1 31072;i:26;i:131072;i:21;i:131072;i:25;i:131072;i: 22;i:131072;i:15;i:131072;i:17;i:131072;i:23;i:131 072;i:6;i:8388607;i:48;i:131072;i:45;i:131072;i:44 ;i:131072;i:7;i:3928574;i:42;i:188416;i:12;i:0;i:1 1;i:0;i:2;i:188416;i:33;i:655374;i:5;i:2814031;i:4 7;i:131072;i:1;i:135217;i:49;i:0;i:3;i:655374;i:31 ;i:655374;i:32;i:655374;i:52;i:651271;i:46;i:13107 2;i:13;i:0;}}i:227;a:28:



Thank you
Fadi Odeh
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01612 seconds
  • Memory Usage 1,789KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete