Menu

#246 Error adding new admin user

v1.0_(example)
open
nobody
5
2019-07-29
2019-07-29
No

There is a problem with adding a new user to the admin side of the program.
There was a change in the database to add usr_showSince. But the code was not updated to add the current date to the insert. Or at least any date.

So I added

    $showSince = date("Y-m-d");

    $sSQL = "INSERT INTO user_usr (usr_per_ID, usr_Password, usr_NeedPasswordChange, usr_LastLogin, usr_AddRecords, usr_EditRecords, usr_DeleteRecords, usr_MenuOptions, usr_ManageGroups, usr_Finance, usr_Notes, usr_Communication, usr_Admin, usr_Style, usr_SearchLimit, usr_showSince, usr_defaultFY, usr_UserName, usr_EditSelf, usr_Canvasser) VALUES (" . $iPersonID . ",'" . md5($sDefault_Pass) . "',1,'" . date("Y-m-d H:i:s") . "', " . $AddRecords . ", " . $EditRecords . ", " . $DeleteRecords . ", " . $MenuOptions . ", " . $ManageGroups . ", " . $Finance . ", " . $Notes . ", " . $Communication . ", " . $Admin . ", '" . $Style . "', 10,". $showSince ."," . $defaultFY . ",\"" . $sUserName . "\"," . $EditSelf . "," . $Canvasser . ")";

This fixed the issue. I will try to do a git pull request soon.

Discussion


Log in to post a comment.