Post Reply 
 
Thread Rating:
  • 0 Votes - 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.)
Post: #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
Find all posts by this user
Quote this message in a reply
09-09-2017, 03:47 AM (This post was last modified: 09-09-2017 04:04 AM by TurboPT.)
Post: #2
RE: Change A Location Code Issue
Thanks for that update, Paul.

Missing table update change committed to SVN
Find all posts by this user
Quote this message in a reply
09-09-2017, 05:30 AM
Post: #3
RE: Change A Location Code Issue
You are very welcome my friend.

https://www.linkedin.com/in/eclipsepaulbecker
Find all posts by this user
Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)