Signup for Account not working. - Printable Version +- Community Support for OpenDocMan (Deprecated) (https://forum.opendocman.com) +-- Forum: OpenDocMan Community Discussion (https://forum.opendocman.com/forum-5.html) +--- Forum: OpenDocMan Bug Reports (https://forum.opendocman.com/forum-8.html) +--- Thread: Signup for Account not working. (/thread-320.html) |
Signup for Account not working. - kedavis425 - 10-06-2010 this is a fresh install of the latest version. I originally had problems creating users and followed the thread fixing those bugs. However, I am still having problems with the Sign Up for an Account Link. I am getting the following error: Error in query: INSERT INTO odm_user (id, username, password, department, phone, Email,last_name, first_name) VALUES('', 'kyle', password('r4fbv'), '1' ,'217 5551212','[email protected]', 'smith', 'kyle' ). Incorrect integer value: '' for column 'id' at row 1 Any ideas? Thanks, Re: Signup for Account not working. - Stephen - 10-06-2010 Which version of MySQL are you using? I just tried that query on 5.1.44 and there were no issues. Re: Signup for Account not working. - kedavis425 - 10-06-2010 We are using version 5.1.51. I changed line 45 in signup.php to: Code: $query = "INSERT INTO {$GLOBALS['CONFIG']['db_prefix']}user (username, password, department, phone, Email,last_name, first_name) VALUES('". addslashes($_POST['username'])."', password('". addslashes(@$_REQUEST['password']) ."'), '" . addslashes($_REQUEST['department'])."' ,'" . addslashes($phonenumber) . "','". addslashes($_REQUEST['Email'])."', '" . addslashes($_REQUEST['last_name']) . "', '" . addslashes($_REQUEST['first_name']) . '\' )'; and it seems to work. Re: Signup for Account not working. - Stephen - 10-06-2010 Thanks for the info. Will add that to the current development version. Found a couple other instances of '' for ID as well. |