zenphoto SQL error

code

`
Zenphoto Error
MySQL Query ( SELECT COUNT(*) FROM comments WHERE type='news' AND inmoderation=0 AND private=0 AND ownerid= ) 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 '' at line 1

Backtrace:

in query (functions-db.php [101])
in query_single_row (zenpage-class-news.php [722])
in ZenpageNews->getCommentCount (template-functions.php [2766])
in getCommentCount (index.php [51])
in include (index.php [118])
`
PHP version 5.2.8
MySQL version 5.0.67-community-log

Received error after updating zenphoto and zenpage from...i dunno, a few weeks old, maybe even a month or two...

acrylian

I've seen that error before but it was not really reproducable. Please try the nightly there has been some fixing on comments recently. Maybe that solves it.

code

okie dokie

code

My website worked fine in 1.1 I dont remember what build number I had...

I have version 1.2.3 [3469]

I dont know if this matters but:
http://domain.com/zp-core/admin-comments.php
Has no errors....

acrylian

I think this is a hiccup in the system..:-) Or do you get that frequently?

code

hiccup in what system? get what frequently? the error? I only got it since I updated to latest from 1.1

acrylian

Hiccup in everything..:-) Sometimes the browser cache plays tricks or the server cache. I actually just wanted to know if you got that error once or everytime in relation with comments.

code

I still get the error on the main page, but comments are viewable in the admin panel

acrylian

Hm, I have currently no idea as I don't see the error right now.

code

I tried a fresh install and its fixed...I think I forgot to delete the files b4 updating... Sorry