ich wollte heute mal die Funktion "lastforum" mit auf der seite einbauen/benutzen leider bekomme ich immer folgende Fehlermeldung:
MySQL Error:
1054 : Unknown column 'b.mods' in 'where clause'
in Query:
SELECT a.id, a.name, c.erst as last, c.id as pid FROM `ic1_topics` a LEFT JOIN `ic1_forums` b ON b.id = a.fid LEFT JOIN ic1_posts c ON c.id = a.last_post_id LEFT JOIN ic1_groupusers gv ON b.view = gv.gid AND gv.uid = 1 LEFT JOIN ic1_groupusers gm ON b.mods = gm.gid AND gm.uid = 1 LEFT JOIN ic1_groupusers gs ON b.start = gs.gid AND gs.uid = 1 LEFT JOIN ic1_groupusers gr ON b.reply = gr.gid AND gr.uid = 1 WHERE ( b.view = 0 OR b.reply = 0 OR b.start = 0 OR b.mods = 0 ) OR ( -9 = -5 ) OR ( b.view >= -9 OR b.mods >= -9 OR b.start >= -9 OR b.reply >= -9 ) OR ( gv.uid IS NOT NULL OR gm.uid IS NOT NULL OR gs.uid IS NOT NULL OR gr.uid IS NOT NULL ) ORDER BY c.time DESC LIMIT 0,5
Debug backtrace:
@ mysql.php:32 -- debug_bt()
@ mysql.php:50 -- db_check_error(...)
@ lastforum.php:37 -- db_query(...)
@ design.php:330 -- require_once(...)
@ design.php:252 -- design->get_boxcontent(...)
@ design.php:44 -- design->get_boxes(...)
@ news.php:12 -- design->design(...)
@ index.php:24 -- require_once(...)
Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /mnt/web8/33/05/51955405/htdocs/include/includes/func/db/mysql.php on line 67
Hat jemand von Euch eine Idee was da los ist ?
Danke im voraus,
Markus
verwendete ilchClan Version: 1.1
betroffene Homepage: externer Link
Zuletzt modifiziert von pologuru am 28.08.2009 - 08:24:30
