| User Error: Query Error:Unknown column 'l.total_view' in 'order clause' - include/library/phpfox/error/error.class.php (91) |
| 1 | include/library/phpfox/error/error.class.php : 91 | trigger_error("Query Error:Unknown column 'l.total_view' in 'order clause'", 256) |
| 2 | include/library/phpfox/database/driver/mysql.class.php : 187 | Phpfox_Error::trigger("Query Error:Unknown column 'l.total_view' in 'order clause'", 256) |
| 3 | include/library/phpfox/database/driver/mysql.class.php : 577 | Phpfox_Database_Driver_Mysql->query("SELECT mt.description_parsed AS description, l.*, 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.last_activity
FROM phpfox_marketplace AS l
JOIN phpfox_marketplace_text AS mt
ON(mt.listing_id = l.listing_id)
JOIN phpfox_user AS u
ON(u.user_id = l.user_id)
WHERE l.view_id = 0 AND l.privacy IN(0)
ORDER BY l.total_view DESC
LIMIT 12
/* OO Query */", Resource id #35) |
| 4 | include/library/phpfox/database/dba.class.php : 126 | Phpfox_Database_Driver_Mysql->_getRows("SELECT mt.description_parsed AS description, l.*, 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.last_activity
FROM phpfox_marketplace AS l
JOIN phpfox_marketplace_text AS mt
ON(mt.listing_id = l.listing_id)
JOIN phpfox_user AS u
ON(u.user_id = l.user_id)
WHERE l.view_id = 0 AND l.privacy IN(0)
ORDER BY l.total_view DESC
LIMIT 12
/* OO Query */", TRUE, Resource id #35) |
| 5 | include/library/phpfox/database/dba.class.php : 530 | Phpfox_Database_Dba->getSlaveRows("SELECT mt.description_parsed AS description, l.*, 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.last_activity
FROM phpfox_marketplace AS l
JOIN phpfox_marketplace_text AS mt
ON(mt.listing_id = l.listing_id)
JOIN phpfox_user AS u
ON(u.user_id = l.user_id)
WHERE l.view_id = 0 AND l.privacy IN(0)
ORDER BY l.total_view DESC
LIMIT 12
/* OO Query */") |
| 6 | include/library/phpfox/search/browse.class.php : 147 | Phpfox_Database_Dba->execute("getSlaveRows") |
| 7 | module/marketplace/include/component/controller/index.class.php : 220 | Phpfox_Search_Browse->execute() |
| 8 | include/library/phpfox/module/module.class.php : 794 | Marketplace_Component_Controller_Index->process() |
| 9 | include/library/phpfox/module/module.class.php : 400 | Phpfox_Module->getComponent("marketplace.index", Array(1), "controller") |
| 10 | include/library/phpfox/phpfox/phpfox.class.php : 1135 | Phpfox_Module->getController() |
| 11 | index.php : 42 | Phpfox::run() |