Modify

Opened 8 years ago

Closed 2 years ago

#1505 closed defect (fixed)

insert into session sql syntax error

Reported by: brian@… Owned by: codeFiend
Priority: normal Component: MantisImportScript
Severity: critical Keywords: insert, session, sql, syntax, python, long quote
Cc: Trac Release: 0.10

Description

I was getting error message about incorrect syntax for the "INSERT INTO session" statements.

I changed this

                       c.execute(
                       """INSERT INTO session
                           (sid, authenticated, last_visit)
                       VALUES """,(result[0]['username'].encode('utf-8'), '1', result[0]['last_visit'].strftime('%s')))

to this

                       c.execute( "INSERT INTO session (sid, authenticated, last_visit) VALUES ('%s', %s, %s)" % (result[0]['username'].encode('utf-8'), '1', result[0]['last_visit'].strftime('%s')) )

and it worked.

I don't know the term for these python long quotes, so please retag this ticket appropriately.

Oh it just dawned on me. You can probably keep the params version of the execute(), but you need to mark the parameters in the query with question marks, or $1, $2, or $3, or something. Shrug, i dunno, it's my first day speaking python.

Attachments (0)

Change History (2)

comment:1 Changed 7 years ago by simona@…

Try to spam my mail plz.

comment:2 Changed 2 years ago by codeFiend

  • Resolution set to fixed
  • Status changed from new to closed

thank you

Add Comment

Modify Ticket

Action
as closed The owner will remain codeFiend.
The resolution will be deleted. Next status will be 'reopened'.
Author


E-mail address and user name can be saved in the Preferences.

 
Note: See TracTickets for help on using tickets.