| gdaybloke | September 9th, 2007 06:37 PM |
MySQL errors
Okay, since I installed PhotoPost on my client's site I've had difficulty getting it to integrate successfully with phpBB. 1. We're running phpBB 2.0.22. Every time someone switches between the forum and the gallery, it logs them out of the gallery, forcing them to manually log in again every time. This is a significant inconvenience to my client and her patrons.
I can only assume this is directly linked to only a dozen or so of the members showing up when clicking the Personal Galleries link from the gallery index.
In the past when I've brought this up I've received some advice on setting the cookies, but each time it's caused other problems - including denying access to the admin panels of the forum when using IE7, which I'm sure you can understand is not acceptable. 2. We've also periodically been receiving mySQL errors. Since I know diddly about mySQL, I'm hoping someone here can provide some insight.
The most recent two batches of errors: Quote:
Originally Posted by September 2nd Quote:
An error was encountered during execution of the query:
DELETE FROM phpbb_sessions WHERE session_user_id=
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 '' at line 1
| Quote:
REPLACE INTO phpbb_sessions (session_id,session_user_id,session_start,session_time,session_ip,session_page,session_logged_in)
VALUES ('6e3c3f72d079a4ed57b35cf4a875a894',, 1188772819, 1188772819, '1896cbbe', '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 ' 1188772819, 1188772819, '1896cbbe', '0', '1')' at line 2
| Quote:
REPLACE INTO phpbb_sessions (session_id,session_user_id,session_start,session_time,session_ip,session_page,session_logged_in)
VALUES ('6e3c3f72d079a4ed57b35cf4a875a894',, 1188772819, 1188772819, '1896cbbe', '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 ' 1188772819, 1188772819, '1896cbbe', '0', '1')' at line 2
|
| Quote:
Originally Posted by September 9th Quote:
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 ('ca5e965344526e346ca50bc9ae4d9f09',, 1189373721, 1189373721, '415c33eb', '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 ' 1189373721, 1189373721, '415c33eb', '0', '1')' at line 2
| Quote:
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 ('ca5e965344526e346ca50bc9ae4d9f09',, 1189373721, 1189373721, '415c33eb', '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 ' 1189373721, 1189373721, '415c33eb', '0', '1')' at line 2
| Quote:
DELETE FROM phpbb_sessions WHERE session_user_id=
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 '' at line 1
|
| I would appreciate any help anyone can provide. If a PhotoPost staff member could take a look at things, that would be a huge help. |
