1062 Duplicate entry '32767' for key 1- Help!

[TennisStringman]

Tonight while navigating from my admin page I get this error message on a white screen. What gives, this is the first time my Zen Cart software isn't working in 1 1/2 years! I haven't changed a thing. I need help, thanks. Fortunately my url TennisStringman.com appears to be working

[DrByte]

Sounds like you're running v1.2.5 and haven't got the fix for this that was built-in to the v1.2.6 upgrade.

Details on this specific issue here:
http://www.zen-cart.com/forum/showthread.php?t=20087

[TennisStringman]

DrByte, thanks for helping out. I tried your advise:

To fix this via phpMyAdmin, access your Zen Cart database and click on the SQL tab, then paste the following in the input field and click Go:
Quote:
ALTER TABLE admin_activity_log CHANGE COLUMN log_id log_id int(15) NOT NULL auto_increment;

But I'm getting the error:

Error

SQL query:

ALTER TABLE admin_activity_log CHANGE COLUMN log_id log_id int( 15 ) NOT NULL AUTO_INCREMENT

MySQL said: Documentation
#1146 - Table 'tennisst_zc1.admin_activity_log' doesn't exist

Maybe I am not accessing the datebase correctly? Should I update to version 1.2.6, will that fix it automactically?
Thanks,
TennisStringman

[DrByte]

If you're going to upgrade, I suggest going to the latest version. Or *at least* 1.2.7 if you're not prepared to jump to the 1.3 series which has a much easier templating system and oodles of new features etc.


As to dealing with your current issue, you likely have table prefixes of "zen_" on all your tablenames. As such, change "ALTER TABLE admin_activity_log ..." to "ALTER TABLE zen_admin_activity_log ..."

[TennisStringman]

Thanks, DrByte. I will upgrade to the lastest when I come back from vacation in a couple of weeks when I have time to read the enormous notes on upgrading. It looks like a daunting task.

[kdtaylor]

Hi.. I am in desperate need of some help!

I am getting this error also
--
1062 Duplicate entry '21280' for key 1
in:
[insert into zen_admin_activity_log (access_date, admin_id, page_accessed, page_parameters, ip_address) values (now(), '2', 'alt_nav.php', '', '124.180.88.19')]
--

I can't get to any of my admin pages at all to even tell you what version I am using. But it was installed about two years ago.

We have not made any changes to our database in some time, however there is a note saying that the activity log needs cleaned. Would this be the problem? I can't even click on the reset button as I get the same error.

I have looked in the zen_admin_activity_log and there is no entry for the value of 21280? The last was 21279..

Could someone please point me in the right direction. The solution linked in the post above does not allow me to access it!

Many thanks
Karen

[kdtaylor]

Disaster averted!

I did a repair on the table and it is now working again!
We had a power outage yesterday and I think that somehow it affected the database.. that was the only change!

REPAIR TABLE zen_admin_activity_log