Index does not exist

1. Open the NewData folder (If customer is running 8.91, rename the Data folder, then change the NewData folder to Data and open Cyrious so it will update the tables. Then shut down Cyrious and the SSLIP. Then rename the Data folder to NewUpdatedData and the original Data folder back to Data)
2. Find the files for the particular table is missing the index
3. Copy the files ending in XGn and YGn files for those tables (where n is a number). These are the secondary index files.
4. Open the Data folder
5. Paste (Ctrl-V)
6. Rebuild that table using dbrebuild

1. Open DBBrowser to look at the Data
2. Open a second DBBrowser and create a temp alais looking at the NewData folder
3. Arrange the two applications so that they're side by side
4. Go through and look at each table to see which one from the live tables is missing the particular index the system was referring to
5. Once table(s) have been located, close each of the DBBrowsers
6. Open the Data folder and rename *.db and *.mb files (i.e Order Database.db becomes Order.db) for the table missing the indexes
7. Deleted the remaining indexes for that table
8. Go into the NewData folder and copy all table files that would replace the live tables files that had the index errors.
9. Open DBBrowser
10. Select SQL tab up top
11. Select the Advanced tab in the middle of the screen.
12. Run SQL below to transfer all records from the bad table to the new table.
13. Open application and test area that was causing problem to see if problem is resolved.
14. dbrebuild

INSERT INTO "[New Table]"
SELECT *
FROM "[Old Table]"