MySQL Error: 1054 : Unknown column 'html' in 'field list' in Query: SELECT news_title, news_text, html FROM ic1_news WHERE news_id = 0 AND `show` > 0 AND `show` <= UNIX_TIMESTAMP() AND (endtime IS NULL OR endtime > UNIX_TIMESTAMP()) Debug backtrace: @ mysql.php:32 -- debug_bt() @ mysql.php:50 -- db_check_error(...) @ news.php:134 -- db_query(...) @ newsextended.php:13 -- require_once(...) @ index.php:25 -- require_once(...) Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /data/apache/users/kilu.de/alphatier/www/include/includes/func/db/mysql.php on line 71 MySQL Error: 1054 : Unknown column 'show' in 'where clause' in Query: SELECT COUNT(*) FROM ic1_news WHERE news_recht >= -9 AND `show` > 0 AND `show` <= UNIX_TIMESTAMP() AND news_id != 0 AND archiv != 1 AND (endtime IS NULL OR endtime > UNIX_TIMESTAMP()) Debug backtrace: @ mysql.php:32 -- debug_bt() @ mysql.php:50 -- db_check_error(...) @ mysql.php:101 -- db_query(...) @ news.php:144 -- db_make_sites(...) @ newsextended.php:13 -- require_once(...) @ index.php:25 -- require_once(...) Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /data/apache/users/kilu.de/alphatier/www/include/includes/func/db/mysql.php on line 54 MySQL Error: 1054 : Unknown column 'a.html' in 'field list' in Query: SELECT a.news_title as title, a.news_id as id, DATE_FORMAT(a.news_time,'%d. %m. %Y - %H:%i Uhr') as datum, DATE_FORMAT(a.news_time,'%W') as dayofweek, a.news_kat as kate, a.news_text as text, b.name as username, c.name as editorname, a.html, a.edit_time, a.klicks, b.id as uid FROM ic1_news as a LEFT JOIN ic1_user as b ON a.user_id = b.id LEFT JOIN ic1_user as c ON a.editor_id = c.id WHERE (-9 <= a.news_recht OR a.news_recht = 0) AND a.`show` > 0 AND a.`show` <= UNIX_TIMESTAMP() AND news_id != 0 AND a.`archiv` != 1 AND (a.endtime IS NULL OR a.endtime > UNIX_TIMESTAMP()) ORDER BY a.news_time DESC LIMIT 0,3 Debug backtrace: @ mysql.php:32 -- debug_bt() @ mysql.php:50 -- db_check_error(...) @ news.php:171 -- db_query(...) @ newsextended.php:13 -- require_once(...) @ index.php:25 -- require_once(...) Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /data/apache/users/kilu.de/alphatier/www/include/includes/func/db/mysql.php on line 58
Woran kann das liegen und wie können wir das beheben?
mfg
verwendete ilchClan Version: 1.1
Zitat geschrieben von rubberduck2006
Sonst würde es funzn 