Hello, I had issues with my DB ( Important: Specify Database Backups Can Fail - #2 by Heryk ) so I decided to restore a previous version. However now I’m getting a new error message when authenticating in SP-7: {"exception": "ProgrammingError", "message": "1146", "data": "Table 'mycology.spuserpolic…

I finally got it to work… I’m not sure what fixed it. I had to restart from scratch! I deleted the mycology DB and the SP-7 docker instance (including the volumes) on my web server. Then I created a new backup file of mycology DB located on my computer and restored it on the server DB. And finally, …

PS. I created a new local dummy DB on SP-6. Then I made a backup of it and restored on my server DB. However, I’m still stuck with the same SP-7 error message… {"exception": "ProgrammingError", "message": "1146", "data": "Table 'mycology.spuserpolicy' doesn't exist", BTW, the table spuserpolicy i…

I read this post describing a similar “Table doesn’t exist” error message… Data Export for Webportal / Specify 7.7 Upgrade - Get Help - Specify Community Forum (specifysoftware.org) So I manually modify the DB AppVersion to 6.8.01 in the spversion table and redeployed SP-7. Unfortunately, it not so…

You run the container the first time. Then you have to restart it a second time for it to create that table.

[image] Upgrading to Specify 7.7+: HTTP 500 error Configuration & Installation If you are updating to Specify 7.7 or newer, Specify is supposed to create new tables related to the security and accounts features. If you encounter the following error upon updating to 7.9.3,…

Database SP-7 Error: Table doesn't exist!

Get Help

mcruz September 18, 2024, 9:37pm 6

Topic		Replies	Views
Upgrading to Specify 7.7+: HTTP 500 error Configuration & Installation Specify-7 , Members-only	1	346	February 22, 2023
Data Export for Webportal / Specify 7.7 Upgrade Get Help	9	526	February 22, 2023
Couldn't find 'Global Prefs'. Application will exit Get Help	2	197	April 10, 2024
Migrate from Specify 6 to 7 with Docker Configuration & Installation Specify-7	1	1139	August 1, 2023
Specify6 Wizard could not insert StorageTreeDef Get Help	5	214	January 31, 2024

Database SP-7 Error: Table doesn't exist!

Related topics