Unknown column 'c.params' in 'field list'


  • Default avatar
    jamey3    
     4 years ago
    0

    We just finished work on a development site and moved it into web root. AWO Coupon isn't working.

    I put Joomla in debug mode and tried to access AWO Coupon in Admin and got the following 500 Error:

    I checked a previous install of AWO Coupon and there isn't a single table I can find with the column params so I'm stumped.

    JDatabaseMySQL::query: 1054 - Unknown column 'c.params' in 'field list' SQL=SELECT c.id,c.coupon_code,c.num_of_uses_type,c.num_of_uses,c.coupon_value_type, c.coupon_value,c.coupon_value_def,c.function_type2,function_type2_mode, c.min_value,c.discount_type,c.user_type,c.function_type,c.startdate,c.expiration,c.order_id,c.published, 0 as usercount,0 as productcount,0 as categorycount,0 as manufacturercount, 0 as vendorcount,0 as shippingcount,c.exclude_special,c.exclude_giftcert,c.note, c.parent_type,0 as parentcount,c.params FROM jos_awocoupon c GROUP BY c.id ORDER BY c.coupon_code LIMIT 0, 20

    Call stack
    # Function Location
    1 JAdministrator->dispatch() /home/spexonth/public_html/administrator/index.php:67
    2 JComponentHelper->renderComponent() /home/spexonth/public_html/administrator/includes/application.php:136
    3 require_once() /home/spexonth/public_html/libraries/joomla/application/component/helper.php:162
    4 JController->execute() /home/spexonth/public_html/administrator/components/com_awocoupon/admin.awocoupon.php:30
    5 JController->display() /home/spexonth/public_html/libraries/joomla/application/component/controller.php:236
    6 AwoCouponViewCoupons->display() /home/spexonth/public_html/libraries/joomla/application/component/controller.php:310
    7 JView->get() /home/spexonth/public_html/administrator/components/com_awocoupon/views/coupons/view.html.php:58
    8 AwoCouponModelCoupons->getData() /home/spexonth/public_html/libraries/joomla/application/component/view.php:364
    9 JModel->_getList() /home/spexonth/public_html/administrator/components/com_awocoupon/models/coupons.php:53
    10 JDatabaseMySQL->loadObjectList() /home/spexonth/public_html/libraries/joomla/application/component/model.php:284
    11 JDatabaseMySQL->query() /home/spexonth/public_html/libraries/joomla/database/database/mysql.php:458
    12 JError->raiseError() /home/spexonth/public_html/libraries/joomla/database/database/mysql.php:231
    13 JError->raise() /home/spexonth/public_html/libraries/joomla/error/error.php:171
    14 JException->__construct() /home/spexonth/public_html/libraries/joomla/error/error.php:136

    TIA
  • Default avatar
    jamey3    
     4 years ago
    0

    I had installed a new version on the dev site but was dropping the tables and importing data from the old site running a previous version of AWO Coupon.

    The new version apparently has a field for params so I created one and it now works.