Hi David
Over the past three weeks I have ensountered a number issues with the PTproduct table in many databases. When I repair the table I get the error message "Duplicate key for record " and then a row is removed and database table is subsequently ok
Do you have any ideas what factors could be causing this?
Regards
Richard
Hi Richard,
"Duplicate key" is the method by which duplicates are prevented from being imported; but i'm not sure why you're seeing this during a table repair. Could you try emptying (TRUNCATE) the products table and then importing all products - that should clear it...
Cheers,
David.