Escaping confusion with Python 3 + MySQL

[Ian Kelly]

On Sun, Mar 26, 2017 at 8:07 AM, Νίκος Βέργος <me.on.nzt at gmail.com> wrote:
> Τη Κυριακή, 26 Μαρτίου 2017 - 5:04:27 μ.μ. UTC+3, ο χρήστης INADA Naoki This error came from MySQL.  If there are no logs in error_log, it's
>> your configuration issue.
>>
>> See https://dev.mysql.com/doc/refman/5.7/en/update.html for Update
>> statement syntax.
>
> cur.execute('''UPDATE visitors SET (pagesID, host, ref, location, useros, browser, visits) VALUES ({}, {}, {}, {}, {}, {}, {}) WHERE host LIKE "%{}%"'''.format(pID, domain, ref, location, useros, browser, lastvisit, domain) )
>
> output of error-log:

You need to change the placeholders back. The poster who told you to
replace them was misinformed.