Hi, ZenPhoto Gurus...

First, I don't think this is a bug (that I know of). I couldn't imagine that it would be as the web app functioned flawlessly a month ago. So I apologize if I am posting in the wrong place.

I was looking for a simple and easy-to-manage online photo album utility for one of my client's websites when I came across zenphoto. Of course, I was real happy with it when I installed it. Unfortunately, now I am getting MySQL errors...

Quote:Zenphoto Error
MySQL Query ( SELECT COUNT(*) AS row_count FROM photo_images, photo_albums WHERE photo_albums.folder!="" AND photo_images.albumid = photo_albums.id AND photo_albums.show = 1 AND (1=1) AND photo_images.show=1 ) failed. Error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'show = 1 AND (1=1) AND photo_images.show=1' at line 1
I find this rather unusual since I had previously installed it and had it running without issue. The only warning I got was about the smart quotes. I find it hard to believe this would be an issue now after it was running fine for a while.

I search for my MySQL Error and didn't find any of the same, so I apologize if this duplicates another post.

I am also wondering if someone has hacked the zenphoto web application. I'm really not a programmer, I'm more of a visual designer. I know how to code html & css, but not so good with php & MySQL, though I can customize php to look like what I want.

The research I am doing is meant to get a web album up for a beauty queen, and she isn't paying me much at all. Actually, this research is blowing away her budget because of these problems, and I haven't even started designing anything, yet.

If I can find a quick fix, I would be happy to straighten out what I have. I don't mind if I have to reinstall the whole dang thing again, and go from there. But I don't want this happening again. I don't like it when an application does not run reliably, and that includes malicious misconduct by others and letting an app get hacked easily. Then again, I have no idea if I was hacked at all. However, any unsecure application that I put online is usually hacked quickly, as I have a high profile.

Anyways, If that is a problem or there is no easy solution, I suppose I should look for another application.

I will be happy to give details by PM or email on the site that was hacked, if required. I would be more than happy to help in any way I can. But I need a simple and reliable photo album up and online ASAP.

Thank you for reading, thanks in advance for any help on this issue.

-Doug

First, this sql seems to be from the getRandomImages() function.

I am not sure what MySQL is complaining about, but it might be the AND (1=1) clause. This seems to be generated when there are no protected albums.

Since you have not told us the details of the site (zenphoto version, what theme, etc.) I can only suggest you not use the getRandomImages() function.