Open
constants.php and change EVIRONMENT from
production to
development, then click shop again, post your error log here.
Code:
define('ENVIRONMENT', '[COLOR=#ff0000]development[/COLOR]');
BRO MY RANKING IS NOT WORKING I ALREADY ADDED SQL TABLE SETTINGS HERE IS ERROR LOG
SELECT TOP 10 c.AccountId, c.Name, c.cLevel, c.Class, c.MapNumber, c.Ctlcode , a.GameIDC, m.IP, m.ConnectStat, ml.mLevel, r.resets, g.grand_resets FROM Character AS c FULL JOIN AccountCharacter AS a ON (c.Name Collate Database_Default = a.GameIDC Collate Database_Default) FULL JOIN [MuOnline].dbo.[MEMB_STAT] AS m ON(c.AccountId Collate Database_Default = m.memb___id Collate Database_Default) INNER JOIN Character AS ml ON (c.Name Collate Database_Default = ml.Name Collate Database_Default) INNER JOIN Character AS r ON (c.Name Collate Database_Default = r.Name Collate Database_Default) INNER JOIN Character AS g ON (c.Name Collate Database_Default = g.Name Collate Database_Default) GROUP BY c.AccountId, c.Name, c.cLevel, c.Class, c.MapNumber, c.Ctlcode , a.GameIDC, m.IP, m.ConnectStat, ml.mLevel, r.resets, g.grand_resets ORDER BY g.grand_resets DESC, r.resets DESC, ml.mLevel DESC,c.cLevel DESC================================================================================exception 'PDOException' with message 'SQLSTATE[42S22]: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Invalid column name 'mLevel'.' in C:\inetpub\wwwroot\application\libraries\lib.db.php:0Stack trace:#0 C:\inetpub\wwwroot\application\libraries\lib.db.php(0): PDO->query()#1 C:\inetpub\wwwroot\application\models\model.rankings.php(0): db->query()#2 C:\inetpub\wwwroot\application\models\model.rankings.php(0): Mrankings->load_player_rankings()#3 C:\inetpub\wwwroot\application\controllers\controller.rankings.php(0): Mrankings->get_ranking_data()#4 C:\inetpub\wwwroot\system\router.class.php(0): rankings->load_ranking_data()#5 C:\inetpub\wwwroot\system\dmn.php(0): router->route()#6 C:\inetpub\wwwroot\index.php(44): require_once('C:\\inetpub\\wwwr...')#7 {main}================================================================================SELECT TOP 5 c.AccountId, c.Name, c.cLevel, c.Class, c.MapNumber, c.Ctlcode , a.GameIDC, m.IP, m.ConnectStat, ml.mLevel, r.resets, g.grand_resets FROM Character AS c FULL JOIN AccountCharacter AS a ON (c.Name Collate Database_Default = a.GameIDC Collate Database_Default) FULL JOIN [MuOnline].dbo.[MEMB_STAT] AS m ON(c.AccountId Collate Database_Default = m.memb___id Collate Database_Default) INNER JOIN Character AS ml ON (c.Name Collate Database_Default = ml.Name Collate Database_Default) INNER JOIN Character AS r ON (c.Name Collate Database_Default = r.Name Collate Database_Default) INNER JOIN Character AS g ON (c.Name Collate Database_Default = g.Name Collate Database_Default) GROUP BY c.AccountId, c.Name, c.cLevel, c.Class, c.MapNumber, c.Ctlcode , a.GameIDC, m.IP, m.ConnectStat, ml.mLevel, r.resets, g.grand_resets ORDER BY g.grand_resets DESC, r.resets DESC, ml.mLevel DESC,c.cLevel DESC================================================================================exception 'PDOException' with message 'SQLSTATE[42S22]: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Invalid column name 'mLevel'.' in C:\inetpub\wwwroot\application\libraries\lib.db.php:0Stack trace:#0 C:\inetpub\wwwroot\application\libraries\lib.db.php(0): PDO->query()#1 C:\inetpub\wwwroot\application\models\model.rankings.php(0): db->query()#2 C:\inetpub\wwwroot\application\models\model.rankings.php(0): Mrankings->load_player_rankings()#3 C:\inetpub\wwwroot\application\controllers\controller.rankings.php(0): Mrankings->get_ranking_data()#4 C:\inetpub\wwwroot\system\router.class.php(0): rankings->load_ranking_data()#5 C:\inetpub\wwwroot\system\dmn.php(0): router->route()#6 C:\inetpub\wwwroot\index.php(44): require_once('C:\\inetpub\\wwwr...')#7 {main}================================================================================SELECT TOP 10 c.AccountId, c.Name, c.cLevel, c.Class, c.MapNumber, c.Ctlcode , a.GameIDC, m.IP, m.ConnectStat, ml.mLevel, r.resets, g.grand_resets FROM Character AS c FULL JOIN AccountCharacter AS a ON (c.Name Collate Database_Default = a.GameIDC Collate Database_Default) FULL JOIN [MuOnline].dbo.[MEMB_STAT] AS m ON(c.AccountId Collate Database_Default = m.memb___id Collate Database_Default) INNER JOIN Character AS ml ON (c.Name Collate Database_Default = ml.Name Collate Database_Default) INNER JOIN Character AS r ON (c.Name Collate Database_Default = r.Name Collate Database_Default) INNER JOIN Character AS g ON (c.Name Collate Database_Default = g.Name Collate Database_Default) GROUP BY c.AccountId, c.Name, c.cLevel, c.Class, c.MapNumber, c.Ctlcode , a.GameIDC, m.IP, m.ConnectStat, ml.mLevel, r.resets, g.grand_resets ORDER BY g.grand_resets DESC, r.resets DESC, ml.mLevel DESC,c.cLevel DESC================================================================================exception 'PDOException' with message 'SQLSTATE[42S22]: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Invalid column name 'mLevel'.' in C:\inetpub\wwwroot\application\libraries\lib.db.php:0Stack trace:#0 C:\inetpub\wwwroot\application\libraries\lib.db.php(0): PDO->query()#1 C:\inetpub\wwwroot\application\models\model.rankings.php(0): db->query()#2 C:\inetpub\wwwroot\application\models\model.rankings.php(0): Mrankings->load_player_rankings()#3 C:\inetpub\wwwroot\application\controllers\controller.rankings.php(0): Mrankings->get_ranking_data()#4 C:\inetpub\wwwroot\system\router.class.php(0): rankings->load_ranking_data()#5 C:\inetpub\wwwroot\system\dmn.php(0): router->route()#6 C:\inetpub\wwwroot\index.php(44): require_once('C:\\inetpub\\wwwr...')#7 {main}================================================================================SELECT TOP 10 c.AccountId, c.Name, c.cLevel, c.Class, c.MapNumber, c.Ctlcode , a.GameIDC, m.IP, m.ConnectStat, ml.mLevel, r.resets, g.grand_resets FROM Character AS c FULL JOIN AccountCharacter AS a ON (c.Name Collate Database_Default = a.GameIDC Collate Database_Default) FULL JOIN [MuOnline].dbo.[MEMB_STAT] AS m ON(c.AccountId Collate Database_Default = m.memb___id Collate Database_Default) INNER JOIN Character AS ml ON (c.Name Collate Database_Default = ml.Name Collate Database_Default) INNER JOIN Character AS r ON (c.Name Collate Database_Default = r.Name Collate Database_Default) INNER JOIN Character AS g ON (c.Name Collate Database_Default = g.Name Collate Database_Default) GROUP BY c.AccountId, c.Name, c.cLevel, c.Class, c.MapNumber, c.Ctlcode , a.GameIDC, m.IP, m.ConnectStat, ml.mLevel, r.resets, g.grand_resets ORDER BY g.grand_resets DESC, r.resets DESC, ml.mLevel DESC,c.cLevel DESC================================================================================exception 'PDOException' with message 'SQLSTATE[42S22]: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Invalid column name 'mLevel'.' in C:\inetpub\wwwroot\application\libraries\lib.db.php:0Stack trace:#0 C:\inetpub\wwwroot\application\libraries\lib.db.php(0): PDO->query()#1 C:\inetpub\wwwroot\application\models\model.rankings.php(0): db->query()#2 C:\inetpub\wwwroot\application\models\model.rankings.php(0): Mrankings->load_player_rankings()#3 C:\inetpub\wwwroot\application\controllers\controller.rankings.php(0): Mrankings->get_ranking_data()#4 C:\inetpub\wwwroot\system\router.class.php(0): rankings->load_ranking_data()#5 C:\inetpub\wwwroot\system\dmn.php(0): router->route()#6 C:\inetpub\wwwroot\index.php(44): require_once('C:\\inetpub\\wwwr...')#7 {main}================================================================================SELECT TOP 10 c.AccountId, c.Name, c.cLevel, c.Class, c.MapNumber, c.Ctlcode , a.GameIDC, m.IP, m.ConnectStat, ml.mLevel, r.resets, g.grand_resets FROM Character AS c FULL JOIN AccountCharacter AS a ON (c.Name Collate Database_Default = a.GameIDC Collate Database_Default) FULL JOIN [MuOnline].dbo.[MEMB_STAT] AS m ON(c.AccountId Collate Database_Default = m.memb___id Collate Database_Default) INNER JOIN Character AS ml ON (c.Name Collate Database_Default = ml.Name Collate Database_Default) INNER JOIN Character AS r ON (c.Name Collate Database_Default = r.Name Collate Database_Default) INNER JOIN Character AS g ON (c.Name Collate Database_Default = g.Name Collate Database_Default) GROUP BY c.AccountId, c.Name, c.cLevel, c.Class, c.MapNumber, c.Ctlcode , a.GameIDC, m.IP, m.ConnectStat, ml.mLevel, r.resets, g.grand_resets ORDER BY g.grand_resets DESC, r.resets DESC, ml.mLevel DESC,c.cLevel DESC================================================================================exception 'PDOException' with message 'SQLSTATE[42S22]: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Invalid column name 'mLevel'.' in C:\inetpub\wwwroot\application\libraries\lib.db.php:0Stack trace:#0 C:\inetpub\wwwroot\application\libraries\lib.db.php(0): PDO->query()#1 C:\inetpub\wwwroot\application\models\model.rankings.php(0): db->query()#2 C:\inetpub\wwwroot\application\models\model.rankings.php(0): Mrankings->load_player_rankings()#3 C:\inetpub\wwwroot\application\controllers\controller.rankings.php(0): Mrankings->get_ranking_data()#4 C:\inetpub\wwwroot\system\router.class.php(0): rankings->load_ranking_data()#5 C:\inetpub\wwwroot\system\dmn.php(0): router->route()#6 C:\inetpub\wwwroot\index.php(44): require_once('C:\\inetpub\\wwwr...')#7 {main}================================================================================SELECT TOP 5 c.AccountId, c.Name, c.cLevel, c.Class, c.MapNumber, c.Ctlcode , a.GameIDC, m.IP, m.ConnectStat, ml.mLevel, r.resets, g.grand_resets FROM Character AS c FULL JOIN AccountCharacter AS a ON (c.Name Collate Database_Default = a.GameIDC Collate Database_Default) FULL JOIN [MuOnline].dbo.[MEMB_STAT] AS m ON(c.AccountId Collate Database_Default = m.memb___id Collate Database_Default) INNER JOIN Character AS ml ON (c.Name Collate Database_Default = ml.Name Collate Database_Default) INNER JOIN Character AS r ON (c.Name Collate Database_Default = r.Name Collate Database_Default) INNER JOIN Character AS g ON (c.Name Collate Database_Default = g.Name Collate Database_Default) GROUP BY c.AccountId, c.Name, c.cLevel, c.Class, c.MapNumber, c.Ctlcode , a.GameIDC, m.IP, m.ConnectStat, ml.mLevel, r.resets, g.grand_resets ORDER BY g.grand_resets DESC, r.resets DESC, ml.mLevel DESC,c.cLevel DESC================================================================================exception 'PDOException' with message 'SQLSTATE[42S22]: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Invalid column name 'mLevel'.' in C:\inetpub\wwwroot\application\libraries\lib.db.php:0Stack trace:#0 C:\inetpub\wwwroot\application\libraries\lib.db.php(0): PDO->query()#1 C:\inetpub\wwwroot\application\models\model.rankings.php(0): db->query()#2 C:\inetpub\wwwroot\application\models\model.rankings.php(0): Mrankings->load_player_rankings()#3 C:\inetpub\wwwroot\application\controllers\controller.rankings.php(0): Mrankings->get_ranking_data()#4 C:\inetpub\wwwroot\system\router.class.php(0): rankings->load_ranking_data()#5 C:\inetpub\wwwroot\system\dmn.php(0): router->route()#6 C:\inetpub\wwwroot\index.php(44): require_once('C:\\inetpub\\wwwr...')#7 {main}================================================================================
Open
constants.php and change EVIRONMENT from
production to
development, then click shop again, post your error log here.
Code:
define('ENVIRONMENT', '[COLOR=#ff0000]development[/COLOR]');
I CAN'T EVEN CLICK AN ITEM NOTHING APPERS I CLICK SWORD MANY TIME NOTHING REALLY APPEARS NO ERROR