Hi Phillip,
There is a problem with the 'Change User Title' shop item. My users have purchased it and activated/configured it successfully. However, shortly after, they say that it was reset back to the previous user title they had before purchasing it.
Any idea?
P.S. If it helps, I've always...
First one ran successfully. The other two came back with errors ("#1060 - Duplicate column name 'external'") but I went on my board and tested creating a new mailing list, and it worked fine.
So what do I do? Keep in mind I have no knowledge of php/mysql. I don't know what those mean.
I don't see how it could've become broken. Maybe I installed a particular plugin that messed up the mysql?
When I add a new mailing list, the following SQL error shows up:
Database error in vBulletin 3.8.7:
Invalid SQL:
INSERT IGNORE INTO dbtech_vbmail_subscription
(userid, mailinglistid)
(
SELECT userid, 3 AS mailinglistid
FROM user AS user
WHERE (
FIND_IN_SET(2...