Advanced search  

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

Pages: [1]   Go Down

Author Topic: Problmes with installation of CMPfetch  (Read 4372 times)

0 Members and 1 Guest are viewing this topic.

natia_a7x

  • Coppermine newbie
  • Offline Offline
  • Posts: 1
Problmes with installation of CMPfetch
« on: January 06, 2011, 09:49:28 pm »

I've updated coppermine gallery on my site http://kimcloutier.fan-sites.org and after that my cpmfetch stopped showing latest images on my main page, so i deleted it and tried to reinstall but i got error like this

Quote
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home2/kimclout/public_html/gallery/cpmfetch/cpmfetch_dao.php on line 1260

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


And instead of images it showed this

Quote
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 cpg14x_pictures AS p LEFT JOIN cpg14x_users AS u ON p.owner_id = u.user_id LEFT JOIN cpg14x_albums AS a ON p.aid = a.aid LEFT JOIN cpg14x_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


PLZ help...
thanks in advance
Logged

Joe Carver

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 1545
  • aka 'i-imagine'
    • Home Page
Re: Problmes with installation of CMPfetch
« Reply #1 on: January 06, 2011, 11:10:57 pm »

Please post cpg 1.5.x requests in the cpg 1.5.xx boards.

Please also post the actual direct link to your Coppermine in the future. http://www.kimcloutier.fan-sites.org/gallery/

First you need to upgrade to cpg 1.5.12 as soon as possible: http://forum.coppermine-gallery.net/index.php/topic,69495.0.html

Then start here.
http://forum.coppermine-gallery.net/index.php/topic,65412.0.html

Moving accordingly.
« Last Edit: January 06, 2011, 11:19:02 pm by Joe Carver »
Logged

fmk

  • Coppermine novice
  • *
  • Offline Offline
  • Gender: Male
  • Posts: 28
    • FMKz Test Bed
Re: Problmes with installation of CMPfetch
« Reply #2 on: January 06, 2011, 11:50:57 pm »

Above link is NOT SAFE FOR WORK.

Board rules / Forum policies
http://forum.coppermine-gallery.net/index.php/topic,55415.msg270616.html#msg270616
Logged
FMK

Love doesn't stop by my door, I am always infatuated with new things.
Pages: [1]   Go Up
 

Page created in 0.02 seconds with 19 queries.