Updating the ezpublish web site database?

Next topic

Author	Message
Jorge estévez	Monday 12 July 2004 6:31:46 pm I would like (working offline developing new options) to update the clients database, but without erasing the information that his database has due to the use of the intranet/web site (eg. forums) Please can someone point out the tables within the database taht should be updated and the ones that should not be touched. If this is not the solution, please tell me what to do. thanks! Diseño Web Cuba Web Design Cuba www.elfosdesign.com
Silke Fox	Tuesday 13 July 2004 6:30:41 am You should use the database update scripts which are provided with newer eZ publish versions. See http://ez.no/ez_publish/documentation/installation/upgrading/upgrading_ez_publish_from_3_a_b_to_3_x_y And you can use the database diff tool after updating to check if it was successful... ;) http://ez.no/ez_publish/documentation/development/scripting/supplied_scripts/database_diffing_tool
Jorge estévez	Sunday 18 July 2004 4:19:26 am Thanks but that was not my question... (Thanks anyway)) I am not upgrading no a new ez version... within the same version 3.4 y have my development site (offline) and the client's site (production)... The client’s site is doing well and the client uses it every day... in the meantime I keep adding new links, sections, etc, to the development site (offline)... At the moment of updating (once I test that everything is doing fine) I upgrade all the files of ez publish to the server... BUT!!! When it comes to the data base I should not erase the old data base and copy the new one because I erase data that has been posted to the database by the client itself (e.g. forums etc)... so only some tables should be updated... Does somebody now wish ones should I update? Any IDEAS? Diseño Web Cuba Web Design Cuba www.elfosdesign.com
Silke Fox	Monday 19 July 2004 12:52:37 am For the future, I would recommend that you perform major changes on the client's database directly and then import that db to your development environment. For now... it's no good idea to update some tables of the database, as this will probably result in an inconsistent database. Try to use packages for content class and content object export/ import. http://ez.no/ez_publish/documentation/ez_publish_3_4/content_object_import_and_export Sections, roles etc. have to be created manually though. Maybe there are better ideas around here... ;)

eZ debug

Timing:	Jan 31 2025 01:35:13
Script start
Timing:	Jan 31 2025 01:35:13
Module start 'layout'
Timing:	Jan 31 2025 01:35:13
Module start 'content'
Timing:	Jan 31 2025 01:35:14
Module end 'content'
Timing:	Jan 31 2025 01:35:14
Script end

Main resources:

Total runtime	1.0455 sec
Peak memory usage	8,192.0000 KB
Database Queries	60

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0059	588.2656	151.2266
Module start 'layout'	0.0059	0.0036	739.4922	220.7188
Module start 'content'	0.0095	1.0351	960.2109	4,311.6641
Module end 'content'	1.0446	0.0008	5,271.8750	11.8125
Script end	1.0454		5,283.6875

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0037	0.3558	16	0.0002
Check MTime	0.0014	0.1296	16	0.0001
Mysql Total
Database connection	0.0007	0.0692	1	0.0007
Mysqli_queries	0.9503	90.9016	60	0.0158
Looping result	0.0007	0.0660	58	0.0000
Template Total	0.9953	95.2	2	0.4977
Template load	0.0019	0.1831	2	0.0010
Template processing	0.9934	95.0194	2	0.4967
Template load and register function	0.0019	0.1818	1	0.0019
states
state_id_array	0.0012	0.1176	1	0.0012
state_identifier_array	0.0008	0.0724	2	0.0004
Override
Cache load	0.0016	0.1540	28	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0023	0.2155	2	0.0011
Fetch class attribute name	0.0035	0.3322	4	0.0009
XML
Image XML parsing	0.0003	0.0276	2	0.0001
class_abstraction
Instantiating content class attribute	0.0000	0.0010	4	0.0000
General
dbfile	0.0008	0.0743	10	0.0001
String conversion	0.0000	0.0008	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
4	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	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 15 Number of unique templates used: 5

Time used to render debug report: 0.0001 secs