mySQL WARNING!DB Error: mySQL Error on Query : SELECT a.*, c.id as cid, c.name_en as catname, a.title_en as atitle, a.slug, a.thumb, a.show_author,
a.show_created, a.short_desc_en, a.caption_en, c.slug as catslug, u.username, a.created, a.modified,
(SELECT COUNT(artid) FROM mod_blog_comments WHERE artid = a.id) as totalcomments, YEAR(a.created) as year,
MONTH(a.created) as month, DATE_FORMAT(a.created, '%d') as day
FROM mod_blog as a
INNER JOIN mod_blog_related_categories rc ON a.id = rc.aid
LEFT JOIN mod_blog_categories as c ON c.id = rc.cid
LEFT JOIN users as u ON u.id = a.uid
WHERE rc.cid = 22
AND c.active = 1
AND a.created <= NOW()
AND (a.expire = '0000-00-00 00:00:00' OR a.expire >= NOW())
AND a.active = 1
ORDER BY a.created DESC LIMIT 0,5
More Information:
- Mysql Error : 1
- Mysql Error no # : Can't create/write to file '/tmp/#sql_120017_0.MAI' (Errcode: 30 "Read-only file system")
- Date : July 16, 2024, 11:34 am
- Referer: 1
- Script: /blog/category/kaleidoskop/