search

bethlakshmi / GBE

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

Reports: Payment Lists report fails for "Alumni" #140

Closed jonkiparsky closed 10 years ago

jonkiparsky commented 10 years ago

Querying for alumni payment status fails with this error:

SELECT DisplayName, EMail, DATE_FORMAT(LastLogin, "%Y-%m-%d") AS LastLogin FROM Users WHERE (CanSignup='Alumni') ORDER BY LastLogin DESC, DisplayName, Query for users 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 '' at line 1

URL for error: http://burlesque-expo.com/MailTo.php?action=72

bethlakshmi commented 10 years ago

We really don't have alumni this year, so this one is low priority.

May even be able to pull it.

On Sun, Dec 29, 2013 at 12:21 AM, Jon Kiparsky notifications@github.comwrote:

Querying for alumni payment status fails with this error:

SELECT DisplayName, EMail, DATE_FORMAT(LastLogin, "%Y-%m-%d") AS LastLogin FROM Users WHERE (CanSignup='Alumni') ORDER BY LastLogin DESC, DisplayName, Query for users 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 '' at line 1

URL for error: http://burlesque-expo.com/MailTo.php?action=72

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

jonkiparsky commented 10 years ago

I'm not really bothered if it's not fixed. Only reporting because I noticed it while doing a verification crawl. Closing it.