Jcomments Latest Module and user votes

[biedron]

Hi,
I have a problem with JComments Latest Module, when I set Module Mode on Show popular comments it tends to show the most negative voted comments, and I want it to show these who are most positive voted ones. What should I do to set it the way I want?

[dkambz]

Found the problem, because the isgood and ispoor columns are unsigned and of type SmallInt, if the calculation isgood - ispoor resulted in negative value the mysql spits out long number and not actual negative number.

Change the database and remove unsigned and this will solve the issue.

Best regards
Dimitri

[smart]

Thank you, Dimitri! I'll fix it with next release.

Quick fix:

Open phpMyAdmin, select your Joomla's database and execute next SQL-query:

Code: (sql)

ALTER TABLE `jos_jcomments` CHANGE `isgood` `isgood` SMALLINT(5) NOT NULL DEFAULT '0';
ALTER TABLE `jos_jcomments` CHANGE `ispoor` `ispoor` SMALLINT(5) NOT NULL DEFAULT '0';