Custom Header Problem

[fareforce]

Coppermine Version: 1.4.8
Website: http://www.alaskastudio.com
Coppermine Installation: http://www.alaskastudio.com/gallery
Coppermine is bridged with SFM


Okay now that I have that out of the way I am trying to include a php file (leftnav.php) for a left menu through the admin control panel. The problem is that the left menu php file accesses a different database on my server then coppermine uses.

My aurora meter uses alaskastudio_com_aurora
Coppermine uses alaskastudio_com_photo

Because of this I get the error:
Database Error: Table 'alaskastudio_com_aurora.smf_sessions' doesn't exist

The error is true, but I can't figure out why it is not switching databases. Unfortunatly, I dont want to move the database for the aurora program to the Coppermine one as it is really big. I am trying to keep it running smoothly, and as quick as possable. Any sugesstions?

[Sami]

Rename leftnav.php to leftnav.txt and attach it to this thread using Additional Options, to check the connection string

[fareforce]

leftnav.php is actually composed of two files.

leftnav.php (which builds the left navigation layout, and aurora.php (the actual aurora program that accesses the database).

I have only included aurora.php (aurora.txt) as that should be the only one in question. I also added some notes so you can see what is going on easier. If for some reason you need the other one, please let me know.

Thank you so much in advance for your help.

[Sami]

okey you have variable conflict problem , bridge file for smf use the $db_name for smf database name
try to rename your $db_name under aurora to something else something like $ar_db_name

[Nibbler]

Are you using the same database username for coppermine or smf and aurora?

[fareforce]

okey you have variable conflict problem , bridge file for smf use the $db_name for smf database name
try to rename your $db_name under aurora to something else something like $ar_db_name

I will try that.

[fareforce]

Are you using the same database username for coppermine or smf and aurora?

Yes - I also kust noticed that I left the username/password in the file. The file has been changed to erase them, and they have been changed.

[Nibbler]

You'll need to either use different mysql users or add code to keep the database connections seperate.

[fareforce]

okey you have variable conflict problem , bridge file for smf use the $db_name for smf database name
try to rename your $db_name under aurora to something else something like $ar_db_name

Now I get:

Code Select Expand

Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 35 bytes) in /home/virtual/site3/fst/var/www/html/gallery/include/debugger.inc.php on line 112
Database Error: Table 'alaskastudio_com_aurora.smf_sessions' doesn't exist
File: /home/virtual/site3/fst/var/www/html/board/Sources/Load.php
Line: 1193
Warning: Unknown(): A session is active. You cannot change the session module's ini settings at this time. in Unknown on line 0

[Joachim Müller]

Fatal error: Allowed memory size of X bytes exhausted

[Sami]

@fareforce:
you didn't replace (change) all $db_name on the aurora meter files

[fareforce]

@fareforce:
you didn't replace (change) all $db_name on the aurora meter files

I did, I just forgot to upload the new file.. here it is..

[fareforce]

You'll need to either use different mysql users or add code to keep the database connections seperate.

add code to CPG or to aurora? Also, what code.. I thought re-establishing the connection would work. In aurora I terminate the connection very quickly to save on bandwidth.

[Nibbler]

Yeah, but you are not actually re-establishing the connection. If you connect again to the same server with the same user then it will just re-use the connection you already had. Your code will then switch to the aurora database and confuse SMF when it cleans up your session. I can't come up with the code to fix it off the top of my head, you'll need to either switch users or code it yourself. Maybe disabling db sessions in SMF will help.

[fareforce]

Yeah, but you are not actually re-establishing the connection. If you connect again to the same server with the same user then it will just re-use the connection you already had. Your code will then switch to the aurora database and confuse SMF when it cleans up your session. I can't come up with the code to fix it off the top of my head, you'll need to either switch users or code it yourself. Maybe disabling db sessions in SMF will help.

I will try it with a different sql login. Now I just have to remeber my root login.. LOL

[fareforce]

Well, as you said it works fine with 2 seperate logins. Now I just have to figure out why the program is blowing apart the template in cpg. It work fine everywhere else.