Severity: Warning
Message: mysqli::query(): (HY000/1021): Disk full (/tmp/#sql_8ec_6.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Filename: mysqli/mysqli_driver.php
Line Number: 307
Backtrace:
File: /home/aksnews/public_html/application/models/Post_model.php
Line: 167
Function: query
File: /home/aksnews/public_html/application/core/Core_Controller.php
Line: 124
Function: get_popular_posts
File: /home/aksnews/public_html/application/controllers/Home_controller.php
Line: 7
Function: __construct
File: /home/aksnews/public_html/index.php
Line: 325
Function: require_once
Error Number: 1021
Disk full (/tmp/#sql_8ec_6.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
SELECT posts.id, posts.title, posts.title_slug, posts.post_type, posts.image_small, posts.image_mime, posts.image_url, users.slug AS author_slug, users.username AS author_username, posts.created_at, hit_counts.count AS pageviews_count, (SELECT COUNT(comments.id) FROM comments WHERE posts.id = comments.post_id AND comments.parent_id = 0 AND comments.status = 1) AS comment_count FROM posts INNER JOIN (SELECT COUNT(post_pageviews.post_id) AS count, post_pageviews.post_id FROM post_pageviews WHERE post_pageviews.created_at > DATE_SUB(NOW(), INTERVAL 7 DAY) GROUP BY post_pageviews.post_id) AS hit_counts ON hit_counts.post_id = posts.id INNER JOIN users ON users.id = posts.user_id INNER JOIN categories ON categories.id = posts.category_id WHERE posts.is_scheduled = 0 AND posts.visibility = 1 AND posts.status = 1 AND posts.lang_id = 1 ORDER BY hit_counts.count DESC LIMIT 5
Filename: models/Post_model.php
Line Number: 167