geofbaum
commented
5 years ago After using the --form id option in sync to sync the rest of the apps, I went back to attempt to just do a regular sync which has produced a new error. This time it's saying that there is no such table in my database however I can still access the data from the table in question via pgAdmin, some python code, or javascript code.
[downloading] Journalier
[processing] Journalier
{ Error: no such table: account_1_form_5
at Database.get lastError [as lastError] (C:\Users\geoffrey\AppData\Local\Pr
ograms\Fulcrum\resources\app.asar\node_modules\minisqlite\dist\index.js:92:24)
at statement.getResults.results (C:\Users\geoffrey\AppData\Local\Programs\Fu
lcrum\resources\app.asar\node_modules\minisqlite\dist\cursor.js:133:45)
at Immediate.Statement.setImmediate (C:\Users\geoffrey\AppData\Local\Program
s\Fulcrum\resources\app.asar\node_modules\minisqlite\dist\index.js:171:7)
at runCallback (timers.js:651:20)
at tryOnImmediate (timers.js:624:5)
at processImmediate [as _immediateCallback] (timers.js:596:5) message: 'no
such table: account_1_form_5' }When I attempt to sync with --form 5 it appears to work and responds with a Synced in 0.463 seconds and no apparent updates to the actual form if I check via pgAdmin or another way to see the quantity of rows. Please also see the attached screen shot from pgAdmin.
zhm
My error is below, this has just happened as I went to sync my local database this morning with Fulcrum. Not sure what is exactly going as it was working last month when I did my sync. I only do a sync once in a while during the winter months because we don't use the app as often. The only thing that has changed since the last sync is the account change due to the price/plan changes. We technically didn't move up or down in terms of features as far as I know so I don't think that should be an issue. The other thing is that we had one large sync (100+ new entries) from one of our devices as one of them was left sitting without syncing to Fulcrum. The reason I bring that up is because as you can see in the code below before the error pops up it is working on the app "Journalier" which is the app that was last synced with the large amount of new entries.
Other than that, the PostgreSQL database hasn't been updated and as I mentioned there were no errors before the account change and the large sync from the one app. Struggling to decide whether or not I should do a clean sync to see if that fixes the issue but I wanted to post here to see if there was suggestion. If anything I will perform a backup of the database before performing the clean sync just in case something happens during the sync that would cause me to lose what is already backedup on the local database. Thanks in advance for any insight or help anyone might be able to provide.