I just installed the program Webphoto (2.11), after the update 2.4.4 Xoops, but an internal error prevents me from using it. I watched all the parameters of the database but I can not locate the source.

Here is the problematic line: SELECT COUNT (*) FROM WHERE 9b456_webphoto_item: limit = 0: offset = 0

Can you tell me how I can correct?

Thank you in advance.

Quote:This syntax is not correct. There should be no = or : .
And the WHERE should come after the tablename, togheter with an expression.
When you limit to 0 records, you don't get any!
Correct is (retrieving eg the first 10 records):
SELECT COUNT (*) FROM xoops_webphoto_item LIMIT 0, 10
or
SELECT COUNT (*) FROM xoops_webphoto_item LIMIT 10 OFFSET 0
or with a WHERE clause for eg selecting a category id 2:
SELECT COUNT (*) FROM xoops_webphoto_item WHERE catid = 2 LIMIT 0, 10
Seems somewhere the SQL request is wrong assembled.