[Help] Dmn CMS can't register or log in.

[marccus]

When i register i got this error. I try also create account using editor and try to log in website still can't log in.

 

[GameMoiRa]

Open application/logs/database_error_log_2020-04-21.txt and send your error log here.

 

[marccus]

Open application/logs/database_error_log_2020-04-21.txt and send your error log here.

exception 'PDOException' with message 'SQLSTATE[22018]: [Microsoft][SQL Server Native Client 10.0][SQL Server]Conversion failed when converting the varchar value 'us' to data type int.' in C:\xampp_5.6\htdocs\application\libraries\lib.db.php:0
Stack trace:
#0 C:\xampp_5.6\htdocs\application\libraries\lib.db.php(0): PDOStatement->execute()
#1 C:\xampp_5.6\htdocs\application\models\model.account.php(0): db->execute()
#2 C:\xampp_5.6\htdocs\application\models\model.account.php(0): Maccount->update_last_login()
#3 C:\xampp_5.6\htdocs\application\controllers\controller.ajax.php(0): Maccount->login_user()
#4 C:\xampp_5.6\htdocs\system\router.class.php(0): ajax->login()
#5 C:\xampp_5.6\htdocs\system\dmn.php(0): router->route()
#6 C:\xampp_5.6\htdocs\index.php(44): require_once('C:\\xampp_5.6\\ht...')
#7 {main}
================================================================================
exception 'PDOException' with message 'SQLSTATE[22018]: [Microsoft][SQL Server Native Client 10.0][SQL Server]Conversion failed when converting the varchar value 'us' to data type int.' in C:\xampp_5.6\htdocs\application\libraries\lib.db.php:0
Stack trace:
#0 C:\xampp_5.6\htdocs\application\libraries\lib.db.php(0): PDOStatement->execute()
#1 C:\xampp_5.6\htdocs\application\models\model.account.php(0): db->execute()
#2 C:\xampp_5.6\htdocs\application\models\model.account.php(0): Maccount->create_account()
#3 C:\xampp_5.6\htdocs\application\controllers\controller.registration.php(0): Maccount->prepare_account()
#4 C:\xampp_5.6\htdocs\system\router.class.php(0): registration->create_account()
#5 C:\xampp_5.6\htdocs\system\dmn.php(0): router->route()
#6 C:\xampp_5.6\htdocs\index.php(44): require_once('C:\\xampp_5.6\\ht...')
#7 {main}
================================================================================
exception 'PDOException' with message 'SQLSTATE[22018]: [Microsoft][SQL Server Native Client 10.0][SQL Server]Conversion failed when converting the varchar value 'us' to data type int.' in C:\xampp_5.6\htdocs\application\libraries\lib.db.php:0
Stack trace:
#0 C:\xampp_5.6\htdocs\application\libraries\lib.db.php(0): PDOStatement->execute()
#1 C:\xampp_5.6\htdocs\application\models\model.account.php(0): db->execute()
#2 C:\xampp_5.6\htdocs\application\models\model.account.php(0): Maccount->create_account()
#3 C:\xampp_5.6\htdocs\application\controllers\controller.registration.php(0): Maccount->prepare_account()
#4 C:\xampp_5.6\htdocs\system\router.class.php(0): registration->create_account()
#5 C:\xampp_5.6\htdocs\system\dmn.php(0): router->route()
#6 C:\xampp_5.6\htdocs\index.php(44): require_once('C:\\xampp_5.6\\ht...')
#7 {main}
================================================================================
exception 'PDOException' with message 'SQLSTATE[22018]: [Microsoft][SQL Server Native Client 10.0][SQL Server]Conversion failed when converting the varchar value 'us' to data type int.' in C:\xampp_5.6\htdocs\application\libraries\lib.db.php:0
Stack trace:
#0 C:\xampp_5.6\htdocs\application\libraries\lib.db.php(0): PDOStatement->execute()
#1 C:\xampp_5.6\htdocs\application\models\model.account.php(0): db->execute()
#2 C:\xampp_5.6\htdocs\application\models\model.account.php(0): Maccount->create_account()
#3 C:\xampp_5.6\htdocs\application\controllers\controller.registration.php(0): Maccount->prepare_account()
#4 C:\xampp_5.6\htdocs\system\router.class.php(0): registration->create_account()
#5 C:\xampp_5.6\htdocs\system\dmn.php(0): router->route()
#6 C:\xampp_5.6\htdocs\index.php(44): require_once('C:\\xampp_5.6\\ht...')
#7 {main}
================================================================================
exception 'PDOException' with message 'SQLSTATE[22018]: [Microsoft][SQL Server Native Client 10.0][SQL Server]Conversion failed when converting the varchar value 'us' to data type int.' in C:\xampp_5.6\htdocs\application\libraries\lib.db.php:0
Stack trace:
#0 C:\xampp_5.6\htdocs\application\libraries\lib.db.php(0): PDOStatement->execute()
#1 C:\xampp_5.6\htdocs\application\models\model.account.php(0): db->execute()
#2 C:\xampp_5.6\htdocs\application\models\model.account.php(0): Maccount->create_account()
#3 C:\xampp_5.6\htdocs\application\controllers\controller.registration.php(0): Maccount->prepare_account()
#4 C:\xampp_5.6\htdocs\system\router.class.php(0): registration->create_account()
#5 C:\xampp_5.6\htdocs\system\dmn.php(0): router->route()
#6 C:\xampp_5.6\htdocs\index.php(44): require_once('C:\\xampp_5.6\\ht...')
#7 {main}
================================================================================
exception 'PDOException' with message 'SQLSTATE[22018]: [Microsoft][SQL Server Native Client 10.0][SQL Server]Conversion failed when converting the varchar value 'us' to data type int.' in C:\xampp_5.6\htdocs\application\libraries\lib.db.php:0
Stack trace:
#0 C:\xampp_5.6\htdocs\application\libraries\lib.db.php(0): PDOStatement->execute()
#1 C:\xampp_5.6\htdocs\application\models\model.account.php(0): db->execute()
#2 C:\xampp_5.6\htdocs\application\models\model.account.php(0): Maccount->create_account()
#3 C:\xampp_5.6\htdocs\application\controllers\controller.registration.php(0): Maccount->prepare_account()
#4 C:\xampp_5.6\htdocs\system\router.class.php(0): registration->create_account()
#5 C:\xampp_5.6\htdocs\system\dmn.php(0): router->route()
#6 C:\xampp_5.6\htdocs\index.php(44): require_once('C:\\xampp_5.6\\ht...')
#7 {main}
================================================================================
exception 'PDOException' with message 'SQLSTATE[22018]: [Microsoft][SQL Server Native Client 10.0][SQL Server]Conversion failed when converting the varchar value 'us' to data type int.' in C:\xampp_5.6\htdocs\application\libraries\lib.db.php:0
Stack trace:
#0 C:\xampp_5.6\htdocs\application\libraries\lib.db.php(0): PDOStatement->execute()
#1 C:\xampp_5.6\htdocs\application\models\model.account.php(0): db->execute()
#2 C:\xampp_5.6\htdocs\application\models\model.account.php(0): Maccount->create_account()
#3 C:\xampp_5.6\htdocs\application\controllers\controller.registration.php(0): Maccount->prepare_account()
#4 C:\xampp_5.6\htdocs\system\router.class.php(0): registration->create_account()
#5 C:\xampp_5.6\htdocs\system\dmn.php(0): router->route()
#6 C:\xampp_5.6\htdocs\index.php(44): require_once('C:\\xampp_5.6\\ht...')
#7 {main}
================================================================================

 

[crew]

Following error "Conversion failed when converting the varchar value 'us' to data type int.' in C:\xampp_5.6\htdocs\application\libraries\lib.db.php:0 "

try to use SQL querry like this ->

UPDATE [MuOnline].[dbo].[MEMB_INFO]set country = 'us'where memb_name = 'test'

 

[cMu]

Following error "Conversion failed when converting the varchar value 'us' to data type int.' in C:\xampp_5.6\htdocs\application\libraries\lib.db.php:0 "

try to use SQL querry like this ->

UPDATE [MuOnline].[dbo].[MEMB_INFO]set country = 'us'where memb_name = 'test'

what? "converting the varchar value 'us' to data type int" he needs to edit the data type of column COUNTRY to allow text. try click right click on table memb_info > design > search for Country > change data type to varchar(10) and its should be fine.