SELECT BlogCategories.Name AS BlogCategoryName,
BlogCategories.NameTranslations AS BlogCategoryNameTranslations,
RepositoryFiles.RepositoryDirectoryID,
RepositoryFiles.Name as FileName,
RepositoryFiles.Width,
RepositoryFiles.Height,
RepositoryFiles.Extension,
RepositoryFiles.ResizeSizes,
RepositoryFiles.OriginalResized,
RD.Name AS DirName,
IF (JD.RepositoryDirectoryID IS NULL, RD.Name, CONCAT(JD.Name,'/',RD.Name)) AS FolderName,
RD.RepositoryDirectoryID AS CurrentDirID,
JD.RepositoryDirectoryID AS ParentDirID,
Blogs.*,
DATE_FORMAT(FROM_UNIXTIME(Blogs.DatePublication), '%d %M %Y') AS FormattedDatePublication,
null AS Photos,
null AS Tags,
null AS URL
FROM Blogs
LEFT JOIN RepositoryFiles ON Blogs.RepositoryFileID = RepositoryFiles.RepositoryFileID
LEFT JOIN RepositoryDirectories AS RD ON RepositoryFiles.RepositoryDirectoryID = RD.RepositoryDirectoryID
LEFT JOIN RepositoryDirectories AS JD ON RD.ParentID = JD.RepositoryDirectoryID INNER JOIN BlogCategories ON Blogs.BlogCategoryID = BlogCategories.BlogCategoryID INNER JOIN BlogPhotos ON Blogs.BlogID = BlogPhotos.BlogID LEFT JOIN BlogReactions ON Blogs.BlogID = BlogReactions.BlogID WHERE (Blogs.Status = 1) AND (Blogs.Status = 1) AND (Blogs.BlogCategoryID = ) AND (Blogs.BlogID !=) GROUP BY Blogs.BlogID ORDER BY Blogs.DatePublication DESC LIMIT 0, 21
SELECT BlogCategories.Name AS BlogCategoryName,
BlogCategories.NameTranslations AS BlogCategoryNameTranslations,
RepositoryFiles.RepositoryDirectoryID,
RepositoryFiles.Name as FileName,
RepositoryFiles.Width,
RepositoryFiles.Height,
RepositoryFiles.Extension,
RepositoryFiles.ResizeSizes,
RepositoryFiles.OriginalResized,
RD.Name AS DirName,
IF (JD.RepositoryDirectoryID IS NULL, RD.Name, CONCAT(JD.Name,'/',RD.Name)) AS FolderName,
RD.RepositoryDirectoryID AS CurrentDirID,
JD.RepositoryDirectoryID AS ParentDirID,
Blogs.*,
DATE_FORMAT(FROM_UNIXTIME(Blogs.DatePublication), '%d %M %Y') AS FormattedDatePublication,
null AS Photos,
null AS Tags,
null AS URL
FROM Blogs
LEFT JOIN RepositoryFiles ON Blogs.RepositoryFileID = RepositoryFiles.RepositoryFileID
LEFT JOIN RepositoryDirectories AS RD ON RepositoryFiles.RepositoryDirectoryID = RD.RepositoryDirectoryID
LEFT JOIN RepositoryDirectories AS JD ON RD.ParentID = JD.RepositoryDirectoryID INNER JOIN BlogCategories ON Blogs.BlogCategoryID = BlogCategories.BlogCategoryID INNER JOIN BlogPhotos ON Blogs.BlogID = BlogPhotos.BlogID LEFT JOIN BlogReactions ON Blogs.BlogID = BlogReactions.BlogID WHERE (Blogs.Status = 1) AND (Blogs.Status = 1) AND (Blogs.BlogCategoryID = ) AND (Blogs.BlogID !=) GROUP BY Blogs.BlogID ORDER BY Blogs.DatePublication DESC LIMIT 0, 21
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AND (Blogs.BlogID !=) GROUP BY Blogs.BlogID ORDER BY Blogs.DatePublication DES' at line 22 Bestand " /home/laplage/domains/laplage-schoenen.be/public_html/core/frontend/blog/blogs.php " veroorzaakt een fout bij
klant .
Functie aanroep bestand /home/laplage/domains/laplage-schoenen.be/public_html/core/frontend/blog/blogs.php op lijn 185
Implementatie bestand /home/laplage/domains/laplage-schoenen.be/public_html/core/frontend/blog/blogcontroller.php op lijn 232
bij La Plage Schoenen