Populate data_map

Next topic

Author	Message
Raymond Williams	Monday 27 March 2006 9:11:17 am In an attempt to do major restructuring on a site, I duplicated my site by: - Duplicating my database - Installing eZ Publish, pointing at that database - Migrating design and settings content from my old site - Changing path and database name references in the various settings files When I create new items in the duplicate database, everything works fine. But, my existing items (the ones duplicated from the old site) are loading only title data, and none of the other data_map elements. The data /does exist/ in the database, I've confirmed that. So, if I understand this correctly, it seems that data_map is a sorting of paging file for data, to avoid multiple SQL transactions? If that is correct, is there a way I can force the data_map to be populated from the existing data? I've already cleared all caches, as someone else suggested in relation to a template issue. The template issue was corrected. Sample debug output follows: Notice: eZMySQLDB::query(0.000 ms) query number per page:0 Mar 27 2006 09:04:09 SET NAMES 'windows-1252' Warning: eZMySQLDB Mar 27 2006 09:04:09 Connection warning: 1115: Unknown character set: 'windows-1252' Timing: Mar 27 2006 09:04:09 Module start 'content' Notice: Mar 27 2006 09:04:09 eZTemplate: Loading template "node/view/full.tpl" with resource "design" Notice: Mar 27 2006 09:04:09 design/prosoft/override/templates/product.tpl, iso-8859-1 Debug: Mar 27 2006 09:04:09 FETCH START URI: design:node/view/full.tpl, design/prosoft/override/templates/product.tpl Error: eZTemplate @ design/prosoft/override/templates/product.tpl:15[9] Mar 27 2006 09:04:09 No such attribute for array(0): name Choose one of following: Warning: eZTemplate:attribute_view_gui Mar 27 2006 09:04:09 Parameter attribute is not an object Error: eZTemplate @ design/prosoft/override/templates/product.tpl:17[9] Mar 27 2006 09:04:09 No such attribute for array(0): product_id Choose one of following: Error: eZTemplate @ design/prosoft/override/templates/product.tpl:19[2] Mar 27 2006 09:04:09 No such attribute for array(0): coming_soon Choose one of following:
Betsy Gamrat	Monday 27 March 2006 10:14:37 am Check the database synchronization. Setup > Upgrade check > Check database consistency It will give you a list of SQL commands that should be run to upgrade the database for use with the new version. You can run them on the command line, or use phpMyAdmin.
Raymond Williams	Monday 27 March 2006 11:18:50 am Thanks for the reply. I ran this utility as suggested, and it came back saying "Database check okay". No change in behavior, unfortunately, and no SQL suggestions.

Author

Message

Monday 27 March 2006 9:11:17 am

In an attempt to do major restructuring on a site, I duplicated my site by:

- Duplicating my database
- Installing eZ Publish, pointing at that database
- Migrating design and settings content from my old site
- Changing path and database name references in the various settings files

When I create new items in the duplicate database, everything works fine. But, my existing items (the ones duplicated from the old site) are loading only title data, and none of the other data_map elements. The data /does exist/ in the database, I've confirmed that. So, if I understand this correctly, it seems that data_map is a sorting of paging file for data, to avoid multiple SQL transactions? If that is correct, is there a way I can force the data_map to be populated from the existing data?

I've already cleared all caches, as someone else suggested in relation to a template issue. The template issue was corrected. Sample debug output follows:

Notice: eZMySQLDB::query(0.000 ms) query number per page:0  	Mar 27 2006 09:04:09

SET NAMES 'windows-1252'

Warning: eZMySQLDB 	Mar 27 2006 09:04:09

Connection warning: 1115: Unknown character set: 'windows-1252'

Timing: 	Mar 27 2006 09:04:09

Module start 'content'

Notice: 	Mar 27 2006 09:04:09

eZTemplate: Loading template "node/view/full.tpl" with resource "design"

Notice: 	Mar 27 2006 09:04:09

design/prosoft/override/templates/product.tpl, iso-8859-1

Debug: 	Mar 27 2006 09:04:09

FETCH START URI: design:node/view/full.tpl, design/prosoft/override/templates/product.tpl

Error: eZTemplate @ design/prosoft/override/templates/product.tpl:15[9] 	Mar 27 2006 09:04:09

No such attribute for array(0): name
Choose one of following: 

Warning: eZTemplate:attribute_view_gui 	Mar 27 2006 09:04:09

Parameter attribute is not an object

Error: eZTemplate @ design/prosoft/override/templates/product.tpl:17[9] 	Mar 27 2006 09:04:09

No such attribute for array(0): product_id
Choose one of following: 

Error: eZTemplate @ design/prosoft/override/templates/product.tpl:19[2] 	Mar 27 2006 09:04:09

No such attribute for array(0): coming_soon
Choose one of following:

Betsy Gamrat

Monday 27 March 2006 10:14:37 am

Check the database synchronization.

Setup > Upgrade check > Check database consistency

It will give you a list of SQL commands that should be run to upgrade the database for use with the new version.

You can run them on the command line, or use phpMyAdmin.

Raymond Williams

Monday 27 March 2006 11:18:50 am

Thanks for the reply. I ran this utility as suggested, and it came back saying "Database check okay". No change in behavior, unfortunately, and no SQL suggestions.

eZ debug

Timing:	Jan 19 2025 00:21:06
Script start
Timing:	Jan 19 2025 00:21:06
Module start 'layout'
Timing:	Jan 19 2025 00:21:06
Module start 'content'
Timing:	Jan 19 2025 00:21:08
Module end 'content'
Timing:	Jan 19 2025 00:21:08
Script end

Main resources:

Total runtime	1.2683 sec
Peak memory usage	4,096.0000 KB
Database Queries	57

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0067	587.9141	152.6250
Module start 'layout'	0.0067	0.0031	740.5391	39.4453
Module start 'content'	0.0098	1.2570	779.9844	505.4766
Module end 'content'	1.2668	0.0014	1,285.4609	12.1719
Script end	1.2683		1,297.6328

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0035	0.2765	16	0.0002
Check MTime	0.0013	0.1059	16	0.0001
Mysql Total
Database connection	0.0013	0.0993	1	0.0013
Mysqli_queries	1.2143	95.7399	57	0.0213
Looping result	0.0006	0.0499	55	0.0000
Template Total	1.2317	97.1	2	0.6159
Template load	0.0025	0.1946	2	0.0012
Template processing	1.2292	96.9175	2	0.6146
Template load and register function	0.0003	0.0207	1	0.0003
states
state_id_array	0.0014	0.1091	1	0.0014
state_identifier_array	0.0008	0.0642	2	0.0004
Override
Cache load	0.0021	0.1620	19	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0012	0.0946	2	0.0006
Fetch class attribute name	0.0024	0.1914	4	0.0006
XML
Image XML parsing	0.0012	0.0909	2	0.0006
class_abstraction
Instantiating content class attribute	0.0000	0.0012	4	0.0000
General
dbfile	0.0008	0.0666	16	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
3	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
4	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
1	content/datatype/view/ezxmltags/line.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/line.tpl
1	content/datatype/view/ezxmltags/literal.tpl	<No override>	extension/community/design/standard/templates/content/datatype/view/ezxmltags/literal.tpl
1	content/datatype/view/ezimage.tpl	<No override>	extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 12 Number of unique templates used: 7

Time used to render debug report: 0.0001 secs