dbupdate from 3.8.6 to 3.9 error

Previous topic

Next topic

Author	Message
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

Author

Message

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 )

Tuesday 16 January 2007 8:51:00 pm

Clear the index of the search before upgrading ?

X+