Advanced search  

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]

Pages: [1]   Go Down

Author Topic: Coppermine users error (Bridged with SMF)  (Read 7422 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.032 seconds with 19 queries.