running upgrade scripts

Next topic

Author	Message
Halvor M	Wednesday 21 December 2005 4:25:45 pm I seem to be having problems actually running the upgrade scripts. Once I enter the command, I get a lot of text running over my screen (basically the commands for mysql), and the whole process lasts for only a second. This is what i wrote: D:\www\_site\update\database\mysql\3.5>d:/wamp/mysql/bin/mysql -u <username> -p <password> <databasename> < dbupdate-3.5.1-to-3.5.2.sql username, password and databasename were all supplied correctly. I suspect there is a very easy fix to this (wrong path or something like that). Appreciate any input, been losing way to much sleep over this upgrade...
Halvor M	Friday 23 December 2005 1:11:53 am I've been trying a lot of variations here, but without success. Seems like my comp is just reciting the file, not actually executing it... Any ideas out there?
Hans Aikema	Friday 23 December 2005 12:24:53 pm You might try changing the buffer-size of your CMD prompt: in the CMD window menu (left side of the titlebar) choose properties, on tab 'layout' change the value for the 'height' of the screenbuffer size (e.g. 500), it's the number of lines you can still scroll back in the window. That way you're at least able to tell what all the replies from mysql are I did some upgrades myself to get a site from 3.4.1 (or something like that) all the way to 3.7.1 when my hosting provider suddenly decided to upgrade to PHP 4.4. The transition from 3.5.1 to 3.5.2 went smoothly as far as I can recall you might also enable logging on your mySQL server. See the MySQL website for more info on achieving this: http://dev.mysql.com/doc/refman/4.1/en/log-files.html
Halvor M	Friday 23 December 2005 3:37:50 pm Thank you so much for your reply - it gave me the "go" to fool around some more. This resulted in the scripts running and my system being operational again :-) the error was the <database> part, which I deleted and everything was fine. Took 1,5 min to run the various scripts... !!! Thanks mate!

eZ debug

Timing:	Jan 19 2025 01:12:39
Script start
Timing:	Jan 19 2025 01:12:39
Module start 'layout'
Timing:	Jan 19 2025 01:12:39
Module start 'content'
Timing:	Jan 19 2025 01:12:40
Module end 'content'
Timing:	Jan 19 2025 01:12:40
Script end

Main resources:

Total runtime	0.7335 sec
Peak memory usage	4,096.0000 KB
Database Queries	60

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0052	589.1719	152.6250
Module start 'layout'	0.0052	0.0027	741.7969	39.4453
Module start 'content'	0.0079	0.7243	781.2422	479.8594
Module end 'content'	0.7322	0.0012	1,261.1016	12.1719
Script end	0.7334		1,273.2734

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0031	0.4243	16	0.0002
Check MTime	0.0013	0.1774	16	0.0001
Mysql Total
Database connection	0.0008	0.1085	1	0.0008
Mysqli_queries	0.6894	93.9866	60	0.0115
Looping result	0.0006	0.0786	58	0.0000
Template Total	0.7041	96.0	2	0.3521
Template load	0.0022	0.3054	2	0.0011
Template processing	0.7019	95.6940	2	0.3509
Template load and register function	0.0003	0.0373	1	0.0003
states
state_id_array	0.0012	0.1598	1	0.0012
state_identifier_array	0.0008	0.1037	2	0.0004
Override
Cache load	0.0018	0.2488	24	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0007	0.0931	2	0.0003
Fetch class attribute name	0.0011	0.1436	4	0.0003
XML
Image XML parsing	0.0002	0.0269	2	0.0001
class_abstraction
Instantiating content class attribute	0.0000	0.0011	4	0.0000
General
dbfile	0.0006	0.0764	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
4	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: 16 Number of unique templates used: 5

Time used to render debug report: 0.0001 secs