adamjedgar Posted May 1, 2017 Share Posted May 1, 2017 (edited) hi guys, i am unable to add users from within phpmyadmin when logging in as the whmcs admin user i created. I cant remember exactly, however, i think that from a cpanel account that i have with a hosting company, users cannot be added from within phpmyadmin anymore. is that the case here...or have i done something wrong when i setup whmcs on my vps? i ask this question because i am experiencing an http error 500 and cannot log into whmcs admin area at the moment and the issues appears to be partly related to sql mode variable "NO_AUTO_CREATE_USER" I dont plan on trying to fix the problem by creating or deleting users...but i wondered if they are in any way related? kind regards, Adam Edited May 1, 2017 by adamjedgar 0 Quote Link to comment Share on other sites More sharing options...
WHMCS Support Manager WHMCS John Posted May 5, 2017 WHMCS Support Manager Share Posted May 5, 2017 Hi, The NO_AUTO_CREATE_USER setting in your MySQL server configuration refers to creating users to access your MySQL server: https://dev.mysql.com/doc/refman/5.7/en/adding-users.html It is not related to inserting records into a table (which is the process for creating admins/clients for use by the WHMCS software). A 500 Internal Server Error might be indicative of a PHP Fatal Error. You can debug that without needing to access the WHMCS Admin area, please refer to the second half of this guide for details how: http://help.whmcs.com/m/64804/l/679701-how-to-resolve-an-http-500-error-after-update 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.