************************************************************
QUERY ERROR @ bestiary.class.php : line 109
************************************************************
SELECT bestiary_entry.id
FROM bestiary_entry
LEFT JOIN bestiary_statline ON (bestiary_statline.entry_id = bestiary_entry.id AND bestiary_statline.level != 0)
WHERE (
(bestiary_entry.level >= 8 OR
(bestiary_statline.level >= 8)
)
GROUP BY bestiary_entry.id
ORDER BY bestiary_entry.name ASC
RESULT :
ERROR : You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'GROUP BY bestiary_entry.id
ORDER BY bestiary_entry.n...' at line 8
************************************************************
Array
(
[0] => Array
(
[file] => /home/stranger/public_html/admin/functions.php
[line] => 240
[function] => execute
[args] => Array
(
[0] => SELECT bestiary_entry.id
FROM bestiary_entry
LEFT JOIN bestiary_statline ON (bestiary_statline.entry_id = bestiary_entry.id AND bestiary_statline.level != 0)
WHERE (
(bestiary_entry.level >= 8 OR
(bestiary_statline.level >= 8)
)
GROUP BY bestiary_entry.id
ORDER BY bestiary_entry.name ASC
[1] => Array
(
[report] =>
[debug] =>
)
)
)
[1] => Array
(
[file] => /home/stranger/public_html/GAMES/TERMITE/keld/classes/bestiary.class.php
[line] => 109
[function] => get
[args] => Array
(
[0] => SELECT bestiary_entry.id
FROM bestiary_entry
LEFT JOIN bestiary_statline ON (bestiary_statline.entry_id = bestiary_entry.id AND bestiary_statline.level != 0)
WHERE (
(bestiary_entry.level >= 8 OR
(bestiary_statline.level >= 8)
)
GROUP BY bestiary_entry.id
ORDER BY bestiary_entry.name ASC
[1] =>
)
)
[2] => Array
(
[file] => /home/stranger/public_html/GAMES/TERMITE/keld/classes/bestiary.class.php
[line] => 114
[function] => find_entries
[class] => bestiary
[object] => bestiary Object
(
)
[type] => ->
[args] => Array
(
[0] => Array
(
[level_min] => 8
)
)
)
[3] => Array
(
[file] => /home/stranger/public_html/GAMES/TERMITE/keld/bestiary.html
[line] => 61
[function] => get_entries
[class] => bestiary
[object] => bestiary Object
(
)
[type] => ->
[args] => Array
(
[0] => Array
(
[level_min] => 8
)
)
)
)