CPMfetch and the laste update of cpg 1.51 don't Work CPMfetch and the laste update of cpg 1.51 don't Work
 

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

CPMfetch and the laste update of cpg 1.51 don't Work

Started by poubao, June 16, 2009, 12:05:38 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

poubao

To day i upgrade a test gallery cpg 1.51 with the last release of svn, and now cpmfetch don't work.
I try to run the install of cpmfetch with a empty cpmfetch_config.php, cpmfetch find the pic's but it give me these errors

Test images - found a total of 55 images:
If all went well, you will see some random images from your gallery displayed here. If not, you may in fact have a problem and will need to seek help by clicking here.
Unknown column 'p.owner_name' in 'field list'

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, u.user_lastvisit AS uUser_lastvisit,u.user_regdate AS uUser_regdate,u.user_email AS uUser_email,u.user_profile1 AS uUser_profile1,u.user_profile2 AS uUser_profile2,u.user_profile3 AS uUser_profile3,u.user_profile4 AS uUser_profile4,u.user_profile5 AS uUser_profile5,u.user_profile6 AS uUser_profile6, 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 cpg15x_pictures AS p LEFT JOIN cpg15x_users AS u ON p.owner_id = u.user_id LEFT JOIN cpg15x_albums AS a ON p.aid = a.aid LEFT JOIN cpg15x_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,4

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/web8/23/92/51954992/htdocs/cpmfetch/cpmfetch_dao.php on line 1260

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /mnt/web8/23/92/51954992/htdocs/cpmfetch/cpmfetch_dao.php on line 1264

These images were found and displayed by using the following PHP code:

poubao  ???
L'incohérence de ceux qui nous dirigent, l'incompétence de ceux qui nous commandent,sont un vibrant hommage pour ceux qui exécutent.
                                          **Général Patton**

Nibbler

Is it expected to work with 1.5?

The owner_name field has been removed. The script needs to pull the username from the users table now.

Joachim Müller

Nobody said that cpmFetch was designed to work with cpg1.5.x - in fact, cpg1.5.x has not been released yet and goes unsupported (as in "no support at all") and is under constant changes, so how could vuud possibly have created a cpmFetch version for it?
Starting this thread on the board dedicated for plugin contributions for cpg1.5.x was not a bright idea neither - you posting clearly doesn't qualify as a valid plugin, but rather a pretty lame report, as you failed to post the needed data according to board rules and the sticky threads on cpmFetch, nor does your posting qualify as valid test report for cpg1.5.x.
Your thread has been moved accordingly.
Please don't abuse your privileges (among them the privilege to start new threads in nearly all boards) in the future. The rules exist for contributors as well. If you want to contribute to the development for cpg1.5.x, start by reading the docs for cpg1.5.x, especially the section that explains valid reporting.

poubao

 Sorry for the
Quote from: Joachim Müller on June 16, 2009, 12:43:18 PM
abuse your privileges (among them the privilege to start new threads in nearly all boards)
But it's an cpg 1.5.1 issue and there is no board for the "Various errors"
Problem solved while modifying cpmfetch/install.php (line 61) as Nibbler suggest
work as expected with cpg 1.5.1 last svn release
poubao  :D
L'incohérence de ceux qui nous dirigent, l'incompétence de ceux qui nous commandent,sont un vibrant hommage pour ceux qui exécutent.
                                          **Général Patton**

Joachim Müller

Quote from: poubao on June 17, 2009, 09:27:24 AM
Sorry for the But it's an cpg 1.5.1 issue and there is no board for the "Various errors"
There is no support at all for cpg1.5.x, so you simply shouldn't have posted that. Why do you behave like that?