Forums / Developer / Updating the ezpublish web site database?

Updating the ezpublish web site database?

« 
Previous topic
|
Developer
|
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 18 2025 15:01:37
Script start
Timing: Jan 18 2025 15:01:37
Module start 'content'
Timing: Jan 18 2025 15:01:38
Module end 'content'
Timing: Jan 18 2025 15:01:38
Script end

Main resources:

Total runtime1.1932 sec
Peak memory usage4,096.0000 KB
Database Queries197

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0114 588.9766180.8125
Module start 'content' 0.01140.9660 769.7891513.8984
Module end 'content' 0.97740.2157 1,283.6875333.4688
Script end 1.1931  1,617.1563 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00480.4030210.0002
Check MTime0.00180.1486210.0001
Mysql Total
Database connection0.00260.216810.0026
Mysqli_queries1.116893.60471970.0057
Looping result0.00240.19841950.0000
Template Total1.153996.720.5770
Template load0.00180.152720.0009
Template processing1.152196.560620.5761
Template load and register function0.00020.016310.0002
states
state_id_array0.00130.110710.0013
state_identifier_array0.00190.155320.0009
Override
Cache load0.00150.1223280.0001
Sytem overhead
Fetch class attribute can translate value0.00160.130730.0005
Fetch class attribute name0.00100.079940.0002
XML
Image XML parsing0.00050.041430.0002
class_abstraction
Instantiating content class attribute0.00000.000740.0000
General
dbfile0.00330.2746210.0002
String conversion0.00000.000630.0000
Note: percentages do not add up to 100% because some accumulators overlap

CSS/JS files loaded with "ezjscPacker" during request:

CacheTypePacklevelSourceFiles
CSS0extension/community/design/community/stylesheets/ext/jquery.autocomplete.css
extension/community_design/design/suncana/stylesheets/scrollbars.css
extension/community_design/design/suncana/stylesheets/tabs.css
extension/community_design/design/suncana/stylesheets/roadmap.css
extension/community_design/design/suncana/stylesheets/content.css
extension/community_design/design/suncana/stylesheets/star-rating.css
extension/community_design/design/suncana/stylesheets/syntax_and_custom_tags.css
extension/community_design/design/suncana/stylesheets/buttons.css
extension/community_design/design/suncana/stylesheets/tweetbox.css
extension/community_design/design/suncana/stylesheets/jquery.fancybox-1.3.4.css
extension/bcsmoothgallery/design/standard/stylesheets/magnific-popup.css
extension/sevenx/design/simple/stylesheets/star_rating.css
extension/sevenx/design/simple/stylesheets/libs/fontawesome/css/all.min.css
extension/sevenx/design/simple/stylesheets/main.v02.css
extension/sevenx/design/simple/stylesheets/main.v02.res.css
JS0extension/ezjscore/design/standard/lib/yui/3.17.2/build/yui/yui-min.js
extension/ezjscore/design/standard/javascript/jquery-3.7.0.min.js
extension/community_design/design/suncana/javascript/jquery.ui.core.min.js
extension/community_design/design/suncana/javascript/jquery.ui.widget.min.js
extension/community_design/design/suncana/javascript/jquery.easing.1.3.js
extension/community_design/design/suncana/javascript/jquery.ui.tabs.js
extension/community_design/design/suncana/javascript/jquery.hoverIntent.min.js
extension/community_design/design/suncana/javascript/jquery.popmenu.js
extension/community_design/design/suncana/javascript/jScrollPane.js
extension/community_design/design/suncana/javascript/jquery.mousewheel.js
extension/community_design/design/suncana/javascript/jquery.cycle.all.js
extension/sevenx/design/simple/javascript/jquery.scrollTo.js
extension/community_design/design/suncana/javascript/jquery.cookie.js
extension/community_design/design/suncana/javascript/ezstarrating_jquery.js
extension/community_design/design/suncana/javascript/jquery.initboxes.js
extension/community_design/design/suncana/javascript/app.js
extension/community_design/design/suncana/javascript/twitterwidget.js
extension/community_design/design/suncana/javascript/community.js
extension/community_design/design/suncana/javascript/roadmap.js
extension/community_design/design/suncana/javascript/ez.js
extension/community_design/design/suncana/javascript/ezshareevents.js
extension/sevenx/design/simple/javascript/main.js

Templates used to render the page:

UsageRequested templateTemplateTemplate loadedEditOverride
1node/view/full.tplfull/forum_topic.tplextension/sevenx/design/simple/override/templates/full/forum_topic.tplEdit templateOverride template
4content/datatype/view/ezxmltext.tpl<No override>extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tplEdit templateOverride template
6content/datatype/view/ezxmltags/paragraph.tpl<No override>extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tplEdit templateOverride template
3content/datatype/view/ezxmltags/line.tpl<No override>design/standard/templates/content/datatype/view/ezxmltags/line.tplEdit templateOverride template
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 15
 Number of unique templates used: 5

Time used to render debug report: 0.0002 secs