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

"Please Note:

At the specific request of Ibexa we are changing this projects name to "Exponential" or "Exponential (CMS)" effective as of August, 11th 2025.
This project is not associated with the original eZ Publish software or its original developer, eZ Systems or Ibexa".

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+