Escaping confusion with Python 3 + MySQL

INADA Naoki songofacandy at gmail.com
Sun Mar 26 10:03:54 EDT 2017


On Sun, Mar 26, 2017 at 10:34 PM, Νίκος Βέργος <me.on.nzt at gmail.com> wrote:
> with import cgitb; cgitb.enable()
>
> ProgrammingError(1064, "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 '(pagesID, host, ref, location, useros, browser, visits) VALUES (1, 'cyta.gr', '' at line 1")
>
> that is all i get form error. error_log doesnt produce errors when iam trying
>

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.



More information about the Python-list mailing list