Print

[altagame]

Hello everyone, gallery was working fine yesturday, just went into have a look at it, and all I get is a "Fatal Error"

Any thoughts or ideas?

Alta.

[Tranz]

It loads fine for me. Maybe it was a temporary server glitch?

[altagame]

Hmm very strange. Still not working here and I am using 2 different computers on 2 different ISP's.

Chris

[altagame]

Note, I also have another copy of coppermine on a different domain but still on this server and it is working perfect.

Alta.

[Joachim Müller]

works as expected for me as well. When getting fatal errors, enable debug_mode in coppermine's config and report the error message (not the debug_output) here.

[altagame]

Hey folks, I can't enable debug mode, all I get is "Fatal Error:" on any page.

Last night I rolled it back to a previous backup I had and all was well. Then I got up today and back to this again... I am going to do the backup again and then turn debug mode on to see if it will show me the problem.


Alta.

[altagame]

Doesn't say anything about any errors. I guess I will wait to see if it corrupts again unless anyone has a suggesstion.

Alta.

[altagame]

Aha! Finally got it. Here is the output;


While executing query "SELECT u.user_id, u.user_password, u.user_level FROM `aba_phpbb1`.phpbb_sessions_keys AS s
                     INNER JOIN `aba_phpbb1`.phpbb_users AS u ON s.user_id = u.user_id WHERE u.user_id = '2' AND u.user_active = 1 AND s.key_id = MD5('f336fcf927bc87fba9a43a5c5e8cbc74')" on Resource id #17

mySQL error: Table 'aba_phpbb1.phpbb_sessions_keys' doesn't exist

Let me know if this means anything to you folks.

Thanks, Chris

[altagame]

ok really weird, now it is back up and working fine, this is the only thing now under the Notices section of the debug mode;

/include/functions.inc.php
Notice line 88: Undefined variable: cpg_show_private_album
/include/themes.inc.php
Notice line 1502: Undefined index: cat_thumb
Notice line 1746: Undefined index: inactive_next_tab
Notice line 1747: Undefined index: inactive_prev_tab
Notice line 1746: Undefined index: inactive_next_tab
Notice line 1747: Undefined index: inactive_prev_tab


Not sure if that helps or not. Hopefully with my last 2 posts someone will have some suggesstions. I really want to get this going so I can take it live.


Chris

[Stramm]

looks to me like server problems your host already fixed

[altagame]

The weird thing is, while this one is down another Coppermine is up and running on the same hosting account. I also have another Coppermine on a different domain but the same server that is running no problem as well.

Any thoughts on it being something with the Bridge with phpBB ?

Thanks,

Chris

[Stramm]

related to mysql

mySQL error: Table 'aba_phpbb1.phpbb_sessions_keys' doesn't exist

[altagame]

Ok good to know. Any advice on what the problem with SQL might be? Wierd how it only effects this account, wonder if I should kill this database and re-create it. Is there a chance that could resolve it or do you think it would be a waste of time?

Thanks a bunch.

Chris

[altagame]

Code: [Select]

mySQL error: Table 'aba_phpbb1.phpbb_sessions_keys' doesn't exist
Just had a closer look at this, correct me if I am reading this wrong,  Coppermine is trying to search my phpbb database for something that does not exist. So I guess I can say now its a bridge issue.

Just don't know how to fix the problem. My BBS is functioning no problem.

Chris

[Stramm]

I thought you said all's working now?
and you don't read wrong, your conclusion is wrong. Coppermine searches the phpbb db for the session keys. That's data necessary for user managemnt. If CPG won't do it, it can't use phpbb usertable
So the error means exactly what it says.. for the actual mysql user the mentioned table doesn't exist
Anyway, if it's working now don't do anything to 'fix' it even more.

[Nibbler]

http://forum.coppermine-gallery.net/index.php?topic=24032.0

[altagame]

ok here is an update that will hopefully help out other people in the future.

I have isolated the issue to bridging the wrong version of PHPBB. I thought I was using .18 but I am only using .17. When I had had it bridged incorrectly, the error would popup at different times. One hour it would be there, the next not. Once I updated to the right version, it seems to be working fine.

Alta.