// Add your reply above here
==================================================
Nick Legg updated this ticket at July 20th, 2011 @ 11:44 AM
* Assigned user changed from "" to "Bugs (at bricolage)"
In your database, run this query:
SELECT * FROM story_instance WHERE story__id = 204774;
I receive this error from time to time when the story is stuck in a partially checked-out state. The results of this query may reveal the same issue. If you have multiple story_instance records with the same version number, that's your problem. It sounds like your duplicate is probably version 11. Find the duplicate that shouldn't exist (yet), because the story hasn't been checked out (yet), and DELETE that record from the database:
DELETE FROM story_instance WHERE id = xxxxxxx;
--------------------------------------------------------------------------------
Assigned: Bugs (at bricolage)
State: new
View this ticket online: http://bricolage.lighthouseapp.com/projects/29601/tickets/276-unable-to-execute-sql-statement
Stop being notified of this ticket's changes: http://bricolage.lighthouseapp.com/watching/33e76c7b346db73af9a27eaeaf61ccd37963b4da
Update your Profile: http://bricolage.lighthouseapp.com/profile
Support: support@lighthouseapp.com or http://help.lighthouseapp.com
==================================================
Nick Legg updated this ticket at July 20th, 2011 @ 11:44 AM
* Assigned user changed from "" to "Bugs (at bricolage)"
In your database, run this query:
SELECT * FROM story_instance WHERE story__id = 204774;
I receive this error from time to time when the story is stuck in a partially checked-out state. The results of this query may reveal the same issue. If you have multiple story_instance records with the same version number, that's your problem. It sounds like your duplicate is probably version 11. Find the duplicate that shouldn't exist (yet), because the story hasn't been checked out (yet), and DELETE that record from the database:
DELETE FROM story_instance WHERE id = xxxxxxx;
--------------------------------------------------------------------------------
Assigned: Bugs (at bricolage)
State: new
View this ticket online: http://bricolage.lighthouseapp.com/projects/29601/tickets/276-unable-to-execute-sql-statement
Stop being notified of this ticket's changes: http://bricolage.lighthouseapp.com/watching/33e76c7b346db73af9a27eaeaf61ccd37963b4da
Update your Profile: http://bricolage.lighthouseapp.com/profile
Support: support@lighthouseapp.com or http://help.lighthouseapp.com