DB Error Fix - Need copy of BxDolCmtsQuery.php

Hoping that someone will take a minute to copy / paste / post their copy of this file so I can figure out what the error is in mine.  I am showing an error on line 54.  Just need to see what should be on line 54.

Don't know if it makes a difference, but I am using Dolpin 7.03

/home/maddie/public_html/inc/classes/BxDolCmtsQuery.php

Dolphin 7.0.3

this will get you the entire fileset.

What db error?

Thank you so much.

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`, 
				(UNIX_TIMESTAMP() - UNIX_TIMESTAMP(`c`.`cmt_time`)) AS `cmt_secs_ago`,
				`p`.`NickName` AS `cmt_author_name`				
			FROM bx_sounds_cmts AS `c`
			LEFT JOIN `Profiles` AS `p` ON (`p`.`ID` = `c`.`cmt_author_id`)
			LEFT JOIN sys_cmts_track AS `r` ON (`r`.`cmt_system_id` = 3 AND `r`.`cmt_id` = `c`.`cmt_id` AND `r`.`cmt_rate_author_id` = 2)
			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_replies' in 'field list'

Found error in the file '/home/maddie/public_html/inc/classes/BxDolCmtsQuery.php' at line 54.
Called 'getAll' function with erroneous argument #0.

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`, 
				(UNIX_TIMESTAMP() - UNIX_TIMESTAMP(`c`.`cmt_time`)) AS `cmt_secs_ago`,
				`p`.`NickName` AS `cmt_author_name`				
			FROM bx_sounds_cmts AS `c`
			LEFT JOIN `Profiles` AS `p` ON (`p`.`ID` = `c`.`cmt_author_id`)
			LEFT JOIN sys_cmts_track AS `r` ON (`r`.`cmt_system_id` = 3 AND `r`.`cmt_id` = `c`.`cmt_id` AND `r`.`cmt_rate_author_id` = 2)
			WHERE `c`.`cmt_object_id` = '1' AND `c`.`cmt_parent_id` = '0'
			ORDER BY `c`.`cmt_time` DESC LIMIT 0, 5

I think you have deleted this cmt_replies field - from

bx_sounds_cmts  try to restore it

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`, 
				(UNIX_TIMESTAMP() - UNIX_TIMESTAMP(`c`.`cmt_time`)) AS `cmt_secs_ago`,
				`p`.`NickName` AS `cmt_author_name`				
			FROM bx_sounds_cmts AS `c`
			LEFT JOIN `Profiles` AS `p` ON (`p`.`ID` = `c`.`cmt_author_id`)
			LEFT JOIN sys_cmts_track AS `r` ON (`r`.`cmt_system_id` = 3 AND `r`.`cmt_id` = `c`.`cmt_id` AND `r`.`cmt_rate_author_id` = 2)
			WHERE `c`.`cmt_object_id` = '1' AND `c`.`cmt_parent_id` = '0'
			ORDER BY `c`.`cmt_time` DESC LIMIT 0, 5

bx_sounds_cmts  try to restore it

That's what I did ... fixed now, thanks.

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`, 
				(UNIX_TIMESTAMP() - UNIX_TIMESTAMP(`c`.`cmt_time`)) AS `cmt_secs_ago`,
				`p`.`NickName` AS `cmt_author_name`				
			FROM bx_sounds_cmts AS `c`
			LEFT JOIN `Profiles` AS `p` ON (`p`.`ID` = `c`.`cmt_author_id`)
			LEFT JOIN sys_cmts_track AS `r` ON (`r`.`cmt_system_id` = 3 AND `r`.`cmt_id` = `c`.`cmt_id` AND `r`.`cmt_rate_author_id` = 2)
			WHERE `c`.`cmt_object_id` = '1' AND `c`.`cmt_parent_id` = '0'
			ORDER BY `c`.`cmt_time` DESC LIMIT 0, 5

bx_sounds_cmts  try to restore it

you are welcome