************************************************************ 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 "%The Anvil\'s Way%") 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 "%The Anvil\'s Way%") ORDER BY IF(keld_gaz...' 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 "%The Anvil\'s Way%") 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 "%The Anvil\'s Way%") 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] => The Anvil's Way ) ) ) [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] => The Anvil's Way ) ) ) )