Moodle

Forum ratings not working 1.8.7+

Details

  • Type: Bug Bug
  • Status: Closed Closed
  • Priority: Major Major
  • Resolution: Won't Fix
  • Affects Version/s: 1.8.7
  • Fix Version/s: None
  • Component/s: Forum
  • Labels:
    None
  • Environment:
    Windows 2003 Server, Apache 2.0.59, MySQL 5.0.18, PHP 5.1.1
  • Database:
    MySQL
  • Affected Branches:
    MOODLE_18_STABLE

Description

Just upgraded to 1.8.7+ about a week ago. Forum ratings are not working. I get:
Could not insert a new rating (0 = 3034) .

Issue Links

This issue has a clone:
MDL-11575 Forum ratings not working Major Closed

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
Melinda Kraft added a comment -

Resolved by following the suggestion to change data types from integer to bigint(10), etc., but am concerned about the fallout when we next upgrade.

Show
Melinda Kraft added a comment - Resolved by following the suggestion to change data types from integer to bigint(10), etc., but am concerned about the fallout when we next upgrade.
Hide
Permalink
Melinda Kraft added a comment -

Like a previous report, upgrading this install always sets the data types by to integer and tinyint. The odd thing is that another Moodle install I have, which is at the same version didn't do this. The one thing that may be impacting this is that the install with the problem is a very old Moodle system that has been upgraded many many times, whereas the working one is only a couple years old. Could this be something in the old config file that needs to be addressed?

Show
Melinda Kraft added a comment - Like a previous report, upgrading this install always sets the data types by to integer and tinyint. The odd thing is that another Moodle install I have, which is at the same version didn't do this. The one thing that may be impacting this is that the install with the problem is a very old Moodle system that has been upgraded many many times, whereas the working one is only a couple years old. Could this be something in the old config file that needs to be addressed?
Hide
Permalink
David Banach added a comment -

I updated to 1.8.8 (Build: 20090128)

from 1.8.7+ (Build: 20081231)

and this broke my forum ratings.

I got an error Invalid rate (141) with no debugging information at all.

I restored the rate.php file from version 1.8.7 and my ratings work again.

Linux
apache 2
PHP 5.25
MYSQL 5.0.67

Show
David Banach added a comment - I updated to 1.8.8 (Build: 20090128) from 1.8.7+ (Build: 20081231) and this broke my forum ratings. I got an error Invalid rate (141) with no debugging information at all. I restored the rate.php file from version 1.8.7 and my ratings work again. Linux apache 2 PHP 5.25 MYSQL 5.0.67
Hide
Permalink
Markus Hagman added a comment -

Same problem here. All ratings broken.

from 1.87 to 1.8.8 (Build: 20090128)

This is major problem!

Show
Markus Hagman added a comment - Same problem here. All ratings broken. from 1.87 to 1.8.8 (Build: 20090128) This is major problem!
Hide
Permalink
Marcello Henrique added a comment -

I have this problem in my platform +/- 5000 users.
Melinda how you fix in specific this problem?

mysql> desc mdl_forum_ratings;
-------------------------------------------------------+

Field Type Null Key Default Extra

-------------------------------------------------------+

id bigint(10) unsigned NO PRI NULL auto_increment
userid bigint(10) unsigned NO MUL 0  
post bigint(10) unsigned NO MUL 0  
time bigint(10) unsigned NO   0  
rating smallint(4) NO   0  

-------------------------------------------------------+
5 rows in set (0.00 sec)

In this mode don't work.

Thanks!

Show
Marcello Henrique added a comment - I have this problem in my platform +/- 5000 users. Melinda how you fix in specific this problem? mysql> desc mdl_forum_ratings; -------------------------------------------------------+
Field Type Null Key Default Extra
-------------------------------------------------------+
id bigint(10) unsigned NO PRI NULL auto_increment
userid bigint(10) unsigned NO MUL 0  
post bigint(10) unsigned NO MUL 0  
time bigint(10) unsigned NO   0  
rating smallint(4) NO   0  
-------------------------------------------------------+ 5 rows in set (0.00 sec) In this mode don't work. Thanks!
Hide
Permalink
Melinda Kraft added a comment -

If your fields are bigint(10), smallint(4), your problem may be different than mine was. My problem was fixed by changing from integer datatype to bigint.

Show
Melinda Kraft added a comment - If your fields are bigint(10), smallint(4), your problem may be different than mine was. My problem was fixed by changing from integer datatype to bigint.
Hide
Permalink
Marcello Henrique added a comment -

My error is attached.

Anybody can help-me?

Show
Marcello Henrique added a comment - My error is attached. Anybody can help-me?
Hide
Permalink
Andrew Davis added a comment -

Hello. 1.8 is no longer maintained by Moodle HQ. Versions 1.9, 2.0 and 2.1 are all available from http://download.moodle.org We strongly recommend upgrading to a version that is being actively maintained.

Show
Andrew Davis added a comment - Hello. 1.8 is no longer maintained by Moodle HQ. Versions 1.9, 2.0 and 2.1 are all available from http://download.moodle.org We strongly recommend upgrading to a version that is being actively maintained.

People

Vote (2)
Watch (2)

Dates

  • Created:
    Updated:
    Resolved:
Atlassian JIRA (v4.4.3#663-r165197) | Report a problem
Powered by a free Atlassian JIRA open source license for Moodle. Try JIRA - bug tracking software for your team.