************************************************************
QUERY ERROR @ gazeteer.class.php : line 62
************************************************************
SELECT * FROM keld_gazeteer LEFT JOIN keld_route_steps krs ON (krs.step_id = keld_gazeteer.id AND krs.route_id = ) WHERE (keld_gazeteer.routes LIKE "%River of Ur%") ORDER BY IF(keld_gazeteer.size='Route',1,0) DESC, krs.position 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 ') WHERE (keld_gazeteer.routes LIKE "%River of Ur%") ORDER BY IF(keld_gazeteer...' at line 1
************************************************************
Array
(
[0] => Array
(
[file] => /home/stranger/public_html/admin/functions.php
[line] => 240
[function] => execute
[args] => Array
(
[0] => SELECT * FROM keld_gazeteer LEFT JOIN keld_route_steps krs ON (krs.step_id = keld_gazeteer.id AND krs.route_id = ) WHERE (keld_gazeteer.routes LIKE "%River of Ur%") ORDER BY IF(keld_gazeteer.size='Route',1,0) DESC, krs.position ASC
[1] => Array
(
[report] =>
[debug] =>
)
)
)
[1] => Array
(
[file] => /home/stranger/public_html/GAMES/TERMITE/keld/classes/gazeteer.class.php
[line] => 62
[function] => get
[args] => Array
(
[0] => SELECT * FROM keld_gazeteer LEFT JOIN keld_route_steps krs ON (krs.step_id = keld_gazeteer.id AND krs.route_id = ) WHERE (keld_gazeteer.routes LIKE "%River of Ur%") ORDER BY IF(keld_gazeteer.size='Route',1,0) DESC, krs.position ASC
[1] =>
)
)
[2] => Array
(
[file] => /home/stranger/public_html/GAMES/TERMITE/keld/classes/gazeteer.class.php
[line] => 67
[function] => find_entries
[class] => gazeteer
[type] => ::
[args] => Array
(
[0] => Array
(
[routes] => River of Ur
)
)
)
[3] => Array
(
[file] => /home/stranger/public_html/GAMES/TERMITE/keld/gazeteer.html
[line] => 66
[function] => get_entries
[class] => gazeteer
[type] => ::
[args] => Array
(
[0] => Array
(
[routes] => River of Ur
)
)
)
)