PearDB inside extension/module

Next topic

Author	Message
Dan C	Thursday 16 December 2004 12:23:51 pm Hi, I'm trying to use a pear DB instance inside of an extension/module. I'm storing the $db instance inside $GLOBALS['mydbinst'] and its working perfectly except for one thing: I'm connecting to database 'dbOne' with PearDB and ezpublish is using the 'ezpub' database. When I enable debugging, I can see that ezpub is now trying to access ez tables from 'dbOne' instead of the 'ezpub' table and its causing some problems(Namely the menu template doesn't show up anymore, it can't grab any content from the db). Does anyone know why this is happening or know of any workarounds? Thanks, Dan
Dan C	Thursday 16 December 2004 6:26:53 pm For anyone else experience similar problems... I haven't found out what the problem is, but I have a solution. I'm thinking perhaps the problem is related to ezDb not using mysql_select_db properly or something... but it doesn't entirely make sense because pearDB and ezDb should be using different link id's... so I wasn't able to figure it out with my testing. I tried using global variables, local variables inside functions, static variables inside classes... and it was always the same problem. Here's my solution: I get peardb to connect to the 'ezpub' database, and every SQL query I do needs to be in the form of 'SELECT * FROM otherdb.tablename' -- in other words, I just specify the name of the other DB I want to access and this seems to keep ezDb happy and inside the correct database. Dan

Author

Message

Thursday 16 December 2004 12:23:51 pm

Hi,

I'm trying to use a pear DB instance inside of an extension/module. I'm storing the $db instance inside $GLOBALS['mydbinst'] and its working perfectly except for one thing:

I'm connecting to database 'dbOne' with PearDB and ezpublish is using the 'ezpub' database. When I enable debugging, I can see that ezpub is now trying to access ez tables from 'dbOne' instead of the 'ezpub' table and its causing some problems(Namely the menu template doesn't show up anymore, it can't grab any content from the db).

Does anyone know why this is happening or know of any workarounds?

Thanks,

Dan

Dan C

Thursday 16 December 2004 6:26:53 pm

For anyone else experience similar problems... I haven't found out what the problem is, but I have a solution.

I'm thinking perhaps the problem is related to ezDb not using mysql_select_db properly or something... but it doesn't entirely make sense because pearDB and ezDb should be using different link id's... so I wasn't able to figure it out with my testing. I tried using global variables, local variables inside functions, static variables inside classes... and it was always the same problem.

Here's my solution:

I get peardb to connect to the 'ezpub' database, and every SQL query I do needs to be in the form of 'SELECT * FROM otherdb.tablename' -- in other words, I just specify the name of the other DB I want to access and this seems to keep ezDb happy and inside the correct database.

Dan

eZ debug

Timing:	Jan 31 2025 00:35:08
Script start
Timing:	Jan 31 2025 00:35:08
Module start 'layout'
Timing:	Jan 31 2025 00:35:08
Module start 'content'
Timing:	Jan 31 2025 00:35:09
Module end 'content'
Timing:	Jan 31 2025 00:35:09
Script end

Main resources:

Total runtime	0.9934 sec
Peak memory usage	8,192.0000 KB
Database Queries	52

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0047	588.1328	151.2109
Module start 'layout'	0.0047	0.0037	739.3438	220.6875
Module start 'content'	0.0084	0.9840	960.0313	4,162.6719
Module end 'content'	0.9924	0.0009	5,122.7031	7.8516
Script end	0.9933		5,130.5547

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0034	0.3447	16	0.0002
Check MTime	0.0012	0.1248	16	0.0001
Mysql Total
Database connection	0.0007	0.0694	1	0.0007
Mysqli_queries	0.9200	92.6134	52	0.0177
Looping result	0.0006	0.0555	50	0.0000
Template Total	0.9447	95.1	2	0.4724
Template load	0.0019	0.1895	2	0.0009
Template processing	0.9428	94.9152	2	0.4714
Template load and register function	0.0012	0.1163	1	0.0012
states
state_id_array	0.0014	0.1366	1	0.0014
state_identifier_array	0.0019	0.1885	2	0.0009
Override
Cache load	0.0015	0.1548	15	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0019	0.1893	1	0.0019
Fetch class attribute name	0.0029	0.2950	2	0.0015
XML
Image XML parsing	0.0001	0.0131	1	0.0001
class_abstraction
Instantiating content class attribute	0.0000	0.0010	2	0.0000
General
dbfile	0.0007	0.0688	10	0.0001
String conversion	0.0000	0.0008	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
2	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
2	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: 6 Number of unique templates used: 4

Time used to render debug report: 0.0001 secs