#1: Fehler bei Coppermine Autor: prosite, Verfasst am: 05.07.2008 01:31 ---- Ich habe das Problem das Coppermine mir beim aufmachen von Album diese Fehler meldung gibt was kann ich tun:
(ich benutze CPG Dragonfly 9.1.X)
Fehlermedung:
A database error has occurred
The webmaster has been notified of the error
CMS Warning line 75: On /index.php?name=coppermine&file=albmgr While executing query "SELECT aid, title, pos, description, thumb FROM cms_cpg_albums WHERE category = ORDER BY pos ASC" the following error occured: 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 'ORDER BY pos ASC' at line 1 In:modules/coppermine/albmgr.php on line: 111
Line 111:
$result = $db->sql_query("SELECT aid, title, pos, description, thumb FROM {$CONFIG['TABLE_ALBUMS']} WHERE category = $cat ORDER BY pos ASC");