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

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19512
Website

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

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19512
Website

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

 

Board footer