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 'D%'
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 'D%'
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] |
|
|
|