News:

You may pay someone to create your store, or you visit our seminar and become a professional yourself with the silver certification

Main Menu

ERROR: remove orders and invoices older than entered years

Started by jflash, February 07, 2025, 10:07:25 AM

Previous topic - Next topic

jflash

Hello!

I report an error when using button 'remove orders and invoices older than entered years'

VirtueMart 4.2.18 11050
Joomla 5.2.3

Found 1032 entries to remove
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 '!ISNULL(o_hash)' at line 2

Call Stack
#    Function    Location
1    ()    JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:138
2    mysqli->prepare()    JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:138
3    Joomla\Database\Mysqli\MysqliStatement->__construct()    JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:1020
4    Joomla\Database\Mysqli\MysqliDriver->prepareStatement()    JROOT/libraries/vendor/joomla/database/src/DatabaseDriver.php:1785
5    Joomla\Database\DatabaseDriver->setQuery()    JROOT/administrator/components/com_virtuemart/helpers/vmclearup.php:176
6    VmClearUp->removeOrdersInvoicesY()    JROOT/administrator/components/com_virtuemart/controllers/updatesmigration.php:1124
7    VirtuemartControllerUpdatesMigration->removeOrdersInvoicesY()    JROOT/libraries/src/MVC/Controller/BaseController.php:730
8    Joomla\CMS\MVC\Controller\BaseController->execute()    JROOT/administrator/components/com_virtuemart/virtuemart.php:77
9    require_once()    JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:71
10    Joomla\CMS\Dispatcher\LegacyComponentDispatcher::Joomla\CMS\Dispatcher\{closure}()    JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:73
11    Joomla\CMS\Dispatcher\LegacyComponentDispatcher->dispatch()    JROOT/libraries/src/Component/ComponentHelper.php:361
12    Joomla\CMS\Component\ComponentHelper::renderComponent()    JROOT/libraries/src/Application/AdministratorApplication.php:150
13    Joomla\CMS\Application\AdministratorApplication->dispatch()    JROOT/libraries/src/Application/AdministratorApplication.php:205
14    Joomla\CMS\Application\AdministratorApplication->doExecute()    JROOT/libraries/src/Application/CMSApplication.php:306
15    Joomla\CMS\Application\CMSApplication->execute()    JROOT/administrator/includes/app.php:58
16    require_once()    JROOT/administrator/index.php:32