Code

Opened 8 years ago

Closed 8 years ago

Last modified 8 years ago

#1543 closed defect (fixed)

[patch] syncdb bug with importing initial sql data

Reported by: Nebojsa Djordjevic <nesh at studioquattro dot co dot yu> Owned by: adrian
Component: Tools Version: magic-removal
Severity: normal Keywords:
Cc: nesh@… Triage Stage: Unreviewed
Has patch: yes Needs documentation: no
Needs tests: no Patch needs improvement: no
Easy pickings: UI/UX:

Description

If you have a multiline SQL data for initial data import you can have You can only execute one statement at a time error when using syncdb command.

Attached patch fixes this and also add SQL statement in which error has occurred to error report.

Attachments (1)

management.diff (1.2 KB) - added by Nebojsa Djordjevic <nesh at studioquattro dot co dot yu> 8 years ago.

Download all attachments as: .zip

Change History (6)

Changed 8 years ago by Nebojsa Djordjevic <nesh at studioquattro dot co dot yu>

comment:1 Changed 8 years ago by Nebojsa Djordjevic <nesh at studioquattro dot co dot yu>

  • Cc nesh@… added

comment:2 Changed 8 years ago by Nebojsa Djordjevic <nesh at studioquattro dot co dot yu>

Also, I think that it's worth to note in the documentation for syncdb that you must quote a bare % inside SQL statements (as a %%), because failing to do that will produce a not enough arguments for format string error.

comment:3 Changed 8 years ago by Nebojsa Djordjevic <nesh at studioquattro dot co dot yu>

  • Component changed from Core framework to Tools

NOTE: this patch requires that all of the SQL statements are in one line only!!

comment:4 Changed 8 years ago by Nebojsa Djordjevic <nesh at studioquattro dot co dot yu>

  • Summary changed from [pathc] syncdb bug with importing initial sql data to [patch] syncdb bug with importing initial sql data

comment:5 Changed 8 years ago by adrian

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

Fixed in [2985].

Add Comment

Modify Ticket

Change Properties
<Author field>
Action
as closed
as The resolution will be set. Next status will be 'closed'
The resolution will be deleted. Next status will be 'new'
Author


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

 
Note: See TracTickets for help on using tickets.