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

FAQ

Moderators

Forum Index > Community > MReviews

MReviews Comment System Doesn't Work! Reply to topic

Blueracer66

Offline
Joined: Jun 30, 2006
Posts: 1

0 👍 / 0 👎

Mon Jul 03, 2006 10:23 pm

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! 😢

Phoenix

Offline
Joined: Mar 18, 2004
Posts: 1543
Location: Netosphere

0 👍 / 0 👎

Tue Aug 01, 2006 9:13 am

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

Post new topic Reply to topic Forum Index > Community > MReviews
Page 1 of 1