Missing script for upgrade

Next topic

Author	Message
Vivek Chopra	Thursday 18 March 2004 10:30:32 am I am trying to upgrade eZpublish from 3.1-1 to 3.3.3 I downloaded the 3.3.3 package and in the update folder there are sql files to update the database. One sql file seems to be missing which is needed to update from 3.2-2 to 3.2-3. Without this file I cannot update the database any further. Has anyone experienced this problem ? any solution? Please help. Vivek
Björn Dieding@xrow.de	Thursday 18 March 2004 11:52:48 am I might be that there was no change in the db layout between those versions. -----from a doc Unfortunatelly this is the theory. Some times it works and somethings it doesn't. Here are serval things you should try too if things are failing. run the updatescripts again update/common/scripts/* still no luck? Try this... Install a fresh version with a demo package under a new DB (Plain preferred) clear all rows from all tables of that new db dump your old one (without tables, just the raw data) press it into the db (manual fix the sql erros) run the updatescripts change settings and do not try to use your old ones -------------------------------------------------------------------------------- Looking for a new job? http://www.xrow.com/xrow-GmbH/Jobs Looking for hosting? http://hostingezpublish.com ----------------------------------------------------------------------------- GMT +01:00 Hannover, Germany Web: http://www.xrow.com/
Vivek Chopra	Thursday 18 March 2004 3:39:00 pm If I run the next available sql script, I get error saying table not found.

Author

Message

Thursday 18 March 2004 10:30:32 am

I am trying to upgrade eZpublish from 3.1-1 to 3.3.3 I downloaded the 3.3.3 package and in the update folder there are sql files to update the database. One sql file seems to be missing which is needed to update from 3.2-2 to 3.2-3.

Without this file I cannot update the database any further.

Has anyone experienced this problem ? any solution?
Please help.

Vivek

Björn Dieding@xrow.de

Thursday 18 March 2004 11:52:48 am

I might be that there was no change in the db layout between those versions.

-----from a doc

Unfortunatelly this is the theory. Some times it works and somethings it doesn't. Here are serval things you should try too if things are failing.

run the updatescripts again update/common/scripts/*
still no luck? Try this...

Install a fresh version with a demo package under a new DB (Plain preferred)
clear all rows from all tables of that new db
dump your old one (without tables, just the raw data)
press it into the db (manual fix the sql erros)
run the updatescripts
change settings and do not try to use your old ones

--------------------------------------------------------------------------------

Looking for a new job? http://www.xrow.com/xrow-GmbH/Jobs
Looking for hosting? http://hostingezpublish.com
-----------------------------------------------------------------------------
GMT +01:00 Hannover, Germany
Web: http://www.xrow.com/

Vivek Chopra

Thursday 18 March 2004 3:39:00 pm

If I run the next available sql script, I get error saying table not found.

eZ debug

Timing:	Jan 19 2025 07:04:36
Script start
Timing:	Jan 19 2025 07:04:36
Module start 'layout'
Timing:	Jan 19 2025 07:04:36
Module start 'content'
Timing:	Jan 19 2025 07:04:37
Module end 'content'
Timing:	Jan 19 2025 07:04:37
Script end

Main resources:

Total runtime	1.3026 sec
Peak memory usage	4,096.0000 KB
Database Queries	57

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0085	589.2734	152.6406
Module start 'layout'	0.0086	0.0054	741.9141	39.4609
Module start 'content'	0.0140	1.2873	781.3750	533.4922
Module end 'content'	1.3013	0.0013	1,314.8672	12.1641
Script end	1.3025		1,327.0313

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0040	0.3092	16	0.0003
Check MTime	0.0019	0.1457	16	0.0001
Mysql Total
Database connection	0.0020	0.1504	1	0.0020
Mysqli_queries	1.2450	95.5782	57	0.0218
Looping result	0.0007	0.0514	55	0.0000
Template Total	1.2545	96.3	2	0.6272
Template load	0.0034	0.2639	2	0.0017
Template processing	1.2510	96.0426	2	0.6255
Template load and register function	0.0001	0.0107	1	0.0001
states
state_id_array	0.0012	0.0933	1	0.0012
state_identifier_array	0.0014	0.1069	2	0.0007
Override
Cache load	0.0027	0.2092	24	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0007	0.0520	2	0.0003
Fetch class attribute name	0.0009	0.0676	4	0.0002
XML
Image XML parsing	0.0007	0.0540	2	0.0004
class_abstraction
Instantiating content class attribute	0.0000	0.0007	4	0.0000
General
dbfile	0.0008	0.0585	16	0.0000
String conversion	0.0000	0.0010	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
3	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
6	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
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: 15 Number of unique templates used: 6

Time used to render debug report: 0.0001 secs