Forums / Developer / PearDB inside extension/module

PearDB inside extension/module

Previous topic

Developer

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

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

eZ debug

Timing:

Jan 18 2025 10:58:34

Script start

Timing:

Jan 18 2025 10:58:34

Module start 'content'

Timing:

Jan 18 2025 10:58:34

Module end 'content'

Timing:

Jan 18 2025 10:58:34

Script end

Main resources:

Total runtime

0.7360 sec

Peak memory usage

4,096.0000 KB

Database Queries

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0084	588.8281	180.8359
Module start 'content'	0.0084	0.7202	769.6641	428.8906
Module end 'content'	0.7287	0.0072	1,198.5547	42.1094
Script end	0.7359		1,240.6641

Checkpoint

Start (sec)

Duration (sec)

Memory at start (KB)

Memory used (KB)

Script start

0.0000

0.0084

588.8281

180.8359

Module start 'content'

0.0084

0.7202

769.6641

428.8906

Module end 'content'

0.7287

0.0072

1,198.5547

42.1094

Script end

0.7359

1,240.6641

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0031	0.4223	14	0.0002
Check MTime	0.0013	0.1825	14	0.0001
Mysql Total
Database connection	0.0007	0.0986	1	0.0007
Mysqli_queries	0.6944	94.3480	53	0.0131
Looping result	0.0005	0.0706	51	0.0000
Template Total	0.7019	95.4	2	0.3509
Template load	0.0020	0.2740	2	0.0010
Template processing	0.6999	95.0934	2	0.3499
Template load and register function	0.0003	0.0455	1	0.0003
states
state_id_array	0.0014	0.1863	1	0.0014
state_identifier_array	0.0010	0.1373	2	0.0005
Override
Cache load	0.0016	0.2160	15	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0007	0.0898	1	0.0007
Fetch class attribute name	0.0014	0.1885	2	0.0007
XML
Image XML parsing	0.0001	0.0148	1	0.0001
class_abstraction
Instantiating content class attribute	0.0001	0.0147	2	0.0001
General
dbfile	0.0045	0.6111	12	0.0004
String conversion	0.0000	0.0008	3	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Accumulator

Duration (sec)

Duration (%)

Count

Average (sec)

Ini load

Load cache

0.0031

0.4223

0.0002

Check MTime

0.0013

0.1825

0.0001

Mysql Total

Database connection

0.0007

0.0986

0.0007

Mysqli_queries

0.6944

94.3480

0.0131

Looping result

0.0005

0.0706

0.0000

Template Total

0.7019

95.4

0.3509

Template load

0.0020

0.2740

0.0010

Template processing

0.6999

95.0934

0.3499

Template load and register function

0.0003

0.0455

0.0003

states

state_id_array

0.0014

0.1863

0.0014

state_identifier_array

0.0010

0.1373

0.0005

Override

Cache load

0.0016

0.2160

0.0001

Sytem overhead

Fetch class attribute can translate value

0.0007

0.0898

0.0007

Fetch class attribute name

0.0014

0.1885

0.0007

XML

Image XML parsing

0.0001

0.0148

0.0001

class_abstraction

Instantiating content class attribute

0.0001

0.0147

0.0001

General

dbfile

0.0045

0.6111

0.0004

String conversion

0.0000

0.0008

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	pagelayout.tpl	<No override>	extension/sevenx/design/simple/templates/pagelayout.tpl
Number of times templates used: 6 Number of unique templates used: 4

Usage

Requested template

Template

Template loaded

Edit

Override

node/view/full.tpl

full/forum_topic.tpl

extension/sevenx/design/simple/override/templates/full/forum_topic.tpl