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
)
)
)
Make Meaning Or Die