Exception caught: MySQL error: Disk full (/tmp/#sql_340924_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") "SELECT SQL_CALC_FOUND_ROWS
p.id,
p.name AS title,
DATE_FORMAT(p.updated, '%d.%m.%Y') AS updated,
DATE_FORMAT(p.released, '%d.%m.%Y') AS released,
COALESCE((SELECT downloads FROM download_counts WHERE file = CONCAT(p.zip, '.zip') LIMIT 1), 0) AS downloads,
IF(rpv.visits IS NULL, 0, rpv.visits) AS visits,
p.game_release_date,
(SELECT COUNT(*) FROM rip_vgm WHERE pack_id = p.id) AS tracks,
p.zip,
p.size,
pi.filename AS image,
p.url,
p.rating,
p.num_ratings,
FLOOR(p.rating * 2) * 5 AS stars,
(SELECT GROUP_CONCAT(CONCAT(REPEAT('★', pr.rating), REPEAT('☆', 5-pr.rating), ' ', pru.username) SEPARATOR '
') AS rating_users FROM rip_pack_ratings pr INNER JOIN phpbb3_users pru ON pru.user_id = pr.phpbb_user_id WHERE pr.topic_id = p.topic_id) AS rating_users
FROM rip_packs p
LEFT JOIN rip_pack_visits rpv ON rpv.topic_id = p.topic_id
LEFT JOIN rip_pack_images pi ON pi.pack_id = p.id AND pi.order = 1
INNER JOIN rip_pack_publishers pp ON pp.pack_id = p.id AND pp.company_id = '918'
WHERE p.name LIKE 'D%'
GROUP BY p.id
ORDER BY weighted_rating DESC, rating DESC, num_ratings DESC
LIMIT 0,21" details
Exception Object
(
[message:protected] => MySQL error: Disk full (/tmp/#sql_340924_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") "SELECT SQL_CALC_FOUND_ROWS
p.id,
p.name AS title,
DATE_FORMAT(p.updated, '%d.%m.%Y') AS updated,
DATE_FORMAT(p.released, '%d.%m.%Y') AS released,
COALESCE((SELECT downloads FROM download_counts WHERE file = CONCAT(p.zip, '.zip') LIMIT 1), 0) AS downloads,
IF(rpv.visits IS NULL, 0, rpv.visits) AS visits,
p.game_release_date,
(SELECT COUNT(*) FROM rip_vgm WHERE pack_id = p.id) AS tracks,
p.zip,
p.size,
pi.filename AS image,
p.url,
p.rating,
p.num_ratings,
FLOOR(p.rating * 2) * 5 AS stars,
(SELECT GROUP_CONCAT(CONCAT(REPEAT('★', pr.rating), REPEAT('☆', 5-pr.rating), ' ', pru.username) SEPARATOR '
') AS rating_users FROM rip_pack_ratings pr INNER JOIN phpbb3_users pru ON pru.user_id = pr.phpbb_user_id WHERE pr.topic_id = p.topic_id) AS rating_users
FROM rip_packs p
LEFT JOIN rip_pack_visits rpv ON rpv.topic_id = p.topic_id
LEFT JOIN rip_pack_images pi ON pi.pack_id = p.id AND pi.order = 1
INNER JOIN rip_pack_publishers pp ON pp.pack_id = p.id AND pp.company_id = '918'
WHERE p.name LIKE 'D%'
GROUP BY p.id
ORDER BY weighted_rating DESC, rating DESC, num_ratings DESC
LIMIT 0,21"
[string:Exception:private] =>
[code:protected] => 0
[file:protected] => /home/vgmrips/public_html/packs/include/MyMySQLi.php
[line:protected] => 54
[trace:Exception:private] => Array
(
[0] => Array
(
[file] => /home/vgmrips/public_html/packs/include/PackModel.php
[line] => 104
[function] => query
[class] => MyMySQLi
[type] => ->
[args] => Array
(
[0] => SELECT SQL_CALC_FOUND_ROWS
p.id,
p.name AS title,
DATE_FORMAT(p.updated, '%d.%m.%Y') AS updated,
DATE_FORMAT(p.released, '%d.%m.%Y') AS released,
COALESCE((SELECT downloads FROM download_counts WHERE file = CONCAT(p.zip, '.zip') LIMIT 1), 0) AS downloads,
IF(rpv.visits IS NULL, 0, rpv.visits) AS visits,
p.game_release_date,
(SELECT COUNT(*) FROM rip_vgm WHERE pack_id = p.id) AS tracks,
p.zip,
p.size,
pi.filename AS image,
p.url,
p.rating,
p.num_ratings,
FLOOR(p.rating * 2) * 5 AS stars,
(SELECT GROUP_CONCAT(CONCAT(REPEAT('★', pr.rating), REPEAT('☆', 5-pr.rating), ' ', pru.username) SEPARATOR '
') AS rating_users FROM rip_pack_ratings pr INNER JOIN phpbb3_users pru ON pru.user_id = pr.phpbb_user_id WHERE pr.topic_id = p.topic_id) AS rating_users
FROM rip_packs p
LEFT JOIN rip_pack_visits rpv ON rpv.topic_id = p.topic_id
LEFT JOIN rip_pack_images pi ON pi.pack_id = p.id AND pi.order = 1
INNER JOIN rip_pack_publishers pp ON pp.pack_id = p.id AND pp.company_id = '918'
WHERE p.name LIKE 'D%'
GROUP BY p.id
ORDER BY weighted_rating DESC, rating DESC, num_ratings DESC
LIMIT 0,21
)
)
[1] => Array
(
[file] => /home/vgmrips/public_html/packs/include/functions.php
[line] => 109
[function] => getResults
[class] => PackModel
[type] => ->
[args] => Array
(
[0] => Array
(
[limit] => 20
[offset] => 0
[order_by] => weighted_rating DESC, rating DESC, num_ratings
[order] => desc
[publisher_id] => 918
[page] => 0
[letter] => D
)
)
)
[2] => Array
(
[file] => /home/vgmrips/public_html/packs/pages/company.php
[line] => 26
[function] => listPacks
[args] => Array
(
[0] => companyPacks.mustache
[1] => Array
(
[order_by] => weighted_rating DESC, rating DESC, num_ratings
[publisher_id] => 918
[page] => 0
[letter] => D
)
[2] => Array
(
[company] => Array
(
[id] => 918
[url] => taito-romstar
[name] => Taito / Romstar
)
[action] => published
)
)
)
[3] => Array
(
[file] => /home/vgmrips/public_html/packs/index.php
[line] => 97
[args] => Array
(
[0] => /home/vgmrips/public_html/packs/pages/company.php
)
[function] => include
)
)
[previous:Exception:private] =>
)