·
Added a discussion

Hello
I'm trying to add a product (subscription) with a monthly recurring payment and I'm getting the error message below.
Any feedback to help me solve this issue would be greatly appreciated.
Query:
SELECT `bx_market_cmts`.*, `sys_cmts_ids`.`id` AS `cmt_unique_id` FROM `bx_market_cmts` LEFT JOIN `sys_cmts_ids` ON (`bx_market_cmts`.`cmt_id` = `sys_cmts_ids`.`cmt_id` AND `sys_cmts_ids`.`system_id` = :system_id) WHERE `bx_market_cmts`.`cmt_object_id` = :cmt_object_id AND `bx_market_cmts`.`cmt_vparent_id` = :cmt_vparent_id ORDER BY `bx_market_cmts`.`cmt_pinned` DESC, `bx_market_cmts`.`cmt_time` ASC LIMIT 0, 0

Mysql error:
Unknown column 'bx_market_cmts.cmt_pinned' in 'order clause'

  • 1423
Comments
    Login or Join to comment.