NukeCops Search Returns SQL Error (multiple times)

Nuke Cadet Joined: Feb 28, 2007 Posts: 5

Quote:

Could not delete old search id sessions

DEBUG MODE

SQL Error : 1153 Got a packet bigger than 'max_allowed_packet'

I've received this error now several times at different instances since I've registered here. I go to Search and the last two instances I received this error were when I ran queries for "images aren't displayed" and "no images" leaving all of the default search options selected. What get's returned is my browser almost crashing, the above error, and hundreds of lines of crap.

Please resolve this issue, thank you.

Posted: Fri Mar 09, 2007 11:12 am

BenXP wrote:

Quote:

Could not delete old search id sessions

DEBUG MODE

SQL Error : 1153 Got a packet bigger than 'max_allowed_packet'

I've received this error now several times at different instances since I've registered here. I go to Search and the last two instances I received this error were when I ran queries for "images aren't displayed" and "no images" leaving all of the default search options selected. What get's returned is my browser almost crashing, the above error, and hundreds of lines of crap.

Please resolve this issue, thank you.

This is a very very busy site and the amount of queries at any given time on this site could easily shut down the mysql server if it's not controlled with a limited amount of connections. My suggestion to you would be wait until there arn't so many people on the site ! At the time of your post here, there were more than 800 Shocked

Though, this is just my guess .

Site Admin Joined: Aug 17, 2003 Posts: 12373

It is a server issue, I really can't solve it.

I will be redoing the forums soon to remedy this problem.

Sergeant Joined: Feb 04, 2004 Posts: 100

As with my site, this happens to busy phpnuke sites. The fix is located here and it definitely works:
http://www.karakas-online.de/forum/viewtopic.php?t=3546&start=0&postdays=0&postorder=asc&highlight=

Sergeant Joined: Feb 04, 2004 Posts: 100

I see those links have been replaced... bummer. Look for nuke_bbsessions full in his site, this fix is there.

Nuke Cadet Joined: Feb 28, 2007 Posts: 5

Sorry to see that it would involve that much work Evaders, good luck. Sad

Thanks for the responses as well.

Nuke Cadet Joined: Mar 16, 2007 Posts: 2

Noticed a bug on your site which almost deterred me because I couldn't register. After being patient and having a look around, I found another way to register. But here's the problem:

Browse to http://www.nukecops.com .
Click 'Forums'.
Click 'Register' (Center of the screen).
Click 'I Agree to these terms and am over or exactly 13 years of age'
Fill out the form and click 'Submit'.
It will tell you that you have entered the wrong code.

Site Admin Joined: Aug 17, 2003 Posts: 12373

Thanxs.. though I'm not sure if you are reporting an error with the Your_Account registration.

I will probably be disabling the forums registration as that causes many headaches like the error you've found.

Corporal Joined: Oct 15, 2003 Posts: 58

Can it be emptied by phpmyadmin? now? the nuke bbsession
If you let it grow it can be up to 30-40 meg and script timeout even by phpmyadmin
it wil consume the server resource with delay insertion and timeout
same I have and ,finally fixed by backup all sql-->manually fix-->dump again

Corporal Joined: Oct 15, 2003 Posts: 58

I think truncate data in nuke_bbsessions as said in
http://www.phpbb.com/community/viewtopic.php?p=395722
can fix the problem ?

Sergeant Joined: Feb 04, 2004 Posts: 100

this issue can be fixed in 2 mins. My forum is just as big as this one and this fixed it.
http://www.phpbb.com/community/viewtopic.php?p=395722

Site Admin Joined: Aug 17, 2003 Posts: 12373

Note: this is a different error than the sessions table error. Searching is much more complicated, as such I will be redoing the forums at a future date

Sergeant Joined: Feb 04, 2004 Posts: 100

exactly... This was the fix I used for the search problem you "were" having. Until this fix I had to manually empty the sessions every few hours.

Looks like you fixed things. what do you do?

Nuke Soldier Joined: Oct 03, 2005 Posts: 21

I have been experiencing the same problem for days now with the search engine returing the exact same error as the first post in this thread.

Site Admin Joined: Aug 17, 2003 Posts: 12373

Thank you, noted.