Hello, I recently installed the Deck app which worked great, but I entered one time a date that was not real on a card (I don’t know how it let me do this btw) and since then the app sends errors each 15 minutes and I don’t know how I could get rid of it… I tried to uninstall the app but it does not fix the broken database entry.
Here is the error messages :
{"reqId":"0S21Yzi3xCEKZhBOTtfw","level":3,"time":"2024-01-28T15:00:03+00:00","remoteAddr":"","user":"--","app":"core","method":"","url":"--","message":"Error while running background job (class: OCA\\Deck\\Cron\\CardDescriptionActivity, arguments: )","userAgent":"--","version":"28.0.1.1","data":{"app":"core","exception":"{\"class\":\"Exception\",\"message\":\"Failed to parse time string (20232-01-15 07:00:00) at position 12 (0): Double time specification\",\"code\":0,\"file\":\"/var/www/html/lib/public/AppFramework/Db/Entity.php:126\",\"trace\":\"#0 /var/www/html/lib/public/AppFramework/Db/Entity.php(126): DateTime->__construct('20232-01-15 07:...')\\n#1 /var/www/html/lib/public/AppFramework/Db/Entity.php(167): OCP\\AppFramework\\Db\\Entity->setter('duedate', Array)\\n#2 /var/www/html/custom_apps/deck/lib/Db/RelationalEntity.php(147): OCP\\AppFramework\\Db\\Entity->__call('setDuedate', Array)\\n#3 /var/www/html/lib/public/AppFramework/Db/Entity.php(75): OCA\\Deck\\Db\\RelationalEntity->__call('setDuedate', Array)\\n#4 /var/www/html/lib/public/AppFramework/Db/QBMapper.php(321): OCP\\AppFramework\\Db\\Entity::fromRow(Array)\\n#5 /var/www/html/lib/public/AppFramework/Db/QBMapper.php(339): OCP\\AppFramework\\Db\\QBMapper->mapRowToEntity(Array)\\n#6 /var/www/html/custom_apps/deck/lib/Db/CardMapper.php(313): OCP\\AppFramework\\Db\\QBMapper->findEntities(Object(OC\\DB\\QueryBuilder\\QueryBuilder))\\n#7 /var/www/html/custom_apps/deck/lib/Cron/CardDescriptionActivity.php(50): OCA\\Deck\\Db\\CardMapper->findUnexposedDescriptionChances()\\n#8 /var/www/html/lib/public/BackgroundJob/Job.php(81): OCA\\Deck\\Cron\\CardDescriptionActivity->run(NULL)\\n#9 /var/www/html/lib/public/BackgroundJob/Job.php(67): OCP\\BackgroundJob\\Job->start(Object(OC\\BackgroundJob\\JobList))\\n#10 /var/www/html/cron.php(152): OCP\\BackgroundJob\\Job->execute(Object(OC\\BackgroundJob\\JobList), Object(OC\\Log))\\n#11 {main}\"}"},"id":"65b66dd987bbe"}
I also executed the occ files:scan and cleanup which did not fix the issue.
Is there anything I can do ? Thanks a lot for your help.
occ maintenance:repair
- Repair MySQL collation
- Not a mysql database -> nothing to do
- Repair mime types
- Clean tags and favorites
- 0 tags of deleted users have been removed.
- 0 tags for delete files have been removed.
- 0 tag entries for deleted tags have been removed.
- 0 tags with no entries have been removed.
- Repair invalid shares
- Move .step file of updater to backup location
- Add move avatar background job
- Add background job
- Add preview cleanup background jobs
- Migrate oauth2_clients table to nextcloud schema
- Update the oauth2_access_tokens table schema.
- Update the oauth2_clients table schema.
- Delete clients (and their related access tokens) with the redirect_uri starting with oc:// or ending with *
- Fix potential broken mount points
- No mounts updated
- Repair language codes
- Add log rotate job
- Clear frontend caches
- Image cache cleared
- JS cache cleared
- Clear every generated avatar
- Add preview background cleanup job
- Queue a one-time job to cleanup old backups of the updater
- Cleanup invalid photocache files for carddav
- Add background job to cleanup login flow v2 tokens
- Remove potentially over exposing share links
- No need to remove link shares.
- Clear access cache of projects
- Reset generated avatar flag
- Keep legacy encryption enabled
- Check encryption key format
- Remove old dashboard app config data
- Add job to cleanup the bruteforce entries
- Queue a one-time job to check for user uploaded certificates
- Repair DAV shares
- Add background job to set the lookup server share state for users
- Add token cleanup job
- Clean up abandoned apps
- Add possibly missing system config
- Add AI tasks cleanup job
- Queue a job to generate metadata
- Upgrading Circles App
- Fix component of birthday calendars
- 1 birthday calendars updated.
- Regenerating birthday calendars to use new icons and fix old birthday events without year
- Adding background jobs to regenerate birthday calendar
- Fix broken values of calendar objects
0 [->--------------------------]
- Registering building of calendar search index as background job
- Add background job
- Register building of social profile search index as background job
- Add background job
- Registering background jobs to update cache for webcal calendars
- Added 0 background jobs to update webcal calendars
- Registering building of calendar reminder index as background job
- Add background job
- Clean up orphan event and contact data
- 0 events without a calendar have been cleaned up
- 0 properties without an events have been cleaned up
- 0 changes without a calendar have been cleaned up
- 0 cached events without a calendar subscription have been cleaned up
- 0 changes without a calendar subscription have been cleaned up
- 0 contacts without an addressbook have been cleaned up
- 0 properties without a contact have been cleaned up
- 0 changes without an addressbook have been cleaned up
- Remove activity entries of private events
- Removed 0 activity entries
- Clean up old calendar subscriptions from deleted users that were not cleaned-up
0 [----->----------------------]
- 0 calendar subscriptions without an user have been cleaned up
- Remove invalid object properties
- 0 invalid object properties removed.
- Copy default images to the app data directory
- Icon external.svg already exists
- Icon external-dark.svg already exists
- Icon settings.svg already exists
- Icon settings-dark.svg already exists
- Fix the share type of guest shares when migrating from ownCloud
- Copy the share password into the dedicated column
- Set existing shares as accepted
- Clean up meta table
- Show a hint about the new editor to existing users
- Update OAuth token expiration times
- Repair Passwords Database Objects
- Checking 0 tag revisions
0 [--------->------------------]
- Fixed 0 tag revisions
- Checking 2 folder revisions
2/2 [============================] 100%
- Fixed 0 folder revisions
- Checking 2 password revisions
2/2 [============================] 100%
- Fixed 0 password revisions
- Checking 0 tag models
0 [-------------------->-------]
- Fixed 0 tag models
- Checking 1 folder models
1/1 [============================] 100%
- Fixed 0 folder models
- Checking 2 password models
2/2 [============================] 100%
- Fixed 0 password models
- Checking 0 password tag relations
0 [--->------------------------]
- Fixed 0 password tag relations
- Checking 0 shares
0 [------->--------------------]
- Fixed 0 shares
- Separate user configured providers internal name and title. Also removes old unnecessary user config.
- Set default group in each provider
- Migrate custom providers to one config key
- Move telegram config to comman providers
- Create help command
- Invalidate access cache for projects conversation provider
- Cache the user display names
- Switches from default updater server to the customer one if a valid subscription is available
- Send an admin notification if monthly report is disabled
- Force-reset all Text sessions before Yjs migration
- Initialize migration of background images from dashboard to theming app
- Add background job to check for backup codes
- Insert UUIDFix background job for user and group in batches
- Remove deprecated refresh time markers for LDAP user records
- Populating added database structures for workflows
The built-in database repair tool is for MySQL and you are using a different database. What are you using? Maybe see if there is a database repair for what you are using?
I installed the nextcloud app pgadmin, connected to a new server with those credentials and searched the keyword deck_cards. I found the table, right click → view-edit data and edited the wrong value. Once done, I clicked on the little save button at the top of the data edit window and the issue is now gone. Thanks a lot for all your responses !