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: Need Help with cpg1.5 and joomla  (Read 4810 times)

0 Members and 1 Guest are viewing this topic.

extreme2211

  • Coppermine newbie
  • Offline Offline
  • Posts: 1
Need Help with cpg1.5 and joomla
« on: November 08, 2012, 02:53:50 am »

I have install cpg1.5 and i uploaded cpmfetch to the same place as i installed cpg when I run the install.php from cpmfetch i get an error

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, 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_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 /home2/techsonh/public_html/mkphoto/photo/cpmfetch/cpmfetch_dao.php on line 1260

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




and I can not get an images on my site I get this error when trying 
Error opening the path to CpmFetch/mkphoto/photo/cpmfetch
name of configuration file:/mkphoto/photo/cpmfetch/cpmfetch_config.php
Please recheck the path for cpmFetch and the name of the configuration file at the module Backend


can some please help me out
Logged

phill104

  • Administrator
  • Coppermine addict
  • *****
  • Country: gb
  • Offline Offline
  • Gender: Male
  • Posts: 4885
    • Windsurf.me
Re: Need Help with cpg1.5 and joomla
« Reply #1 on: November 08, 2012, 09:10:25 am »

So that is not an error with neither Joomla nor CPG but the cpmfetch script?

There is a fix for that we came up with some time back (VUUD, the developer of cpmfetch has not been around for quite a while). I cannot find the thread right now (searching on a mobile phone is not easy) but take a look in the cpmfetch forum and you should find the code to adjust. CPM fetch was designed for CPG1.4.x and was never re-written for CPG1.5.x so the code in the thread is just a workaround.
Logged
It is a mistake to think you can solve any major problems just with potatoes.
Pages: [1]   Go Up
 

Page created in 0.017 seconds with 19 queries.