diff -r 3ec9ac297045 -r 8d85b52ac9b6 plugins/SpecialPageFuncs.php --- a/plugins/SpecialPageFuncs.php Mon Dec 28 16:53:19 2009 -0500 +++ b/plugins/SpecialPageFuncs.php Mon Jan 04 11:09:50 2010 -0500 @@ -298,7 +298,12 @@ $db->free_result(); - $q = $db->sql_unbuffered_query('SELECT CONCAT("ns=",namespace,";pid=",urlname) AS identifier, name FROM '.table_prefix.'pages WHERE visible!=0 ORDER BY name ASC;'); + // This query needs to be generated based on the DBMS + $concat_column = ENANO_DBLAYER == 'MYSQL' + ? 'CONCAT("ns=",namespace,";pid=",urlname)' + : "'ns=' || namespace || ';pid=' || urlname"; + + $q = $db->sql_unbuffered_query("SELECT $concat_column AS identifier, name FROM " . table_prefix . "pages WHERE visible != 0 ORDER BY name ASC;"); if ( !$q ) $db->_die();