Forum

Hello

Newsletters can send by Filtering in Tab User Core Fields. But, when set Filtering in Tab User Custom Fields , error comes: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '9 '') ORDER BY a.id ASC' at line 8

Extension should fixed.

Thank you

Thuong

Hello

Thank you for reporting this issue. When is this happening?

Please enable DEBUG mode from global configuration. It will provide exact location from where the error is coming.

Hi there,

Open an Email in Admin for edit, error come:

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '9 '') ORDER BY a.id ASC' at line 8.

Call stack# Function Location

1()JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:1412Joomla\Database\Mysqli\MysqliStatement->__construct()

JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:10893Joomla\Database\Mysqli\MysqliDriver->prepareStatement()

JROOT/libraries/vendor/joomla/database/src/DatabaseDriver.php:19004Joomla\Database\DatabaseDriver->setQuery()

JROOT/libraries/techfry/src/TfUser.php:3175TechFry\Library\TfUser::filter_users()

JROOT/administrator/components/com_tfmail/tmpl/mail/edit_statistics.php:176include()

Hello

Unfortunately, we are not able to reproduce this issue at our end. Please send login details to mail@techfry.com so that we can investigate further.

Thank you