DB ERROR: 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 'ASC
ORDER BY artistName ASC' at line 4
QUERYY:
SELECT artistName,
COUNT(reviewID) AS total FROM reviews
WHERE IF(alternateSort IS NULL, artistName, alternateSort) LIKE 'H%'
GROUP BY artistName ASC
ORDER BY artistName ASC
| 0 |
| file |
/home/stdave/daveshort.org/www/reviews/letter.php |
| line |
20 |
| function |
get |
| class |
MysqlDatabase |
| object |
| result |
[empty string] |
| getConnection |
[function] |
| getMysqli |
[function] |
| formatDateTime |
[function] |
| get |
[function] |
| multiQuery |
[function] |
| getField |
[function] |
| escape |
[function] |
| update |
[function] |
| query |
[function] |
| startTransaction |
[function] |
| endTransaction |
[function] |
| rollback |
[function] |
| getList |
[function] |
| getOneRow |
[function] |
|
| type |
-> |
| args |
| 0 |
SELECT artistName,
COUNT(reviewID) AS total FROM reviews
WHERE IF(alternateSort IS NULL, artistName, alternateSort) LIKE 'H%'
GROUP BY artistName ASC
ORDER BY artistName ASC |
|
|
| 1 |
| file |
/home/stdave/daveshort.org/www/passthrough.php |
| line |
187 |
| function |
show |
| args |
| 0 |
| _parameters |
| letter |
| type |
1 |
| requiredSource |
1 |
| required |
TRUE |
| save |
TRUE |
| validate |
TRUE |
| source |
1 |
| __construct |
[function] |
| getSource |
[function] |
| getName |
[function] |
| setType |
[function] |
| getType |
[function] |
| getValue |
[function] |
| getSave |
[function] |
| setRequired |
[function] |
| setRequiredType |
[function] |
| setValidation |
[function] |
| setRequiredSource |
[function] |
| check |
[function] |
| isCorrectSource |
[function] |
| parse |
[function] |
| isCorrectType |
[function] |
|
|
| session |
| _messages |
|
| _taskMessages |
|
| _data |
|
| _permissions |
|
| _errors |
|
| _groups |
|
| __construct |
[function] |
| register |
[function] |
| getFromSession |
[function] |
| isRegistered |
[function] |
| getUser |
[function] |
| saveToSession |
[function] |
| __destruct |
[function] |
| __set |
[function] |
| __get |
[function] |
| hasMessages |
[function] |
| getMessages |
[function] |
| peekMessages |
[function] |
| addMessage |
[function] |
| addTaskMessage |
[function] |
| hasTaskMessages |
[function] |
| getTaskMessages |
[function] |
| clearTaskMessages |
[function] |
| getErrors |
[function] |
| peekErrors |
[function] |
| addError |
[function] |
| addPermission |
[function] |
| getPermission |
[function] |
| addGroup |
[function] |
| getPermissions |
[function] |
| getGroups |
[function] |
| isMemberOfGroup |
[function] |
| destroy |
[function] |
|
| requiredPermissions |
|
| requiredGroups |
|
| _requiredParameters |
|
| _data |
| letters |
| A |
4 |
| B |
9 |
| C |
4 |
| D |
4 |
| E |
3 |
| F |
5 |
| G |
6 |
| H |
2 |
| I |
1 |
| J |
0 |
| K |
1 |
| L |
2 |
| M |
3 |
| N |
5 |
| O |
1 |
| P |
5 |
| Q |
2 |
| R |
8 |
| S |
6 |
| T |
1 |
| U |
0 |
| V |
1 |
| W |
1 |
| X |
0 |
| Y |
1 |
| Z |
1 |
|
|
| _overrideOutput |
[empty string] |
| _postvars |
|
| _getvars |
|
| __construct |
[function] |
| getAccessMethod |
[function] |
| getOutputMethod |
[function] |
| setDatabase |
[function] |
| getDatabase |
[function] |
| addRequiredPermission |
[function] |
| addRequiredGroup |
[function] |
| shouldCheck |
[function] |
| getFullPath |
[function] |
| checkPermissions |
[function] |
| checkGroups |
[function] |
| checkPage |
[function] |
| checkAccess |
[function] |
| renderPostParameters |
[function] |
| commitSession |
[function] |
| renderGetParameters |
[function] |
| __get |
[function] |
| __set |
[function] |
| addHeader |
[function] |
| headerNow |
[function] |
| getAjaxPath |
[function] |
| getRelativeAjaxPath |
[function] |
| getCurrentPage |
[function] |
| get |
[function] |
| post |
[function] |
| getGet |
[function] |
| getPost |
[function] |
| redirectRelative |
[function] |
| redirectAbsolute |
[function] |
| redirectFromRoot |
[function] |
| getHeaders |
[function] |
| isOutputOverridden |
[function] |
| debug |
[function] |
| getDebugData |
[function] |
| getFilePath |
[function] |
| getWebPath |
[function] |
| getRequestPath |
[function] |
| getRequestMethod |
[function] |
| isGetVar |
[function] |
| isPostVar |
[function] |
| getReferer |
[function] |
| getData |
[function] |
| addRequiredParameter |
[function] |
| isHTTPS |
[function] |
| getFullURI |
[function] |
| checkParameters |
[function] |
| cleanURL |
[function] |
| filterVariable |
[function] |
| arrayToQueryString |
[function] |
|
|
|