Owncloud 10.9.1 - Migrated from local hosting to VPS hosting - User List not displaying likely for the same reason cannot share files

Steps to reproduce

  1. Login as an administrator => users
  2. Everyone Group indicates (9) users but they are not displayed
  3. Previously groups DO display the users in the group
  4. When attempting to share a file or directory, the user list does not display even when you put in a valid user, therefore you cannot make a share
  5. You can create a new user and login as the user but once again you cannot display the new user in the Everyone list.
  6. *** The original server was running php ver 7.3 the new server is running php ver 7.4

Expected behaviour

Tell us what should happen
The admin should see the list of users should display so you may edit them
When sharing the users should be able to be “tagged” to share a file or directory

Actual behaviour

Tell us what happens instead
No user list is displayed and no users are displayed while attempting to share

Server configuration

Operating system:
Debian 10 - VPS
Web server:
Apache
Database:
MariaSQL
PHP version:
7.4
ownCloud version: (see ownCloud admin page)
10.9.1
Updated from an older ownCloud or fresh install:
Migrated from local hosting to VPS - Both Debian 10
Where did you install ownCloud from:
owncloud community website
Signing status (ownCloud 9.0 and above):

Login as admin user into your ownCloud and access 
http://example.com/index.php/settings/integrity/failed 
No errors have been found.
paste the results into https://gist.github.com/ and puth the link here.

The content of config/config.php:

Log in to the web-UI with an administrator account and click on
'admin' -> 'Generate Config Report' -> 'Download ownCloud config report'
This report includes the config.php settings, the list of activated apps
and other details in a well sanitized form.
or 
If you have access to your command line run e.g.:
sudo -u www-data php occ config:list system
from within your ownCloud installation folder
{
    "system": {
        "instanceid": "ocl06yd2d13j",
        "passwordsalt": "***REMOVED SENSITIVE VALUE***",
        "secret": "***REMOVED SENSITIVE VALUE***",
        "trusted_domains": [
            "localhost",
            "********.us",
            "www.******.us",
            "1***.***.***.***"
        ],
        "datadirectory": "\/var\/www\/html\/owncloud\/data",
        "overwrite.cli.url": "http:\/\/***.***.***.***\/owncloud",
        "dbtype": "mysql",
        "version": "10.9.1.2",
        "dbname": "owncloud",
        "dbhost": "localhost",
        "dbtableprefix": "oc_",
        "mysql.utf8mb4": true,
        "dbuser": "***REMOVED SENSITIVE VALUE***",
        "dbpassword": "***REMOVED SENSITIVE VALUE***",
        "allow_user_to_change_mail_address": "",
        "logtimezone": "UTC",
        "apps_paths": [
            {
                "path": "\/var\/www\/html\/owncloud\/apps",
                "url": "\/apps",
                "writable": false
            },
            {
                "path": "\/var\/www\/html\/owncloud\/apps-external",
                "url": "\/apps-external",
                "writable": true
            }
        ],
        "installed": true,
        "mail_domain": "***REMOVED SENSITIVE VALUE***",
        "mail_from_address": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpmode": "smtp",
        "mail_smtpauthtype": "LOGIN",
        "mail_smtpauth": 1,
        "mail_smtphost": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpport": "25",
        "mail_smtpname": "***REMOVED SENSITIVE VALUE***",
        "mail_smtppassword": "***REMOVED SENSITIVE VALUE***"
    }
}

*ATTENTION:* Do not post your config.php file in public as is. Please use one of the above
methods whenever possible. Both, the generated reports from the web-ui and from occ config:list
consistently remove sensitive data. You still may want to review the report before sending.
If done manually then it is critical for your own privacy to dilligently
remove *all* host names, passwords, usernames, salts and other credentials before posting.
You should assume that attackers find such information and will use them against your systems.

List of activated apps:

If you have access to your command line run e.g.:
sudo -u www-data php occ app:list
from within your ownCloud installation folder.
Enabled:
  - calendar:
    - Version: 1.6.4
    - Path: /var/www/html/owncloud/apps-external/calendar
  - dav:
    - Version: 0.7.0
    - Path: /var/www/html/owncloud/apps/dav
  - federatedfilesharing:
    - Version: 0.5.0
    - Path: /var/www/html/owncloud/apps/federatedfilesharing
  - files:
    - Version: 1.5.2
    - Path: /var/www/html/owncloud/apps/files
  - files_external:
    - Version: 0.8.0
    - Path: /var/www/html/owncloud/apps/files_external
  - files_mediaviewer:
    - Version: 1.0.5
    - Path: /var/www/html/owncloud/apps/files_mediaviewer
  - files_sharing:
    - Version: 0.14.0
    - Path: /var/www/html/owncloud/apps/files_sharing
  - files_texteditor:
    - Version: 2.4.1
    - Path: /var/www/html/owncloud/apps-external/files_texteditor
  - files_trashbin:
    - Version: 0.9.1
    - Path: /var/www/html/owncloud/apps/files_trashbin
  - market:
    - Version: 0.6.3
    - Path: /var/www/html/owncloud/apps-external/market
  - updatenotification:
    - Version: 0.2.1
    - Path: /var/www/html/owncloud/apps/updatenotification
Disabled:
  - comments:
    - Path: /var/www/html/owncloud/apps/comments
  - configreport:
    - Path: /var/www/html/owncloud/apps/configreport
  - encryption:
    - Path: /var/www/html/owncloud/apps/encryption
  - external:
    - Path: /var/www/html/owncloud/apps/external
  - federation:
    - Path: /var/www/html/owncloud/apps/federation
  - files_versions:
    - Path: /var/www/html/owncloud/apps/files_versions
  - firstrunwizard:
    - Path: /var/www/html/owncloud/apps/firstrunwizard
  - notifications:
    - Path: /var/www/html/owncloud/apps/notifications
  - provisioning_api:
    - Path: /var/www/html/owncloud/apps/provisioning_api
  - systemtags:
    - Path: /var/www/html/owncloud/apps/systemtags
  - user_external:
    - Path: /var/www/html/owncloud/apps/user_external

Are you using external storage, if yes which one: local/smb/sftp/…
NO Not at this time
Are you using encryption: yes/no
NO
Are you using an external user-backend, if yes which one: LDAP/ActiveDirectory/Webdav/…
NO

LDAP configuration (delete this part if not used)

N/A

With access to your command line run e.g.:
sudo -u www-data php occ ldap:show-config
from within your ownCloud installation folder
There are no commands defined in the "ldap" namespace.

Without access to your command line download the data/owncloud.db to your local
computer or access your SQL server remotely and run the select query:
SELECT * FROM `oc_appconfig` WHERE `appid` = 'user_ldap';

Eventually replace sensitive data as the name/IP-address of your LDAP server or groups.

Client configuration

Browser:
Firefox
Chrome
Operating system:
Windows 10

Logs

Web server error log

Insert your webserver log here

ownCloud log (data/owncloud.log)

owncloud.log excerpt
{“reqId”:“YqAB99qzEyqUSC@A0IPiygAAAAk”,“level”:3,“time”:“2022-06-08T01:57:11+00:00”,“remoteAddr”:“108.58.17.122”,“user”:“jon.a”,“app”:“index”,“method”:“GET”,“url”:"/owncloud/index.php/settings/users/users?offset=0&limit=200&gid=_everyone&pattern=",“message”:“Exception: {“Exception”:“Doctrine\\DBAL\\Exception\\DriverException”,“Message”:“An exception occurred while executing ‘SELECT DISTINCT a.id AS id, user_id, lower_user_id, display_name, email, last_login, backend, state, quota, home FROM oc_accounts a LEFT JOIN oc_account_terms t ON a.id = t.account_id WHERE (lower_user_id LIKE ?) OR (display_name COLLATE utf8mb4_general_ci LIKE ?) OR (email COLLATE utf8mb4_general_ci LIKE ?) OR (t.term LIKE ?) ORDER BY display_name ASC LIMIT 200’ with params [\”%%\”, \"%%\", \"%%\", \"%%\"]:\n\nSQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION ‘utf8mb4_general_ci’ is not valid for CHARACTER SET ‘utf8’",“Code”:0,“Trace”:"#0 \/var\/www\/html\/owncloud\/lib\/composer\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/DBALException.php(182): Doctrine\\DBAL\\Driver\\AbstractMySQLDriver->convertException()\n#1 \/var\/www\/html\/owncloud\/lib\/composer\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/DBALException.php(159): Doctrine\\DBAL\\DBALException::wrapException()\n#2 \/var\/www\/html\/owncloud\/lib\/composer\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Connection.php(2225): Doctrine\\DBAL\\DBALException::driverExceptionDuringQuery()\n#3 \/var\/www\/html\/owncloud\/lib\/composer\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Statement.php(185): Doctrine\\DBAL\\Connection->handleExceptionDuringQuery()\n#4 \/var\/www\/html\/owncloud\/lib\/public\/AppFramework\/Db\/Mapper.php(242): Doctrine\\DBAL\\Statement->execute()\n#5 \/var\/www\/html\/owncloud\/lib\/public\/AppFramework\/Db\/Mapper.php(346): OCP\\AppFramework\\Db\\Mapper->execute()\n#6 \/var\/www\/html\/owncloud\/lib\/private\/User\/AccountMapper.php(176): OCP\\AppFramework\\Db\\Mapper->findEntities()\n#7 \/var\/www\/html\/owncloud\/lib\/private\/User\/Manager.php(307): OC\\User\\AccountMapper->find()\n#8 \/var\/www\/html\/owncloud\/settings\/Controller\/UsersController.php(304): OC\\User\\Manager->find()\n#9 \/var\/www\/html\/owncloud\/lib\/private\/AppFramework\/Http\/Dispatcher.php(170): OC\\Settings\\Controller\\UsersController->index()\n#10 \/var\/www\/html\/owncloud\/lib\/private\/AppFramework\/Http\/Dispatcher.php(89): OC\\AppFramework\\Http\\Dispatcher->executeController()\n#11 \/var\/www\/html\/owncloud\/lib\/private\/AppFramework\/App.php(100): OC\\AppFramework\\Http\\Dispatcher->dispatch()\n#12 \/var\/www\/html\/owncloud\/lib\/private\/AppFramework\/Routing\/RouteActionHandler.php(47): OC\\AppFramework\\App::main()\n#13 \/var\/www\/html\/owncloud\/lib\/private\/Route\/Router.php(344): OC\\AppFramework\\Routing\\RouteActionHandler->__invoke()\n#14 \/var\/www\/html\/owncloud\/lib\/base.php(927): OC\\Route\\Router->match()\n#15 \/var\/www\/html\/owncloud\/index.php(54): OC::handleRequest()\n#16 {main}",“File”:"\/var\/www\/html\/owncloud\/lib\/composer\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/AbstractMySQLDriver.php",“Line”:128}"}
{“reqId”:“YqAB99qzEyqUSC@A0IPiygAAAAk”,“level”:3,“time”:“2022-06-08T01:57:11+00:00”,“remoteAddr”:“108.58.17.122”,“user”:“jon.a”,“app”:“index”,“method”:“GET”,“url”:"/owncloud/index.php/settings/users/users?offset=0&limit=200&gid=_everyone&pattern=",“message”:“Caused by: {“Exception”:“Doctrine\\DBAL\\Driver\\PDO\\Exception”,“Message”:“SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION ‘utf8mb4_general_ci’ is not valid for CHARACTER SET ‘utf8’”,“Code”:“42000”,“Trace”:”#0 \/var\/www\/html\/owncloud\/lib\/composer\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/PDOStatement.php(119): Doctrine\\DBAL\\Driver\\PDO\\Exception::new()\n#1 \/var\/www\/html\/owncloud\/lib\/composer\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Statement.php(179): Doctrine\\DBAL\\Driver\\PDOStatement->execute()\n#2 \/var\/www\/html\/owncloud\/lib\/public\/AppFramework\/Db\/Mapper.php(242): Doctrine\\DBAL\\Statement->execute()\n#3 \/var\/www\/html\/owncloud\/lib\/public\/AppFramework\/Db\/Mapper.php(346): OCP\\AppFramework\\Db\\Mapper->execute()\n#4 \/var\/www\/html\/owncloud\/lib\/private\/User\/AccountMapper.php(176): OCP\\AppFramework\\Db\\Mapper->findEntities()\n#5 \/var\/www\/html\/owncloud\/lib\/private\/User\/Manager.php(307): OC\\User\\AccountMapper->find()\n#6 \/var\/www\/html\/owncloud\/settings\/Controller\/UsersController.php(304): OC\\User\\Manager->find()\n#7 \/var\/www\/html\/owncloud\/lib\/private\/AppFramework\/Http\/Dispatcher.php(170): OC\\Settings\\Controller\\UsersController->index()\n#8 \/var\/www\/html\/owncloud\/lib\/private\/AppFramework\/Http\/Dispatcher.php(89): OC\\AppFramework\\Http\\Dispatcher->executeController()\n#9 \/var\/www\/html\/owncloud\/lib\/private\/AppFramework\/App.php(100): OC\\AppFramework\\Http\\Dispatcher->dispatch()\n#10 \/var\/www\/html\/owncloud\/lib\/private\/AppFramework\/Routing\/RouteActionHandler.php(47): OC\\AppFramework\\App::main()\n#11 \/var\/www\/html\/owncloud\/lib\/private\/Route\/Router.php(344): OC\\AppFramework\\Routing\\RouteActionHandler->__invoke()\n#12 \/var\/www\/html\/owncloud\/lib\/base.php(927): OC\\Route\\Router->match()\n#13 \/var\/www\/html\/owncloud\/index.php(54): OC::handleRequest()\n#14 {main}",“File”:"\/var\/www\/html\/owncloud\/lib\/composer\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/PDO\/Exception.php",“Line”:18}"}
{“reqId”:“YqAB99qzEyqUSC@A0IPiygAAAAk”,“level”:3,“time”:“2022-06-08T01:57:11+00:00”,“remoteAddr”:“108.58.17.122”,“user”:“jon.a”,“app”:“index”,“method”:“GET”,“url”:"/owncloud/index.php/settings/users/users?offset=0&limit=200&gid=_everyone&pattern=",“message”:“Caused by: {“Exception”:“PDOException”,“Message”:“SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION ‘utf8mb4_general_ci’ is not valid for CHARACTER SET ‘utf8’”,“Code”:“42000”,“Trace”:”#0 \/var\/www\/html\/owncloud\/lib\/composer\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/PDOStatement.php(117): PDOStatement->execute()\n#1 \/var\/www\/html\/owncloud\/lib\/composer\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Statement.php(179): Doctrine\\DBAL\\Driver\\PDOStatement->execute()\n#2 \/var\/www\/html\/owncloud\/lib\/public\/AppFramework\/Db\/Mapper.php(242): Doctrine\\DBAL\\Statement->execute()\n#3 \/var\/www\/html\/owncloud\/lib\/public\/AppFramework\/Db\/Mapper.php(346): OCP\\AppFramework\\Db\\Mapper->execute()\n#4 \/var\/www\/html\/owncloud\/lib\/private\/User\/AccountMapper.php(176): OCP\\AppFramework\\Db\\Mapper->findEntities()\n#5 \/var\/www\/html\/owncloud\/lib\/private\/User\/Manager.php(307): OC\\User\\AccountMapper->find()\n#6 \/var\/www\/html\/owncloud\/settings\/Controller\/UsersController.php(304): OC\\User\\Manager->find()\n#7 \/var\/www\/html\/owncloud\/lib\/private\/AppFramework\/Http\/Dispatcher.php(170): OC\\Settings\\Controller\\UsersController->index()\n#8 \/var\/www\/html\/owncloud\/lib\/private\/AppFramework\/Http\/Dispatcher.php(89): OC\\AppFramework\\Http\\Dispatcher->executeController()\n#9 \/var\/www\/html\/owncloud\/lib\/private\/AppFramework\/App.php(100): OC\\AppFramework\\Http\\Dispatcher->dispatch()\n#10 \/var\/www\/html\/owncloud\/lib\/private\/AppFramework\/Routing\/RouteActionHandler.php(47): OC\\AppFramework\\App::main()\n#11 \/var\/www\/html\/owncloud\/lib\/private\/Route\/Router.php(344): OC\\AppFramework\\Routing\\RouteActionHandler->__invoke()\n#12 \/var\/www\/html\/owncloud\/lib\/base.php(927): OC\\Route\\Router->match()\n#13 \/var\/www\/html\/owncloud\/index.php(54): OC::handleRequest()\n#14 {main}",“File”:"\/var\/www\/html\/owncloud\/lib\/composer\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/PDOStatement.php",“Line”:117}"}


cap2

Insert your ownCloud log here

Browser log

Insert your browser log here, this could for example include:

a) The javascript console log
b) The network log 
c) ...

I assume, there was something wrong with your database migration. On my systems, it is utf8mb4_bin, not utf8mb4_general_ci.

Did you follow the official way?

This post was flagged by the community and is temporarily hidden.

Wrong topic, wrong forum. No clue what you’re talking about.

Yes I followed the procedure noted here: Migrating to a Different Server :: ownCloud Documentation

What is odd is that the users are in fact there (th group count is shown just no users as seen in the screen grabs I included) and I can create new users. All the users can login to the server normally including newly created users. We have a calendars that share normally that was previously configured, same goes with files and directories. I cannot list users to edit them or add to groups because they are not listed in the Everyone group. Users or Admins are not able to share files or directories I believe for the same reason because we are unable to list users to tag to share.

I see in the log and your reference to "Syntax error or access violation: 1253 COLLATION ‘utf8mb4_general_ci’ is not valid for CHARACTER SET ‘utf8’

So the question is how do I fix this?

capnjb

With a little search “mysql change collation”:

No warranty, it’s your responsibility. But I know you have a backup. :wink:

Hi Alfredb, I read the instruction link you provided and it looks like a high probability of error in the process. It is beyond my understanding and skill set as I have zero experience working with sql databases. I did get a list of table for the owncloud database and it appears to be 88 tables to edit. :astonished:
I don’t know how the data could have been modified because it was imported from a working database that still works as expected. There have only been a couple additions to the calendar. Perhaps the safest procedure is to try to replace the working database with the one that has issues. I have backup of both old and new :grin:. What do you think? I will need to figure out how to replace the database which will be a task in itself. What do you think? capnjb

Another search, this time here in the forum:

Maybe it relates to this. I think it is worth a try.

Alfredb, Yes I agree it looks like it is worth a try. I will play with it a little later and post the outcome. Thank you! capnjb

1 Like

Tried running convert-mysql-charset but no joy. There were 3 database errors… Th tried running convert database but errored that and the original database was sql and could not be converted to sql.

So this is still in limbo… not sure where to go next. :thinking:

root@k1imd:/var/www/html/owncloud# sudo -u www-data php occ db:convert-mysql-charset
Change collation for oc_group_user …
Change collation for oc_calendarsubscriptions …
Change collation for oc_documents_op …
Change collation for oc_oc_filecache_6i4zlb9r2jtkz …
Change collation for oc_oc_filecache_rtzscosek3nbf …
Change collation for oc_federated_reshares …
Change collation for oc_jobs …
Change collation for oc_bookmarks_tags …
Change collation for oc_migrations …
Change collation for oc_credentials …
Change collation for oc_calendars …
Change collation for oc_music_ampache_users …
Change collation for oc_calendarchanges …
Change collation for oc_documents_session …
Change collation for oc_comments …
Change collation for oc_news_feeds …
Change collation for oc_dav_job_status …
Change collation for oc_trusted_servers …
Change collation for oc_persistent_locks …
Change collation for oc_users_external …
Change collation for oc_filecache …
Change collation for oc_music_playlists …
Change collation for oc_bookmarks …
Change collation for oc_privatedata …
Change collation for oc_richdocuments_op …
Change collation for oc_ldap_group_members …
Change collation for oc_richdocuments_revisions …
Change collation for oc_oc_filecache_5705662558e21 …
Change collation for oc_dav_shares …
Change collation for oc_preferences …
Change collation for oc_notifications …
Change collation for oc_ldap_group_mapping …
Change collation for oc_news_folders …
Change collation for oc_addressbookchanges …
Change collation for oc_systemtag_object_mapping …
Change collation for oc_storages …
Change collation for oc_music_artists …
Change collation for oc_oc_filecache_84870ddfaf4ae …
Change collation for oc_vcategory …
Change collation for oc_users …
Change collation for oc_files_trash …
Change collation for oc_appconfig …
Change collation for oc_activity …

In AbstractMySQLDriver.php line 128:

An exception occurred while executing ‘ALTER TABLE oc_activity CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;’:

SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large. The maximum row size for the used table type, not counting
BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs

In Exception.php line 18:

SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large. The maximum row size for the used table type, not counting
BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs

In PDOStatement.php line 117:

SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large. The maximum row size for the used table type, not counting
BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs

db:convert-mysql-charset

root@k1imd:/var/www/html/owncloud#

capnjb

Since the collation process did not work I backed up the working original database that is still operating on the original local host. I then copied it to the VPS and restored it. I have the same results as I had with the previous database. The list of users is not available when sharing files or directories. Users DO show up in groups that they were previously assigned to. Shared Calendar appears to work OK. Below is an excerpt of the owncloud.log file after the recent restore. I am at a loss why a working database does not work on a different server.

Log:
{“reqId”:“YqO1ockvw7d6HAuoi4XnvgAAAAU”,“level”:4,“time”:“2022-06-10T21:20:34+00:00”,“remoteAddr”:“108.58.17.122”,“user”:“maggie.a”,“app”:“webdav”,“method”:“REPORT”,“url”:"/owncloud/remote.php/dav/principals/users/maggie.a/",“message”:“Exception: HTTP/1.1 503 System in maintenance mode.: {“Exception”:“Sabre\\DAV\\Exception\\ServiceUnavailable”,“Message”:“System in maintenance mode.”,“Code”:0,“Trace”:”#0 \/var\/www\/html\/owncloud\/lib\/composer\/sabre\/event\/lib\/WildcardEmitterTrait.php(89): OCA\\DAV\\Connector\\Sabre\\MaintenancePlugin->checkMaintenanceMode()\n#1 \/var\/www\/html\/owncloud\/lib\/composer\/sabre\/dav\/lib\/DAV\/Server.php(456): Sabre\\DAV\\Server->emit()\n#2 \/var\/www\/html\/owncloud\/lib\/composer\/sabre\/dav\/lib\/DAV\/Server.php(253): Sabre\\DAV\\Server->invokeMethod()\n#3 \/var\/www\/html\/owncloud\/apps\/dav\/lib\/Server.php(345): Sabre\\DAV\\Server->start()\n#4 \/var\/www\/html\/owncloud\/apps\/dav\/appinfo\/v2\/remote.php(31): OCA\\DAV\\Server->exec()\n#5 \/var\/www\/html\/owncloud\/remote.php(165): require_once(’\/var\/www\/html\/o…’)\n#6 {main}",“File”:"\/var\/www\/html\/owncloud\/apps\/dav\/lib\/Connector\/Sabre\/MaintenancePlugin.php",“Line”:82}"}
{“reqId”:“YqO1op-8EXXw-mJp@r6QWQAAAAI”,“level”:4,“time”:“2022-06-10T21:20:34+00:00”,“remoteAddr”:“108.58.17.122”,“user”:“maggie.a”,“app”:“webdav”,“method”:“PROPFIND”,“url”:"/owncloud/remote.php/dav/calendars/maggie.a/",“message”:“Exception: HTTP/1.1 503 System in maintenance mode.: {“Exception”:“Sabre\\DAV\\Exception\\ServiceUnavailable”,“Message”:“System in maintenance mode.”,“Code”:0,“Trace”:”#0 \/var\/www\/html\/owncloud\/lib\/composer\/sabre\/event\/lib\/WildcardEmitterTrait.php(89): OCA\\DAV\\Connector\\Sabre\\MaintenancePlugin->checkMaintenanceMode()\n#1 \/var\/www\/html\/owncloud\/lib\/composer\/sabre\/dav\/lib\/DAV\/Server.php(456): Sabre\\DAV\\Server->emit()\n#2 \/var\/www\/html\/owncloud\/lib\/composer\/sabre\/dav\/lib\/DAV\/Server.php(253): Sabre\\DAV\\Server->invokeMethod()\n#3 \/var\/www\/html\/owncloud\/apps\/dav\/lib\/Server.php(345): Sabre\\DAV\\Server->start()\n#4 \/var\/www\/html\/owncloud\/apps\/dav\/appinfo\/v2\/remote.php(31): OCA\\DAV\\Server->exec()\n#5 \/var\/www\/html\/owncloud\/remote.php(165): require_once(’\/var\/www\/html\/o…’)\n#6 {main}",“File”:"\/var\/www\/html\/owncloud\/apps\/dav\/lib\/Connector\/Sabre\/MaintenancePlugin.php",“Line”:82}"}
{“reqId”:“YqO2n0vV3IBPwI5M@yTnhwAAAAM”,“level”:4,“time”:“2022-06-10T21:24:47+00:00”,“remoteAddr”:“108.58.17.122”,“user”:"–",“app”:“webdav”,“method”:“OPTIONS”,“url”:"/owncloud/remote.php/dav/principals/users/jon.a/",“message”:“Exception: HTTP/1.1 503 System in maintenance mode.: {“Exception”:“Sabre\\DAV\\Exception\\ServiceUnavailable”,“Message”:“System in maintenance mode.”,“Code”:0,“Trace”:”#0 \/var\/www\/html\/owncloud\/lib\/composer\/sabre\/event\/lib\/WildcardEmitterTrait.php(89): OCA\\DAV\\Connector\\Sabre\\MaintenancePlugin->checkMaintenanceMode()\n#1 \/var\/www\/html\/owncloud\/lib\/composer\/sabre\/dav\/lib\/DAV\/Server.php(456): Sabre\\DAV\\Server->emit()\n#2 \/var\/www\/html\/owncloud\/lib\/composer\/sabre\/dav\/lib\/DAV\/Server.php(253): Sabre\\DAV\\Server->invokeMethod()\n#3 \/var\/www\/html\/owncloud\/apps\/dav\/lib\/Server.php(345): Sabre\\DAV\\Server->start()\n#4 \/var\/www\/html\/owncloud\/apps\/dav\/appinfo\/v2\/remote.php(31): OCA\\DAV\\Server->exec()\n#5 \/var\/www\/html\/owncloud\/remote.php(165): require_once(’\/var\/www\/html\/o…’)\n#6 {main}",“File”:"\/var\/www\/html\/owncloud\/apps\/dav\/lib\/Connector\/Sabre\/MaintenancePlugin.php",“Line”:82}"}
{“reqId”:“YqO2nzRPU4QnmUeGfvUh9AAAAAg”,“level”:4,“time”:“2022-06-10T21:24:48+00:00”,“remoteAddr”:“108.58.17.122”,“user”:"–",“app”:“webdav”,“method”:“REPORT”,“url”:"/owncloud/remote.php/dav/principals/users/jon.a/",“message”:“Exception: HTTP/1.1 503 System in maintenance mode.: {“Exception”:“Sabre\\DAV\\Exception\\ServiceUnavailable”,“Message”:“System in maintenance mode.”,“Code”:0,“Trace”:”#0 \/var\/www\/html\/owncloud\/lib\/composer\/sabre\/event\/lib\/WildcardEmitterTrait.php(89): OCA\\DAV\\Connector\\Sabre\\MaintenancePlugin->checkMaintenanceMode()\n#1 \/var\/www\/html\/owncloud\/lib\/composer\/sabre\/dav\/lib\/DAV\/Server.php(456): Sabre\\DAV\\Server->emit()\n#2 \/var\/www\/html\/owncloud\/lib\/composer\/sabre\/dav\/lib\/DAV\/Server.php(253): Sabre\\DAV\\Server->invokeMethod()\n#3 \/var\/www\/html\/owncloud\/apps\/dav\/lib\/Server.php(345): Sabre\\DAV\\Server->start()\n#4 \/var\/www\/html\/owncloud\/apps\/dav\/appinfo\/v2\/remote.php(31): OCA\\DAV\\Server->exec()\n#5 \/var\/www\/html\/owncloud\/remote.php(165): require_once(’\/var\/www\/html\/o…’)\n#6 {main}",“File”:"\/var\/www\/html\/owncloud\/apps\/dav\/lib\/Connector\/Sabre\/MaintenancePlugin.php",“Line”:82}"}
{“reqId”:“YqO2oI4vFJvEIAOOOfPqfwAAABA”,“level”:4,“time”:“2022-06-10T21:24:48+00:00”,“remoteAddr”:“108.58.17.122”,“user”:"–",“app”:“webdav”,“method”:“PROPFIND”,“url”:"/owncloud/remote.php/dav/calendars/jon.a/",“message”:“Exception: HTTP/1.1 503 System in maintenance mode.: {“Exception”:“Sabre\\DAV\\Exception\\ServiceUnavailable”,“Message”:“System in maintenance mode.”,“Code”:0,“Trace”:”#0 \/var\/www\/html\/owncloud\/lib\/composer\/sabre\/event\/lib\/WildcardEmitterTrait.php(89): OCA\\DAV\\Connector\\Sabre\\MaintenancePlugin->checkMaintenanceMode()\n#1 \/var\/www\/html\/owncloud\/lib\/composer\/sabre\/dav\/lib\/DAV\/Server.php(456): Sabre\\DAV\\Server->emit()\n#2 \/var\/www\/html\/owncloud\/lib\/composer\/sabre\/dav\/lib\/DAV\/Server.php(253): Sabre\\DAV\\Server->invokeMethod()\n#3 \/var\/www\/html\/owncloud\/apps\/dav\/lib\/Server.php(345): Sabre\\DAV\\Server->start()\n#4 \/var\/www\/html\/owncloud\/apps\/dav\/appinfo\/v2\/remote.php(31): OCA\\DAV\\Server->exec()\n#5 \/var\/www\/html\/owncloud\/remote.php(165): require_once(’\/var\/www\/html\/o…’)\n#6 {main}",“File”:"\/var\/www\/html\/owncloud\/apps\/dav\/lib\/Connector\/Sabre\/MaintenancePlugin.php",“Line”:82}"}
{“reqId”:“YqO4jjoFuBYIfCL1KPApTAAAAAA”,“level”:4,“time”:“2022-06-10T21:33:04+00:00”,“remoteAddr”:“108.58.17.122”,“user”:"–",“app”:“webdav”,“method”:“PROPFIND”,“url”:"/owncloud/remote.php/dav/calendars/jon.a/texasitems/",“message”:“Exception: HTTP/1.1 503 System in maintenance mode.: {“Exception”:“Sabre\\DAV\\Exception\\ServiceUnavailable”,“Message”:“System in maintenance mode.”,“Code”:0,“Trace”:”#0 \/var\/www\/html\/owncloud\/lib\/composer\/sabre\/event\/lib\/WildcardEmitterTrait.php(89): OCA\\DAV\\Connector\\Sabre\\MaintenancePlugin->checkMaintenanceMode()\n#1 \/var\/www\/html\/owncloud\/lib\/composer\/sabre\/dav\/lib\/DAV\/Server.php(456): Sabre\\DAV\\Server->emit()\n#2 \/var\/www\/html\/owncloud\/lib\/composer\/sabre\/dav\/lib\/DAV\/Server.php(253): Sabre\\DAV\\Server->invokeMethod()\n#3 \/var\/www\/html\/owncloud\/apps\/dav\/lib\/Server.php(345): Sabre\\DAV\\Server->start()\n#4 \/var\/www\/html\/owncloud\/apps\/dav\/appinfo\/v2\/remote.php(31): OCA\\DAV\\Server->exec()\n#5 \/var\/www\/html\/owncloud\/remote.php(165): require_once(’\/var\/www\/html\/o…’)\n#6 {main}",“File”:"\/var\/www\/html\/owncloud\/apps\/dav\/lib\/Connector\/Sabre\/MaintenancePlugin.php",“Line”:82}"}
{“reqId”:“YqO4jnu0EJywZlFCJ@Ck1QAAAAE”,“level”:4,“time”:“2022-06-10T21:33:04+00:00”,“remoteAddr”:“108.58.17.122”,“user”:"–",“app”:“webdav”,“method”:“PROPFIND”,“url”:"/owncloud/remote.php/dav/calendars/jon.a/jon/",“message”:“Exception: HTTP/1.1 503 System in maintenance mode.: {“Exception”:“Sabre\\DAV\\Exception\\ServiceUnavailable”,“Message”:“System in maintenance mode.”,“Code”:0,“Trace”:”#0 \/var\/www\/html\/owncloud\/lib\/composer\/sabre\/event\/lib\/WildcardEmitterTrait.php(89): OCA\\DAV\\Connector\\Sabre\\MaintenancePlugin->checkMaintenanceMode()\n#1 \/var\/www\/html\/owncloud\/lib\/composer\/sabre\/dav\/lib\/DAV\/Server.php(456): Sabre\\DAV\\Server->emit()\n#2 \/var\/www\/html\/owncloud\/lib\/composer\/sabre\/dav\/lib\/DAV\/Server.php(253): Sabre\\DAV\\Server->invokeMethod()\n#3 \/var\/www\/html\/owncloud\/apps\/dav\/lib\/Server.php(345): Sabre\\DAV\\Server->start()\n#4 \/var\/www\/html\/owncloud\/apps\/dav\/appinfo\/v2\/remote.php(31): OCA\\DAV\\Server->exec()\n#5 \/var\/www\/html\/owncloud\/remote.php(165): require_once(’\/var\/www\/html\/o…’)\n#6 {main}",“File”:"\/var\/www\/html\/owncloud\/apps\/dav\/lib\/Connector\/Sabre\/MaintenancePlugin.php",“Line”:82}"}
{“reqId”:“YqO4jkvV3IBPwI5M@yTniAAAAAM”,“level”:4,“time”:“2022-06-10T21:33:04+00:00”,“remoteAddr”:“108.58.17.122”,“user”:"–",“app”:“webdav”,“method”:“PROPFIND”,“url”:"/owncloud/remote.php/dav/calendars/jon.a/possible-events/",“message”:“Exception: HTTP/1.1 503 System in maintenance mode.: {“Exception”:“Sabre\\DAV\\Exception\\ServiceUnavailable”,“Message”:“System in maintenance mode.”,“Code”:0,“Trace”:”#0 \/var\/www\/html\/owncloud\/lib\/composer\/sabre\/event\/lib\/WildcardEmitterTrait.php(89): OCA\\DAV\\Connector\\Sabre\\MaintenancePlugin->checkMaintenanceMode()\n#1 \/var\/www\/html\/owncloud\/lib\/composer\/sabre\/dav\/lib\/DAV\/Server.php(456): Sabre\\DAV\\Server->emit()\n#2 \/var\/www\/html\/owncloud\/lib\/composer\/sabre\/dav\/lib\/DAV\/Server.php(253): Sabre\\DAV\\Server->invokeMethod()\n#3 \/var\/www\/html\/owncloud\/apps\/dav\/lib\/Server.php(345): Sabre\\DAV\\Server->start()\n#4 \/var\/www\/html\/owncloud\/apps\/dav\/appinfo\/v2\/remote.php(31): OCA\\DAV\\Server->exec()\n#5 \/var\/www\/html\/owncloud\/remote.php(165): require_once(’\/var\/www\/html\/o…’)\n#6 {main}",“File”:"\/var\/www\/html\/owncloud\/apps\/dav\/lib\/Connector\/Sabre\/MaintenancePlugin.php",“Line”:82}"}

and

\DBALException::driverExceptionDuringQuery()\n#3 \/var\/www\/html\/owncloud\/lib\/composer\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Statement.php(185): Doctrine\\DBAL\\Connection->handleExceptionDuringQuery()\n#4 \/var\/www\/html\/owncloud\/lib\/public\/AppFramework\/Db\/Mapper.php(242): Doctrine\\DBAL\\Statement->execute()\n#5 \/var\/www\/html\/owncloud\/lib\/public\/AppFramework\/Db\/Mapper.php(346): OCP\\AppFramework\\Db\\Mapper->execute()\n#6 \/var\/www\/html\/owncloud\/lib\/private\/User\/AccountMapper.php(176): OCP\\AppFramework\\Db\\Mapper->findEntities()\n#7 \/var\/www\/html\/owncloud\/lib\/private\/User\/Manager.php(307): OC\\User\\AccountMapper->find()\n#8 \/var\/www\/html\/owncloud\/settings\/Controller\/UsersController.php(304): OC\\User\\Manager->find()\n#9 \/var\/www\/html\/owncloud\/lib\/private\/AppFramework\/Http\/Dispatcher.php(170): OC\\Settings\\Controller\\UsersController->index()\n#10 \/var\/www\/html\/owncloud\/lib\/private\/AppFramework\/Http\/Dispatcher.php(89): OC\\AppFramework\\Http\\Dispatcher->executeController()\n#11 \/var\/www\/html\/owncloud\/lib\/private\/AppFramework\/App.php(100): OC\\AppFramework\\Http\\Dispatcher->dispatch()\n#12 \/var\/www\/html\/owncloud\/lib\/private\/AppFramework\/Routing\/RouteActionHandler.php(47): OC\\AppFramework\\App::main()\n#13 \/var\/www\/html\/owncloud\/lib\/private\/Route\/Router.php(344): OC\\AppFramework\\Routing\\RouteActionHandler->__invoke()\n#14 \/var\/www\/html\/owncloud\/lib\/base.php(927): OC\\Route\\Router->match()\n#15 \/var\/www\/html\/owncloud\/index.php(54): OC::handleRequest()\n#16 {main}",“File”:"\/var\/www\/html\/owncloud\/lib\/composer\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/AbstractMySQLDriver.php",“Line”:128}"}
{“reqId”:“YqO@VGSKGx-CAX@vxMCQjAAAAAM”,“level”:3,“time”:“2022-06-10T21:57:40+00:00”,“remoteAddr”:“108.58.17.122”,“user”:“jon.a”,“app”:“index”,“method”:“GET”,“url”:"/owncloud/index.php/settings/users/users?offset=0&limit=200&gid=_everyone&pattern=",“message”:“Caused by: {“Exception”:“Doctrine\\DBAL\\Driver\\PDO\\Exception”,“Message”:“SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION ‘utf8mb4_general_ci’ is not valid for CHARACTER SET ‘utf8’”,“Code”:“42000”,“Trace”:”#0 \/var\/www\/html\/owncloud\/lib\/composer\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/PDOStatement.php(119): Doctrine\\DBAL\\Driver\\PDO\\Exception::new()\n#1 \/var\/www\/html\/owncloud\/lib\/composer\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Statement.php(179): Doctrine\\DBAL\\Driver\\PDOStatement->execute()\n#2 \/var\/www\/html\/owncloud\/lib\/public\/AppFramework\/Db\/Mapper.php(242): Doctrine\\DBAL\\Statement->execute()\n#3 \/var\/www\/html\/owncloud\/lib\/public\/AppFramework\/Db\/Mapper.php(346): OCP\\AppFramework\\Db\\Mapper->execute()\n#4 \/var\/www\/html\/owncloud\/lib\/private\/User\/AccountMapper.php(176): OCP\\AppFramework\\Db\\Mapper->findEntities()\n#5 \/var\/www\/html\/owncloud\/lib\/private\/User\/Manager.php(307): OC\\User\\AccountMapper->find()\n#6 \/var\/www\/html\/owncloud\/settings\/Controller\/UsersController.php(304): OC\\User\\Manager->find()\n#7 \/var\/www\/html\/owncloud\/lib\/private\/AppFramework\/Http\/Dispatcher.php(170): OC\\Settings\\Controller\\UsersController->index()\n#8 \/var\/www\/html\/owncloud\/lib\/private\/AppFramework\/Http\/Dispatcher.php(89): OC\\AppFramework\\Http\\Dispatcher->executeController()\n#9 \/var\/www\/html\/owncloud\/lib\/private\/AppFramework\/App.php(100): OC\\AppFramework\\Http\\Dispatcher->dispatch()\n#10 \/var\/www\/html\/owncloud\/lib\/private\/AppFramework\/Routing\/RouteActionHandler.php(47): OC\\AppFramework\\App::main()\n#11 \/var\/www\/html\/owncloud\/lib\/private\/Route\/Router.php(344): OC\\AppFramework\\Routing\\RouteActionHandler->__invoke()\n#12 \/var\/www\/html\/owncloud\/lib\/base.php(927): OC\\Route\\Router->match()\n#13 \/var\/www\/html\/owncloud\/index.php(54): OC::handleRequest()\n#14 {main}",“File”:"\/var\/www\/html\/owncloud\/lib\/composer\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/PDO\/Exception.php",“Line”:18}"}
{“reqId”:“YqO@VGSKGx-CAX@vxMCQjAAAAAM”,“level”:3,“time”:“2022-06-10T21:57:40+00:00”,“remoteAddr”:“108.58.17.122”,“user”:“jon.a”,“app”:“index”,“method”:“GET”,“url”:"/owncloud/index.php/settings/users/users?offset=0&limit=200&gid=_everyone&pattern=",“message”:“Caused by: {“Exception”:“PDOException”,“Message”:“SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION ‘utf8mb4_general_ci’ is not valid for CHARACTER SET ‘utf8’”,“Code”:“42000”,“Trace”:”#0 \/var\/www\/html\/owncloud\/lib\/composer\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/PDOStatement.php(117): PDOStatement->execute()\n#1 \/var\/www\/html\/owncloud\/lib\/composer\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Statement.php(179): Doctrine\\DBAL\\Driver\\PDOStatement->execute()\n#2 \/var\/www\/html\/owncloud\/lib\/public\/AppFramework\/Db\/Mapper.php(242): Doctrine\\DBAL\\Statement->execute()\n#3 \/var\/www\/html\/owncloud\/lib\/public\/AppFramework\/Db\/Mapper.php(346): OCP\\AppFramework\\Db\\Mapper->execute()\n#4 \/var\/www\/html\/owncloud\/lib\/private\/User\/AccountMapper.php(176): OCP\\AppFramework\\Db\\Mapper->findEntities()\n#5 \/var\/www\/html\/owncloud\/lib\/private\/User\/Manager.php(307): OC\\User\\AccountMapper->find()\n#6 \/var\/www\/html\/owncloud\/settings\/Controller\/UsersController.php(304): OC\\User\\Manager->find()\n#7 \/var\/www\/html\/owncloud\/lib\/private\/AppFramework\/Http\/Dispatcher.php(170): OC\\Settings\\Controller\\UsersController->index()\n#8 \/var\/www\/html\/owncloud\/lib\/private\/AppFramework\/Http\/Dispatcher.php(89): OC\\AppFramework\\Http\\Dispatcher->executeController()\n#9 \/var\/www\/html\/owncloud\/lib\/private\/AppFramework\/App.php(100): OC\\AppFramework\\Http\\Dispatcher->dispatch()\n#10 \/var\/www\/html\/owncloud\/lib\/private\/AppFramework\/Routing\/RouteActionHandler.php(47): OC\\AppFramework\\App::main()\n#11 \/var\/www\/html\/owncloud\/lib\/private\/Route\/Router.php(344): OC\\AppFramework\\Routing\\RouteActionHandler->__invoke()\n#12 \/var\/www\/html\/owncloud\/lib\/base.php(927): OC\\Route\\Router->match()\n#13 \/var\/www\/html\/owncloud\/index.php(54): OC::handleRequest()\n#14 {main}",“File”:"\/var\/www\/html\/owncloud\/lib\/composer\/doctrine\/dbal\/lib\/Doctrine\/DBAL\

I am stumped. Anyone have a guesses at solutions? Is there a module missing from MariaDB?

capnjb

I did some more checking and both the original and the new server are running php 7.4.

The calendar shares seem to work as does the public shares. The issue is only sharing groups & users because the list does not display. The “everyone” list in the admin user list does not display.

When attempting to share with a group or user the little searching “circle” icon flashes for a few seconds then disappears. When attempting to display the users list the same thing occurs the searching “circle” is displayed but does not show any users. Very frustrating because everything “almost” works perfectly.

All the users are active and can login using their credentials as shown in the users list.

capnjb

Does appear to be a character collate issue. Another clue! However the question is how to fix it?

capnjb

I really do not understand, why you are ignoring the solution/link I gave you. Instead, you continue screwing up your system more and more, although we have seen that none of the steps taken are succeeding. Everything has a “probability of error”, but keep in mind, you still have a serious issue to solve.

The cited solution for changing the collation really works. Everything required is written there, you simply have to follow these steps.

Fiddling with backups over and over again won’t bring you any closer to a solution. Unless you want to reinstall. According to your logs, the wrong collation seems to be the problem. Please fix this, don’t try anything else.

At the end, please do not blame ownCloud, it’s not its fault, and you had a chance to fix it.

I ran the query to correct the collate seemingly fixing the issue see:
MariaDB [owncloud]> SELECT CONCAT(“ALTER TABLE “, TABLE_SCHEMA, ‘.’, TABLE_NAME,” COLLATE utf8mb4_bin;”) AS ExecuteTheString FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA=“owncloud” AND TABLE_TYPE=“BASE TABLE”;
±------------------------------------------------------------------------+
| ExecuteTheString |
±------------------------------------------------------------------------+
| ALTER TABLE owncloud.oc_group_user COLLATE utf8mb4_bin; |
| ALTER TABLE owncloud.oc_calendarsubscriptions COLLATE utf8mb4_bin; |
| ALTER TABLE owncloud.oc_documents_op COLLATE utf8mb4_bin; |
| ALTER TABLE owncloud.oc_oc_filecache_6i4zlb9r2jtkz COLLATE utf8mb4_bin; |
| ALTER TABLE owncloud.oc_oc_filecache_rtzscosek3nbf COLLATE utf8mb4_bin; |
| ALTER TABLE owncloud.oc_federated_reshares COLLATE utf8mb4_bin; |
| ALTER TABLE owncloud.oc_jobs COLLATE utf8mb4_bin; |
| ALTER TABLE owncloud.oc_bookmarks_tags COLLATE utf8mb4_bin; |
| ALTER TABLE owncloud.oc_migrations COLLATE utf8mb4_bin; |
| ALTER TABLE owncloud.oc_credentials COLLATE utf8mb4_bin; |
| ALTER TABLE owncloud.oc_calendars COLLATE utf8mb4_bin; |
| ALTER TABLE owncloud.oc_music_ampache_users COLLATE utf8mb4_bin; |
| ALTER TABLE owncloud.oc_calendarchanges COLLATE utf8mb4_bin; |
| ALTER TABLE owncloud.oc_documents_session COLLATE utf8mb4_bin; |
| ALTER TABLE owncloud.oc_comments COLLATE utf8mb4_bin; |
| ALTER TABLE owncloud.oc_news_feeds COLLATE utf8mb4_bin; |
| ALTER TABLE owncloud.oc_dav_job_status COLLATE utf8mb4_bin; |
| ALTER TABLE owncloud.oc_trusted_servers COLLATE utf8mb4_bin; |
| ALTER TABLE owncloud.oc_persistent_locks COLLATE utf8mb4_bin; |
| ALTER TABLE owncloud.oc_users_external COLLATE utf8mb4_bin; |
| ALTER TABLE owncloud.oc_custom_group_member COLLATE utf8mb4_bin; |
| ALTER TABLE owncloud.oc_filecache COLLATE utf8mb4_bin; |
| ALTER TABLE owncloud.oc_music_playlists COLLATE utf8mb4_bin; |
| ALTER TABLE owncloud.oc_bookmarks COLLATE utf8mb4_bin; |
| ALTER TABLE owncloud.oc_music_playlist_tracks COLLATE utf8mb4_bin; |
| ALTER TABLE owncloud.oc_privatedata COLLATE utf8mb4_bin; |
| ALTER TABLE owncloud.oc_richdocuments_op COLLATE utf8mb4_bin; |
| ALTER TABLE owncloud.oc_ldap_group_members COLLATE utf8mb4_bin; |
| ALTER TABLE owncloud.oc_music_album_artists COLLATE utf8mb4_bin; |
| ALTER TABLE owncloud.oc_richdocuments_revisions COLLATE utf8mb4_bin; |
| ALTER TABLE owncloud.oc_oc_filecache_5705662558e21 COLLATE utf8mb4_bin; |
| ALTER TABLE owncloud.oc_dav_shares COLLATE utf8mb4_bin; |
| ALTER TABLE owncloud.oc_preferences COLLATE utf8mb4_bin; |
| ALTER TABLE owncloud.oc_notifications COLLATE utf8mb4_bin; |
| ALTER TABLE owncloud.oc_ldap_group_mapping COLLATE utf8mb4_bin; |
| ALTER TABLE owncloud.oc_news_folders COLLATE utf8mb4_bin; |
| ALTER TABLE owncloud.oc_addressbookchanges COLLATE utf8mb4_bin; |
| ALTER TABLE owncloud.oc_systemtag_object_mapping COLLATE utf8mb4_bin; |
| ALTER TABLE owncloud.oc_storages COLLATE utf8mb4_bin; |
| ALTER TABLE owncloud.oc_music_artists COLLATE utf8mb4_bin; |
| ALTER TABLE owncloud.oc_custom_group COLLATE utf8mb4_bin; |
| ALTER TABLE owncloud.oc_oc_filecache_84870ddfaf4ae COLLATE utf8mb4_bin; |
| ALTER TABLE owncloud.oc_vcategory COLLATE utf8mb4_bin; |
| ALTER TABLE owncloud.oc_users COLLATE utf8mb4_bin; |
| ALTER TABLE owncloud.oc_files_trash COLLATE utf8mb4_bin; |
| ALTER TABLE owncloud.oc_appconfig COLLATE utf8mb4_bin; |
| ALTER TABLE owncloud.oc_activity COLLATE utf8mb4_bin; |
| ALTER TABLE owncloud.oc_systemtag COLLATE utf8mb4_bin; |
| ALTER TABLE owncloud.oc_comments_read_markers COLLATE utf8mb4_bin; |
| ALTER TABLE owncloud.oc_file_locks COLLATE utf8mb4_bin; |
| ALTER TABLE owncloud.oc_richdocuments_session COLLATE utf8mb4_bin; |
| ALTER TABLE owncloud.oc_properties COLLATE utf8mb4_bin; |
| ALTER TABLE owncloud.oc_cards_properties COLLATE utf8mb4_bin; |
| ALTER TABLE owncloud.oc_groups COLLATE utf8mb4_bin; |
| ALTER TABLE owncloud.oc_external_applicable COLLATE utf8mb4_bin; |
| ALTER TABLE owncloud.oc_systemtag_group COLLATE utf8mb4_bin; |
| ALTER TABLE owncloud.oc_lucene_status COLLATE utf8mb4_bin; |
| ALTER TABLE owncloud.oc_vcategory_to_object COLLATE utf8mb4_bin; |
| ALTER TABLE owncloud.oc_authtoken COLLATE utf8mb4_bin; |
| ALTER TABLE owncloud.oc_external_mounts COLLATE utf8mb4_bin; |
| ALTER TABLE owncloud.oc_share COLLATE utf8mb4_bin; |
| ALTER TABLE owncloud.oc_music_ampache_sessions COLLATE utf8mb4_bin; |
| ALTER TABLE owncloud.oc_dav_properties COLLATE utf8mb4_bin; |
| ALTER TABLE owncloud.oc_share_external COLLATE utf8mb4_bin; |
| ALTER TABLE owncloud.oc_richdocuments_member COLLATE utf8mb4_bin; |
| ALTER TABLE owncloud.oc_richdocuments_wopi COLLATE utf8mb4_bin; |
| ALTER TABLE owncloud.oc_music_albums COLLATE utf8mb4_bin; |
| ALTER TABLE owncloud.oc_oc_filecache_48418b8d37405 COLLATE utf8mb4_bin; |
| ALTER TABLE owncloud.oc_mimetypes COLLATE utf8mb4_bin; |
| ALTER TABLE owncloud.oc_activity_mq COLLATE utf8mb4_bin; |
| ALTER TABLE owncloud.oc_calendarobjects COLLATE utf8mb4_bin; |
| ALTER TABLE owncloud.oc_account_terms COLLATE utf8mb4_bin; |
| ALTER TABLE owncloud.oc_schedulingobjects COLLATE utf8mb4_bin; |
| ALTER TABLE owncloud.oc_documents_invite COLLATE utf8mb4_bin; |
| ALTER TABLE owncloud.oc_news_items COLLATE utf8mb4_bin; |
| ALTER TABLE owncloud.oc_shorten COLLATE utf8mb4_bin; |
| ALTER TABLE owncloud.oc_accounts COLLATE utf8mb4_bin; |
| ALTER TABLE owncloud.oc_addressbooks COLLATE utf8mb4_bin; |
| ALTER TABLE owncloud.oc_external_config COLLATE utf8mb4_bin; |
| ALTER TABLE owncloud.oc_documents_revisions COLLATE utf8mb4_bin; |
| ALTER TABLE owncloud.oc_music_tracks COLLATE utf8mb4_bin; |
| ALTER TABLE owncloud.oc_mounts COLLATE utf8mb4_bin; |
| ALTER TABLE owncloud.oc_external_options COLLATE utf8mb4_bin; |
| ALTER TABLE owncloud.oc_documents_member COLLATE utf8mb4_bin; |
| ALTER TABLE owncloud.oc_richdocuments_invite COLLATE utf8mb4_bin; |
| ALTER TABLE owncloud.oc_ldap_user_mapping COLLATE utf8mb4_bin; |
| ALTER TABLE owncloud.oc_cards COLLATE utf8mb4_bin; |
| ALTER TABLE owncloud.oc_group_admin COLLATE utf8mb4_bin; |
±------------------------------------------------------------------------+
88 rows in set (0.005 sec)

However when I list the table I see that the collate did not change?

MariaDB [owncloud]> SELECT * FROM INFORMATION_SCHEMA.TABLES
→ WHERE TABLE_SCHEMA=“owncloud”
→ AND TABLE_TYPE=“BASE TABLE”;
±--------------±-------------±------------------------------±-----------±-------±--------±-----------±-----------±---------------±------------±----------------±-------------±----------±---------------±--------------------±--------------------±-----------±----------------±---------±---------------±--------------±-----------------±----------+
| TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME | TABLE_TYPE | ENGINE | VERSION | ROW_FORMAT | TABLE_ROWS | AVG_ROW_LENGTH | DATA_LENGTH | MAX_DATA_LENGTH | INDEX_LENGTH | DATA_FREE | AUTO_INCREMENT | CREATE_TIME | UPDATE_TIME | CHECK_TIME | TABLE_COLLATION | CHECKSUM | CREATE_OPTIONS | TABLE_COMMENT | MAX_INDEX_LENGTH | TEMPORARY |
±--------------±-------------±------------------------------±-----------±-------±--------±-----------±-----------±---------------±------------±----------------±-------------±----------±---------------±--------------------±--------------------±-----------±----------------±---------±---------------±--------------±-----------------±----------+
| def | owncloud | oc_group_user | BASE TABLE | InnoDB | 10 | Dynamic | 30 | 546 | 16384 | 0 | 16384 | 0 | NULL | 2022-06-24 19:14:38 | NULL | NULL | utf8mb4_bin | NULL | | | 0 | N |
| def | owncloud | oc_calendarsubscriptions | BASE TABLE | InnoDB | 10 | Dynamic | 4 | 4096 | 16384 | 0 | 16384 | 0 | 6 | 2022-06-24 19:14:38 | NULL | NULL | utf8mb4_bin | NULL | | | 0 | N |
| def | owncloud | oc_documents_op | BASE TABLE | InnoDB | 10 | Dynamic | 32 | 512 | 16384 | 0 | 16384 | 0 | 33 | 2022-06-24 19:14:38 | NULL | NULL | utf8mb4_bin | NULL | | | 0 | N |
| def | owncloud | oc_oc_filecache_6i4zlb9r2jtkz | BASE TABLE | InnoDB | 10 | Dynamic | 664738 | 262 | 174768128 | 0 | 152109056 | 0 | 6524961 | 2022-06-24 19:15:28 | NULL | NULL | utf8mb4_bin | NULL | | | 0 | N |
| def | owncloud | oc_oc_filecache_rtzscosek3nbf | BASE TABLE | InnoDB | 10 | Dynamic | 4757534 | 242 | 1154482176 | 0 | 993230848 | 0 | 6524961 | 2022-06-24 19:24:51 | NULL | NULL | utf8mb4_bin | NULL | | | 0 | N |
| def | owncloud | oc_federated_reshares | BASE TABLE | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2022-06-24 19:24:51 | NULL | NULL | utf8mb4_bin | NULL | | | 0 | N |
| def | owncloud | oc_jobs | BASE TABLE | InnoDB | 10 | Dynamic | 21 | 780 | 16384 | 0 | 16384 | 0 | 265 | 2022-06-24 19:24:51 | NULL | NULL | utf8mb4_bin | NULL | | | 0 | N |
| def | owncloud | oc_bookmarks_tags | BASE TABLE | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 16384 | 0 | NULL | 2022-06-24 19:24:52 | NULL | NULL | utf8mb4_bin | NULL | | | 0 | N |
| def | owncloud | oc_migrations | BASE TABLE | InnoDB | 10 | Dynamic | 62 | 264 | 16384 | 0 | 0 | 0 | NULL | 2022-06-24 19:24:52 | NULL | NULL | utf8mb4_bin | NULL | | | 0 | N |
| def | owncloud | oc_credentials | BASE TABLE | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 16384 | 0 | NULL | 2022-06-24 19:24:52 | NULL | NULL | utf8mb4_bin | NULL | | | 0 | N |
| def | owncloud | oc_calendars | BASE TABLE | InnoDB | 10 | Dynamic | 39 | 420 | 16384 | 0 | 16384 | 0 | 69 | 2022-06-24 19:24:52 | NULL | NULL | utf8mb4_bin | NULL | | | 0 | N |
| def | owncloud | oc_music_ampache_users | BASE TABLE | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 16384 | 0 | 3 | 2022-06-24 19:24:52 | NULL | NULL | utf8mb4_bin | NULL | | | 0 | N |
| def | owncloud | oc_calendarchanges | BASE TABLE | InnoDB | 10 | Dynamic | 5796 | 87 | 507904 | 0 | 212992 | 0 | 5883 | 2022-06-24 19:24:53 | NULL | NULL | utf8mb4_bin | NULL | | | 0 | N |
| def | owncloud | oc_documents_session | BASE TABLE | InnoDB | 10 | Dynamic | 8 | 2048 | 16384 | 0 | 0 | 0 | NULL | 2022-06-24 19:24:53 | NULL | NULL | utf8mb4_bin | NULL | | | 0 | N |
| def | owncloud | oc_comments | BASE TABLE | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 65536 | 0 | 1 | 2022-06-24 19:24:53 | NULL | NULL | utf8mb4_bin | NULL | | | 0 | N |
| def | owncloud | oc_news_feeds | BASE TABLE | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 49152 | 0 | 2 | 2022-06-24 19:24:53 | NULL | NULL | utf8mb4_bin | NULL | | | 0 | N |
| def | owncloud | oc_dav_job_status | BASE TABLE | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 16384 | 0 | 1 | 2022-06-24 19:24:53 | NULL | NULL | utf8mb4_bin | NULL | | | 0 | N |
| def | owncloud | oc_trusted_servers | BASE TABLE | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 16384 | 0 | 1 | 2022-06-24 19:24:53 | NULL | NULL | utf8mb4_bin | NULL | | | 0 | N |
| def | owncloud | oc_persistent_locks | BASE TABLE | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 49152 | 0 | 1 | 2022-06-24 19:24:53 | NULL | NULL | utf8mb4_bin | NULL | | | 0 | N |
| def | owncloud | oc_users_external | BASE TABLE | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2022-06-24 19:24:53 | NULL | NULL | utf8mb4_bin | NULL | | | 0 | N |
| def | owncloud | oc_custom_group_member | BASE TABLE | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2022-06-07 09:37:45 | NULL | NULL | utf8mb4_bin | NULL | | | 0 | N |
| def | owncloud | oc_filecache | BASE TABLE | InnoDB | 10 | Dynamic | 3464060 | 281 | 975175680 | 0 | 914702336 | 0 | 19116728 | 2022-06-24 19:33:38 | NULL | NULL | utf8mb4_bin | NULL | | | 0 | N |
| def | owncloud | oc_music_playlists | BASE TABLE | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 0 | 0 | 1 | 2022-06-24 19:33:38 | NULL | NULL | utf8mb4_bin | NULL | | | 0 | N |
| def | owncloud | oc_bookmarks | BASE TABLE | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 0 | 0 | 1 | 2022-06-24 19:33:38 | NULL | NULL | utf8mb4_bin | NULL | | | 0 | N |
| def | owncloud | oc_music_playlist_tracks | BASE TABLE | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 16384 | 0 | NULL | 2022-06-10 16:31:05 | NULL | NULL | utf8_bin | NULL | | | 0 | N |
| def | owncloud | oc_privatedata | BASE TABLE | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 0 | 0 | 1 | 2022-06-24 19:33:38 | NULL | NULL | utf8mb4_bin | NULL | | | 0 | N |
| def | owncloud | oc_richdocuments_op | BASE TABLE | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 16384 | 0 | 2 | 2022-06-24 19:33:38 | NULL | NULL | utf8mb4_bin | NULL | | | 0 | N |
| def | owncloud | oc_ldap_group_members | BASE TABLE | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2022-06-24 19:33:39 | NULL | NULL | utf8mb4_bin | NULL | | | 0 | N |
| def | owncloud | oc_music_album_artists | BASE TABLE | InnoDB | 10 | Dynamic | 881 | 74 | 65536 | 0 | 49152 | 0 | NULL | 2022-06-10 16:31:05 | NULL | NULL | utf8_bin | NULL | | | 0 | N |
| def | owncloud | oc_richdocuments_revisions | BASE TABLE | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2022-06-24 19:33:39 | NULL | NULL | utf8mb4_bin | NULL | | | 0 | N |
| def | owncloud | oc_oc_filecache_5705662558e21 | BASE TABLE | InnoDB | 10 | Dynamic | 1048826 | 269 | 282869760 | 0 | 251985920 | 0 | 1269902 | 2022-06-24 19:36:05 | NULL | NULL | utf8mb4_bin | NULL | | | 0 | N |
| def | owncloud | oc_dav_shares | BASE TABLE | InnoDB | 10 | Dynamic | 20 | 819 | 16384 | 0 | 16384 | 0 | 51 | 2022-06-24 19:36:05 | NULL | NULL | utf8mb4_bin | NULL | | | 0 | N |
| def | owncloud | oc_preferences | BASE TABLE | InnoDB | 10 | Dynamic | 183 | 89 | 16384 | 0 | 0 | 0 | NULL | 2022-06-24 19:36:05 | NULL | NULL | utf8mb4_bin | NULL | | | 0 | N |
| def | owncloud | oc_notifications | BASE TABLE | InnoDB | 10 | Dynamic | 2 | 8192 | 16384 | 0 | 65536 | 0 | 6 | 2022-06-24 19:36:05 | NULL | NULL | utf8mb4_bin | NULL | | | 0 | N |
| def | owncloud | oc_ldap_group_mapping | BASE TABLE | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 16384 | 0 | NULL | 2022-06-24 19:36:05 | NULL | NULL | utf8mb4_bin | NULL | | | 0 | N |
| def | owncloud | oc_news_folders | BASE TABLE | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 32768 | 0 | 1 | 2022-06-24 19:36:05 | NULL | NULL | utf8mb4_bin | NULL | | | 0 | N |
| def | owncloud | oc_addressbookchanges | BASE TABLE | InnoDB | 10 | Dynamic | 203 | 80 | 16384 | 0 | 16384 | 0 | 204 | 2022-06-24 19:36:06 | NULL | NULL | utf8mb4_bin | NULL | | | 0 | N |
| def | owncloud | oc_systemtag_object_mapping | BASE TABLE | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2022-06-24 19:36:06 | NULL | NULL | utf8mb4_bin | NULL | | | 0 | N |
| def | owncloud | oc_storages | BASE TABLE | InnoDB | 10 | Dynamic | 216 | 227 | 49152 | 0 | 16384 | 0 | 283 | 2022-06-24 19:36:06 | NULL | NULL | utf8mb4_bin | NULL | | | 0 | N |
| def | owncloud | oc_music_artists | BASE TABLE | InnoDB | 10 | Dynamic | 521 | 125 | 65536 | 0 | 0 | 0 | 540 | 2022-06-24 19:36:06 | NULL | NULL | utf8mb4_bin | NULL | | | 0 | N |
| def | owncloud | oc_custom_group | BASE TABLE | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 16384 | 0 | 1 | 2022-06-07 09:37:45 | NULL | NULL | utf8mb4_bin | NULL | | | 0 | N |
| def | owncloud | oc_oc_filecache_84870ddfaf4ae | BASE TABLE | InnoDB | 10 | Dynamic | 950776 | 278 | 265027584 | 0 | 232046592 | 0 | 1269902 | 2022-06-24 19:38:21 | NULL | NULL | utf8mb4_bin | NULL | | | 0 | N |
| def | owncloud | oc_vcategory | BASE TABLE | InnoDB | 10 | Dynamic | 75 | 218 | 16384 | 0 | 49152 | 0 | 91 | 2022-06-24 19:38:21 | NULL | NULL | utf8mb4_bin | NULL | | | 0 | N |
| def | owncloud | oc_users | BASE TABLE | InnoDB | 10 | Dynamic | 9 | 1820 | 16384 | 0 | 0 | 0 | NULL | 2022-06-24 19:38:21 | NULL | NULL | utf8mb4_bin | NULL | | | 0 | N |
| def | owncloud | oc_files_trash | BASE TABLE | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 49152 | 0 | 33 | 2022-06-24 19:38:21 | NULL | NULL | utf8mb4_bin | NULL | | | 0 | N |
| def | owncloud | oc_appconfig | BASE TABLE | InnoDB | 10 | Dynamic | 252 | 65 | 16384 | 0 | 32768 | 0 | NULL | 2022-06-24 19:38:21 | 2022-06-24 23:39:10 | NULL | utf8mb4_bin | NULL | | | 0 | N |
| def | owncloud | oc_activity | BASE TABLE | InnoDB | 10 | Dynamic | 1751 | 907 | 1589248 | 0 | 409600 | 4194304 | 6029 | 2022-06-10 16:21:08 | NULL | NULL | utf8_bin | NULL | | | 0 | N |
| def | owncloud | oc_systemtag | BASE TABLE | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 16384 | 0 | 1 | 2022-06-10 16:51:40 | NULL | NULL | utf8_bin | NULL | | | 0 | N |
| def | owncloud | oc_comments_read_markers | BASE TABLE | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 16384 | 0 | NULL | 2022-06-10 16:21:11 | NULL | NULL | utf8_bin | NULL | | | 0 | N |
| def | owncloud | oc_file_locks | BASE TABLE | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 32768 | 0 | 1103284 | 2022-06-10 16:21:13 | NULL | NULL | utf8_bin | NULL | | | 0 | N |
| def | owncloud | oc_richdocuments_session | BASE TABLE | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2022-06-10 16:51:39 | NULL | NULL | utf8_bin | NULL | | | 0 | N |
| def | owncloud | oc_properties | BASE TABLE | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 16384 | 0 | 1 | 2022-06-10 16:51:39 | NULL | NULL | utf8_bin | NULL | | | 0 | N |
| def | owncloud | oc_cards_properties | BASE TABLE | InnoDB | 10 | Dynamic | 45 | 364 | 16384 | 0 | 65536 | 0 | 824 | 2022-06-10 16:21:11 | NULL | NULL | utf8_bin | NULL | | | 0 | N |
| def | owncloud | oc_groups | BASE TABLE | InnoDB | 10 | Dynamic | 11 | 1489 | 16384 | 0 | 0 | 0 | NULL | 2022-06-10 16:31:04 | NULL | NULL | utf8_bin | NULL | | | 0 | N |
| def | owncloud | oc_external_applicable | BASE TABLE | InnoDB | 10 | Dynamic | 23 | 712 | 16384 | 0 | 49152 | 0 | 107 | 2022-06-10 16:21:12 | NULL | NULL | utf8_bin | NULL | | | 0 | N |
| def | owncloud | oc_systemtag_group | BASE TABLE | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2022-06-10 16:51:40 | NULL | NULL | utf8_bin | NULL | | | 0 | N |
| def | owncloud | oc_lucene_status | BASE TABLE | InnoDB | 10 | Dynamic | 1807 | 45 | 81920 | 0 | 49152 | 0 | NULL | 2022-06-10 16:31:05 | NULL | NULL | utf8_bin | NULL | | | 0 | N |
| def | owncloud | oc_vcategory_to_object | BASE TABLE | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 16384 | 0 | NULL | 2022-06-10 16:51:41 | NULL | NULL | utf8_bin | NULL | | | 0 | N |
| def | owncloud | oc_authtoken | BASE TABLE | InnoDB | 10 | Dynamic | 24 | 682 | 16384 | 0 | 32768 | 0 | 104956 | 2022-06-10 16:21:09 | NULL | NULL | utf8_bin | NULL | | | 0 | N |
| def | owncloud | oc_external_mounts | BASE TABLE | InnoDB | 10 | Dynamic | 11 | 1489 | 16384 | 0 | 0 | 0 | 38 | 2022-06-10 16:21:12 | NULL | NULL | utf8_bin | NULL | | | 0 | N |
| def | owncloud | oc_share | BASE TABLE | InnoDB | 10 | Dynamic | 8 | 2048 | 16384 | 0 | 98304 | 0 | 45 | 2022-06-10 16:51:40 | NULL | NULL | utf8_bin | NULL | | | 0 | N |
| def | owncloud | oc_music_ampache_sessions | BASE TABLE | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 16384 | 0 | 1 | 2022-06-10 16:31:05 | NULL | NULL | utf8_bin | NULL | | | 0 | N |
| def | owncloud | oc_dav_properties | BASE TABLE | InnoDB | 10 | Dynamic | 45 | 364 | 16384 | 0 | 16384 | 0 | 46 | 2022-06-10 16:21:11 | NULL | NULL | utf8_bin | NULL | | | 0 | N |
| def | owncloud | oc_share_external | BASE TABLE | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 32768 | 0 | 1 | 2022-06-10 16:51:40 | NULL | NULL | utf8_bin | NULL | | | 0 | N |
| def | owncloud | oc_richdocuments_member | BASE TABLE | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 0 | 0 | 2 | 2022-06-10 16:51:39 | NULL | NULL | utf8_bin | NULL | | | 0 | N |
| def | owncloud | oc_richdocuments_wopi | BASE TABLE | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 16384 | 0 | 1 | 2022-06-10

16:51:39 | NULL | NULL | utf8_bin | NULL | | | 0 | N |
| def | owncloud | oc_music_albums | BASE TABLE | InnoDB | 10 | Dynamic | 881 | 92 | 81920 | 0 | 16384 | 0 | 904 | 2022-06-10 16:31:05 | NULL | NULL | utf8_bin | NULL | | | 0 | N |
| def | owncloud | oc_oc_filecache_48418b8d37405 | BASE TABLE | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 81920 | 0 | 1 | 2022-06-10 16:31:07 | NULL | NULL | utf8_bin | NULL | | | 0 | N |
| def | owncloud | oc_mimetypes | BASE TABLE | InnoDB | 10 | Dynamic | 122 | 134 | 16384 | 0 | 16384 | 0 | 128 | 2022-06-10 16:31:05 | NULL | NULL | utf8_bin | NULL | | | 0 | N |
| def | owncloud | oc_activity_mq | BASE TABLE | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 49152 | 0 | 1 | 2022-06-10 16:21:09 | NULL | NULL | utf8_bin | NULL | | | 0 | N |
| def | owncloud | oc_calendarobjects | BASE TABLE | InnoDB | 10 | Dynamic | 1528 | 1726 | 2637824 | 0 | 163840 | 4194304 | 2017 | 2022-06-10 16:21:10 | NULL | NULL | utf8_bin | NULL | | | 0 | N |
| def | owncloud | oc_account_terms | BASE TABLE | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 32768 | 0 | 1 | 2022-06-10 16:21:08 | NULL | NULL | utf8_bin | NULL | | | 0 | N |
| def | owncloud | oc_schedulingobjects | BASE TABLE | InnoDB | 10 | Dynamic | 7 | 2340 | 16384 | 0 | 0 | 0 | 10 | 2022-06-10 16:51:39 | NULL | NULL | utf8_bin | NULL | | | 0 | N |
| def | owncloud | oc_documents_invite | BASE TABLE | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2022-06-10 16:21:12 | NULL | NULL | utf8_bin | NULL | | | 0 | N |
| def | owncloud | oc_news_items | BASE TABLE | InnoDB | 10 | Dynamic | 4509 | 585 | 2637824 | 0 | 524288 | 4194304 | 4635 | 2022-06-10 16:31:06 | NULL | NULL | utf8_bin | NULL | | | 0 | N |
| def | owncloud | oc_shorten | BASE TABLE | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 0 | 0 | 1 | 2022-06-10 16:51:40 | NULL | NULL | utf8_bin | NULL | | | 0 | N |
| def | owncloud | oc_accounts | BASE TABLE | InnoDB | 10 | Dynamic | 9 | 1820 | 16384 | 0 | 65536 | 0 | 32 | 2022-06-10 16:21:08 | NULL | NULL | utf8_bin | NULL | | | 0 | N |
| def | owncloud | oc_addressbooks | BASE TABLE | InnoDB | 10 | Dynamic | 12 | 1365 | 16384 | 0 | 16384 | 0 | 25 | 2022-06-10 16:21:09 | NULL | NULL | utf8_bin | NULL | | | 0 | N |
| def | owncloud | oc_external_config | BASE TABLE | InnoDB | 10 | Dynamic | 63 | 260 | 16384 | 0 | 32768 | 0 | 219 | 2022-06-10 16:21:12 | NULL | NULL | utf8_bin | NULL | | | 0 | N |
| def | owncloud | oc_documents_revisions | BASE TABLE | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2022-06-10 16:21:12 | NULL | NULL | utf8_bin | NULL | | | 0 | N |
| def | owncloud | oc_music_tracks | BASE TABLE | InnoDB | 10 | Dynamic | 2300 | 99 | 229376 | 0 | 262144 | 0 | 2341 | 2022-06-10 16:31:06 | NULL | NULL | utf8_bin | NULL | | | 0 | N |
| def | owncloud | oc_mounts | BASE TABLE | InnoDB | 10 | Dynamic | 10 | 1638 | 16384 | 0 | 65536 | 0 | 597 | 2022-06-10 16:31:05 | NULL | NULL | utf8_bin | NULL | | | 0 | N |
| def | owncloud | oc_external_options | BASE TABLE | InnoDB | 10 | Dynamic | 65 | 252 | 16384 | 0 | 32768 | 0 | 174 | 2022-06-10 16:21:12 | NULL | NULL | utf8_bin | NULL | | | 0 | N |
| def | owncloud | oc_documents_member | BASE TABLE | InnoDB | 10 | Dynamic | 9 | 1820 | 16384 | 0 | 0 | 0 | 10 | 2022-06-10 16:21:12 | NULL | NULL | utf8_bin | NULL | | | 0 | N |
| def | owncloud | oc_richdocuments_invite | BASE TABLE | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2022-06-10 16:51:39 | NULL | NULL | utf8_bin | NULL | | | 0 | N |
| def | owncloud | oc_ldap_user_mapping | BASE TABLE | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 16384 | 0 | NULL | 2022-06-10 16:31:05 | NULL | NULL | utf8_bin | NULL | | | 0 | N |
| def | owncloud | oc_cards | BASE TABLE | InnoDB | 10 | Dynamic | 8 | 12288 | 98304 | 0 | 16384 | 0 | 41 | 2022-06-10 16:21:11 | NULL | NULL | utf8_bin | NULL | | | 0 | N |
| def | owncloud | oc_group_admin | BASE TABLE | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 16384 | 0 | NULL | 2022-06-10 16:31:04 | NULL | NULL | utf8_bin | NULL | | | 0 | N |
±--------------±-------------±------------------------------±-----------±-------±--------±-----------±-----------±---------------±------------±----------------±-------------±----------±---------------±--------------------±--------------------±-----------±----------------±---------±---------------±--------------±-----------------±----------+

At oc_activity the collate changed to utf8_bin which it was proir to the conversion attempt.

I also added to /etc.mysql/mariadb.conf.d/50-server.cnf the following that was suggested… still no joy.

Added 220625 - Trying to fix database callate issue

[mysql]
default-character-set=utf8mb4

this is only for the mysqld standalone daemon

Added 220625 - Trying to fix database callate issue

[mysqld]
collation-server = utf8mb4_unicode_ci
init-connect=‘SET NAMES utf8mb4’
character-set-server = utf8mb4

Not sure how to fix the database, doe sit no appear that the backup and import corrupted the database and I need to start over? The only data that is important to me is the users and the calendar.

Capnjb

Well, you did something, but not exactly what you were told to!

You have to create a script from the output of the command first.

  • Remove all the leading and trailing ‘|’ chars from the text.
  • Store it as SQL-script.
  • Run that script on your DB, but PLEASE DO ANOTHER BACKUP FIRST.

Example: Line

| ALTER TABLE owncloud.oc_group_user COLLATE utf8mb4_bin; |

from your dump becomes

ALTER TABLE owncloud.oc_group_user COLLATE utf8mb4_bin; 

which is an executable SQL statement.

I’ve done this for you, you can copy my script from here.

Good Luck!

DISCLAIMER: No Warranty, it’s your system, your risk.

1 Like