mySQL Error (1064): 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 deleted = 0 ORDER BY slot ASC' at line 1 Error occurred while running query: SELECT title, CONCAT('uploads/artworks/',picture) AS picture, CONCAT('uploads/artworks/',picture_full) AS picture_full, picture_full AS PCFULL FROM pictures WHERE id_artist = AND deleted = 0 ORDER BY slot ASC mySQL Error (1064): 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 deleted = 0 ORDER BY slot ASC LIMIT 15,17' at line 1 Error occurred while running query: SELECT title, CONCAT('uploads/artworks/',picture) AS picture FROM pictures WHERE id_artist = AND deleted = 0 ORDER BY slot ASC LIMIT 15,17mySQL Error (1064): 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 c.active = 1
AND c.deleted = 0
GROUP BY c.id_content
ORDER BY c.pub' at line 17 Error occurred while running query:
SELECT c.id_content, c.pubdate, REPLACE(c.title, '&', '|-|') AS title, c.brief,
CASE
WHEN c.id_content_type = 2 THEN CONCAT('/english/news/',c.url,'.html')
WHEN c.id_content_type = 3 THEN CONCAT('/english/expositions/',c.url,'.html')
WHEN c.id_content_type = 4 THEN CONCAT('/english/publications/jimmie-/',c.url,'.html')
END AS url,
CASE
WHEN c.id_content_type = 2 THEN IF(LENGTH(c.thumbnail)>0, CONCAT('uploads/news/',c.thumbnail), 'images/th-home-2.png')
WHEN c.id_content_type = 3 THEN IF(LENGTH(c.thumbnail)>0, CONCAT('uploads/exhibitions/',c.thumbnail), 'images/th-home-2.png')
WHEN c.id_content_type = 4 THEN IF(LENGTH(c.thumbnail)>0, CONCAT('uploads/publications/',c.thumbnail), 'images/th-home-2.png')
END AS thumbnail
FROM contents AS c
LEFT JOIN artists_news AS ac ON ac.id_content = c.id_content
WHERE c.id_content_type IN (2,3,4)
AND c.id_language = 2
AND ac.id_artist =
AND c.active = 1
AND c.deleted = 0
GROUP BY c.id_content
ORDER BY c.pubdate DESC
mySQL Error (1064): 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 v.deleted = 0 AND v.id_language = 2 ORDER BY v.id_video DESC' at line 4 Error occurred while running query:
SELECT v.id_video, CONCAT('/english/artists/jimmie-/',v.url,'.html') as url, v.title, v.brief, v.thumbnail
FROM videos v, artists_videos a
WHERE v.id_video = a.id_video AND v.active = 1 AND a.id_artist =
AND v.deleted = 0 AND v.id_language = 2 ORDER BY v.id_video DESC
kurimanzutto -
