Forums / Install & configuration / Upgrading from 3.2-5 to 3.4-1, MySQL problem and resolution

Upgrading from 3.2-5 to 3.4-1, MySQL problem and resolution

Previous topic

Install & configuration

Next topic

Author	Message
Conor Murray	Monday 23 August 2004 4:43:10 am There doesn't appear to be any MySQL update info for 3.2-5 provided in the 3.4-1 package. To upgrade, run the 3.2-4 to 3.3-1 updater, then the subsequent updates until your database is at 3.4-1. You shouldn't see any error messages, but if you check the database with the admin tool at http://your.ez.url/youradminpath/setup/systemupgrade (don't click this URL, it won't work!) you will find that there are database problems. Copy the queries suggested and paste them into a file to feed to MySQL and you should be running smoothly in no time. Don't forget to check the database again AFTER the updates! Other than this the update from 3.2-5 to 3.4-1 seems quite smooth under Linux... images etc. all working :) Hopefully 3.5-x will be another smooth update! Language is a virus - William S Burroughs

Author

Message

Conor Murray

Monday 23 August 2004 4:43:10 am

There doesn't appear to be any MySQL update info for 3.2-5 provided in the 3.4-1 package.

To upgrade, run the 3.2-4 to 3.3-1 updater, then the subsequent updates until your database is at 3.4-1. You shouldn't see any error messages, but if you check the database with the admin tool at http://your.ez.url/youradminpath/setup/systemupgrade (don't click this URL, it won't work!) you will find that there are database problems. Copy the queries suggested and paste them into a file to feed to MySQL and you should be running smoothly in no time. Don't forget to check the database again AFTER the updates!

Other than this the update from 3.2-5 to 3.4-1 seems quite smooth under Linux... images etc. all working :)

Hopefully 3.5-x will be another smooth update!

Language is a virus - William S Burroughs

eZ debug

Timing:

Jan 31 2025 01:27:16

Script start

Timing:

Jan 31 2025 01:27:16

Module start 'content'

Timing:

Jan 31 2025 01:27:16

Module end 'content'

Timing:

Jan 31 2025 01:27:16

Script end

Main resources:

Total runtime

0.1885 sec

Peak memory usage

8,192.0000 KB

Database Queries

141

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0084	588.2891	370.2500
Module start 'content'	0.0084	0.0142	958.5391	997.4531
Module end 'content'	0.0226	0.1659	1,955.9922	3,890.3672
Script end	0.1885		5,846.3594

Checkpoint

Start (sec)

Duration (sec)

Memory at start (KB)

Memory used (KB)

Script start

0.0000

0.0084

588.2891

370.2500

Module start 'content'

0.0084

0.0142

958.5391

997.4531

Module end 'content'

0.0226

0.1659

1,955.9922

3,890.3672

Script end

0.1885

5,846.3594

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0045	2.3984	20	0.0002
Check MTime	0.0015	0.7731	20	0.0001
Mysql Total
Database connection	0.0006	0.2987	1	0.0006
Mysqli_queries	0.0930	49.3123	141	0.0007
Looping result	0.0014	0.7463	139	0.0000
Template Total	0.1655	87.8	1	0.1655
Template load	0.0008	0.4201	1	0.0008
Template processing	0.1647	87.3569	1	0.1647
Override
Cache load	0.0006	0.2982	1	0.0006
Sytem overhead
Fetch class attribute can translate value	0.0021	1.1011	1	0.0021
XML
Image XML parsing	0.0002	0.1272	1	0.0002
General
dbfile	0.0104	5.4904	20	0.0005
String conversion	0.0000	0.0037	3	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Accumulator

Duration (sec)

Duration (%)

Count

Average (sec)

Ini load

Load cache

0.0045

2.3984

0.0002

Check MTime

0.0015

0.7731

0.0001

Mysql Total

Database connection

0.0006

0.2987

0.0006

Mysqli_queries

0.0930

49.3123

141

0.0007

Looping result

0.0014

0.7463

139

0.0000

Template Total

0.1655

87.8

0.1655

Template load

0.0008

0.4201

0.0008

Template processing

0.1647

87.3569

0.1647

Override

Cache load

0.0006

0.2982

0.0006

Sytem overhead

Fetch class attribute can translate value

0.0021

1.1011

0.0021

XML

Image XML parsing

0.0002

0.1272

0.0002

General

dbfile

0.0104

5.4904

0.0005

String conversion

0.0000

0.0037

0.0000

Note: percentages do not add up to 100% because some accumulators overlap

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

Cache	Type	Packlevel	SourceFiles
	CSS	0	extension/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
	JS	0	extension/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

Cache

Type

Packlevel

SourceFiles

CSS

extension/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

extension/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:

Usage	Requested template	Template	Template loaded	Edit	Override
1	pagelayout.tpl	<No override>	extension/sevenx/design/simple/templates/pagelayout.tpl
Number of times templates used: 1 Number of unique templates used: 1

Usage

Requested template

Template

Template loaded

Edit

Override

pagelayout.tpl

<No override>

extension/sevenx/design/simple/templates/pagelayout.tpl

Number of times templates used: 1
Number of unique templates used: 1

Time used to render debug report: 0.0001 secs