Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Change A Location Code Issue
09-08-2017, 11:40 PM, (This post was last modified: 09-08-2017, 11:48 PM by VortecCPI.)
#1
Change A Location Code Issue
When changing a Location Code (in Utilities section ) the LocationsUsers table is not updated so the change process seems to be incomplete.

I had to change the LocCode in the LocationUsers table manually.
I added the following code to Z_ChangeLocationCode.php at line 236:

echo '<br />' . _('Changing user location records');
$sql = "UPDATE locationusers SET loccode='" . $_POST['NewLocationID'] . "' WHERE loccode='" . $_POST['OldLocationID'] . "'";
$ErrMsg = _('The SQL to update users records failed');
$result = DB_query($sql,$ErrMsg,$DbgMsg,true);
echo ' ... ' . _('completed');
https://www.linkedin.com/in/eclipsepaulbecker
Reply
09-09-2017, 03:47 AM, (This post was last modified: 09-09-2017, 04:04 AM by TurboPT.)
#2
RE: Change A Location Code Issue
Thanks for that update, Paul.

Missing table update change committed to SVN
Reply
09-09-2017, 05:30 AM,
#3
RE: Change A Location Code Issue
You are very welcome my friend.
https://www.linkedin.com/in/eclipsepaulbecker
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)