Another 2006 MySQL server has gone away issue

[maza]

Everytime I try to go into admin area, this same message will appear :

WARNING: The Admin Activity Log table has records over 2 months old and should be cleaned ... 04-01-2009 2006 MySQL server has gone away
in:
[select * from coupon_gv_queue where release_flag='N']
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

2006 MySQL server has gone away
in:
[select count(*) as total from sessions where sesskey = 'dc397e233f26bb9f6f496b2d33fe162e']
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Its been a while since I last logged into the admin area. It just suddenly happened. I did not do any change or upgrades as far as I can remember. The site in public mode works just fine (browsing, putting orders etc.)

Version : 1.3.7 (if not mistaken, already forgotten)
Hosting company : Malaysia Hosting 2 U
My Website : www.radiomeal.com

[data_digger]

There are two options:

• there are too many rows in those tables (common for sessions table, uncommon for coupon_gv_queuetable)
• table structure is damaged (common error for all tables)

Log in to phpmyadmin or similar tool and execute:

TRUNCATE table sessions;
REPAIR TABLE sessions;
REPAIR TABLE coupon_gv_queuetable; 

Should work. If it won't help execute also:

SELECT count(*) FROM coupon_gv_queuetable; 

And write here how many rows this table has. You can also execute

SHOW CREATE TABLE coupon_gv_queuetable; 

and copy it here.

If it does help consider switching to innodb tables (especially in case of sessions table).

[maza]

OK I can log into myphpadmin, but I don't know how to execute that command. A total newbie here

[data_digger]

There should be "SQL" button at top of the right panel. Click it and paste above 'queries' into it one by one (hit "GO" for each query).

[maza]

OK I got it executed successfully but it did not help to solve the problem. I still get the same message when trying to login.

BTW, this is what it shows when executing the SHOW CREATE TABLE command

coupon_gv_queue CREATE TABLE `coupon_gv_queue` (
`unique_id` int...

[data_digger]

There should be more output from SHOW CREATE TABLE. I'm mostly looking for character encoding, some versions of mysql does not support RLIKE against columns with ucs2 (AFAIR) character set.

[maza]

Well, that's the one I got from my phpadmin though. Not sure if I got it wrong.

[maza]

Hi, could somebody help with this issue? I can't go into my admin CP because of this...

[Ajeh]

I can get to your shop ...

I can get to the login page for your Zen Cart admin ...

What is it that you cannot get to?

When you say you cannot get to the admin CP do you mean the Zen Cart Admin? Or do you mean your domain control panel?

If you mean the Zen Cart Admin, do you get the login screen?

You need more details ... in one section it sounds like a problem with your Control Panel from your hosting provider (in which case you need to speak to them) and in another that you are having issues with your Zen Cart Admin ...

Type slowly now, I do not read fast ...

[maza]

Hi Linda,

Yes, I cannot log into my Zen Cart Admin. I can see the login screen, but whenever trying to login with my username and password, I will get the message like what I mentioned in my first post of this thread.

Help...!