Database access problems


#1

Hello,

yesterday i opend a topic related to LDAP App installation. Today i treid to install external storage support app and i got an identical (more or less) message.
"An exception occurred while executing 'CREATE TABLE oc_external_mounts (mount_id BIGINT AUTO_INCREMENT NOT NULL, mount_point VARCHAR(128) NOT NULL, storage_backend VARCHAR(64) NOT NULL, auth_backend VARCHAR(64) NOT NULL, priority INT DEFAULT 100 NOT NULL, type INT NOT NULL, PRIMARY KEY(mount_id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_bin ENGINE = InnoDB': SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'oc_external_mounts' already exists"

I guess this is a database access problem, but i am far from being an expert. Can someone translate this message into human language for me ?

It reads like the db-table already exits. How can i check/delete this in MariaDB-Client ? Unfortunately i am not familiar to SQL :frowning:

Hello,
if i try to install the official LDAP app i get the following error message:
"An exception occurred while executing 'CREATE TABLE oc_ldap_user_mapping (ldap_dn VARCHAR(255) DEFAULT '' NOT NULL, owncloud_name VARCHAR(255) DEFAULT '' NOT NULL, directory_uuid VARCHAR(255) DEFAULT '' NOT NULL, UNIQUE INDEX ldap_dn_users (ldap_dn), PRIMARY KEY(owncloud_name)) DEFAULT CHARACTER SET utf8 COLLATE utf8_bin ENGINE = InnoDB': SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'oc_ldap_user_mapping' already exists"

Server configuration
Operating system: SLES 12 SP2
Web server: apache2.4
Database: MariaDB
PHP version: 5.5
ownCloud version (see ownCloud admin page): 9.1
Updated from an older ownCloud or fresh install: fresh install
Special configuration (external storage, external authentication, reverse proxy, server-side-encryption): nothing known to me

Any help is appreciated.


#2

Please report such issues always directly to the developers at [1]. You might also find some existing threads there.

[1]