Upgrade from 3.4.1 to 3.4.2 problem !

Next topic

Author	Message
Mieczyslaw Morzonek	Sunday 26 September 2004 1:04:45 am I`ve upgrade files and database and when i click check files i ve go message " File consistency check OK" but problem is when i click chech database i ve got message like this Warning, your database is not consistent with the distribution database. To revert your database to distribution setup, run the following SQL queries: ALTER TABLE ezurl_object_link DROP INDEX PRIMARY; What does it mean? Can i ignore this warning?
Frederik Holljen	Sunday 26 September 2004 11:51:00 pm This means that the primary key index in the table ezurl_object_link is not present in the main distribution while it is in your installation. You can run the given SQL sentence on you sql database to make the problem go away. This is a small issue and you can also safely ignore it.
Mieczyslaw Morzonek	Monday 27 September 2004 10:23:10 am When i execute this query " ALTER TABLE ezurl_object_link DROP INDEX PRIMARY " MySQL told me that "#1064 - Something is wrong in your syntax near 'PRIMARY' in line 1 " What`s wrong with SQL syntax? This is a bug? What i must to do?
Jan Borsodi	Tuesday 28 September 2004 4:33:10 am I believe it is a small bug in the db consistency checker, the generated SQL is not valid. The correct SQL is: ALTER TABLE ezurl_object_link DROP PRIMARY KEY; But if this is the case did you remember to update the database with the file: update/database/mysql/3.4/dbupdate-3.4.1-to-3.4.2.sql This file contains the SQL code above. -- Amos Documentation: http://ez.no/ez_publish/documentation FAQ: http://ez.no/ez_publish/documentation/faq
Derick Rethans	Tuesday 05 October 2004 1:06:54 am This problem with the DB Consistency Checker is now fixed for 3.4.3 (rev. 8446) and 3.5.0beta (rev. 8445).

eZ debug

Timing:	Jan 19 2025 00:32:46
Script start
Timing:	Jan 19 2025 00:32:46
Module start 'layout'
Timing:	Jan 19 2025 00:32:46
Module start 'content'
Timing:	Jan 19 2025 00:32:47
Module end 'content'
Timing:	Jan 19 2025 00:32:47
Script end

Main resources:

Total runtime	0.7726 sec
Peak memory usage	4,096.0000 KB
Database Queries	67

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0001	0.0077	588.0391	152.6406
Module start 'layout'	0.0078	0.0036	740.6797	39.4766
Module start 'content'	0.0114	0.7596	780.1563	641.8281
Module end 'content'	0.7710	0.0016	1,421.9844	12.1406
Script end	0.7726		1,434.1250

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0041	0.5345	16	0.0003
Check MTime	0.0018	0.2316	16	0.0001
Mysql Total
Database connection	0.0009	0.1157	1	0.0009
Mysqli_queries	0.7042	91.1456	67	0.0105
Looping result	0.0008	0.1074	65	0.0000
Template Total	0.7176	92.9	2	0.3588
Template load	0.0023	0.2932	2	0.0011
Template processing	0.7153	92.5846	2	0.3577
Template load and register function	0.0002	0.0285	1	0.0002
states
state_id_array	0.0025	0.3300	1	0.0025
state_identifier_array	0.0013	0.1715	2	0.0007
Override
Cache load	0.0020	0.2629	26	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0008	0.1024	4	0.0002
Fetch class attribute name	0.0016	0.2041	8	0.0002
XML
Image XML parsing	0.0022	0.2819	4	0.0005
class_abstraction
Instantiating content class attribute	0.0000	0.0023	8	0.0000
General
dbfile	0.0017	0.2220	29	0.0001
String conversion	0.0000	0.0009	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

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
5	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
9	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
3	content/datatype/view/ezxmltags/line.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/line.tpl
3	content/datatype/view/ezimage.tpl	<No override>	extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tpl
2	content/datatype/view/ezxmltags/literal.tpl	<No override>	extension/community/design/standard/templates/content/datatype/view/ezxmltags/literal.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 24 Number of unique templates used: 7

Time used to render debug report: 0.0001 secs