Forums / Install & configuration / Populate data_map

Populate data_map

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.

eZ debug

Timing: Jan 31 2025 05:33:46
Script start
Timing: Jan 31 2025 05:33:46
Module start 'content'
Timing: Jan 31 2025 05:33:46
Module end 'content'
Timing: Jan 31 2025 05:33:46
Script end

Main resources:

Total runtime0.1554 sec
Peak memory usage2,048.0000 KB
Database Queries141

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0052 587.9297180.8359
Module start 'content' 0.00520.0077 768.765694.0078
Module end 'content' 0.01290.1424 862.7734524.2500
Script end 0.1553  1,387.0234 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00322.0835200.0002
Check MTime0.00130.8244200.0001
Mysql Total
Database connection0.00070.460910.0007
Mysqli_queries0.104367.10881410.0007
Looping result0.00130.85001390.0000
Template Total0.142191.410.1421
Template load0.00080.516810.0008
Template processing0.141390.929510.1413
Override
Cache load0.00050.335910.0005
Sytem overhead
Fetch class attribute can translate value0.00090.610710.0009
XML
Image XML parsing0.00030.168610.0003
General
dbfile0.01086.9431200.0005
String conversion0.00000.003730.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
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 1
 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs