DragonflyCMS Projects > MReviews > MReviews Comment System Doesn't Work! > Community Forums > Phoenix Netology
Forum Index > Community > MReviews

MReviews Comment System Doesn't Work! Reply to topic


Hello,

I just added MReaviews to my site. It seems like like a cool module but the comment system is not working.

Here's the database error email tat is sent to me when someone tries to post a comment:

On /index.php?name=MReviews
While executing query "INSERT into cms_MReviews_comments values (NULL, 1, 'WebSiteGuru', 'XX.XXX.XX.XXX', now(), 'Look nice so far, I might have to get XBox 360 just to try it out. :twisted:', 10)"

the following error occured: Column 'rid' cannot be null

In: /home/www/bluebiohazard.com/modules/MReviews/index.php on line: 990

Guest information:
User id: 9
Username: WebSiteGuru
Admin: No
IP: XX.XXX.XX.XXX
Host: pool-XX-XXX-XX-XXX.lsanca.dsl-w.verizon.net


Can somebody tell me how to fix it? Thanks! 😄

Please enter your server specs in your user profile! 😢


Which version do you have and where did you get it?

In the current version, the first column isn't "rid".

Installer table structure is com_id int(10) NOT NULL auto_increment, rid int(10) NOT NULL default '0', userid varchar(25) NOT NULL default '', userip varchar(15) NOT NULL DEFAULT 0, date datetime default NULL, comments text NOT NULL, score int(10) NOT NULL default '0', PRIMARY KEY (com_id)
There will be some issues with MySQL5, but certainly not column order.

Donations & Audit for DragonflyCMS

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):

All times are Australia/Adelaide


Jump to: