Unrecoverable error

[Yellowspurs]

Several of my members are having log in problem with photopost. I have the gallery intergrated with the forum and it's been running fine for over 4 years.

But lately some members are having the following error when they try to log in into the gallery:

"We're sorry, but the system experienced an unrecoverable error. Please try again later."

If someone know what the problem is, please drop a line.

My photopost version is 5.62

[Chuck S]

try setting the debug option to email errors and then post here the specific error so we can assist. what happens when you try logging in?

[Yellowspurs]

Below is the error report I got when I set the debug option to email.

An error was encountered during execution of the query:

REPLACE INTO phpbb_sessions (session_id,session_user_id,session_start,session_time,session_ip,session_page,session_logged_in)
VALUES ('d9a00eaca685dec6e7f99fdd8bb75342',, 1217824486, 1217824486, '4ca8ce6a', '0', '1')

The query returned with an errorcode of:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 1217824486, 1217824486, '4ca8ce6a', '0', '1')' at line 2

If you need assistence or feel this is a 'bug'; please report it to our support forums at: http://www.photopost.com/members/forum/f66/index.html

To turn off these emails, set $debug=0 in your config-inc.php file.

[Yellowspurs]

I've created a nick so you can test it.
Please test it at Naked heels :: Index and My Photo Gallery - Main Index - Powered by PhotoPost

You can test it with "chuck" and pass word "chuck"

Forum log in is ok. The problem is in the gallery, it say "Invalid login. Please check your username and password, or register."

When I clear the cookie and try to log in again, it say "log in successfully" but when I look at it, it haven't log me in yet.

[Chuck S]

Make sure lines 218-219 of phpbb2.php in your photopost forums subdirectory read this

Content visible to verified customers only.

[Yellowspurs]

I have the exact same code in my phpbb2.php. Below are the code that I copy from my file.

$query = "REPLACE INTO {$Globals['dprefix']}sessions (session_id,session_user_id,session_start,session_time,session_ip,session_page,session_logged_in)
VALUES ('$session_id',{$User['userid']}, $sesstime, $sesstime, '$ipaddr', '0', '1')";

[Yellowspurs]

Just a note,
This problem only happen to a few old members but happen to all new members.

[Chuck S]

Your line and mine are not the same copy and paste what I have

[Yellowspurs]

Hi Chuck, I've found out the error and want to share.
What happened was that I have several database and I point the forum config file to one database while pointing the config file of the photopost to another. This is why all new member can't upload photos since the gallery does not recognize them.

[Chuck S]

Yes that would indeed be an issue if the database info is not correct for the proper forum database.