Bug #3630

Wrong syntax in showback calculate for sqlite < 3.7.11

Added by Daniel Molina over 6 years ago. Updated over 6 years ago.

Status:ClosedStart date:02/23/2015
Priority:HighDue date:
Assignee:-% Done:

0%

Category:Core & System
Target version:Release 4.12
Resolution:fixed Pull request:
Affected Versions:Development

Description

REPLACE INTO vm_showback (vmid, year, month, body) VALUES (0,2015,2,'<SHOWBACK><VMID> ....
Error: near ",": syntax error

http://stackoverflow.com/questions/1609637/is-it-possible-to-insert-multiple-rows-at-a-time-in-an-sqlite-database


Related issues

Duplicated by Bug #3631: Multiple insert syntax is not supported by CentOS 6.6 sqlite Closed 02/23/2015

Associated revisions

Revision 3da52fe1
Added by Carlos Martín over 6 years ago

Bug #3630: Showback uses a transaction for sqlite backends

Revision 760a829c
Added by Carlos Martín over 6 years ago

Bug #3630: Fix syntax error when mysql support is not compiled

History

#1 Updated by Ruben S. Montero over 6 years ago

  • Duplicated by Bug #3631: Multiple insert syntax is not supported by CentOS 6.6 sqlite added

#2 Updated by Ruben S. Montero over 6 years ago

  • Status changed from New to Closed
  • Resolution set to fixed

Also available in: Atom PDF