search

nextcloud / polls

🗳️ Polls app for Nextcloud
https://apps.nextcloud.com/apps/polls
GNU Affero General Public License v3.0
252 stars 73 forks source link

Error SQL when try to activate the Polls Plugins on Nextcloud 20 #1545

Closed shadowmedicis closed 3 years ago

shadowmedicis commented 3 years ago

What is going wrong?

When you download and activate the Polls plugin from the applications available on the Nextcloud. An error is displayed and the application cannot be launched

To Reproduce Steps to reproduce the behavior:

  1. Go to 'Applications'
  2. Click on 'Organisation Catégorie'
  3. Scroll down to 'Polls'
  4. Click On "Download and activate"
  5. See error

Screenshots SQL_error_plugin_Polls SQL_error_plugin_Polls2

Information about your polls installation

1.8.1

Fresh installation or update from a prior version (from which one)? Fresh install from store

How did you install this version?(Appstore or describe installation) Appstore version

Information about your Instance of Nextcloud

**Nextcloud version: 20.0.9 (Recently upgrade from 15, 16, 17,18,19 Nextcloud version)

List of activated apps: Enabled:

Nextcloud configuration: "system": { "instanceid": "REMOVED SENSITIVE VALUE", "passwordsalt": "REMOVED SENSITIVE VALUE", "secret": "REMOVED SENSITIVE VALUE", "trusted_domains": [ "REMOVED SENSITIVE VALUE" ], "datadirectory": "REMOVED SENSITIVE VALUE", "overwrite.cli.url": "REMOVED SENSITIVE VALUE", "dbtype": "mysql", "version": "20.0.9.1", "default_language": "fr", "defaultapp": "files", "auth.bruteforce.protection.enabled": true, "logtimezone": "UTC", "installed": true, "memcache.local": "\OC\Memcache\APCu", "mail_smtpmode": "smtp", "mail_from_address": "REMOVED SENSITIVE VALUE", "mail_domain": "REMOVED SENSITIVE VALUE", "mail_smtpport": "25", "mail_smtphost": "REMOVED SENSITIVE VALUE", "ldapIgnoreNamingRules": false, "ldapProviderFactory": "\OCA\User_LDAP\LDAPProviderFactory", "logfile": "\/var\/log\/nextcloud.log", "loglevel": 1, "maintenance": false, "theme": "", "updater.release.channel": "stable", "dbname": "REMOVED SENSITIVE VALUE", "dbhost": "REMOVED SENSITIVE VALUE", "dbuser": "REMOVED SENSITIVE VALUE", "dbpassword": "REMOVED SENSITIVE VALUE", "mysql.utf8mb4": true, "encryption.legacy_format_support": false, "encryption.key_storage_migrated": false, "mail_sendmailmode": "smtp" } }

Server configuration

**Database: MariaDB version "10.1.47-MariaDB-0ubuntu0.18.04.1" is used

**PHP version: php7.4-fpm

**Are you using an external user-backend, if yes which one: Yes, LDAPS Intégration (port 636)

Client configuration

Browser: Microsoft Edge 89.0.774.68 (Version officielle) (64 bits)

Logs

Nextcloud log (data/nextcloud.log)

nextcloud_log_croped.log

dartcafe commented 3 years ago

Check your database configuration and switch to innodb_file_format = Barracuda and innodb_large_prefix=ON which is the default. See also #1375

dartcafe commented 3 years ago

Additionally see https://docs.nextcloud.com/server/latest/admin_manual/configuration_database/linux_database_configuration.html

dartcafe commented 3 years ago

You should also consider updating to mariaDB 10.2, because 10.1 is deprecated from NC 21 on. See: https://docs.nextcloud.com/server/20/admin_manual/installation/system_requirements.html

shadowmedicis commented 3 years ago

Hello dartcafe,

Indeed I have just modified the innodb configuration of the nextcloud database. It worked !! Yes I will plan this upgrade Thank you very much for your help and quick response.

Have a good day

github-actions[bot] commented 2 months ago

This thread has been automatically locked since there has not been any recent activity after it was closed. Please open a new issue for related bugs.