While opening or restoring a QuickBooks for Mac backup file you may receive an Error_No such table: Schema History.
Intuit reports that the cause of this Error is presently unknown and is currently under investigation.
Intuit recommends two (2) possible solutions for this problem. In some cases the first solution may solve your problem; however, in some cases you may need to proceed from the first to the second solution to resolve the issue. You should perform the solutions in the order shown.
Recommended Solution 1: Repair Mac Disk Permissions
Many things you install or create in Mac also create a small package receipt file which is kept in /Library/Receipts/ as files with an extension “.bom”. These files contain a list of the proper permissions for each file. When you verify or repair disk permissions in Mac the Disk Utility reviews each of the .bom files and compares that list to the actual permissions for each file listed. If the permissions differ, Disk Utility reports the difference and then corrects them if you have selected the Repair Disk Permissions option.
You may be able to fix the QuickBooks for Mac Schema History (No such table) Error by repairing disk permissions. Follow these steps to attempt this repair:
- Close QuickBooks for Mac.
- Click the Finder icon.
- Open the Mac Applications folder.
- Open the Utilities folder.
- Open Disk Utilities.
- Select the Repair Disk Permissions options check-box.
- Restart your Mac computer.
- Open QuickBooks and
- Look for a Company file in the Trash folder.
- Open this Company file (It should be a good copy of the file you were working on when the error happened.)
If you still encounter the error, try solution 2 below.
Recommended Solution 2: Restore a recent backup
If Recommended Solution 1 doesn't work, your company file may be damaged and it will be necessary to restore a recent backup and re-enter any changes since the restored backup.