Hi,
While we were using old hosting company (15 days ago) on php 4.3.4/mysql
4.x based Linux server, the application I wrote to upload new products i
MySQL was working fine.
After we moved now I'm getting strange error I can't explain. I think it's
caused by moving to mysql 5.
For example: in the application csv file is uploaded to the server, then
it reads product no. from product row and search if such exosts in DB. If
yes, add prod. number to message that will list all products that admin
tried to upload but they already exists.
But, I'll sometimes get the error message, e.g.:
Duplicate entry 'Lavander Peak Purse-L' fo r key 6
The thing I don't understand is 'Lavander Peak Purse' (without -L) is
product name and it's not index nor unique?!? And there is no such a
product in DB?!?
Why is '-L' added to the products? What does it mean? What's key 6?
I tried to find answer on mysql.com but only think I found is
Error: 1062 SQLSTATE: 23000 (ER_DUP_ENTRY)
Message: Duplicate entry '%s' for key %d
CREATE TABLE `web_products` (
`prod_id` int(8) unsigned NOT NULL auto_increment,
`prod_no` varchar(50) NOT NULL default '',
`prod_name` varchar(255) NOT NULL default '',
`prod_description` text,
`prod_colors` text,
`prod_includes` text,
`prod_catalog` varchar(45) default NULL,
`prod_status` enum('hidden','live','new') NOT NULL default 'new',
`prod_supplier` varchar(45) default NULL,
`prod_start_date` date default '0000-00-00',
`prod_end_date` date default '0000-00-00',
`prod_featured` enum('0','1') default NULL,
`on_sale` enum('Yes','No') NOT NULL default 'No',
PRIMARY KEY (`prod_id`),
UNIQUE KEY `prod_no` (`prod_no`),
KEY `products_index1` (`prod_status`),
KEY `products_index2` (`prod_start_date`,`prod_end_date`),
KEY `on_sale` (`on_sale`),
FULLTEXT KEY `prod_search` (`prod_name`,`prod_description`),
FULLTEXT KEY `prod_no_2` (`prod_no`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6151 ;
Thanks for any help
-afan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
