ezp3.6.1.beta1: EZSW-004 Failed inserting data to mysql...

Author Message

Alexandre Cunha

Tuesday 03 May 2005 6:43:42 am

Hi,

On my first try to install ezp 3.6.1. beta 1. i got this error in the last step of the istallation process:

EZSW-004Failed inserting data to mysql
BLOB column 'path_identification_string' can't be used in key specification with the used table type

What is wrong ?

Using FC3, apache 2.0, php 4.3.9, mysql 3.23

axel

http://AlexandreCunha.com

Jan Borsodi

Wednesday 04 May 2005 12:09:02 am

In 3.6 we try to make the tables using the <i>InnoDB</i> type, however on MySQL 3.23 it has some problems with these tables.
Because of this we added a check on the version number of MySQL so that we only use <i>innodb</i> for 4.0 or higher.

My guess is the there is something wrong in the check, i'll try it again on my machine.

--
Amos

Documentation: http://ez.no/ez_publish/documentation
FAQ: http://ez.no/ez_publish/documentation/faq

Jan Borsodi

Wednesday 04 May 2005 5:43:17 am

The problem has been found and fixed and will be included in 3.6.0rc1.

If you want to fix this yourself you can edit <i>kernel/setup/steps/ezstep_create_sites.php</i> and look for <i>innodb</i>, then change this text to <i>myisam</i>.
In other words the line should look like:

$params['table_type'] = 'myisam';

--
Amos

Documentation: http://ez.no/ez_publish/documentation
FAQ: http://ez.no/ez_publish/documentation/faq

Alexandre Cunha

Wednesday 04 May 2005 9:29:31 am

Hi,

Thanks. The error EZSW-004 is solved now.
But unfortunetly, remain another annoying problem in the last step of 3.6.1beta1 instalation.

The same problem exist for other ezp versions.

More info here:
http://ez.no/community/forum/install_configuration/install_fails_on_fc3_php_fatal_error
http://ez.no/community/bugs/problem_with_instalation_fatal_error/fedora_core_3_fatal_installation_problem
http://ez.no/community/bugs/ez_publish_3_5_0_not_working_on_fedora_core_3

Not sure if is a ezp bug or a problem in the default settings Apache+Mysql+Php on Fedora Core 3.

I hope someone can help.

axel

http://AlexandreCunha.com

Jan Borsodi

Friday 06 May 2005 1:00:56 am

I believe this is yet another example of the PHP reference bug.
We are still working on a solution for it but it will take some time to get everything to work properly.

Could you try to do a manual setup and see if you can get it to work?

--
Amos

Documentation: http://ez.no/ez_publish/documentation
FAQ: http://ez.no/ez_publish/documentation/faq

Frederik Holljen

Wednesday 11 May 2005 12:14:27 am

I've just installed eZ publish 3.6 beta1 successfully on FC3 with the exact same setup that you are using (clean install).
In other words: there is probably some configuration issue with one of these tools. Have you changed any php/apache/mysql settings at all?

Alexandre Cunha

Wednesday 18 May 2005 12:43:49 pm

<quote>
I've just installed eZ publish 3.6 beta1 successfully on FC3 with the exact same setup that you are using (clean install).
In other words: there is probably some configuration issue with one of these tools. Have you changed any php/apache/mysql settings at all?
</quote>

Hi Frederik

Thanks for your time testing with FC3.
The only change I have made is the httpd.conf enabling UserDir mode and disabling SElinux on my FC3.

I have more info about.

On my default instalation, I have:
php 4.3.9, Apache 2.0.52, mysql 3.23.58

With this config, I get the error
"Fatal error: eZ publish did not finish its request
The execution of eZ publish was abruptly ended, the debug output is present below."
on the last step of 3.6.0 rc1 instalation (and other versions)

The same error when I try use sites made with 3.4.2, and 3.4.4.

After upgrade to PHP 4.3.11, I finally can finish the instalation in the 3.6.0rc1 and 3.5.0
With other ezp versions (3.4.2 and 3.4.6) Im unable to install and run installed sites (previous instalation made with other linux distro)

Any ideias ?

axel

http://AlexandreCunha.com

Frederik Holljen

Thursday 19 May 2005 12:13:28 am

It sounds a lot like the reference problem in PHP that has been haunting us for a while now. We are still working very hard to resolve this problem.

Alexandre Cunha

Thursday 19 May 2005 9:30:52 am

Thanks,

This weekend I will try use Apache 1.3 to check if get some trouble.
Have someone any info about Apache 1.3+ezp and this "referene bug" ?

Its the fisrt time I try apache 2.
Before, have used SuSe 9.2 with apache 1.3 without any problematic bugs.

By the way ... where I can find more info about this "problematic reference bug" ?

thanks

axel

PS: someone knows where I can get a ready to install RPM of apache 1.3 to FC3 ?

http://AlexandreCunha.com

Alexandre Cunha

Tuesday 07 June 2005 11:58:47 pm

Have installed Apache 1.3 + PHP 4.3.11 + mysql 4.23 on the FC3 and now all sites are working fine.

thanks

http://AlexandreCunha.com

Frederik Holljen

Wednesday 08 June 2005 2:39:55 am

The PHP reference problem has been resolved in the upcoming PHP 4.4.

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 18 2025 11:04:05
Script start
Timing: Jan 18 2025 11:04:05
Module start 'layout'
Timing: Jan 18 2025 11:04:05
Module start 'content'
Timing: Jan 18 2025 11:04:06
Module end 'content'
Timing: Jan 18 2025 11:04:06
Script end

Main resources:

Total runtime0.8912 sec
Peak memory usage4,096.0000 KB
Database Queries83

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0061 588.1641152.6563
Module start 'layout' 0.00610.0039 740.820339.5234
Module start 'content' 0.00990.8798 780.3438683.9219
Module end 'content' 0.88970.0015 1,464.265624.0938
Script end 0.8912  1,488.3594 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00340.3808160.0002
Check MTime0.00150.1685160.0001
Mysql Total
Database connection0.00090.097610.0009
Mysqli_queries0.803190.1060830.0097
Looping result0.00080.0927810.0000
Template Total0.851095.520.4255
Template load0.00240.271020.0012
Template processing0.848695.214920.4243
Template load and register function0.00030.037310.0003
states
state_id_array0.00580.654910.0058
state_identifier_array0.00220.246520.0011
Override
Cache load0.00230.2563800.0000
Sytem overhead
Fetch class attribute can translate value0.00070.075530.0002
Fetch class attribute name0.00220.2445130.0002
XML
Image XML parsing0.00100.111630.0003
class_abstraction
Instantiating content class attribute0.00000.0049170.0000
General
dbfile0.00090.0983230.0000
String conversion0.00000.001240.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
11content/datatype/view/ezxmltext.tpl<No override>extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tplEdit templateOverride template
21content/datatype/view/ezxmltags/paragraph.tpl<No override>extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tplEdit templateOverride template
2content/datatype/view/ezxmltags/literal.tpl<No override>extension/community/design/standard/templates/content/datatype/view/ezxmltags/literal.tplEdit templateOverride template
6content/datatype/view/ezimage.tpl<No override>extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tplEdit templateOverride template
13content/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: 55
 Number of unique templates used: 7

Time used to render debug report: 0.0001 secs