3127: The INSERT INTO statement contains the following unknown field name: '<FieldName>'. Make sure you have typed the name correctly, and try the operation again.

Published: September 5, 2007


Last Updated: 2011-10-25

Applies To


When attempting to save changes made to Button names, Facilities Tab items, Rule settings or other entries you receive the following error:



Where <FieldName> is the name of a field in the database (e.g. 'TrackTime').





Upgrading a version 2.0x database directly to version 2.7x or 2.8x is not supported. You must upgrade the 2.0x database to 2.5x or 2.60 before using it with 2.7x and higher.


If you have upgraded using the correct procedure, or have not upgraded at all, there is a problem with your database. Although the original database is still accessible and functional, there is an unrepairable problem with one or more tables in the database. You must start from scratch with a new database.  The old database can be retained as an Archive in the event you need to run reports on older data.


  1. Move your master database.  This copy will be used as your Archive, allowing you to access your old data.
    1. Close Guard1 Plus.
    2. Open My Computer and navigate to C:\Program Files\Guard1 Plus (or C:\TimeKeeping Systems\Guard1 Plus if Windows Vista.)
    3. Right-click the file G1Master.g1p and select Cut. NOTE: depending on your Windows View settings, you may not be able to see the .g1p file extension. Choose the G1Master file with the large blue "1" icon.
    4. Paste the file to the folder C:\Program Files\Guard1 Plus\Archives (or C:\TimeKeeping Systems\Guard1 Plus\Archives if Windows Vista.)
    5. Right-click the file you just pasted and select Rename.
    6. Rename the file to "Archive of G1Master, DATE & prior.g1p" (where DATE is today's date.)
  2. Open Guard1 Plus. You will see a message stating "Now setting up master database...please wait."


Guard1 Plus has created a new, empty database. You will have to set up your Buttons and Facilities from scratch.  DO NOT restore your data from the old database - doing so will import the corrupt tables to your new database, causing the same problem with the new file.


See Guard1 Plus Data Maintenance for information on how to prevent database problems.




Fields not present in 2.01 schema added to the 2.50 Rule table:

FieldName (Type, Size)

SpecifyTourOrder (Yes/No, 1)

TrackTime (Yes/No , 1)

TrackTimeMin (Integer, 2)

TrackTimeMax (Integer, 2)












Copyright © TimeKeeping Systems, Inc.