id	summary	reporter	owner	description	type	status	priority	component	severity	resolution	keywords	cc	release
2216	[patch included] Plugin fails to update mood entry	dexen	tanktarta	with Trac 10.4 and decent SQLite. It seems that string in SQLite (in my configuration) is stored as 'DD-MM-YYYY', while the plugin uses 'DD/MM/YYYY' format, thus SQL query doesn't find existing row -- and fails upon issuing INSERT (rather than UPDATE, which would be issued should the plugin find previous entry). \r\nThe difference in formatting of date field may be due to regionall setting (LOCALE).\r\n\r\nI kinda fixed it by commenting out:\r\n__#date_time = now.strftime("%d/%m/%Y");\r\nand adding above it following code:\r\n__date_time = str(now.date())\r\n(I'm sorry it's not a real patch, I'm in hurry now >_>;; )	defect	assigned	normal	NikoNikoPlugin	normal				0.10