comments without album selected doesn't work [1.4 bug]

[cryogenic]

I've noticed that if I'm on the default page without having chosen any particular gallery/album and I click the "last comments" link, it fails with a critical error. Putting cpg in debug mode reveals the following error:

Code Select Expand

While executing query "SELECT COUNT(*) from cpg130_comments, cpg130_pictures  WHERE approved = 'YES' AND cpg130_comments.pid = cpg130_pictures.pid AND ( )" on 0

mySQL 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 ')' at line 1
The error appears to be in the "AND ( )" part.... when I do the same while actually IN a gallery, the query reads as follows:

Code Select Expand

SELECT COUNT(*) from cpg130_comments, cpg130_pictures  WHERE approved = 'YES' AND cpg130_comments.pid = cpg130_pictures.pid AND ( aid IN (8)  )

I don't know if 1.3 does the same thing or not as I never really checked it when I had 1.3 installed. It basically seems as though it's not passing anything into the query when it's on the default page. I expected it to give me a list of ALL recent comments in ALL my galleries. Anything I can edit in order to make it do that?

[Joachim Müller]

there's no support for the devel version (you're free to use it on your own risk, it isn't meant for production sites), you're on your own with this issue, sorry. The issue itself has been reported before, so I can confirm that there's a bug somewhere. The solution to this issue will be discussed on the closed developers board, check the cvs frequently to find out if this has improved.

Locking this thread now.

Joachim