Post by ikhlief » Sun Oct 13, 2013 7:08 pm

Hi,

I am trying to create new category but I get the following error:
Notice: Error: Duplicate entry '0' for key 'PRIMARY'
Error No: 1062
INSERT INTO category SET parent_id = '0', `top` = '1', `column` = '1', sort_order = '0', status = '1', date_modified = NOW(), date_added = NOW() in /home1/jecjo/public_html/jecjordan.com/system/database/mysql.php on line 50

I have a lot of modification and don't know when this start, so I deleted all old files and uploaded new files without modifications to make sure that it's not something from the files and the same problem!!!

Please help my site is closed now because of this.

Thanks

Active Member

Posts

Joined
Wed Nov 24, 2010 9:15 pm

Post by ikhlief » Mon Oct 14, 2013 2:16 am

I noticed something. It creats first category normaly but give the category id 0 in phpAdmin. When you create second category it gives him the same id 0 so I got the error!!!!
Please I need help.

Active Member

Posts

Joined
Wed Nov 24, 2010 9:15 pm

Post by ikhlief » Tue Oct 15, 2013 4:54 am

Any suggestions please? Thanks for your help but my store is stopped since three days because of this.

Active Member

Posts

Joined
Wed Nov 24, 2010 9:15 pm

Post by Qphoria » Tue Oct 15, 2013 5:12 am

Hmm that almost sounds like the category_id field isn't setup as an autoincrement field. This is a fresh 1.5.6 install?

Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am

Post by ikhlief » Tue Oct 15, 2013 5:21 am

I tried to upgrade to V1.5.6 from 1.5.5.1 but the upgrade didn't completed as I got error, and each time I visit my site it gives me the upgrade steps again, so I decided to cancel upgrade and to go back for my old version, so I installed the old files again and my site worked normally for about one month in front end, but when I tried to create new categories a couple of days ago and tried to take database I started to get these errors!!

Active Member

Posts

Joined
Wed Nov 24, 2010 9:15 pm

Post by ikhlief » Wed Oct 16, 2013 7:58 pm

Any suggestions?

Active Member

Posts

Joined
Wed Nov 24, 2010 9:15 pm
Who is online

Users browsing this forum: Amazon [Bot], Google [Bot] and 64 guests