ezuser_discountrule table missing

Previous topic

Install & configuration

Next topic

Author	Message
peter peter	Thursday 07 July 2005 7:40:32 am Hi, i changed nothing. but now comes a error when opening the basket. Fatal error: A database transaction in eZ publish failed. the "ezuser_discountrule" table is missing?
Łukasz Serwatka	Friday 22 July 2005 3:33:46 am You can restore your table structure executing SQL code. From eZ publish 3.6 distro CREATE TABLE `ezuser_discountrule` ( `contentobject_id` int(11) default NULL, `discountrule_id` int(11) default NULL, `id` int(11) NOT NULL auto_increment, `name` varchar(255) NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; Personal website -> http://serwatka.net Blog (about eZ Publish) -> http://serwatka.net/blog

Author

Message

peter peter

Thursday 07 July 2005 7:40:32 am

Hi,
i changed nothing. but now comes a error when opening the basket.

Fatal error: A database transaction in eZ publish failed.

the "ezuser_discountrule" table is missing?

Łukasz Serwatka

Friday 22 July 2005 3:33:46 am

You can restore your table structure executing SQL code.

From eZ publish 3.6 distro

CREATE TABLE `ezuser_discountrule` (
  `contentobject_id` int(11) default NULL,
  `discountrule_id` int(11) default NULL,
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Personal website -> http://serwatka.net
Blog (about eZ Publish) -> http://serwatka.net/blog

eZ debug

Timing:	Jan 31 2025 00:20:49
Script start
Timing:	Jan 31 2025 00:20:49
Module start 'layout'
Timing:	Jan 31 2025 00:20:49
Module start 'content'
Timing:	Jan 31 2025 00:20:49
Module end 'content'
Timing:	Jan 31 2025 00:20:49
Script end

Main resources:

Total runtime	0.0431 sec
Peak memory usage	4,096.0000 KB
Database Queries	3

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0058	588.2578	151.2266
Module start 'layout'	0.0058	0.0053	739.4844	220.7188
Module start 'content'	0.0110	0.0305	960.2031	997.9609
Module end 'content'	0.0416	0.0014	1,958.1641	29.9922
Script end	0.0430		1,988.1563

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0030	6.9705	14	0.0002
Check MTime	0.0012	2.7183	14	0.0001
Mysql Total
Database connection	0.0007	1.5444	1	0.0007
Mysqli_queries	0.0035	8.1477	3	0.0012
Looping result	0.0000	0.0443	1	0.0000
Template Total	0.0010	2.2	1	0.0010
Template load	0.0008	1.7698	1	0.0008
Template processing	0.0002	0.4114	1	0.0002
Override
Cache load	0.0005	1.2614	1	0.0005
General
dbfile	0.0119	27.6881	8	0.0015
String conversion	0.0000	0.0210	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