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 01-21-2006 16:56:34
Product Table Not Converting
Am in the process of converting CCP5.0 from CSV to MySQL, and most tables are converting with no problems at all. However, I did run into some problems with three or four tables -- but the one I am most concerned about is the product table. When I click to change it, it loads this into a blank page:
Code:
CREATE TABLE product (product_id VARCHAR(30) PRIMARY KEY,product_name VARCHAR(60),product_number VARCHAR(30),product_pricestatus VARCHAR(4),product_regprice VARCHAR(10),product_saleprice VARCHAR(10),product_volprice VARCHAR(200),product_voltext TEXT,product_recurprice VARCHAR(10),product_recurstatus VARCHAR(4),product_keywords VARCHAR(100),product_usecatdisc VARCHAR(4),product_taxstateprov VARCHAR(4),product_taxcountry VARCHAR(4),product_useinv VARCHAR(4),product_inv VARCHAR(10),product_usemax VARCHAR(4),product_max VARCHAR(10),product_imgxlguse VARCHAR(4),product_imgxlg VARCHAR(30),product_imglg VARCHAR(25530),product_imgsm VARCHAR(30),product_lgdisp VARCHAR(30),product_addemtext TEXT,product_splashdisp VARCHAR(4),product_new VARCHAR(4),product_special VARCHAR(4),product_bestsell VARCHAR(4),product_descshort TEXT,product_desclong TEXT,product_delmethod VARCHAR(40),product_dlfile VARCHAR(30),product_shiplocal VARCHAR(40),product_shipint VARCHAR(40),product_shipweight VARCHAR(10),product_shiplength VARCHAR(10),product_shipwidth VARCHAR(10),product_shipheight VARCHAR(10),product_shipnumbox VARCHAR(4),product_customship VARCHAR(30),product_shiponename VARCHAR(40),product_shiponeprice VARCHAR(10),product_shiptwoname VARCHAR(40),product_shiptwoprice VARCHAR(10),product_shipthreename VARCHAR(40),product_shipthreeprice VARCHAR(10),product_shipemail VARCHAR(40),product_shipstateprov VARCHAR(50),product_shipcountry VARCHAR(50),product_shipzip VARCHAR(10),product_xprod TEXT,product_xopt TEXT,product_xcat TEXT,product_sorton VARCHAR(100))
That's all I see and have to use the Back button to get back to the CCP5.0 interface.
Why is this happening? What can I do to fix this?
Please note that 1) I DO NOT have access to the server and 2) I did not install this application nor can I update it for the owner and 3) I do not have access to the database or utilities for managing it. But I can ask the webhost to do stuff if I know what to ask him to do.
Thank you! Lee
Offline
#2 01-23-2006 23:51:49
Re: Product Table Not Converting
Bump -- help!!
I now have access to the installation via ftp.
Offline
#3 01-24-2006 09:16:09
Re: Product Table Not Converting
It has been a long time since I worked with 5.0 so I don't remember how it reported errors. In 5.1, it will tell you what the problem is if you know what to look for. It doesn't look like 5.0 is doing that.
In 5.1, the most common problem that stops the transfer to database is a duplicate key file. You might down load the product.csv file (In BINARY) and open it up. I use Excel for this. Do a sort on the first column making sure that it selects all the adjacent columns. Look for duplicates in the first column, and if there are any, delete all but one row or change the data in the first column so that it is no longer a duplication. Save it in csv format and upload in binary. Then try to make the switch.
Offline
#4 01-24-2006 14:47:22
Offline
#5 01-25-2006 13:17:56
- GoBrushless.com
- Member
- Registered: 06-29-2005
- Posts: 431
Re: Product Table Not Converting
yeah i had the same problem when trying to convert my mailinglist.csv to mySQL... good grief. you know how hard it is to FIND let alone remove dupe entries in a mailing list with thousands of addresses?
PHFEW!
Offline