Coppermine Userpics

[JayBachatero]

Delete the ModSettings.php~ file.  The one with the ~.

[Trashcan]

Ok, almost there!  so far, the modifications have worked.  I am looking at the config portion and it is asking for the prefix for thumbnails.  Once again, forgive my "ID10t" error, but what is this refering to?

[Trashcan]

nevermind, I got it.

Many thanks for the support on this one!

[Trashcan]

ouch, new issue and not sure where to look

I have a user who gets someone elses pictures showing up under their profile.

so user X get's user Y's pictures

I did not see right off hand where to look or modify this

[JayBachatero]

Check if the id of the members match on coppermine and the forum.  What I mean is check if ID x on the forum belong to id x on the gallery.

[Trashcan]

Check if the id of the members match on coppermine and the forum.  What I mean is check if ID x on the forum belong to id x on the gallery.

the users user names match, but I can't confirm that the passwords match.

I have a test account that I use in both spots coppermine and smf and I get no user pics in smf.  If I log in as my admin account, the right pics show up

[JayBachatero]

I mean the id not user name.

[Trashcan]

I mean the id not user name.

Ah, sorry.  I see what you are talking about.  So the ID's need to match?  I can change those, or should change them if necessary in which area, smf or coppermine?

[Trashcan]

where can I verify their id's?  I think I saw once area in myphpadmin, but I hate trying to figure out anything in there by hunt and peck.  How can I verify they match in a fairly easy place?

[JayBachatero]

No, no need to edit.  I just want to know if they match.  I think I might have to take another approach into this and change the query.

[Trashcan]

No, no need to edit.  I just want to know if they match.  I think I might have to take another approach into this and change the query.

It appears they do NOT match.  I can look at the url for the link to the profile in each area (smf and coppermine) and the id# does not match.

[JayBachatero]

Ok I found a way that it works.  I'll update the package in a bit.

In Profile.php

Code (find) Select Expand


// Select the images
$requestImages = db_query("
SELECT pid, filepath, filename, owner_id, owner_name
FROM {$modSettings[cpgPrefix]}_pictures
WHERE owner_id = $memID
AND approved = 'YES'
$extensions
ORDER BY pid DESC
LIMIT $modSettings[cpgMaxPictures]", __FILE__, __LINE__);


Code (replace) Select Expand


// Set the $ouserName
$ownerName = $context['member']['username'];

// Select the images
$requestImages = db_query("
SELECT pid, filepath, filename, owner_id, owner_name
FROM {$modSettings[cpgPrefix]}_pictures
WHERE owner_name = '$ownerName'
AND approved = 'YES'
$extensions
ORDER BY pid DESC
LIMIT $modSettings[cpgMaxPictures]", __FILE__, __LINE__);


[Trashcan]

I got it to work, but had to modify this line

Code Select Expand

FROM {$modSettings[cpgPrefix]}pictures

[Trashcan]

ttt

[JayBachatero]

Change
FROM {$modSettings[cpgPrefix]}pictures

to
FROM {$modSettings['cpgPrefix']}pictures

[Trashcan]

Change
FROM {$modSettings[cpgPrefix]}pictures

to
FROM {$modSettings['cpgPrefix']}pictures

you are da man!!!
Thank you so much for helping me get this sorted out!

[JayBachatero]

Everything working fine then now?

[Trashcan]

Everything working fine then now?

Yes, perfectly.  Nothing in the error logs, users have pictures in their profile as they should
Thanks again!

[taucher]

Here you go.

Profile working  - Pictures not showing 

Thanks anyway 

I have the same Problem. Editet every file from hand, cpg and smf are in the same database, all settings are made, but no images are shown. hm. what could be the misstake? also there are no messages in the error logs.

[JayBachatero]

Are the settings correct in Admin > Features and Options?