forum.coppermine-gallery.net
Support => cpg1.4.x Support => Older/other versions => cpg1.4 cpmFetch by vuud => Topic started by: eeL on March 26, 2008, 03:32:46 am
-
cpg1.4 cpmFetch has been working great for our website. I logged in today and all of a sudden I get this:
SELECT p.filepath AS pFilepath, p.filename AS pFilename, p.aid AS pAid, p.filesize AS pFilesize, p.title AS pTitle, p.caption AS pCaption, p.owner_name AS pOwner_name, p.owner_id as pOwnerId, p.ctime AS pCtime, p.hits AS pHits, p.pid AS pPid, p.pic_rating AS pPic_Rating, p.votes AS pVotes, p.pwidth AS pWidth, p.pheight AS pHeight, p.user1 as pUser1, p.user2 as pUser2, p.user3 as pUser3, p.user4 as pUser4, c.cid as cCid, c.name as cName, c.description as cDescription, c.pos as cPos, c.parent as cParent, c.thumb as cThumb, a.aid AS aAid, a.title AS aTitle, a.description AS aDescription, a.visibility as aVisibility, a.pos as aPos, a.category as aCategory, a.thumb as aThumb, a.keyword as aKeyword FROM cpg1410_pictures AS p LEFT JOIN cpg1410_albums AS a ON p.aid = a.aid LEFT JOIN cpg1410_categories AS c ON a.category = c.cid WHERE 1 AND p.approved='YES' AND ((a.visibility = 0 OR a.visibility IS NULL) AND (a.alb_password IS NULL OR a.alb_password = "")) ORDER BY p.ctime DESC LIMIT 0,8
Here is where you can view it:
http://www.thefishingstation.com/ (http://www.thefishingstation.com/)
Any help would greatly be appreciated.
-
Post the code used. Link to gallery is http://thefishingstation.com/hook/. As you require login, post a non-admin test user account as well.
-
Thank you
User GauGau
pw test
echo "<CENTER>";
print ("<a href=\"http://thefishingstation.com/gallery/index.php\">Members Recent Photos</a>");
include "../gallery/cpmfetch/cpmfetch.php";
$objCpm = new cpm("../gallery/cpmfetch/cpmfetch_config.php");
$objCpm->cpm_viewLastAddedMedia(2,4);
$objCpm->cpm_close();
print ("<a href=\"http://thefishingstation.com/gallery/index.php\">View Gallery</a>");
echo "</center>";
-
Got a chance to look at this?
-
That's not the entire code. What you see is the unwanted output of a mysql query.
-
Okay, but thsi is what I have used for years and it was working. The only thing I did was to add Joomla on a different domain on a shared hosting.
-
What kind of answer do you expect? I'm not a mind reader. I don't know what happened with Joomla. I have never used Joomla, I'm not familiar with it at all. Try the code you posted above on a standalone page (not integrated into Joomla) to verify.
-
Just trying to understand, that's all. Didn't mean to offend you. Thank you for your time in reading this.
-
Did you do as I suggested and try the code on a standalone page to check wether the problem lies in Joomla or cpmFetch?
-
Joomla had nothing to do with the web site in question. I installed it on the same server that thefishingstation is on. The fishingstation website has no connection to Joomla. I figure that you would want as much honest info/varibles that might have caused the code to stop working. I haven't had a chance to test it as a stand alone, but thanks for your reply.
-
Just replaced the all the fetch files and fixed.
-
I could never understand why a poster can not edit their own post? I run 13 different forums (different brands) Makes no sense.
Anyway, what I meant to say was, I just uploaded all new cpmFetch files and all is well. Thanks!
-
This would be solved.
-
Do you mean "this has been solved"? If yes, please explain us how you did (for the benefit of others with similar issues). Or do you mean "I want this to be solved"?
-
I had tried to edit my first comment,
Just replaced the all the fetch files and fixed.
to this:
I just uploaded all new cpmFetch files (made sure I did a backup first) and it had fixed the issue.
Thus, this would be solved. Thank you.