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, DATE_FORMAT(a.created, '%d') 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 a.created <= NOW()
AND (a.expire = '0000-00-00 00:00:00' OR a.expire >= NOW())
AND title_br REGEXP '^P'
AND a.active = 1
ORDER BY a.created DESC LIMIT 0,6
More Information:
- Mysql Error : 1054
- Mysql Error no # : Unknown column 'title_br' in 'where clause'
- Date : May 12, 2025, 7:32 pm
- Referer:
- Script: /blog/?letter=P
