Exception caught: MySQL error: Disk full (/tmp/#sql_340924_2.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_composers pcp ON pcp.pack_id = p.id AND pcp.composer_id = '2020'
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_2.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_composers pcp ON pcp.pack_id = p.id AND pcp.composer_id = '2020'
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_composers pcp ON pcp.pack_id = p.id AND pcp.composer_id = '2020'
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
[composer_id] => 2020
[page] => 0
)
)
)
[2] => Array
(
[file] => /home/vgmrips/public_html/packs/pages/composer.php
[line] => 12
[function] => listPacks
[args] => Array
(
[0] => composer.mustache
[1] => Array
(
[composer_id] => 2020
[order_by] => weighted_rating DESC, rating DESC, num_ratings
[page] => 0
)
[2] => Array
(
[composer] => Array
(
[id] => 2020
[url] => karsten-obarski
[name] =>
[name_jp] =>
[name_en] => Karsten Obarski
[alias_of] =>
[alias_type] =>
[alias_comment] =>
[from] =>
[birth_date] =>
[death_date] =>
[gender] =>
[website] =>
[vgmdb_id] =>
[gmb100_id] =>
[num_packs] => 1
)
)
)
)
[3] => Array
(
[file] => /home/vgmrips/public_html/packs/index.php
[line] => 97
[args] => Array
(
[0] => /home/vgmrips/public_html/packs/pages/composer.php
)
[function] => include
)
)
[previous:Exception:private] =>
)