Jump to content


Photo

Approving or Deleting comment from ACP -> Manage Articles causes SQL error


Originally from ticket 797835, confirmed locally using a fresh install with default data

When trying to delete or approve a comment on an IP.Content article from the ACP (e.g. http://.../admin/index.php?app=ccs&module=articles&section=articles&do=comments&record=1), the following SQL error is thrown:

Date: Sat, 28 Apr 2012 12:39:01 +0000
 Error: 1054 - Unknown column 'p.topic_id' in 'on clause'
 IP Address: 127.0.0.1 - /ipb331/admin/index.php?adsess=251784beb3c196026ac143712b12f04b&app=ccs&module=articles&section=articles&do=deleteComment&comment=1&filter=
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 mySQL query error: SELECT c.*,r.* FROM ccs_database_comments c  LEFT JOIN ccs_custom_database_1 r ON ( r.record_topicid=p.topic_id )   WHERE c.comment_id=1
 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
 | File                                                                       | Function                                                                      | Line No.          |
 |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
 | C:\wamp\www\ipb331\admin\applications_addon\ips\ccs\modules_admin\articles\articles.php| [admin_ccs_databases_records]._deleteComment                                  | 779               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | C:\wamp\www\ipb331\admin\applications_addon\ips\ccs\modules_admin\articles\articles.php| [admin_ccs_articles_articles]._deleteComment                                  | 252               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | C:\wamp\www\ipb331\admin\sources\base\ipsController.php                    | [admin_ccs_articles_articles].doExecute                                       | 306               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

Status: Fixed
Version: 2.3.1
Fixed In: 2.3.2


1 Comments

I couldn't see any issues with approving. I can duplicate issues with deleting and editing though, which I've fixed.