Hello guys, im getting this error all over the place ... I installed dmncms with great success and now when i enabled the registration settings and e.t.c. i cannot do nothing...
I get this error:
ELECT TOP 1 c.AccountId, c.Name, c.cLevel, c.Class, c.MapNumber, c.Ctlcode , a.GameIDC, m.IP, m.ConnectStat, ml.MASTER_LEVEL, 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 T_MasterLevelSystem AS ml ON (c.Name Collate Database_Default = ml.CHAR_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) WHERE c.Ctlcode NOT IN (8,16,32) GROUP BY c.AccountId, c.Name, c.cLevel, c.Class, c.MapNumber, c.Ctlcode , a.GameIDC, m.IP, m.ConnectStat, ml.MASTER_LEVEL, r.Resets, g.Grand_Resets ORDER BY g.Grand_Resets DESC, r.Resets DESC, ml.MASTER_LEVEL DESC,c.cLevel DESC================================================================================PDOException: SQLSTATE[42S02]: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Invalid object name 'T_MasterLevelSystem'. in C:\xampp\htdocs\application\libraries\lib.db.php:98Stack trace:#0 C:\xampp\htdocs\application\libraries\lib.db.php(98): PDO->query('SELECT TOP 1 c....')#1 C:\xampp\htdocs\application\models\model.rankings.php(117): db->query('SELECT TOP 1 c....')#2 C:\xampp\htdocs\application\models\model.rankings.php(37): Mrankings->load_player_rankings('DEFAULT', Array, Array, 1)#3 C:\xampp\htdocs\application\controllers\controller.rankings.php(137): Mrankings->get_ranking_data('players', 'DEFAULT', Array, Array, 1)#4 C:\xampp\htdocs\system\router.class.php(80): rankings->top_player()#5 C:\xampp\htdocs\system\dmn.php(25): router->route(Object(request))#6 C:\xampp\htdocs\index.php(33): require_once('C:\\xampp\\htdocs...')#7 {main}================================================================================
I readed somewhere that i need to change something but i dont know how and what...
Please guys!
I get this error:
Sql sintax error. Please check application/logs/database_error_log_2020-10-03.txt for errors.
And also this is the error msg in the log file:
ELECT TOP 1 c.AccountId, c.Name, c.cLevel, c.Class, c.MapNumber, c.Ctlcode , a.GameIDC, m.IP, m.ConnectStat, ml.MASTER_LEVEL, 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 T_MasterLevelSystem AS ml ON (c.Name Collate Database_Default = ml.CHAR_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) WHERE c.Ctlcode NOT IN (8,16,32) GROUP BY c.AccountId, c.Name, c.cLevel, c.Class, c.MapNumber, c.Ctlcode , a.GameIDC, m.IP, m.ConnectStat, ml.MASTER_LEVEL, r.Resets, g.Grand_Resets ORDER BY g.Grand_Resets DESC, r.Resets DESC, ml.MASTER_LEVEL DESC,c.cLevel DESC================================================================================PDOException: SQLSTATE[42S02]: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Invalid object name 'T_MasterLevelSystem'. in C:\xampp\htdocs\application\libraries\lib.db.php:98Stack trace:#0 C:\xampp\htdocs\application\libraries\lib.db.php(98): PDO->query('SELECT TOP 1 c....')#1 C:\xampp\htdocs\application\models\model.rankings.php(117): db->query('SELECT TOP 1 c....')#2 C:\xampp\htdocs\application\models\model.rankings.php(37): Mrankings->load_player_rankings('DEFAULT', Array, Array, 1)#3 C:\xampp\htdocs\application\controllers\controller.rankings.php(137): Mrankings->get_ranking_data('players', 'DEFAULT', Array, Array, 1)#4 C:\xampp\htdocs\system\router.class.php(80): rankings->top_player()#5 C:\xampp\htdocs\system\dmn.php(25): router->route(Object(request))#6 C:\xampp\htdocs\index.php(33): require_once('C:\\xampp\\htdocs...')#7 {main}================================================================================
I readed somewhere that i need to change something but i dont know how and what...
Please guys!
