vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)
-   -   MySQL error 1153 while editing forum in ACP (https://vborg.vbsupport.ru/showthread.php?t=301058)

Stefan118 08-11-2013 12:38 PM

MySQL error 1153 while editing forum in ACP
 
I was editing the discription of a forum, and when i pressed the save button i got this error.
I tried it again, and again the error.

Then i just entered a random forum in the ACP ( Forums & moderators --> Forum manager --> edit forum) and hit the save button. Again the error!

I disabled all the plugins to see if that was the issue, but i still get the error.

The error 1153 says: Got a packet bigger than 'max_allowed_packet' bytes.
I googled this, and there is a lot of info, infact... TOO much info.

What can i do about this?
Using vB 4.2.1

ForceHSS 08-11-2013 12:48 PM

You need to ask your host to allow you more send them the full error they will know what to do

Stefan118 08-11-2013 01:01 PM

ok...
not untill tomorow unfortunately.
Helpdesk closed in the weekends.

I tried to capture the error to show it here, but it is to big.

ForceHSS 08-11-2013 02:36 PM

You can upload it in a zip file if its that big we might be able to help with parts of it.

Stefan118 08-11-2013 05:35 PM

Good one...
I copied and pasted the error in a tekst document and it is only 1,21 mb large!!!
So i made it a zipfile indeed.

My forum is in dutch language, so parts of the tekst in the error are also dutch.

The attached document contains the error i got while i had all plugins disabled.

ForceHSS 08-12-2013 03:19 PM

in your /includes/config.php file, what is listed for "$config['Datastore']['class']" or is that commented out (which is the default)?
I'd suggest reuploading all the default files
Run this just in case
vBulletin Manual

Stefan118 08-12-2013 05:14 PM

In the config.php file it should be standard... I did not changed it. Maybe the previous owner, but the last 3 years i own the forum it has not been changed.

What it says is: $config['Datastore']['class'] = 'vB_Datastore_Memcached';

Edit 1:
Ho, wait... It is commented out.
Compleet script part is:
/*
$config['Datastore']['class'] = 'vB_Datastore_Memcached';
$i = 0;
// First Server
$i++;
$config['Misc']['memcacheserver'][$i] = '127.0.0.1';
$config['Misc']['memcacheport'][$i] = 11211;
$config['Misc']['memcachepersistent'][$i] = true;
$config['Misc']['memcacheweight'][$i] = 1;
$config['Misc']['memcachetimeout'][$i] = 1;
$config['Misc']['memcacheretry_interval'][$i] = 15;
*/

Edit 2:
I reuploaded all files.
Tried it again, same error.
Updated and repaired the database, and after that i tried to update the counters.
All were updated fine, exept Rebuilding forum information. Here i got the same 1153 error.
So the problem seems to be in creating, editing, updating etc the forum part.

ForceHSS 08-12-2013 10:41 PM

might be best to put in a support ticket i am to tired to think

Zachery 08-12-2013 10:43 PM

Remove your attachment, the datastore can have some sensitive information.

Like I responded in your ticket:
MySQL Error : Got a packet bigger than 'max_allowed_packet' bytes

This isn't an issue a database restore could ever fix. More data than is allowed was sent to MySQL, MySQL freaked out.

ForceHSS 08-13-2013 12:14 AM

Sorry i could not help more did not get the best sleep last nite and its hard to think when i am tired but after having a short rest was just about to say what support said too you


All times are GMT. The time now is 02:41 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.00958 seconds
  • Memory Usage 1,728KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (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)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete