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+

eZ debug

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0069	589.1563	152.6406
Module start 'layout'	0.0070	0.0025	741.7969	39.4766
Module start 'content'	0.0095	0.6194	781.2734	517.5000
Module end 'content'	0.6288	0.0017	1,298.7734	8.1406
Script end	0.6305		1,306.9141

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0034	0.5430	16	0.0002
Check MTime	0.0013	0.2136	16	0.0001
Mysql Total
Database connection	0.0010	0.1626	1	0.0010
Mysqli_queries	0.5831	92.4858	54	0.0108
Looping result	0.0007	0.1090	52	0.0000
Template Total	0.5900	93.6	2	0.2950
Template load	0.0020	0.3171	2	0.0010
Template processing	0.5879	93.2469	2	0.2940
Template load and register function	0.0005	0.0717	1	0.0005
states
state_id_array	0.0013	0.2124	1	0.0013
state_identifier_array	0.0009	0.1494	2	0.0005
Override
Cache load	0.0016	0.2560	14	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0007	0.1074	2	0.0003
Fetch class attribute name	0.0015	0.2375	3	0.0005
XML
Image XML parsing	0.0006	0.0898	2	0.0003
class_abstraction
Instantiating content class attribute	0.0000	0.0012	3	0.0000
General
dbfile	0.0018	0.2929	16	0.0001
String conversion	0.0000	0.0011	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Usage	Requested template	Template	Template loaded
1	node/view/full.tpl	full/forum_topic.tpl	extension/sevenx/design/simple/override/templates/full/forum_topic.tpl
2	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
2	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
1	content/datatype/view/ezimage.tpl	<No override>	extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 7 Number of unique templates used: 5

Time used to render debug report: 0.0001 secs