Crash on start with An exception occurred while executing 'CREATE table oc_locks_w2g #17

Activity

1. Patt92 commented on Nov 17, 2017

   

   Patt92

   on Nov 17, 2017

   Owner

   More actions

   Please refer to #14
   A faulty DB setup can cause this
2. Patt92

   closed this as completedon Nov 17, 2017
3. nconder commented on Nov 17, 2017

   

   nconder

   on Nov 17, 2017

   Author

   More actions

   Humm, dont think I have a faulty DB setup things run perfectly fine without this app and have been for a very long time without error. If I add the app this error occurs and when I delete it everything is back to normal. Maybe the app has not accounted for something or you can point me to what fault could possible cause this. The user running NextCloud has DB owner permissions and it seem to be this app that is trying to create the table referenced in the error that will not create. Has this been tested with MariaDB?
4. Patt92 commented on Nov 18, 2017

   

   Patt92

   on Nov 18, 2017

   Owner

   More actions

   It‘s clearly written in your log entry...

   Specified key was too long; max key length is 767 bytes

   follow the issue, I replied and change the DB configuration. With a non modded MySQL instance, it would have worked. It‘s caused by the MariaDB default config
5. nconder commented on Nov 18, 2017

   

   nconder

   on Nov 18, 2017

   Author

   More actions

   Thanks @Patt92 for taking some time and explaining in a little more detail.