Shop Confirm Order fails: Fatal error: A database...

Next topic

Author	Message
Maarten Holland	Monday 31 July 2006 3:05:48 am Hi everyone, I'm running 3.7 and created some products. When testing, I've choosen 'add to basket', set quantity to one, filled in my personal details and clicked 'confirm' in the final screen. At that point an error is returned: 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-f8b2b30blabla07b17 and has been logged. Please include the transaction ID and the current URL when contacting the system administrator. ezPublish error.log shows: Query error: Access denied for user 'myusername'@'localhost' to database 'mydatabase'. Query: LOCK TABLES ezorder WRITE. Transaction in progress failed due to DB error, transaction was rollbacked. Transaction ID is TRANSID-f8b2b30blabla07b17. I've checked the MySQL username and database: Both are correct. The order IS inserted into table 'ezorder'. I've tried this both as anonymous user and administrator with full control. I truly hope you can shine some light on this problem. Your help is highly appreciated. Cheers, Maarten
Pascal Specht	Friday 08 June 2007 6:54:32 am Hello, this still may happen in 3.9.2 and is not a bug in the shop system. Turning on SQL Debug information was very precious to find the origin of the problem: Error: eZMySQLDB Access denied for user 'johndoe'@'localhost' to database 'mylovelycustomer'. Query: LOCK TABLES ezorder WRITE ... well, the user hadn't the LOCK table authorization... Hope this helps others! Pascal

Author

Message

Monday 31 July 2006 3:05:48 am

Hi everyone,

I'm running 3.7 and created some products. When testing, I've choosen 'add to basket', set quantity to one, filled in my personal details and clicked 'confirm' in the final screen. At that point an error is returned:

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-f8b2b30blabla07b17 and has been logged.
Please include the transaction ID and the current URL when contacting the system administrator.

ezPublish error.log shows:

Query error: Access denied for user 'myusername'@'localhost' to database 'mydatabase'.
Query: LOCK TABLES ezorder WRITE. Transaction in progress failed due to DB error, transaction was rollbacked. Transaction ID is TRANSID-f8b2b30blabla07b17.

I've checked the MySQL username and database: Both are correct. The order IS inserted into table 'ezorder'.

I've tried this both as anonymous user and administrator with full control.

I truly hope you can shine some light on this problem.

Your help is highly appreciated.

Cheers,

Maarten

Pascal Specht

Friday 08 June 2007 6:54:32 am

Hello,

this still may happen in 3.9.2 and is not a bug in the shop system.
Turning on SQL Debug information was very precious to find the origin of the problem:

Error: eZMySQLDB
Access denied for user 'johndoe'@'localhost' to database 'mylovelycustomer'. Query: LOCK TABLES ezorder WRITE

... well, the user hadn't the LOCK table authorization...

Hope this helps others!

Pascal

eZ debug

Timing:	Jan 18 2025 22:24:02
Script start
Timing:	Jan 18 2025 22:24:02
Module start 'layout'
Timing:	Jan 18 2025 22:24:02
Module start 'content'
Timing:	Jan 18 2025 22:24:02
Module end 'content'
Timing:	Jan 18 2025 22:24:02
Script end

Main resources:

Total runtime	0.0150 sec
Peak memory usage	2,048.0000 KB
Database Queries	3

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0059	588.0469	152.6406
Module start 'layout'	0.0059	0.0027	740.6875	39.4922
Module start 'content'	0.0086	0.0044	780.1797	89.3672
Module end 'content'	0.0130	0.0019	869.5469	30.3047
Script end	0.0149		899.8516

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0024	16.2702	14	0.0002
Check MTime	0.0011	7.4153	14	0.0001
Mysql Total
Database connection	0.0008	5.2900	1	0.0008
Mysqli_queries	0.0021	14.1306	3	0.0007
Looping result	0.0000	0.0813	1	0.0000
Template Total	0.0016	10.7	1	0.0016
Template load	0.0009	5.9389	1	0.0009
Template processing	0.0007	4.6889	1	0.0007
Override
Cache load	0.0006	4.1995	1	0.0006
General
dbfile	0.0003	1.8670	8	0.0000
String conversion	0.0000	0.0478	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded	Edit	Override
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 1 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs