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
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