Retrieving possible list for use in a subsequent INSERT

Denis McMahon denismfmcmahon at gmail.com
Fri Nov 1 15:12:14 EDT 2013


On Thu, 31 Oct 2013 11:32:29 +0200, Nick the Gr33k wrote:

> The error seen form error log is:

> [Thu Oct 31 09:29:35 2013] [error] [client 46.198.103.93]
> pymysql.err.InternalError: (1241, 'Operand should contain 1 column(s)')

> (cID, refs, host, city, useros, browser, visits, downloads) )

I suspect the issue is that, as a list type, the pysql interface expects 
to map "downloads" to either multiple columns, or one column in multiple 
rows, ie it is expecting the list to deliver multiple data items to the 
database, but the database is looking for a single data item.

-- 
Denis McMahon, denismfmcmahon at gmail.com



More information about the Python-list mailing list