PDA

View Full Version : problem getting random thumbs

blikum
3rd of August 2002 (Sat), 13:40
First of all.. THANK YOU Pekka for EE. It solved a long-time problem for me getting all of my THOUSANDS of photos online. I just installed it and after a couple problems, it's generally working great. I had to use the non-backquote setup on my server, which I discovered in a reply you posted to another user. That might be relevant to the issue I'm posting about.

I get this error on my index.php page:

Some random photos from this exhibition:

Error getting thumbs: You have an error in your SQL syntax near 'RAND() LIMIT 10 ' at line 21

Any help is greatly appreciated.
Gianna
27th of September 2002 (Fri), 08:50
I am having the exact same problem with my thumbnails on the front page. My webhost insisted on installing EE for me, and it took awhile to get up to speed with adding/editing photos. But now, everything is working GREAT!

Pekka, thank you so much for all your hard work. I've been wanting to learn PHP for a long time now, and working with your program is giving me some very valuable experience with it.

--Gianna
Gianna
27th of September 2002 (Fri), 11:46
I tried Pekka's "show last 5 photos" patch mentioned elsewhere on this forum and it solved the problem, at least for now. I'm not sure what we're going to do with the front page, anyhow... last 5 photos may be fine instead of random. Is it possible to show the 5 or 10 or... most popular photos?

-GL
Pekka
27th of September 2002 (Fri), 12:30
Gianna wrote:
I tried Pekka's "show last 5 photos" patch mentioned elsewhere on this forum and it solved the problem, at least for now. I'm not sure what we're going to do with the front page, anyhow... last 5 photos may be fine instead of random. Is it possible to show the 5 or 10 or... most popular photos?

-GL


Next version (don't ask when, very soon :) ) has a dynamic index page system which will let you define all exhibition listing "components" separately. For microthumbs you have e.g. option to show

random X,
last X,
X most popular

and there's also a fourth option: select one of the above randomly for each listed exhibition. If you use thumb number = 0 you don't see any microthumbs there.