Installation issue

[TTom911]

Hi, I am keen to try out jComments as I have heard a lot of good report. Sadly, I have an issue after the installation (which reported no error messages). I attached a screen shot, which is easier than describing the issue (see the labels in the screenshot).

ANy suggestion what went wrong and how  can fix?

Using J! 1.5.20, PHP 5.2.9, XAMPP on Mac (local host at the moment)

[smart]

It looks like we've some issues with directory permissions. Check permissions to folder /language/en-GB/. Also you could check write permissions for other folders listed in JComments Installation Guide.

[TTom911]

no, that's all ok, is the standard directories which require read/write access anyway in Joomla

Must be something else.

Also, I just started testing with PhocaGallery and get a strange error message (not sure if that is a Phoca or jComment issue). When displayed 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

[smart]

no, that's all ok, is the standard directories which require read/write access anyway in Joomla

Must be something else.

As shown on you screenshot you haven't JComments language files in you language directory (check file {site root}/language/en-GB/en-GB.com_jcomments.ini). You could copy them manually from distributive or check permissions and reinstall component.

Also, I just started testing with PhocaGallery and get a strange error message (not sure if that is a Phoca or jComment issue). When displayed 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

What MySQL version do you use? This quite correct SQL-query - I've checked it on my test site and it works fine for me.

[TTom911]

SQL 5.1.33
(Apache/2.2.11 (Unix) DAV/2 mod_ssl/2.2.11 OpenSSL/0.9.7l PHP/5.2.9 mod_perl/2.0.4 Perl/v5.10.0)

[TTom911]

ok, copied the ini's and that works now. THANKS!! Strange why that happened!? Any idea, just interested...

SQL error still there of course. But, that only happens (just started using it anyway, so I have preliminary experience) when the comment is posted via a Phoca Gallery Image. Article comments show ok.

[TTom911]

really strange:

- I had 4 test comments in the jComments admin panel: 2 with no problems showing (coming frm articles), 2 with SQL issue (coming from Phoca)

- I the deleted the 2 faulty comments, leaving only 2 valid comments in the jComment admin panel and refreshed the frontend view

BUT

in the module 3 (!) comments still show: the two good ones and one remaining bad one with the SQL error (again, only 2(!) comments remain in the components admin panel while 3 do show in the module....)

all on local host at the moment

[smart]

in the module 3 (!) comments still show: the two good ones and one remaining bad one with the SQL error

This is because Joomla's cache. You could clear it manually or wait until it refreshes.

At this moment I've no ideas regarding SQL-query error. It looks like correct query and works fine for me.

[TTom911]

I posted the issue (SQL error) also on the Phoca forum. Here is the response from Jan, the Phoca Developer, he recons there my be a SQL query error in the app:

------


Top
Re: PhocaGallery / jComments / SQL error
by Jan on 27 Sep 2010, 19:22

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
If you find some Phoca extensions useful, please vote for them on: extensions.joomla.org

Jan
Phoca Hero

 
Posts: 14886
Joined: 10 Nov 2007, 18:23
Location: Czech Republic

[smart]

I posted the issue (SQL error) also on the Phoca forum. Here is the response from Jan, the Phoca Developer, he recons there my be a SQL query error in the app

Could you show me corrected SQL?