[Done v155] PHP Fatal error: 1062uplicate entry '0' for key 'PRIMARY'

[mydakota]

ok i have copying pasting this into sql section of admin panel didn't help me still issue is still there i would have though this would have fixed it.

# This script simply rebuilds the auto-increment settings on tables which should have them.
# $ Id: $

ALTER TABLE upgrade_exceptions CHANGE COLUMN upgrade_exception_id upgrade_exception_id smallint(5) NOT NULL auto_increment;
ALTER TABLE address_book CHANGE COLUMN address_book_id address_book_id int(11) NOT NULL auto_increment;
ALTER TABLE address_format CHANGE COLUMN address_format_id address_format_id int(11) NOT NULL auto_increment;
ALTER TABLE admin CHANGE COLUMN admin_id admin_id int(11) NOT NULL auto_increment;
ALTER TABLE admin_activity_log CHANGE COLUMN log_id log_id int(15) NOT NULL auto_increment;
ALTER TABLE authorizenet CHANGE COLUMN id id int(11) unsigned NOT NULL auto_increment;
ALTER TABLE banners CHANGE COLUMN banners_id banners_id int(11) NOT NULL auto_increment;
ALTER TABLE banners_history CHANGE COLUMN banners_history_id banners_history_id int(11) NOT NULL auto_increment;
ALTER TABLE categories CHANGE COLUMN categories_id categories_id int(11) NOT NULL auto_increment;
ALTER TABLE configuration CHANGE COLUMN configuration_id configuration_id int(11) NOT NULL auto_increment;
ALTER TABLE configuration_group CHANGE COLUMN configuration_group_id configuration_group_id int(11) NOT NULL auto_increment;
ALTER TABLE countries CHANGE COLUMN countries_id countries_id int(11) NOT NULL auto_increment;
ALTER TABLE coupon_email_track CHANGE COLUMN unique_id unique_id int(11) NOT NULL auto_increment;
ALTER TABLE coupon_gv_queue CHANGE COLUMN unique_id unique_id int(5) NOT NULL auto_increment;
ALTER TABLE coupon_redeem_track CHANGE COLUMN unique_id unique_id int(11) NOT NULL auto_increment;
ALTER TABLE coupon_restrict CHANGE COLUMN restrict_id restrict_id int(11) NOT NULL auto_increment;
ALTER TABLE coupons CHANGE COLUMN coupon_id coupon_id int(11) NOT NULL auto_increment;
ALTER TABLE currencies CHANGE COLUMN currencies_id currencies_id int(11) NOT NULL auto_increment;
ALTER TABLE customers CHANGE COLUMN customers_id customers_id int(11) NOT NULL auto_increment;
ALTER TABLE customers_basket CHANGE COLUMN customers_basket_id customers_basket_id int(11) NOT NULL auto_increment;
ALTER TABLE customers_basket_attributes CHANGE COLUMN customers_basket_attributes_id customers_basket_attributes_id int(11) NOT NULL auto_increment;
ALTER TABLE email_archive CHANGE COLUMN archive_id archive_id int(11) NOT NULL auto_increment;
ALTER TABLE featured CHANGE COLUMN featured_id featured_id int(11) NOT NULL auto_increment;
ALTER TABLE files_uploaded CHANGE COLUMN files_uploaded_id files_uploaded_id int(11) NOT NULL auto_increment;
ALTER TABLE geo_zones CHANGE COLUMN geo_zone_id geo_zone_id int(11) NOT NULL auto_increment;
ALTER TABLE group_pricing CHANGE COLUMN group_id group_id int(11) NOT NULL auto_increment;
ALTER TABLE ezpages CHANGE COLUMN pages_id pages_id int(11) NOT NULL auto_increment;
ALTER TABLE languages CHANGE COLUMN languages_id languages_id int(11) NOT NULL auto_increment;
ALTER TABLE layout_boxes CHANGE COLUMN layout_id layout_id int(11) NOT NULL auto_increment;
ALTER TABLE manufacturers CHANGE COLUMN manufacturers_id manufacturers_id int(11) NOT NULL auto_increment;
ALTER TABLE media_clips CHANGE COLUMN clip_id clip_id int(11) NOT NULL auto_increment;
ALTER TABLE media_manager CHANGE COLUMN media_id media_id int(11) NOT NULL auto_increment;
ALTER TABLE media_types CHANGE COLUMN type_id type_id int(11) NOT NULL auto_increment;
ALTER TABLE music_genre CHANGE COLUMN music_genre_id music_genre_id int(11) NOT NULL auto_increment;
ALTER TABLE newsletters CHANGE COLUMN newsletters_id newsletters_id int(11) NOT NULL auto_increment;
ALTER TABLE orders CHANGE COLUMN orders_id orders_id int(11) NOT NULL auto_increment;
ALTER TABLE orders_products CHANGE COLUMN orders_products_id orders_products_id int(11) NOT NULL auto_increment;
ALTER TABLE orders_products_attributes CHANGE COLUMN orders_products_attributes_id orders_products_attributes_id int(11) NOT NULL auto_increment;
ALTER TABLE orders_products_download CHANGE COLUMN orders_products_download_id orders_products_download_id int(11) NOT NULL auto_increment;
ALTER TABLE orders_status_history CHANGE COLUMN orders_status_history_id orders_status_history_id int(11) NOT NULL auto_increment;
ALTER TABLE orders_total CHANGE COLUMN orders_total_id orders_total_id int(10) unsigned NOT NULL auto_increment;
ALTER TABLE paypal_session CHANGE COLUMN unique_id unique_id int(11) NOT NULL auto_increment;
ALTER TABLE paypal CHANGE COLUMN paypal_ipn_id paypal_ipn_id int(11) unsigned NOT NULL auto_increment;
ALTER TABLE paypal_testing CHANGE COLUMN paypal_ipn_id paypal_ipn_id int(11) unsigned NOT NULL auto_increment;
ALTER TABLE paypal_payment_status CHANGE COLUMN payment_status_id payment_status_id int(11) NOT NULL auto_increment;
ALTER TABLE paypal_payment_status_history CHANGE COLUMN payment_status_history_id payment_status_history_id int(11) NOT NULL auto_increment;
ALTER TABLE product_type_layout CHANGE COLUMN configuration_id configuration_id int(11) NOT NULL auto_increment;
ALTER TABLE product_types CHANGE COLUMN type_id type_id int(11) NOT NULL auto_increment;
ALTER TABLE products CHANGE COLUMN products_id products_id int(11) NOT NULL auto_increment;
ALTER TABLE products_attributes CHANGE COLUMN products_attributes_id products_attributes_id int(11) NOT NULL auto_increment;
ALTER TABLE products_description CHANGE COLUMN products_id products_id int(11) NOT NULL auto_increment;
ALTER TABLE products_options_values_to_products_options CHANGE COLUMN products_options_values_to_products_options_id products_options_values_to_products_options_id int(11) NOT NULL auto_increment;
ALTER TABLE project_version CHANGE COLUMN project_version_id project_version_id tinyint(3) NOT NULL auto_increment;
ALTER TABLE project_version_history CHANGE COLUMN project_version_id project_version_id tinyint(3) NOT NULL auto_increment;
ALTER TABLE query_builder CHANGE COLUMN query_id query_id int(11) NOT NULL auto_increment;
ALTER TABLE record_artists CHANGE COLUMN artists_id artists_id int(11) NOT NULL auto_increment;
ALTER TABLE record_company CHANGE COLUMN record_company_id record_company_id int(11) NOT NULL auto_increment;
ALTER TABLE reviews CHANGE COLUMN reviews_id reviews_id int(11) NOT NULL auto_increment;
ALTER TABLE salemaker_sales CHANGE COLUMN sale_id sale_id int(11) NOT NULL auto_increment;
ALTER TABLE specials CHANGE COLUMN specials_id specials_id int(11) NOT NULL auto_increment;
ALTER TABLE tax_class CHANGE COLUMN tax_class_id tax_class_id int(11) NOT NULL auto_increment;
ALTER TABLE tax_rates CHANGE COLUMN tax_rates_id tax_rates_id int(11) NOT NULL auto_increment;
ALTER TABLE template_select CHANGE COLUMN template_id template_id int(11) NOT NULL auto_increment;
ALTER TABLE zones CHANGE COLUMN zone_id zone_id int(11) NOT NULL auto_increment;
ALTER TABLE zones_to_geo_zones CHANGE COLUMN association_id association_id int(11) NOT NULL auto_increment;

[mydakota]

Looks like I either need to start from scratch a new site or change hosting company's as it would seem to be a I issue with the CrazyDomains server weird though as all worked ok until I had to restore site all my back ups were done correctly as per instructions on ZenCart site for php 5.5 eprox version . So if I rebuild my site and have to restore it I'll just have to keep rebuilding it over and over how much fun . Would seem the CrazyDomains team have no idea what this error is

[mydakota]

Crazy domains server

https://onedrive.live.com/redir?resi...OZBCcoYgRr8iMA

Local host wamp server

https://onedrive.live.com/redir?resi...FcWxkavZChMV4A

Lol yes my desktop is full lol

[webmanstudios]

Hi mydakota,

I had/have the same issue on a Crazy Domains on a shared server.

I feel it's definitely a CD issue, although they insist is a ZC issue and to talk to the developer about fixing the issue. It happened to my site a little while back, after they updated their servers.

i haven't been able to find a fix for the issue here in the forums or online and my attributes for products currently doesn't work. I have implemented a Neanderthal technology solution, basically advising customers to enter their attribute options in the comments section of the special instructions form of the checkout forms - most do, but now and again a customer forgets or overlooks entering the details and a simple phone call is in order to determine the customer attribute options.

So the bottom line, until I get time to rebuild the site from scratch my Neanderthal solution will have to do.

Good luck sorting out your issue. :)

kind Regards

les :)

[mydakota]

hi thanks for this info yes its defiantly there servers i was hesitant on using crazy-domains as my host. ill will give them the opportunity to fix the issue before i dedicate my life to warning others with videos and spam bots lol I did find a way to get attributes to work and apply by going into phpmyadmin and under product attributes i find the attribute with a 0 as its id and manually call it something like 22 or similar to the other attributes but not the same then i can add more but have to keep manually change its attribute id in phpmyadmin maybe a easier way for you to at least update your attributes. I will prob be forced down this path but if i have to rebuild my site i will move hosting company's to one that actually can run zen-cart properly. but before i jump the gun ill give them some time to fix this and keep you updated on a possible fix if i find one.

[kobra]

mydakota,
I was looking back through the information you supplied and did not see php ver or mysql ver

Using ZC v1.5.4 I believe requires the mysqli extentions

You can go to your admin > tools > server/version info and see if msqli is present

BTW: This is not a "bug" so someone might relocate this posting

[mydakota]

we are still to determine weather this is a zencart or server issue so could easily be a bug

[Design75]

we are still to determine weather this is a zencart or server issue so could easily be a bug

What I think Cobra meant, was that it is not a bug in a default Zen Cart setup, but it may stil be a "bug" in your configuration, but then it should not be in the bugs section of the forum.
Have you tried running your site on a localhost like xampp? if it runs ok there, we could probably rule out an error in the site.

[mydakota]

works fine on my wamp server no issues at all

[mc12345678]

Have searched a little more on this issue. The problem described typically comes from the mysql server having the mode: NO_AUTO_VALUE_ON_ZERO set. Review of the settings appears possible through direction offered on the following mysql page: http://dev.mysql.com/doc/refman/5.7/..._value_on_zero

Specifically through a query such as:

SELECT @@GLOBAL.sql_mode;
SELECT @@SESSION.sql_mode;

Would have to work with the hosting company about disabling the above mode either globally or for you.