DB problem with moving eZ installation (MySQL error: 1073)

Author Message

Martin Simek

Friday 30 December 2005 1:12:13 am

Hi,

I have developed one eZ site on my local machine where is MySQL 4.0.21-nt and now I want to transfer full DB to server where is MySQL 4.0.12-nt. I gain this error when I am importing data (structure + data):

"#1073 - BLOB column 'path_identification_string' catn't be used in key specification with the used table type".

What may I do to import DB properly?

Thanks,
Martin Simek

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.

eZ debug

Timing: Jan 19 2025 03:30:55
Script start
Timing: Jan 19 2025 03:30:55
Module start 'layout'
Timing: Jan 19 2025 03:30:55
Module start 'content'
Timing: Jan 19 2025 03:30:56
Module end 'content'
Timing: Jan 19 2025 03:30:56
Script end

Main resources:

Total runtime0.9809 sec
Peak memory usage4,096.0000 KB
Database Queries46

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0055 589.4375152.6563
Module start 'layout' 0.00550.0052 742.093839.4922
Module start 'content' 0.01070.9688 781.5859399.9922
Module end 'content' 0.97940.0015 1,181.57818.0938
Script end 0.9809  1,189.6719 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00420.4290160.0003
Check MTime0.00200.2050160.0001
Mysql Total
Database connection0.00080.080210.0008
Mysqli_queries0.933895.1940460.0203
Looping result0.00050.0501440.0000
Template Total0.938295.620.4691
Template load0.00350.353320.0017
Template processing0.934795.290020.4674
Template load and register function0.00020.024510.0002
states
state_id_array0.00160.161810.0016
state_identifier_array0.00220.222520.0011
Override
Cache load0.00260.262490.0003
Sytem overhead
Fetch class attribute can translate value0.00070.070610.0007
Fetch class attribute name0.00080.086110.0008
XML
Image XML parsing0.00010.012210.0001
class_abstraction
Instantiating content class attribute0.00000.000510.0000
General
dbfile0.00140.1418100.0001
String conversion0.00000.001140.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

UsageRequested templateTemplateTemplate loadedEditOverride
1node/view/full.tplfull/forum_topic.tplextension/sevenx/design/simple/override/templates/full/forum_topic.tplEdit templateOverride template
1content/datatype/view/ezxmltext.tpl<No override>extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tplEdit templateOverride template
2content/datatype/view/ezxmltags/paragraph.tpl<No override>extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tplEdit templateOverride template
1content/datatype/view/ezxmltags/line.tpl<No override>design/standard/templates/content/datatype/view/ezxmltags/line.tplEdit templateOverride template
1print_pagelayout.tpl<No override>extension/community/design/community/templates/print_pagelayout.tplEdit templateOverride template
 Number of times templates used: 6
 Number of unique templates used: 5

Time used to render debug report: 0.0001 secs