Upgrade to 4.3 : how to specify the DB in updatenodeassignment.php ?

Previous topic

Install & configuration

Next topic

Author	Message
Hakim Bouras	Saturday 03 April 2010 9:09:54 am Hi, The Upgrading instructions 4.2x to 4.3.x say : Step 5: Running the system upgrade scripts Run the following command from the root of your eZ Publish directory: php update/common/scripts/4.3/updatenodeassignment.php In a multisite config, how one can specify on which db (siteaccess) the script is supposed to run ? Thanks, Hakim Bouras PRISMALOG - Creation de site Internet
Hakim Bouras	Sunday 04 April 2010 12:08:02 am After digging some more, the answer is to use one site access for each DB that needs to be updated : php update/common/scripts/4.3/updatenodeassignment.php -s <SITE-NAME> All the scripts built using eZScript and eZCLI are natively able to receive many parameters (see eZScript::getOptions ) One more info for people using multi-site config with database settings stored in extensions, you may update the script line 141 and change : 'use-extensions' => true Hope it helps, Hakim
Nicolas Pastorino	Tuesday 06 April 2010 2:14:56 am " One more info for people using multi-site config with database settings stored in extensions, you may update the script line 141 and change : 'use-extensions' => true " Hi Hakim, Thanks for sharing the solution, very useful. I can see there is a bug in the updatenodeassignment.php script, would you mind reporting it in the issue tracker ? http://issue.ez.no/ezpublish (or, if a similar issue already exists, simply comment on it). Thanks in advance ! Cheers, -- Nicolas Pastorino Director Community - eZ Member of the Community Project Board eZ Publish Community on twitter: http://twitter.com/ezcommunity t : http://twitter.com/jeanvoye G+ : http://plus.tl/jeanvoye

Author

Message

Hakim Bouras

Saturday 03 April 2010 9:09:54 am

Hi,

The Upgrading instructions 4.2x to 4.3.x say :

Step 5: Running the system upgrade scripts
Run the following command from the root of your eZ Publish directory:
php update/common/scripts/4.3/updatenodeassignment.php

In a multisite config, how one can specify on which db (siteaccess) the script is supposed to run ?

Thanks,

Hakim Bouras
PRISMALOG - Creation de site Internet

Hakim Bouras

Sunday 04 April 2010 12:08:02 am

After digging some more, the answer is to use one site access for each DB that needs to be updated :

php update/common/scripts/4.3/updatenodeassignment.php -s <SITE-NAME>

All the scripts built using eZScript and eZCLI are natively able to receive many parameters (see eZScript::getOptions )

One more info for people using multi-site config with database settings stored in extensions, you may update the script line 141 and change :

'use-extensions' => true

Hope it helps,

Hakim

Nicolas Pastorino

Tuesday 06 April 2010 2:14:56 am

One more info for people using multi-site config with database settings stored in extensions, you may update the script line 141 and change :

'use-extensions' => true

Hi Hakim,

Thanks for sharing the solution, very useful. I can see there is a bug in the updatenodeassignment.php script, would you mind reporting it in the issue tracker ? http://issue.ez.no/ezpublish (or, if a similar issue already exists, simply comment on it).

Thanks in advance !
Cheers,

--
Nicolas Pastorino
Director Community - eZ
Member of the Community Project Board

eZ Publish Community on twitter: http://twitter.com/ezcommunity

t : http://twitter.com/jeanvoye
G+ : http://plus.tl/jeanvoye

eZ debug

Timing:	Jan 18 2025 10:20:16
Script start
Timing:	Jan 18 2025 10:20:16
Module start 'layout'
Timing:	Jan 18 2025 10:20:16
Module start 'content'
Timing:	Jan 18 2025 10:20:17
Module end 'content'
Timing:	Jan 18 2025 10:20:17
Script end

Main resources:

Total runtime	0.7660 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.0054	588.3984	152.6875
Module start 'layout'	0.0054	0.0029	741.0859	39.5234
Module start 'content'	0.0083	0.7563	780.6094	561.4844
Module end 'content'	0.7645	0.0014	1,342.0938	12.0781
Script end	0.7659		1,354.1719

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0031	0.4107	16	0.0002
Check MTime	0.0014	0.1804	16	0.0001
Mysql Total
Database connection	0.0007	0.0931	1	0.0007
Mysqli_queries	0.7031	91.7966	60	0.0117
Looping result	0.0006	0.0755	58	0.0000
Template Total	0.7340	95.8	2	0.3670
Template load	0.0023	0.2949	2	0.0011
Template processing	0.7318	95.5340	2	0.3659
Template load and register function	0.0001	0.0111	1	0.0001
states
state_id_array	0.0011	0.1470	1	0.0011
state_identifier_array	0.0011	0.1432	2	0.0005
Override
Cache load	0.0020	0.2593	43	0.0000
Sytem overhead
Fetch class attribute can translate value	0.0010	0.1304	2	0.0005
Fetch class attribute name	0.0015	0.2014	5	0.0003
XML
Image XML parsing	0.0009	0.1166	2	0.0004
class_abstraction
Instantiating content class attribute	0.0000	0.0016	6	0.0000
General
dbfile	0.0008	0.1098	22	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/ezimage.tpl	<No override>	extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tpl
3	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
13	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
3	content/datatype/view/ezxmltags/emphasize.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/emphasize.tpl
4	content/datatype/view/ezxmltags/strong.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/strong.tpl
3	content/datatype/view/ezxmltags/link.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/link.tpl
1	content/datatype/view/ezxmltags/quote.tpl	datatype/ezxmltext/quote.tpl	extension/ezwebin/design/ezwebin/override/templates/datatype/ezxmltext/quote.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 35 Number of unique templates used: 10

Time used to render debug report: 0.0001 secs