Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: Coppermine users error (Bridged with SMF)  (Read 7423 times)

0 Members and 1 Guest are viewing this topic.

jjqualls

  • Coppermine newbie
  • Offline Offline
  • Posts: 7
Coppermine users error (Bridged with SMF)
« on: September 12, 2014, 04:10:22 am »

I have the following issue when trying to bridge coppermine and SMF:
When I click the Users link I get
 "Critical error
 There was an error while processing a database query"
The tester account isn't really useful since this only shows to administrators, but any ideas? Mysql version 5.0
It is not a huge deal breaker, but it's a fresh install of coppermine so haven't throughly tested it, and thinking this might lead to a bigger problem later on if there's something not right with the database.

Coppermine install: neayardsales.com/gallery
Bridging app install: neayardsales.com/forum
Coppermine version: cpg1.5.30
Bridging app version: SMF 2.0.8
Test user account: tester / password

BridgeManager settings:
Bridge app URL:  neayarsales.com/forum
Relative path to your bridge app's config file:  ../forum/
Cookie name or prefix: Don't know anything about this
Use bridge app custom groups?:  0
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: Coppermine users error (Bridged with SMF)
« Reply #1 on: September 12, 2014, 09:54:07 am »

Please enable debug mode and post the extended error message.
Logged

jjqualls

  • Coppermine newbie
  • Offline Offline
  • Posts: 7
Re: Coppermine users error (Bridged with SMF)
« Reply #2 on: September 12, 2014, 10:07:07 pm »

Code: [Select]
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 `nea1422811262756`.smf_members AS u INNER JOIN `nea1423601425410`.cpg15x_2usergroups AS g ON u.id_post_group+100 = g.group_id LEFT JOIN `nea1423601425410`.cpg15x_2pictures 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 230

mySQL error: SELECT command denied to user 'nea1422811262756'@'184.168.27.36' for table 'cpg15x_2usergroups'


The user listed is the original user of the SMF database, but not the coppermine database (both set up by a godaddy installation), so after bridging I don't know if there's some sort of permission issue here.
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: Coppermine users error (Bridged with SMF)
« Reply #3 on: September 12, 2014, 10:12:33 pm »

It's a MySQL permission issue. The affected user (nea1422811262756) needs at least read access to both the SMF and CPG database.
Logged
Pages: [1]   Go Up
 

Page created in 0.016 seconds with 19 queries.