SMF bridge causing critical errors SMF bridge causing critical errors
 

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Main Menu

SMF bridge causing critical errors

Started by treehstn, June 06, 2023, 12:26:22 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

treehstn

(tried to post this as a new topic in the 1.6 bridging category but there's not a New Topic button there.)

I'm getting critical errors in my gallery after installing the SMF 2.1.x bridge.  I tried turning both SMF and CM back to their basic themes with no effect.  Disabled the bridge and it fixed all of the critical errors. Also tested it using a registered user (not just the Admin user) and still got the critical error when clicking on Memberlist. Any help would be so appreciated! Here are the debug reports for each error I'm getting:

Clicking on "Memberlist" button gives:
While executing query 'SELECT id_member AS user_id, real_name AS user_name, email_address AS user_email, date_registered AS user_regdate, last_login AS user_lastvisit, is_activated AS user_active, COUNT(pid) AS pic_count, ROUND(SUM(total_filesize)/1024) AS disk_usage, group_name, group_quota FROM `familyt8_smf515`.smfux_members AS u INNER JOIN `familyt8_cpg427`.cpgd8_usergroups AS g ON u.id_post_group+100 = g.group_id LEFT JOIN `familyt8_cpg427`.cpgd8_pictures AS p ON p.owner_id = u.id_member GROUP BY user_id ORDER BY user_regdate DESC LIMIT 0, 25;' in bridge/udb_base.inc.php on line 59
database error: 0 :

Clicking on the "Users" button in the admin menu gives:
While executing query 'SELECT id_member AS user_id, real_name AS user_name, email_address AS user_email, date_registered AS user_regdate, last_login AS user_lastvisit, is_activated AS user_active, COUNT(pid) AS pic_count, ROUND(SUM(total_filesize)/1024) AS disk_usage, group_name, group_quota FROM `familyt8_smf515`.smfux_members AS u INNER JOIN `familyt8_cpg427`.cpgd8_usergroups AS g ON u.id_post_group+100 = g.group_id LEFT JOIN `familyt8_cpg427`.cpgd8_pictures AS p ON p.owner_id = u.id_member GROUP BY user_id ORDER BY user_regdate DESC LIMIT 0, 25;' in bridge/udb_base.inc.php on line 59
database error: 0 :

I'm also getting a 403 page when clicking on "Show News" and "Hide Admin Controls" but I think that is a different issue.  Just listing it here for full disclosure.

Coppermine Version  1.6.25 (stable)
SMF Version  2.1.3
SMF Bridge Version  2.1.x
Apache Version   2.4.57
MySQL Version   10.5.15-MariaDB-cll-lve
Architecture   x86_64
Operating System   linux
PHP Version 7.4.33
Perl Version   5.26.3
Kernel Version   4.18.0-425.10.1.lve.el8.x86_64


treehstn


treehstn

Now I'm also seeing the following line under the debug box on the pages with critical errors.  I may have just not seen them until now but I suspect that they showed up after the web hosting support team was working on a couple of pages that I was getting 403 errors.  Here's the line that is there now:

File: /home/familyt8/public_html/include/functions.inc.php - Line: 250