id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
2729	[patch] sqlinitialdata files with dos line endings error out on Gnu/Linux	Joeboy	Adrian Holovaty	"On my Gnu/Linux box, trying to use sqlinitialdata files provided by my windows-using colleagues, I get:

{{{
joe@edward ~/reportlab/libs/rltravelprod/djtravel $ ./manage.py reset holidays

You have requested a database reset.
This will IRREVERSIBLY DESTROY any data in your database.
Are you sure you want to do this?

Type 'yes' to continue, or 'no' to cancel: yes
Error: holidays couldn't be installed. Possible reasons:
  * The database isn't running or isn't configured correctly.
  * At least one of the database tables already exists.
  * The SQL was invalid.
Hint: Look at the output of 'django-admin.py sqlreset holidays'. That's the SQL this command wasn't able to run.
The full error: (1064, ""You have an error in your SQL syntax; check the manual that corresponds to your MySQL
server version for the right syntax to use near ';\r\nINSERT INTO `holidays_resort` (id, name, region_id) VALUES
(2,'Cavtat',1);\r\nI' at line 1"")
}}}

Converting to unix line endings fixes it."	defect	closed	Database layer (models, ORM)	dev	normal	fixed	sqlinitialdata dos windows	django25@… dev@…	Unreviewed	1	0	0	0	0	0