search

nextcloud / recognize

👁 👂 Smart media tagging for Nextcloud: recognizes faces, objects, landscapes, music genres
https://apps.nextcloud.com/apps/recognize
GNU Affero General Public License v3.0
558 stars 46 forks source link

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

Closed kgroot closed 3 months ago

kgroot commented 3 months ago

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[bot] commented 3 months ago

Hello :wave:

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 :blue_heart:

marcelklehr commented 3 months ago

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

kgroot commented 3 months ago

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