qkeypadzones: Field 'keypadzoneid' not found
Hint Ref: 020910150006
Hint Date: 15/10/2009
Problem: An installation in Hungary was having problems setting up the keypadzones on their site. After adding the zones when they tried to Save and Close the window the error qkeypadzones: Field 'keypadzoneid' not found appeared.
Also on the access TAB on the contract when clicking the Change Setting button a simlar error qaccesszones: Field 'keypadzone' not found also appeared.
The problem did not happen when the database was brough back locally.
Solution: In CONTROL PANEL - REGIONAL AND LANGUAGE OPTIONS click on the Customize or Customize This Format button. Go to the Sorting TAB and change the sort from Default to Technical. Click Apply then Click OK and finally click Apply a final time on the orignal screen. Closing Space Manager and opening it again should now have the problem resolved.
(Please Note: This Procedure can be destructive and should only be used by Advanced Users. RADical Systems (UK) Limited or its Partners cannot be held responsible, in anyway, for any consequence of using this or any other Database Function, Procedure or SQL command. Responsibility resides solely with the user.
IT IS HIGHLY RECOMMENDED THAT A FULL AND VALID SPACE MANAGER DATABASE BACKUP IS TAKEN AND VERIFIED AS VALID BEFORE MAKING ANY CHANGES TO THE DATABASE.)