PhocaGallery / jComments SQL error

[TTom911]

I just started testing with PhocaGallery and get a strange error message (not sure if that is a Phoca or jComment issue).

When posting a comment in PhocaGallery and display in the Latest jComments Module I get:

No valid database connection 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 'as imgid c.id as catid, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id,' at line 1 SQL=SELECT a.id, as imgid c.id as catid, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug FROM jos_phocagallery AS a LEFT JOIN jos_phocagallery_categories AS c ON c.id = a.catid WHERE a.id = 67
test2
27.09.10 09:07

Article comments show ok in the Latest jComments Module. Seems to happen only in connection with PhocaGallery.

Any idea?

Here is what Jan, the developer of Phoca Gallery, said:

----------------------

Hi, I don't know the module, but seems there is a syntax error in sql query:

CODE: SELECT ALL
a.id, as imgid c.id as catid,


this should be changed e.g. to:

a.id as imgid, c.id as catid ... or similar.


Jan

-------------------------

[smart]

This post isn't informative because you didn't post corrected SQL...

[TTom911]

Sorry, what do you mean, I am not familiar with SQL, otherwise I might have fixed it myself...

I just let you know that Jan/Phoca Gallery thinks contrary to you, that there IS a SQL error in your query.

I suggest you discuss that with your developer?!

[TopCop]

Have you installed the actual and latest JComments plugin from Jan's page?
When I updated JComments to the latest version I had the same error showing up. I downloaded and installed Jan's latest plugin version for JComments and there are no problems anymore.


TopCop

[TTom911]

Thanks for the hint, I'll try that!!