[solved] The comments do not appear in the administration side

[jims34]

Hello,

I use joomla! 2.5 and 2.3.0 jcomments. I have problem administration side of my site. I do not see the comments submitted, the list remains empty when I made ​​"Manage comments" in the component jcomments.

I receive notifications of new comments by email but can not have them in "Manage comments". If I remove the email notification option is the same.

Can someone help me?

Thank you in advance,

Jean-Michel
www.parcours-photographique.com

[dnca]

Same problem here but with jcomments 2.3.0 and joomla 1.5.26 

The MySQL table keep updating after each comment inserted but there's no way to make them appear in backend.

Please help

[smart]

Try to press Refresh Objects in Manage comments section...

[dnca]

That's the problem: pressing the button changes nothing, comments are not displayed in backend panel. The popup reports "Objects information was refreshed!" but nothing happens even after closing and refreshing.

- Tried unistalling and reinstalling JComments --> nothing changes

- Tried unistalling, deleting MySQL tables, reinstalling JComments and reimporting tables--> nothing changes

- Tried repairing database --> nothing changes, no errors

- Tried "Refresh Object" with debug on --> no errors

- Tried changing code in jcommentspopup.php (as in this post: http://www.joomlatune.com/forum/index.php/topic,4279.0.html) --> error Fatal error: Call to undefined method JToolBar::getName()

Some other info that could be useful:

Email reporting is ok.
SQL tables are updating normally after each comment inserted.
Other than this problem the component is working fine.
The admin module "JComments Latest Backend" works fine.

JComments 2.3.0
Joomla 1.5.26
PHP 5.2.17

What else should I try?

PS: here is a screenshot of the backend panel. Pagination is ok but there is no comment displayed.

[smart]

I've found why it was so... We had an issue with MySQL error 'Illegal mix of collations' because we had different collations for  #__jcomments and #__jcomments_objects tables.

This problem could be easy fixed by execution query (do not forget to replace jos with your table prefix):

Code: (sql)

ALTER TABLE `jos_jcomments_objects`
CHANGE `object_group` `object_group` VARCHAR(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT ''
, CHANGE `lang` `lang` VARCHAR(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT ''
, CHANGE `title` `title` VARCHAR(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT ''
, CHANGE `link` `link` VARCHAR(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT ''
;

[dnca]

Thanks a lot, problem solved 

[JoniDevise]

I hope it possible to  change that in knew version of jcomments  .