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.