Irgendeiner eine Idee, warum folgende Zeile:
Code
$db_top = $db->query("SELECT * FROM bb".$n."_kt_paare p WHERE NOT p.paarid IN (SELECT u.paarid FROM bb".$n."_kt_usertipps u WHERE p.paarid = u.paarid AND u.userid = ".$zuser.")");
einen Mysql Fehler 1064 auswirft?
ZitatAlles anzeigenSQL-DATABASE ERROR
Database error in WoltLab Burning Board (2.3.6): Invalid SQL: SELECT * FROM bb1_kt_paare p WHERE NOT p.paarid IN (SELECT u.paarid FROM bb1_kt_usertipps u WHERE p.paarid = u.paarid AND u.userid = '615')
mysql error: 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 'SELECT u.paarid FROM bb1_kt_usertipps u WHERE p.paarid = u.paar
mysql error number: 1064
mysql version: 4.0.27-standard
php version: 4.4.9
Date: 07.07.2009 @ 23:28