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.
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
SELECT 4, 80
WHERE NOT EXISTS (
WHERE listid = 4 AND userid = 80