marym Posted June 17, 2010 Share Posted June 17, 2010 When i try to login to the admin panel for the first time it doesn't take the username and password i think i created.. 1) is there a way to reset this? 2) is there a way to re-install so i can do this over again? 0 Quote Link to comment Share on other sites More sharing options...
marym Posted June 17, 2010 Author Share Posted June 17, 2010 I have reinstalled 3x already... no matter what user ID i put..and no matter what password it always gives me.. login failed... im getting really frustrated 0 Quote Link to comment Share on other sites More sharing options...
marym Posted June 17, 2010 Author Share Posted June 17, 2010 I have resolve my issue.. steps to resolve 1) go into my my.ini and remove the value of sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" to sql-mode="" 2) connect to my database i had created for billing via the mySQL CLI Client 3) trucate the table tbladmins 4) TRUNCATE tbladmins; INSERT INTO tbladmins (`roleid`, `username`, `password`, `firstname`, `lastname`, `email`, `template`) VALUES ( '1', 'admin', MD5('temp123'), 'Temp', 'User', 'temp@domain.com', 'v4' ); 5) restart MySQL and IIS After that i was able to login 0 Quote Link to comment Share on other sites More sharing options...
WHMCS Support Manager WHMCS John Posted June 21, 2010 WHMCS Support Manager Share Posted June 21, 2010 Yes, WHMCS requires MySQL strict mode to be disabled. 0 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.