I've successfully moved site from one host another and everything is now working OK.

Except the search function. If you enter anything into the Search box, I get the error below. In this instance I searched for "mat"


MySQL Error Occured
1062: Duplicate entry '0' for key 1

QUERY = INSERT INTO CubeCart_search (`searchstr`, `hits`) VALUES ('MAT', '1')


Any ideas on what's wrong ?

thanks

102 people read this & not 1 answer?

I've removed the search function cos I've no idea what is causing the problem :-(

Looks like the problem is much bigger. I can't add a product now. I get the same error. All since I upgraded to the new version. Anyone got any ideas before I have to rebuild my entire store from scratch again ?