search

bethlakshmi / GBE

Code repository for the Great Boston Burlesque Expo
3 stars 0 forks source link

Order of Acts prevents submitting Tech Info #146

Closed burlexpo closed 10 years ago

burlexpo commented 10 years ago

If the "Order" column is filled in before the performer submits their tech info, it creates a conflict which prevents them from submitting their information.

Error message is

Insert or Update into Acts failed: 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 'Order="9" where ActId = '8'' at line 1

bethlakshmi commented 10 years ago

Argh. OK. I recognize it. It'll need some time to figure out how to fix it. I'll start on it after the update to the live site.

-B

On Sat, Jan 11, 2014 at 9:20 AM, Scratch notifications@github.com wrote:

If the "Order" column is filled in before the performer submits their tech info, it creates a conflict which prevents them from submitting their information.

Error message is

Insert or Update into Acts failed: 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 'Order="9" where ActId = '8'' at line 1

— Reply to this email directly or view it on GitHubhttps://github.com/bethlakshmi/GBE/issues/146 .

bethlakshmi commented 10 years ago

FIXED IT!

That was annoying, it came up before, but this time I figured it out - Order is a reserved word in SQL, so it was messing up as a column name update if I didn't escape it with a strange sort of quote. Pushed to live site.