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...
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
Zenphoto
Comments
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.