Dragonfly CMS - German Community

prosite · Joined: Jul 04, 2008 Posts: 1

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");

Für schnelle hilfe währe ich dankbar

Ertan · Joined: Mar 19, 2004 Posts: 1247 Location: Germany

Array:

Nano's fix is here, includes/cssmainmenu.php,
dragonflycms.org/cvs/h....php?g=1.2

dragonflycms.org/Forum...rt=15.html