phplib/mysql problem

[aworthin]

The following is a message I have posted to the phplib mailing list but have received no responses and thought maybe someone who reads this could help me:

I am using a page that uses session, auth, and perm that use the database
sts_control. Within the page I have a db object setup that accesses
sts_control for some information. I have a second db object that access the
database sts_app for the main functionality of the application. On these
pages I am receiving the following error at the bottom when the page_close()
is called:

Database error: Invalid SQL: update active_sessions set val='deleted for
length', changed='20010201162441' where
sid='2eec7ef0448477a576bccbaab8fe4fa7' and name='sts_Session'
MySQL Error: 1146(Table 'sts_app.active_sessions' doesn't exist)

The db object for sts_control and sts_app use different user/password pairs.

Any idea what is causing this?

Thanks

[smulpur]

Looks like you are using the wrong db handle. For the message, it is trying to locate table, active_sessions in sts_app db where as it is probably in sts_control db.

[aworthin]

I double checked and I am not using the wrong db object. What I was told a year or more ago when I had a similar problem was that phplib was using persistent connections to mysql and if both db objects were setup with the same user/pass combo it would result in the same type of error. I orignally had them using the same user/pass but changed them thinking it would fix the problem and it didn't.

Any ideas?

Thanks