I have facing a issue when I open the Coupon page
An error has occurred.
1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE shop_id IN ('0', '0')' at line 1
and the debug is showing following error
\libraries\joomla\database\driver\mysqli.php:665
Call stack
# Function Location
1 () JROOT\libraries\joomla\database\driver\mysqli.php:665
2 JDatabaseDriverMysqli->execute() JROOT\libraries\joomla\database\driver.php:1740
3 JDatabaseDriver->loadResult() JROOT\administrator\components\com_jshopping\models\coupons.php:49
4 JshoppingModelCoupons->getCountCoupons() JROOT\administrator\components\com_jshopping\controllers\coupons.php:35
5 JshoppingControllerCoupons->display() JROOT\libraries\src\MVC\Controller\BaseController.php:710
6 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT\administrator\components\com_jshopping\jshopping.php:63
7 require_once() JROOT\libraries\src\Component\ComponentHelper.php:402
8 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT\libraries\src\Component\ComponentHelper.php:377
9 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT\libraries\src\Application\AdministratorApplication.php:101
10 Joomla\CMS\Application\AdministratorApplication->dispatch() JROOT\libraries\src\Application\AdministratorApplication.php:159
11 Joomla\CMS\Application\AdministratorApplication->doExecute() JROOT\libraries\src\Application\CMSApplication.php:196
12 Joomla\CMS\Application\CMSApplication->execute() JROOT\administrator\index.php:51
when someone trying to complete order and checkout page showing this error
Fehler: 1054
Unknown column 'coupon_free_discount' in 'field list'
screenshot_83.png
screenshot_84.png
Joomla: 3.9.18
JoomShopping: 3.17.0
PHP: 7.2
MySQL: 5.5.5-10.1.41-MariaDB-0+deb9u1
Website Url: localhost
JoomShopping: 3.17.0
PHP: 7.2
MySQL: 5.5.5-10.1.41-MariaDB-0+deb9u1
Website Url: localhost
Last change: 15.05.2020 09:48
