coppermine-gallery.com/forum

Support => cpg1.3.x Support => Older/other versions => cpg1.3 (BBS) Integration / Bridging => Topic started by: freesouljah on January 17, 2006, 05:01:46 AM

Title: New Bridge file for phpBB ERROR in CPM Fetch RSS
Post by: freesouljah on January 17, 2006, 05:01:46 AM
I tried asking this in the cpm fetch rss post (http://forum.coppermine-gallery.net/index.php?topic=17381.msg119382#msg119382)...but vuud told me it wasn't a cpmfetch issue...


with the new bridge file for phpBB 2.18 the rss feed isn't working right...

It shows the photo & info like normal, but when someone clicks the thumbnail or the 'open in browser' option it gives this error:

QuoteNotice: Use of undefined constant PHPBB_SESSIONS_KEYS_TABLE - assumed 'PHPBB_SESSIONS_KEYS_TABLE' in /home/staticp/public_html/photos/bridge/phpbb.inc.php on line 108
Fatal error :
There was an error while processing a database query


line 108 is:

$sql = "SELECT u.user_id, u.username as user_name, u.user_level, u.user_posts " . "FROM " .  $UDB_DB_NAME_PREFIX . PHPBB_TABLE_PREFIX . PHPBB_SESSIONS_KEYS_TABLE . " AS s INNER JOIN " . $UDB_DB_NAME_PREFIX . PHPBB_TABLE_PREFIX . PHPBB_USER_TABLE . " AS u ON s.user_id = u.user_id WHERE u.user_id = '$cookie_uid' AND u.user_active = 1 AND s.key_id = MD5('$cookie_pass')";



and the old one (before the 2.18 update) was:

$sql = "SELECT user_id, username as user_name, user_level " . "FROM " . $UDB_DB_NAME_PREFIX . PHPBB_TABLE_PREFIX . PHPBB_USER_TABLE . " " . "WHERE user_id='$cookie_uid' AND user_password='$cookie_pass' AND user_active='1'";

thanks
Title: Re: New Bridge file for phpBB ERROR in CPM Fetch RSS
Post by: Joachim Müller on January 17, 2006, 09:20:33 AM
http://forum.coppermine-gallery.net/index.php?topic=17684.0
Title: Re: New Bridge file for phpBB ERROR in CPM Fetch RSS
Post by: freesouljah on January 17, 2006, 10:23:05 AM
oops...sorry...

well, I had some extra time on my hands...so I decided to go ahead and upgrade to 1.4 and the problem is fixed....so thanks for replying anyways

:D