CpmFetch 1.4 On... Displaying data and images from CPG on your website

[ferrer]

I wondered if it is possible to do the following with CPM Fetch. I have two types of images in my coppermine. Landscape and Portait, All of my Landscape thumbnails are 250 pixels wide. Would it be possible to change CPM Fetch  so that when including random files it would only include landscape pictures? Or is this not very easy to do?

[kadekawa]

ok got my earlier problem fixed - was a bridging problem with phpbb now a new one - which goes to my noobishness on php/html/and the interweb in general

cpm_viewTopRatedMediaFrom ($source, $rows, $columns, [array $options=""])

how do i actually define the $source string?

ive seen the examples given in the manual
$source = "cat=2,3:album=12,13,10"; for example but where should this go?

thank you in advance and happy valentines day everyone!

[HPG]

Okay, this is odd ...

I've got everything to work in my cftest.php file, it's all 'Pass', but my preview thumbnails are not showing up. I have no clue why.

Here is my cftest:   http://www.hpgalerij.net/cpmfetch/cftest.php

I checked my prefixes and they're all correct. I'm pretty sure it's because the cftest uses two "//"'s in the image source ( src="//albums/wpw-20050525/thumb_50913025_8.jpg") but I have no idea where this can be fixed.

Any help would be greatly appreciated!

[Antifmradio]

Lets do what needs to be  done first shall we? 

What version of coppermine you are using Coppermine Photo Gallery v1.4.2
What version of CoppermineFetch you are using 6.0
A link to your website and gallery website = www.clubex.com/index1.php gallery = www.clubexl.com/gallery.index.php
A link to an example of the problem (if possible) Please see top right of www.clubexl.com/index1.php
How computer savvy you are (newbie, intermediate, damn good) not damn good but better then intermediate
What kind of web server you are running on (if known) LINUX
Include the syntax of the command you are using.

also
when i open the page where the CPMFETCH should display an image i get this error
Unknown column 'u.user_website' in 'field list'
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/virtual/clubexl/public_html/cpmfetch/cpmfetch_dao.php on line 695

Unknown column 'u.user_website' in 'field list'
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/virtual/clubexl/public_html/cpmfetch/cpmfetch_dao.php on line 695

On my CPMFETCH TEST page (supplied by the big man)
i see all PASS and INFO. There are NO failures in the test but i do get this at the bottom
Unknown column 'u.user_website' in 'field list'
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/virtual/clubexl/public_html/cpmfetch/cpmfetch_dao.php on line 695


I have CPMFETCH in its own folder just outside of ROOT
i have CPG in its own folder Just outside of ROOT

not sure what other info would help.
...this is where i do the usual <fingers  pointing together, squelching a small "HELP?" >

[engleb]

I've done a bit of searching here and reading through the docs at fistfullofcode.com without any luck, so I thought I'd ask here in hopes that either I just missed something really obvious or someone else has done the same thing and will share the procedure.

On my site, I'd like to include images from the last x albums.  More specifically, I'd like to display the image that is set as the "Album thumbnail" for the last x added albums.  Searching the forums here and reading the docs on the main site, I don't see anything that will do what I'm looking for.

Is this something that is possible with CpmFetch as it currently works?  If not, has anyone modified it or created something similar?

Thanks,
Brett

[vb28]

Sorry, I have been building and installing a router for the past few days.  I've been getting home at 2am, and getting up and heading back.

back home? ;-)



Yeah, I am back...  How is your problem?  Sometimes these things have a way of resolving themselves...

Hi vuud,

i am having the same problem as Andreas W. i don't did you guys found a soluation for it..?
http://albums/fun/thumb_ATT00060.gif

[robinna]

okay, I found something that seems to work to solve the problem below (and I am not using xoops, just a plain ol' simple php with a little css on my home page). I was having a similiar problem to antifmradio (the specifics are below).
I will be interested to know if it works for others with the same problem. I did read through the threads concerning cpmfetch, but in all honesty, I had a hard time figuring out which thing referred to which problem or issue (maybe this thread could be split up into more specific topics?)
I also read the cpmfetch documentation and while I didn't see the specific answer to my problem (if it was there, I did indeed miss it, but there is ALOT of wonderful, helpful info about setting it up, etc.)
However: here is what I found that seemed to work.
http://www.xoops.org/modules/newbb/viewtopic.php?topic_id=44476&viewmode=flat&order=ASC&start=20


..and here is all of the stuff about my problem:
What version of coppermine you are using Coppermine Photo Gallery v1.4.3
What version of CoppermineFetch you are using 1.6.2
What kind of web server you are running on (if known) LINUX

error message:
when i open the page where the CPMFETCH should display an image i get this error
Unknown column 'u.user_website' in 'field list'
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in
(path info specific to my site)/cpmfetch/cpmfetch_dao.php on line 710

On my CPMFETCH TEST page
i see all PASS and INFO. There are NO failures in the test but i do get this at the bottom
Unknown column 'u.user_website' in 'field list'
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in (path info specific to my site)/cpmfetch/cpmfetch_dao.php on line 710

I have CPMFETCH in its own folder just outside of ROOT
i have CPG in its own folder Just outside of ROOT

---------------------------
good luck! You can see it working at
http://www.robinart.com

robinna

[nicedreams]

error message:
when i open the page where the CPMFETCH should display an image i get this error
Unknown column 'u.user_website' in 'field list'
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in
(path info specific to my site)/cpmfetch/cpmfetch_dao.php on line 710

On my CPMFETCH TEST page
i see all PASS and INFO. There are NO failures in the test but i do get this at the bottom
Unknown column 'u.user_website' in 'field list'
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in (path info specific to my site)/cpmfetch/cpmfetch_dao.php on line 710

There is a line in cpmfetch_dao.php that you need to change depending on the version of cpm. Between line 55-65, there is a var $sqlPictureAlbumSelect line,reverse which one is commented out. That will fix that error message.

Jim

[robinna]

thanks for the info but mine is working just fine, after I followed the directions over at the xoops forum (which is in the link in my previous post) For those of you having the same problem, the solution might depend on which version of coppermine or cpmfetch you have as to what the fix is and how much php experience you have as to the easier way of doing. 

the problem/error message in question is:
Unknown column 'u.user_website' in 'field list'
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in
(path info specific to my site)/cpmfetch/cpmfetch_dao.php on line 710

(...and I only include that info so that folks will know which error I'm talking about because mine is working just fine... )

[vuud]

Hi,  I just thought I would post a quick note here saying I am not dead.  No matter what the press reports.

I've been incredibly busy though leaving little time for fixing cpmfetch.  Hopefully after this week I will be back in shape to polish off the next release.


Anyone with u.username problems - there was a post a little while ago with someone detailing how to fix that problem.

Vuud

[robinna]

thanks for such a great tool!
also, I just wanted to say thanks for the documentation at fistfull of code; it is excellent. I found alot of info about customizing the cpmfetch results. I wanted to do pull only from certain categories and albums, and found all of the info I needed here:
http://www.fistfullofcode.com/projects/copperminefetch/manual/ch05s02.html

thanks again, just what I was looking for!
robinna

[somnaom]

Hi all,

Solved my problem now - didn't fully read what i needed to do from the suggestions already posted.

Hence I can confirm that the following modifications will enable cpmfetch1.6.2 to work with cpm1.4.3 bridged to phpbb2.0.19.


>Open cpmfetch_dao.php
>Comment out line 57
>Remove comments from around line 62 (As per the instructions in the release notes!)

>Find:

Code Select Expand

$this->sqlPictureSourceSelect = " " . $database_table_prefix . "pictures as p, " . $database_table_prefix . "albums as a, "
. $database_table_prefix . "users AS u ";

>Replace with:

Code Select Expand

$this->sqlPictureSourceSelect = " " . $database_table_prefix . "pictures as p, " . $database_table_prefix . "albums as a, "
. $database_table_prefix . "users AS u , phpbb_users AS phpbb ";
(If your phpbb database tables have a different prefix than 'phpbb_' then change the phpbb_users as needed to use the same prefix as your phpbb database tables use.)

>Find every occurance of u.user_id and change it to phpbb.user_id. (This is the step I failed to read!)
>Save cpmfetch_dao.php and then try cftest.php.


Many thanks to all - just thought it would be good to present the entire solution in one place - hopefully i've not made a mistake in trying to remember what i did to make it all work together!

Keep up the good work - loving this addon to Coppermine!

This solved my problem too. But I got another one instead: three copies of every thumbnail. 
(phpBB 2.0.19, cpg 1.4.3 & CpmFetch 1.6.2) 

[Skully1]

Hi all.  A little confused why this post can't be posted in the correct forum (CPMFetch)... anyways....

I'm not a programmer but have a joomla/CPG/SMF site that I want to use the functionality that CPMFetch provides.

What I would like would be to post results from CPMFetch into my wrapped CPM inside Mambo.   I've tried looking at the code (again, not a programmer) and there doesn't seem to be a way to get this to work.  It would be great.

Here's my site:  www.insanebunkers.com

Thanks in advance to anyone that wants to help/comment. 

[howie10]

Hi everyone.

I love the idea of this mod, - but i'm not sure it's going to work for me   

I have my CPG 1.4.1 running on a home server using Apache 2.0 and MYSQL5. I have got cftest.php working perfectly.   

However, I want to show the images from the gallery on my ISP-hosted CGI space.

From reading the original docs and some of the forum postings, I suspect that images cannot be grabbed by a php page running on another server.
Can anyone confirm this?
Is there a known workaround? (ie.. using static http refs instead)   :-\

Appreciate any help.

Howie

[soldstatic]

Could someone help me track down how to eliminate the border around the images generated by cpm fetch?

[dropmachine]

Seems I am getting the same error as many others. I've done a search, and haven't found a fix that works yet.

I don't have PHPBB installed, if that helps.

cpmfetch_dao.php on line 710


Whats goin on? How do I fix this? newest version of CPM and Fetch installed...

[younk]

i also get the:"

Code Select Expand

Unknown column 'u.user_website' in 'field list'
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mounted-storage/home10/sub002/sc16206-UEQL/babez.dk/cpmfetch/cpmfetch_dao.php on line 710
Error as dropmachine. But i keep following this topic, and hope that someday there will be a fix!

[Sasse]

Same problem as younk and dropmachine!

Unknown column 'u.user_website' in 'field list'

I hope that there will be a fix, too!

Thx for any help!

[lisah]

Is it possible to display images only from certain categories?

[Dakey]

Same problem as younk and dropmachine!

Unknown column 'u.user_website' in 'field list'

I hope that there will be a fix, too!

Thx for any help!

Same problem for me...  :'(