hallo habe heute noch eine version 6.0 bei mir gefunden habe es installiert konnte auch ein member anlegen aber beim einloggen bekomme ich volgene fehlermeldung
Query: SELECT DISTINCT `ClassifiedsAdvertisements`.`ID`, `ClassifiedsAdvertisements`.`Subject`, `ClassifiedsAdvertisements`.`Media`, `Profiles`.`NickName`, UNIX_TIMESTAMP( `ClassifiedsAdvertisements`.`DateTime` ) as `DateTime_f`, `ClassifiedsAdvertisements`.`DateTime`, `Classifieds`.`Name`, `Classifieds`.`ID` AS `CatID`, `ClassifiedsSubs`.`NameSub`, `ClassifiedsSubs`.`ID` AS `SubCatID`, `ClassifiedsAdvertisements`.`Message`, COUNT(`ClsAdvComments`.`ID`) AS 'CommCount' FROM `ClassifiedsAdvertisements` LEFT JOIN `ClassifiedsSubs` ON `ClassifiedsSubs`.`ID`=`ClassifiedsAdvertisements`.`IDClassifiedsSubs` LEFT JOIN `Classifieds` ON `Classifieds`.`ID`=`ClassifiedsSubs`.`IDClassified` LEFT JOIN `Profiles` ON `Profiles`.`ID`=`ClassifiedsAdvertisements`.`IDProfile` LEFT JOIN `ClsAdvComments` ON `ClsAdvComments`.`IDAdv`=`ClassifiedsAdvertisements`.`ID` WHERE `ClassifiedsAdvertisements`.`IDProfile` = AND `ClassifiedsAdvertisements`.`Status` = 'active' GROUP BY `ClassifiedsAdvertisements`.`ID` ORDER BY `DateTime` DESC LIMIT 5 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 'AND `ClassifiedsAdvertisements`.`Status` = 'active' GROUP BY `ClassifiedsA' at line 20
dan eine scrall box mit volgendem code
Found error in file /srv/www/vhosts/my-sam.de/htdocs/member.php at line 243. Called db_res function with erroneous argument #0 Debug backtrace: Array ( [1] => Array ( [file] => /srv/www/vhosts/my-sam.de/htdocs/member.php [line] => 243 [function] => db_res [args] => Array ( [0] => SELECT DISTINCT `ClassifiedsAdvertisements`.`ID`, `ClassifiedsAdvertisements`.`Subject`, `ClassifiedsAdvertisements`.`Media`, `Profiles`.`NickName`, UNIX_TIMESTAMP( `ClassifiedsAdvertisements`.`DateTime` ) as `DateTime_f`, `ClassifiedsAdvertisements`.`DateTime`, `Classifieds`.`Name`, `Classifieds`.`ID` AS `CatID`, `ClassifiedsSubs`.`NameSub`, `ClassifiedsSubs`.`ID` AS `SubCatID`, `ClassifiedsAdvertisements`.`Message`, COUNT(`ClsAdvComments`.`ID`) AS 'CommCount' FROM `ClassifiedsAdvertisements` LEFT JOIN `ClassifiedsSubs` ON `ClassifiedsSubs`.`ID`=`ClassifiedsAdvertisements`.`IDClassifiedsSubs` LEFT JOIN `Classifieds` ON `Classifieds`.`ID`=`ClassifiedsSubs`.`IDClassified` LEFT JOIN `Profiles` ON `Profiles`.`ID`=`ClassifiedsAdvertisements`.`IDProfile` LEFT JOIN `ClsAdvComments` ON `ClsAdvComments`.`IDAdv`=`ClassifiedsAdvertisements`.`ID` WHERE `ClassifiedsAdvertisements`.`IDProfile` = AND `ClassifiedsAdvertisements`.`Status` = 'active' GROUP BY `ClassifiedsAdvertisements`.`ID` ORDER BY `DateTime` DESC LIMIT 5 ) ) [2] => Array ( [file] => /srv/www/vhosts/my-sam.de/htdocs/member.php [line] => 157 [function] => PageCompClassifieds [args] => Array ( [0] => [1] => ) ) [3] => Array ( [file] => /srv/www/vhosts/my-sam.de/htdocs/member.php [line] => 127 [function] => getPageBlocks [args] => Array ( [0] => 1 ) ) )
Query: SELECT DISTINCT `ClassifiedsAdvertisements`.`ID`, `ClassifiedsAdvertisements`.`Subject`, `ClassifiedsAdvertisements`.`Media`, `Profiles`.`NickName`, UNIX_TIMESTAMP( `ClassifiedsAdvertisements`.`DateTime` ) as `DateTime_f`, `ClassifiedsAdvertisements`.`DateTime`, `Classifieds`.`Name`, `Classifieds`.`ID` AS `CatID`, `ClassifiedsSubs`.`NameSub`, `ClassifiedsSubs`.`ID` AS `SubCatID`, `ClassifiedsAdvertisements`.`Message`, COUNT(`ClsAdvComments`.`ID`) AS 'CommCount' FROM `ClassifiedsAdvertisements` LEFT JOIN `ClassifiedsSubs` ON `ClassifiedsSubs`.`ID`=`ClassifiedsAdvertisements`.`IDClassifiedsSubs` LEFT JOIN `Classifieds` ON `Classifieds`.`ID`=`ClassifiedsSubs`.`IDClassified` LEFT JOIN `Profiles` ON `Profiles`.`ID`=`ClassifiedsAdvertisements`.`IDProfile` LEFT JOIN `ClsAdvComments` ON `ClsAdvComments`.`IDAdv`=`ClassifiedsAdvertisements`.`ID` WHERE `ClassifiedsAdvertisements`.`IDProfile` = AND `ClassifiedsAdvertisements`.`Status` = 'active' GROUP BY `ClassifiedsAdvertisements`.`ID` ORDER BY `DateTime` DESC LIMIT 5 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 'AND `ClassifiedsAdvertisements`.`Status` = 'active' GROUP BY `ClassifiedsA' at line 20
dan eine scrall box mit volgendem code
Found error in file /srv/www/vhosts/my-sam.de/htdocs/member.php at line 243. Called db_res function with erroneous argument #0 Debug backtrace: Array ( [1] => Array ( [file] => /srv/www/vhosts/my-sam.de/htdocs/member.php [line] => 243 [function] => db_res [args] => Array ( [0] => SELECT DISTINCT `ClassifiedsAdvertisements`.`ID`, `ClassifiedsAdvertisements`.`Subject`, `ClassifiedsAdvertisements`.`Media`, `Profiles`.`NickName`, UNIX_TIMESTAMP( `ClassifiedsAdvertisements`.`DateTime` ) as `DateTime_f`, `ClassifiedsAdvertisements`.`DateTime`, `Classifieds`.`Name`, `Classifieds`.`ID` AS `CatID`, `ClassifiedsSubs`.`NameSub`, `ClassifiedsSubs`.`ID` AS `SubCatID`, `ClassifiedsAdvertisements`.`Message`, COUNT(`ClsAdvComments`.`ID`) AS 'CommCount' FROM `ClassifiedsAdvertisements` LEFT JOIN `ClassifiedsSubs` ON `ClassifiedsSubs`.`ID`=`ClassifiedsAdvertisements`.`IDClassifiedsSubs` LEFT JOIN `Classifieds` ON `Classifieds`.`ID`=`ClassifiedsSubs`.`IDClassified` LEFT JOIN `Profiles` ON `Profiles`.`ID`=`ClassifiedsAdvertisements`.`IDProfile` LEFT JOIN `ClsAdvComments` ON `ClsAdvComments`.`IDAdv`=`ClassifiedsAdvertisements`.`ID` WHERE `ClassifiedsAdvertisements`.`IDProfile` = AND `ClassifiedsAdvertisements`.`Status` = 'active' GROUP BY `ClassifiedsAdvertisements`.`ID` ORDER BY `DateTime` DESC LIMIT 5 ) ) [2] => Array ( [file] => /srv/www/vhosts/my-sam.de/htdocs/member.php [line] => 157 [function] => PageCompClassifieds [args] => Array ( [0] => [1] => ) ) [3] => Array ( [file] => /srv/www/vhosts/my-sam.de/htdocs/member.php [line] => 127 [function] => getPageBlocks [args] => Array ( [0] => 1 ) ) )