Error after upgrade to 1.56 stable Error after upgrade to 1.56 stable
 

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

Main Menu

Error after upgrade to 1.56 stable

Started by MONARCH, June 13, 2010, 05:53:17 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

MONARCH

I have read the docs about posting and searched the board for answers.

I upgraded to 1.56 and the gallery works fine.

However, i cannot use cpmfetch.

The gallery is at: http://www.monarchhousing.org/gallerynew/

In searching the board I found comments about possible problems with plugins and mods. i have no plugins or mods.

I have used myphpadmin to check the database and found no problems.

This is the error message:

Test images - found a total of 1722 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 cpg_pictures AS p LEFT JOIN cpg_users AS u ON p.owner_id = u.user_id LEFT JOIN cpg_albums AS a ON p.aid = a.aid LEFT JOIN cpg_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 /home6/monarchh/public_html/gallerynew/cpmfetch/cpmfetch_dao.php on line 1260

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home6/monarchh/public_html/gallerynew/cpmfetch/cpmfetch_dao.php on line 1264

I will appreciate any help that you can provide to resolve this issue.

François Keller

a little search on the board had giving you this post http://forum.coppermine-gallery.net/index.php/topic,65412.0.html
Please, next time search before asking...
mooving to the cpg1.5.x board
Avez vous lu la DOC ? la FAQ ? et cherché sur le forum avant de poster ?
Did you read the DOC ? the FAQ ? and search the board before posting ?
Mon Blog

Joachim Müller

Nobody said that mods written for cpg1.4.x would continue to work with cpg1.5.x...