I am trying to use the function to move subscribers from one list to another and I am getting the following SQL error. Phplist 3.6.2 and all the plugins are at the latest versions. Any help appreciated.
Subscriber commands
Database error 1064 while doing query 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 NOT EXISTS ( SELECT * FROM phplist_list…’ at line 4
A problem with the query: INSERT INTO phplist_listuser
(listid, userid)
SELECT 4, 80
WHERE NOT EXISTS (
SELECT *
FROM phplist_listuser
WHERE listid = 4 AND userid = 80
)
@bpuli1 I’m guessing the error is due to the SQL not having a table name, but it works for me.
Do you know the version of MariaDB that you are using?
Can you install and try a new version to see whether that is the problem.
On the Manage Plugins page use this package URL. It will overwrite the currently installed version of the plugin