Kryptronic Software Support Forum
You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.
#1 09-29-2004 18:27:00
- terrygreen
- Member
- Registered: 09-29-2004
- Posts: 2
Unable To Update Catagory
Our cart is able to add new products to the cart properly but when managing the product to catagory with the "relate", or add a new catagory it gives a script error as follows:
Script Execution Error
The following error was just encountered:
DBD::mysql::db do failed: Duplicate entry '1' for key 1 at /home/virtual/portermax.com/var/www/cgi-bin/ccp5/library/common/database.pl line 526.
the database being used is MySql, and everything else is working properly but the updating of catagories. Any help would be greatly helpful. Thanks!
Offline
#2 10-01-2004 14:14:45
Re: Unable To Update Catagory
Switch the tables:
category
prodxcat
Back into CSV mode, then download the files:
./data/tables/category.csv
./data/tables/prodxcat.csv
And edit them with Excel. Make sure you have no blank lines or duplicate *_id fields in the files. Upload back to the server in BINARY mode & switch back to MySQL.
Nick Hendler
Offline
#3 10-03-2004 23:41:35
- terrygreen
- Member
- Registered: 09-29-2004
- Posts: 2
Re: Unable To Update Catagory
Thank you very much for the advise, but after doing just as you suggest the prodxcat.csv is now not able to switch back to MySql, giving the same script error. There didn't appear to be anything wrong with the file, as there were no blanks or repeats. Might there be anything else to try? Many thanks... Terry
Offline
#4 10-11-2004 09:14:40
Re: Unable To Update Catagory
Is there an error in the logs? Can you try an import using a utility like PHPMyAdmin and do you see an error message there? There is most likely a duplicate key issue.
Nick Hendler
Offline