after activating ezfind and adding table for solaris index getting db error

Next topic

Author	Message
Romeo Antony	Sunday 24 October 2010 8:35:12 am Transaction in progress failed due to DB error, transaction was rollbacked. Transaction ID is TRANSID-03716807180dbc7c6e746a63bab549aa. [ Oct 24 2010 19:03:42 ] [192.168.0.200] eZMySQLiDB: Query error (1146): Table 'muscatdaily.ezfind_elevate_configuration' doesn't exist. Query: DELETE FROM ezfind_elevate_configuration WHERE contentobject_id='424' [ Oct 24 2010 19:03:42 ] [192.168.0.200] eZDBInterface::commit TRANSID-b24467d0fd31ca91a430fc44171c872f: ezfind_elevate_configuration error. Do anyone have a better idea about it. I am unable to get into so site access even admin site access. But when I deactivate ezfind , working fine
Paul Borgermans	Sunday 24 October 2010 3:00:47 pm You need to create a dedicated table used by ez find (elevation feature), see extension/ezfind/sql/<yourrdbms>/<yourrdbms>.sql Then the error will disappear hth Paul eZ Publish, eZ Find, Solr expert consulting and training http://twitter.com/paulborgermans
Romeo Antony	Sunday 24 October 2010 3:07:53 pm Thankyou paul. did and I think now I am not getting error. Thanks a lot
Gaetano Giunta	Monday 25 October 2010 4:55:23 am Please note that since version 4.3 of eZP, if you just go to the Setup \| Upgrade Check \| DB Upgrade check page in the admin interface (after having activated eZFind but not created the table) eZP will gently warn you and produce the SQL string that you need to run to create the table, to copy and paste from the browser into your sql console. Principal Consultant International Business Member of the Community Project Board
Romeo Antony	Monday 25 October 2010 6:27:08 am Suppose if I run executed the create tabel query from extension/ezfind/sql/<yourrdbms>/<yourrdbms>.sql instead of the one that generated on browser(as Gaetano told me) when check the db upgrade with warning. it would cause any issues in future.?
Gaetano Giunta	Monday 25 October 2010 6:44:39 am In principle, the one that eZP suggests to you should be exactly the same as the one you find in extension/ezfind/sql/<yourrdbms>/<yourrdbms>.sql. So, after having created it by hand running extension/ezfind/sql/<yourrdbms>/<yourrdbms>.sql, you are welcome to: - run the db upgrade check once more (it never hurts) - feel more confident that everything is ok if there is no discrepancy shown, or - if there is any discrepancy shown, report it here or in the issue tracker :-) Principal Consultant International Business Member of the Community Project Board

eZ debug

Timing:	Jan 18 2025 10:40:35
Script start
Timing:	Jan 18 2025 10:40:35
Module start 'layout'
Timing:	Jan 18 2025 10:40:35
Module start 'content'
Timing:	Jan 18 2025 10:40:36
Module end 'content'
Timing:	Jan 18 2025 10:40:36
Script end

Main resources:

Total runtime	0.8553 sec
Peak memory usage	4,096.0000 KB
Database Queries	70

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0079	589.5547	152.6875
Module start 'layout'	0.0079	0.0083	742.2422	39.5625
Module start 'content'	0.0162	0.8378	781.8047	623.7109
Module end 'content'	0.8540	0.0013	1,405.5156	16.0547
Script end	0.8553		1,421.5703

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0037	0.4271	16	0.0002
Check MTime	0.0014	0.1606	16	0.0001
Mysql Total
Database connection	0.0007	0.0866	1	0.0007
Mysqli_queries	0.7796	91.1491	70	0.0111
Looping result	0.0008	0.0924	68	0.0000
Template Total	0.8030	93.9	2	0.4015
Template load	0.0036	0.4266	2	0.0018
Template processing	0.7994	93.4600	2	0.3997
Template load and register function	0.0001	0.0116	1	0.0001
states
state_id_array	0.0016	0.1894	1	0.0016
state_identifier_array	0.0021	0.2467	2	0.0011
Override
Cache load	0.0032	0.3723	38	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0007	0.0838	3	0.0002
Fetch class attribute name	0.0020	0.2382	9	0.0002
XML
Image XML parsing	0.0016	0.1828	3	0.0005
class_abstraction
Instantiating content class attribute	0.0000	0.0027	12	0.0000
General
dbfile	0.0011	0.1230	29	0.0000
String conversion	0.0000	0.0011	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
1	node/view/full.tpl	full/forum_topic.tpl	extension/sevenx/design/simple/override/templates/full/forum_topic.tpl
6	content/datatype/view/ezimage.tpl	<No override>	extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tpl
6	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
1	content/datatype/view/ezxmltags/line.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/line.tpl
6	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 21 Number of unique templates used: 6

Time used to render debug report: 0.0001 secs