NextCloud error: Data too long for column 'version' at row 1

[kgroot]

Which version of recognize are you using?

7.1.0

Enabled Modes

Face recognition

TensorFlow mode

Normal mode

Downstream App

other, please specify below

Which Nextcloud version do you have installed?

Nextcloud Hub 8 (29.0.4)

Which Operating system do you have installed?

Synology DS920+, DSM 7.2.1-69057 Update 5

Which database are you running Nextcloud on?

MariaDB 10 (10.11.6-1369)

Which Docker container are you using to run Nextcloud? (if applicable)

No response

How much RAM does your server have?

20GiB (9% used)

What processor Architecture does your CPU have?

x86_64 (INTEL Celeron J4125)

Describe the Bug

During installation or activation of Recognize, I get the error:

An exception occurred while executing a query: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'version' at row 1
could not enable apps

It stops there. Re-installation fails because the tables are already present in the database:
An error occurred during the request. Unable to proceed.
The column "threshold" on table "nc_recognize_face_detections" already exists.

Expected Behavior

Recognize gets installed

To Reproduce

Remove all tables named recognize.
Install recognize plugin on Nextcloud on Synology DS920

Debug log

No response

[github-actions]

Hello 👋

Thank you for taking the time to open this issue with recognize. I know it's frustrating when software
causes problems. You have made the right choice to come here and open an issue to make sure your problem gets looked at
and if possible solved.
I try to answer all issues and if possible fix all bugs here, but it sometimes takes a while until I get to it.
Until then, please be patient.
Note also that GitHub is a place where people meet to make software better together. Nobody here is under any obligation
to help you, solve your problems or deliver on any expectations or demands you may have, but if enough people come together we can
collaborate to make this software better. For everyone.
Thus, if you can, you could also look at other issues to see whether you can help other people with your knowledge
and experience. If you have coding experience it would also be awesome if you could step up to dive into the code and
try to fix the odd bug yourself. Everyone will be thankful for extra helping hands!
One last word: If you feel, at any point, like you need to vent, this is not the place for it; you can go to the forum,
to twitter or somewhere else. But this is a technical issue tracker, so please make sure to
focus on the tech and keep your opinions to yourself. (Also see our Code of Conduct. Really.)

I look forward to working with you on this issue
Cheers 💙

[marcelklehr]

Hi @kgroot
You will need to remove the relevant entries in the oc_migrations table as well before attempting a reinstall.

[kgroot]

Marcel,

Wow, that helped. I did install, but ended up with a few errors and an Recognize that was not enabled. I tried to enable and waited for the next error, but there was no error. It looks as if it is installed and enabled.

The errors were access problems, probably not from recognize, but from something else.

Up to using recognize.

Thanks.

Klaas groot