mySQL WARNING!DB Error: mySQL Error on Query : SELECT a.*, c.id as cid, c.name_en as catname, a.title_en as atitle, c.slug as catslug, u.username, CONCAT(u.fname,' ',u.lname) as fullname,
(SELECT COUNT(artid) FROM mod_blog_comments WHERE artid = a.id) as totalcomments, YEAR(a.created) as year, MONTH(a.created) as month, DAY(a.created) as day
FROM mod_blog as a
LEFT JOIN mod_blog_categories as c ON c.id = a.cid
LEFT JOIN users as u ON u.id = a.uid
WHERE u.username = 'marcom'
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,10
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, 9:49 am
- Referer: 1
- Script: /blog/author/marcom/