Forum


TF Mail - Error - Newsletters > Filter User Custom Fields

THUONG
18%
Posts: 18
TF Mail
July 05, 2024

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

Joomla Fry
100%
Posts: 934
July 06, 2024

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.

THUONG
18%
Posts: 18
July 06, 2024

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

Joomla Fry
100%
Posts: 934
July 06, 2024

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

Login to Reply