Achso okay,
Dann habe ich keine gruppen.
Kann ich den code einfach raus nehmen ohne das was schlimmes passiert ? Denn gruppen brauche ich für die News im grundegenommen gar nicht.
~edit~
Okay, den code kann ich nicht einfach so rausnehmen.
Denn dann kommt dieser fehler hier:
MySQL Error:
1064 : 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 ') != (a.news_groups | ))))' at line 15
in Query:
SELECT a.news_title as title, a.news_text, a.news_kat, a.news_recht, a.news_groups, a.html, DATE_FORMAT(a.news_time,'%d. %m. %Y - %H:%i Uhr') as datum, DATE_FORMAT(a.news_time,'%W') as dayofweek, b.name as username, c.name as editorname, a.html, a.edit_time, a.klicks, b.id as uid FROM ic1_news 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 a.news_id = 8 AND a.`show` > 0 AND a.`show` <= UNIX_TIMESTAMP() AND (a.endtime IS NULL OR a.endtime > UNIX_TIMESTAMP()) AND (((512 | a.news_recht) = a.news_recht) OR (a.news_groups != 0 AND ((a.news_groups ^ ) != (a.news_groups | ))))
Debug backtrace:
@ mysql.php:32 -- debug_bt()
@ mysql.php:50 -- db_check_error(...)
@ news.php:137 -- db_query(...)
@ newsextended.php:13 -- require_once(...)
@ index.php:42 -- require_once(...)
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /kunden/312677_65428/webseiten/include/includes/func/db/mysql.php on line 71
MySQL Error:
1064 : 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 ') != (news_groups | )))) AND `show` > 0 AND `show` <= UNIX_TIMESTAMP() AND news' at line 2
in Query:
SELECT COUNT(*) FROM ic1_news WHERE (((512 | news_recht) = news_recht) OR (news_groups != 0 AND ((news_groups ^ ) != (news_groups | )))) AND `show` > 0 AND `show` <= UNIX_TIMESTAMP() AND news_id != 8 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:207 -- db_make_sites(...)
@ newsextended.php:13 -- require_once(...)
@ index.php:42 -- require_once(...)
Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /kunden/312677_65428/webseiten/include/includes/func/db/mysql.php on line 54
MySQL Error:
1064 : 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 ') != (a.news_groups | )))) AND a.`show` > 0 AND a.`show` <= UNIX_TIMESTAMP()' at line 18
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 (((512 | a.news_recht) = a.news_recht) OR (a.news_groups != 0 AND ((a.news_groups ^ ) != (a.news_groups | )))) AND a.`show` > 0 AND a.`show` <= UNIX_TIMESTAMP() AND news_id != 8 AND a.`archiv` != 1 AND (a.endtime IS NULL OR a.endtime > UNIX_TIMESTAMP()) ORDER BY a.news_time DESC LIMIT 0,5
Debug backtrace:
@ mysql.php:32 -- debug_bt()
@ mysql.php:50 -- db_check_error(...)
@ news.php:235 -- db_query(...)
@ newsextended.php:13 -- require_once(...)
@ index.php:42 -- require_once(...)
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /kunden/312677_65428/webseiten/include/includes/func/db/mysql.php on line 71
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /kunden/312677_65428/webseiten/include/includes/func/db/mysql.php on line 58
Wie kann ich das nun hin bekommen ?
Werde den code wieder einfügen aber dann ist ja wieder der fehler da wie beim ersten Post
Zuletzt modifiziert von Shoutala am 26.02.2011 - 21:32:33
Sa. 26.02.2011
10:41 Uhr
#1
