1062 Duplicate entry '0' for key 1 after export/import of database

[DrByte]

I am experiencing this problem in my admin area when I try to go anywhere.

What can be done to correct this?

cshart

1. Run the SQL statements above, via phpMyAdmin
2. Use phpMyAdmin to do a Database Backup, and then click on the admin_activity_log table and click the "Empty" button.

[jdimaging]

Dr. Byte, thank you so much for this script. I have spent the last week moving sites and this overwhelmed me. I found your script, ran it and voila. Thank you.

Darlene

[ljdream00]

Dr. Byte.... You are the Greatest. your script fixed my issue. Thanks

[tigergirl]

1. Run the SQL statements above, via phpMyAdmin
2. Use phpMyAdmin to do a Database Backup, and then click on the admin_activity_log table and click the "Empty" button.

Thank you so much DrByte! I just had to do this and it worked PERFECTLY! You're a sanity saver!
Leah

[virtualahmad]

Dr. Byte, thank you so much for this script. I have spent the last week moving sites and this overwhelmed me. I found your script, ran it and voila. Thank you.

Darlene

Ditto !

[drbyday]

Drbyte!

Please can you create a SQL command for phpmyadmin for zencart version 1.2.1?

Please, I would really appreciate it.

[LloydR]

Hi All

I could really use some help with my issue:
1062 Duplicate entry '0' for key 1
in:
[insert into banners_history (banners_id, banners_shown, banners_history_date) values ('52', 1, now())]


Link to my site:
http://www.digitalsaonline.co.za/catalog/

I have done everything on this forum as suggested and still having the same issue

I have cleared history on all tables that i could find listed here, have run the SQL script and have gone and DEL all my banners in PHPmyAdmin

What else do i need to do to fix this

Issue is coming up in both site and admin

Admin error is:
1062 Duplicate entry '0' for key 1
in:
[insert into admin_activity_log (access_date, admin_id, page_accessed, page_parameters, ip_address) values (now(), '1', 'store_manager.php', '', '198.54.202.30')]
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.


All help appreciated

Thanks

[LloydR]

Hi All

Any update please or help on my post?

[DrByte]

When did this start happening?
How does that relate to things done to your webserver or your site or your database or your hosting account?
What version of Zen Cart? Is this an upgrade? from which version(s)? When?
What addons do you have installed?




Side-note: the proper etiquette for "bumping" your post is to post more information about the problem, not just say "help". Related info: http://www.zen-cart.com/forum/faq.ph...aq_do_and_dont

[LloydR]

When did this start happening?
How does that relate to things done to your webserver or your site or your database or your hosting account?
What version of Zen Cart? Is this an upgrade? from which version(s)? When?
What addons do you have installed?




Side-note: the proper etiquette for "bumping" your post is to post more information about the problem, not just say "help". Related info: http://www.zen-cart.com/forum/faq.ph...aq_do_and_dont

Thank you so much for the reply
My site generates income for my family and really need to get it working for my clients to purchase from me from tomorrow

It started yesterday
Not sure i understand your second ?
Not an upgrade, its a install from zencart zip files, version "New Version Available v1.3.8" so i think its version 1.3.7
Started my site a year ago and moved to new hosting company about 5 months ago, all has been working fine
Add ons:
I think the cart editor addon, allows me to edit client orders, thats about it

Thanks again for the reply