A database transaction error occured while installing eZ 4.1

A database transaction error occured while installing eZ 4.1

Tuesday 17 March 2009 6:59:49 pm - 7 replies

Modified on Tuesday 17 March 2009 7:01:11 pm by Jianjun Hu

Author Message

André R.

Wednesday 18 March 2009 12:05:50 am

At what stage? using witch package?

But most of all, check your transaction log to see what query caused the problem!

eZ Online Editor 5: http://projects.ez.no/ezoe || eZJSCore (Ajax): http://projects.ez.no/ezjscore || eZ Publish EE http://ez.no/eZPublish/eZ-Publish-Enterprise-Subscription
@: http://twitter.com/andrerom

Jianjun Hu

Wednesday 18 March 2009 12:50:46 am

Thanks for your reply!

The stage was exactly <b>after sending installing message to ez.no</b> and the installing progress was <b>92%</b>. I used <b>Website Interface 1.4</b>.
I'm sorry I didn't find the <b>transaction log</b>.

OnlyBlue

☆..·°∴°.☆°°.☆°.
°∴ °☆ .·enjoy star° .·★°∴°
∴°.°★ .·°
  ミ☆°∴°.★☆° ∴·°
°.☆° .·∴° 

Is it a pleasure after all to practice in due time what one has learnt?

André R.

Wednesday 18 March 2009 3:18:19 am

hmm, can not reproduce.

Setup:
* Vista 64bit + Apache 2.0.63 + php 5.2.9 (xampserver 2.0g)

Selections:
* eng-GB + nor-No
* map french demo content to eng-GB
* mysqli
* webin 1.4.0

eZ Online Editor 5: http://projects.ez.no/ezoe || eZJSCore (Ajax): http://projects.ez.no/ezjscore || eZ Publish EE http://ez.no/eZPublish/eZ-Publish-Enterprise-Subscription
@: http://twitter.com/andrerom

Jianjun Hu

Wednesday 18 March 2009 7:59:45 am

The installation succeed by using <b>Plain site</b> and <b>eZ Flow </b>. But the <b>Website Interface</b> never succeed. I will try again tomorrow.

OnlyBlue

☆..·°∴°.☆°°.☆°.
°∴ °☆ .·enjoy star° .·★°∴°
∴°.°★ .·°
  ミ☆°∴°.★☆° ∴·°
°.☆° .·∴° 

Is it a pleasure after all to practice in due time what one has learnt?

Jianjun Hu

Wednesday 18 March 2009 7:33:03 pm

Same error occured at the same stage while installing the <b>eZ Publish 4.1.0</b> with the package <b>Website Interface 1.4-0</b>.

OnlyBlue

☆..·°∴°.☆°°.☆°.
°∴ °☆ .·enjoy star° .·★°∴°
∴°.°★ .·°
  ミ☆°∴°.★☆° ∴·°
°.☆° .·∴° 

Is it a pleasure after all to practice in due time what one has learnt?

André R.

Wednesday 18 March 2009 11:49:34 pm

And you have some more info on what options you select now? (I assume you use the same selections every time, feel free to correct me.)

eZ Online Editor 5: http://projects.ez.no/ezoe || eZJSCore (Ajax): http://projects.ez.no/ezjscore || eZ Publish EE http://ez.no/eZPublish/eZ-Publish-Enterprise-Subscription
@: http://twitter.com/andrerom

Jianjun Hu

Thursday 19 March 2009 1:21:21 am

I record all the settings this time.

1.
Chinese
2.
smtp.mail.yahoo.com
3.
MySQL
4.
localhost
3306
ez41
ez41
5.
Chinese+English(United Kingdom)
6.
Website Interface (ver. 1.4-0)
7.
French -> English(United Kingdom)
8.
URL
9.
admin
Administeator
User
xxx@yahoo.com
password
password

The content of the register info email is:

Site info:

  Site package  - ezwebin_site
  Title         - Website Interface
  URL           - http://localhost/ez41/index.php/ezwebin_site
  Admin URL     - http://localhost/ez41/index.php/ezwebin_site_admin
  Access type   - url
  Access value  - ezwebin_site


Web server info:
Version - Apache/2.2.4 (Win32) DAV/2 mod_ssl/2.2.4 OpenSSL/0.9.8e 

mod_autoindex_color mod_perl/2.0.3 Perl/v5.8.8

PHP info:
Version - 5.2.3

OS info
Name - Windows NT 5.1 build 2600

Database info:
Type - MySQL
Driver - ezmysql


Email info:
Transport - SMTP

Image conversion:

ImageGD extension was found and used.

Regional info:
Primary - chi-CN
Additional - eng-GB, chi-CN

Critical tests

variables_order - Success
directory_permissions - Success
phpversion - Success
database_extensions - Success
image_conversion - Success
open_basedir - Success
safe_mode - Success
memory_limit - Success
execution_time - Success
magic_quotes_runtime - Success
allow_url_fopen - Success
accept_path_info - Success
php_session - Success
file_upload - Success
zlib_extension - Success
dom_extension - Success
timezone - Success

Other tests:

php_magicquotes - Failure
mbstring_extension - Success
curl_extension - Failure
imagegd_extension - Success
imagemagick_program - Failure
database_all_extensions - Success
php_register_globals - Success
texttoimage_functions - Success

When the installation complete, the following errors apperared:

 *   EZSW-004
      Failed inserting data to mysql
      Table 'ezapprove_items' already exists
 * EZSW-040
      Failed to initialize site package 'ezwebin_site'

The transaction error didn't appeare this time.
Actually, I deleted all the table from the database before installing.

☆..·°∴°.☆°°.☆°.
°∴ °☆ .·enjoy star° .·★°∴°
∴°.°★ .·°
  ミ☆°∴°.★☆° ∴·°
°.☆° .·∴° 

Is it a pleasure after all to practice in due time what one has learnt?

You must be logged in to post messages in this topic!

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