Forums / Install & configuration / ezp3.6.1.beta1: EZSW-004 Failed inserting data to mysql...

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.