| User Error: Query Error:Unknown column 'm.total_view' in 'ORDER BY' - include/library/phpfox/error/error.class.php (95) |
| 1 | include/library/phpfox/error/error.class.php : 95 | trigger_error("Query Error:Unknown column 'm.total_view' in 'ORDER BY'", 256) |
| 2 | include/library/phpfox/database/driver/mysql.class.php : 187 | Phpfox_Error::trigger("Query Error:Unknown column 'm.total_view' in 'ORDER BY'", 256) |
| 3 | include/library/phpfox/database/driver/mysql.class.php : 577 | Phpfox_Database_Driver_Mysql->query("SELECT lik.like_id AS is_liked, m.*, u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id
FROM phpfox_music_album AS m
LEFT JOIN phpfox_like AS lik
ON(lik.type_id = 'music_album' AND lik.item_id = m.album_id AND lik.user_id = 0)
JOIN phpfox_user AS u
ON(u.user_id = m.user_id)
WHERE m.view_id = 0 AND m.privacy IN(0)
ORDER BY m.total_view DESC
LIMIT 10
/* OO Query */", {Mysqli}) |
| 4 | include/library/phpfox/database/dba.class.php : 126 | Phpfox_Database_Driver_Mysql->_getRows("SELECT lik.like_id AS is_liked, m.*, u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id
FROM phpfox_music_album AS m
LEFT JOIN phpfox_like AS lik
ON(lik.type_id = 'music_album' AND lik.item_id = m.album_id AND lik.user_id = 0)
JOIN phpfox_user AS u
ON(u.user_id = m.user_id)
WHERE m.view_id = 0 AND m.privacy IN(0)
ORDER BY m.total_view DESC
LIMIT 10
/* OO Query */", TRUE, {Mysqli}) |
| 5 | include/library/phpfox/database/dba.class.php : 560 | Phpfox_Database_Dba->getSlaveRows("SELECT lik.like_id AS is_liked, m.*, u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id
FROM phpfox_music_album AS m
LEFT JOIN phpfox_like AS lik
ON(lik.type_id = 'music_album' AND lik.item_id = m.album_id AND lik.user_id = 0)
JOIN phpfox_user AS u
ON(u.user_id = m.user_id)
WHERE m.view_id = 0 AND m.privacy IN(0)
ORDER BY m.total_view DESC
LIMIT 10
/* OO Query */") |
| 6 | include/library/phpfox/search/browse.class.php : 174 | Phpfox_Database_Dba->execute("getSlaveRows") |
| 7 | module/music/include/component/controller/browse/album.class.php : 100 | Phpfox_Search_Browse->execute() |
| 8 | include/library/phpfox/module/module.class.php : 843 | Music_Component_Controller_Browse_Album->process() |
| 9 | include/library/phpfox/module/module.class.php : 424 | Phpfox_Module->getComponent("music.browse.album", Array(1), "controller") |
| 10 | include/library/phpfox/phpfox/phpfox.class.php : 1297 | Phpfox_Module->getController() |
| 11 | index.php : 42 | Phpfox::run() |