Database query error

I am getting Database query error as below.
 
Query:
SELECT `r`.`cmt_rate` AS `cmt_rated`, `c`.`cmt_id`, `c`.`cmt_parent_id`, `c`.`cmt_object_id`, `c`.`cmt_author_id`, `c`.`cmt_text`, `c`.`cmt_mood`, `c`.`cmt_rate`, `c`.`cmt_rate_count`, `c`.`cmt_replies`, (1382635422 - UNIX_TIMESTAMP(`c`.`cmt_time`)) AS `cmt_secs_ago`, `p`.`NickName` AS `cmt_author_name` FROM bx_groups_blog_cmts AS `c` LEFT JOIN `Profiles` AS `p` ON (`p`.`ID` = `c`.`cmt_author_id`) LEFT JOIN bx_groups_blog_cmts_track AS `r` ON (`r`.`cmt_system_id` = 37 AND `r`.`cmt_id` = `c`.`cmt_id` AND `r`.`cmt_rate_author_id` = 1) WHERE `c`.`cmt_object_id` = '1' AND `c`.`cmt_parent_id` = '0' ORDER BY `c`.`cmt_time` DESC LIMIT 0, 5
Mysql error:
Unknown column 'c.cmt_text' in 'field list'
 
Please teach me what should I do with this error!!
Quote · 24 Oct 2013

Any one?

Quote · 25 Oct 2013

The Error Message is telling you what is wrong. It says you are missing the Column cmt_text in the Table bx_groups_blog_cmts.

Quote · 25 Oct 2013

This error is coming from a 3rd party mod since there are no tables called bx_groups_blog_cmts in the default boonex module install SQL files.

 Might need to reach out to the owner of the module.

 

Nothing to see here
Quote · 25 Oct 2013

Your database has been modified. That field is normally present in the bx_groups_blog_cmts table. 

Paypal email is jeromemingo@gmail.com - http://www.boonex.com/market/posts/modzzz
Quote · 25 Oct 2013

Have you installed the group blogs module from the market?  Normal Dolphin does not have blogs for groups.

Geeks, making the world a better place
Quote · 26 Oct 2013

 

Have you installed the group blogs module from the market?  Normal Dolphin does not have blogs for groups.

 I believe this is from Ultimate Blogs by Modzzz.

Quote · 26 Oct 2013

HI,

Yes, this is Ultimate Blogs by Modzzz.
I am asking him for help right now.

So I think problem will be solve. Will let you know later.

Quote · 26 Oct 2013

The referenced database table is not a part of the Ultimate Blogs. It is a part of the Premium Groups mod. The field that is being reported as missing is a normal part of the module so someone has messed with your database. You can fix it by running the following query on your database :

ALTER TABLE `bx_groups_blog_cmts` ADD `cmt_text` text NOT NULL;

HI,

Yes, this is Ultimate Blogs by Modzzz.
I am asking him for help right now.

So I think problem will be solve. Will let you know later.

 

Paypal email is jeromemingo@gmail.com - http://www.boonex.com/market/posts/modzzz
Quote · 26 Oct 2013

Thank you so much for your help modzzz!

Problem is fixed with following code.

ALTER TABLE `bx_groups_blog_cmts` ADD `************` text NOT NULL;


Quote · 26 Oct 2013
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.