Forums / Install & configuration / dbupdate from 3.8.6 to 3.9 error

dbupdate from 3.8.6 to 3.9 error

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