BoonEx Blog

I’ve had an error just suddenly appear and I’m not understanding how it has arrived or how to fix it.

————————————–

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 `Classified' at line 20

Found error in file member.php
at line 243. Called db_res function
with erroneous argument #0

Debug backtrace:
Array
(
    [1] => Array
        (
   [file] => 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] => member.php
   [line] => 157
   [function] => PageCompClassifieds
   [args] => Array
       (
  [0] =>
  [1] =>
       )

        )

    [3] => Array
        (
   [file] => member.php
   [line] => 127
   [function] => getPageBlocks
   [args] => Array
       (
  [0] => 1
       )

        )

)