Forums / Install & configuration / A database transaction error occured while installing eZ 4.1

A database transaction error occured while installing eZ 4.1

Next topic

Author	Message
Jianjun Hu	Tuesday 17 March 2009 6:59:49 pm The related configuration of my PC is as following: Windows XP SP2 XAMPP 1.6.3a --Apache 2.2.4 --PHP 5.2.3 --MySQL 5.0.45 An error occured while I'm installing <b>eZ Publish 4.1.0</b>. Fatal error: A database transaction in eZ Publish failed. The current execution was stopped to prevent further problems. You should contact the System Administrator of this site with the information on this page. The current transaction ID is TRANSID-7cd620332a91ef3e8799c69050b66ab1 and has been logged. Please include the transaction ID and the current URL when contacting the system administrator. The <b>error.log</b> is: [ Mar 18 2009 02:22:55 ] [127.0.0.1] eZDBInterface::commit TRANSID-7cd620332a91ef3e8799c69050b66ab1: Transaction in progress failed due to DB error, transaction was rollbacked. Transaction ID is TRANSID-7cd620332a91ef3e8799c69050b66ab1. What's the problem? How can I solved it? Thanks! OnlyBlue ☆．．·°∴°．☆°°．☆°． °∴ °☆ ．·enjoy star° ．·★°∴° ∴°．°★ ．·° 　ミ☆°∴°．★☆° ∴·° °．☆° ．·∴°　 Is it a pleasure after all to practice in due time what one has learnt?
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?