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.

eZ debug

Timing: Jan 18 2025 04:26:53
Script start
Timing: Jan 18 2025 04:26:53
Module start 'content'
Timing: Jan 18 2025 04:26:54
Module end 'content'
Timing: Jan 18 2025 04:26:54
Script end

Main resources:

Total runtime1.2033 sec
Peak memory usage4,096.0000 KB
Database Queries220

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0189 589.0938180.8047
Module start 'content' 0.01891.0431 769.8984685.0313
Module end 'content' 1.06210.1411 1,454.9297348.4219
Script end 1.2032  1,803.3516 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00540.4472210.0003
Check MTime0.00270.2259210.0001
Mysql Total
Database connection0.00170.142610.0017
Mysqli_queries1.100791.47812200.0050
Looping result0.00210.17812180.0000
Template Total1.149595.520.5748
Template load0.00200.164720.0010
Template processing1.147595.368020.5738
Template load and register function0.00010.011910.0001
states
state_id_array0.00220.184410.0022
state_identifier_array0.00130.110620.0007
Override
Cache load0.00180.1456800.0000
Sytem overhead
Fetch class attribute can translate value0.00160.136940.0004
Fetch class attribute name0.00140.1176130.0001
XML
Image XML parsing0.00120.103640.0003
class_abstraction
Instantiating content class attribute0.00000.0028170.0000
General
dbfile0.00250.2056340.0001
String conversion0.00000.000930.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
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
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/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