Forums / Install & configuration / dbupdate from 3.8.6 to 3.9 error
Guillaume Kempfer
Tuesday 16 January 2007 1:20:57 pm
Hi,
I get an error when i try to update mysql db from 3.8.6 to 3.9.
mysql -u xxx -pxxx xxx<update/database/mysql/3.9/dbupdate-3.8.0-to-3.9.0.sql
return an error :
ERROR 1062 (23000) at line 141: Duplicate entry 'biosph?re' for key 2
The line 141 is :
INSERT INTO ezsearch_search_phrase_new ( phrase, phrase_count, result_count )
Xavier Dutoit
Tuesday 16 January 2007 8:51:00 pm
Clear the index of the search before upgrading ?
X+
http://www.sydesy.com