https://bugs.kde.org/show_bug.cgi?id=451153

--- Comment #19 from bugskde...@goland.org ---
(In reply to Maik Qualmann from comment #18)
> Try running the following commands in the database (mysql) if it works
> normally:
> 
> USE digikam;
> CREATE TABLE IF NOT EXISTS PrivCheck (id INT) ENGINE InnoDB;
> DROP TABLE PrivCheck;
> 
> Maik

MariaDB [(none)]> USE digikam;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
MariaDB [digikam]> CREATE TABLE IF NOT EXISTS PrivCheck (id INT) ENGINE InnoDB;
ERROR 1813 (HY000): Tablespace for table '`digikam`.`PrivCheck`' exists. Please
DISCARD the tablespace before IMPORT
MariaDB [digikam]> DROP TABLE PrivCheck;
ERROR 1051 (42S02): Unknown table 'digikam.PrivCheck'
MariaDB [digikam]> 

So I tried:
MariaDB [digikam]> ALTER TABLE PrivCheck DISCARD TABLESPACE;
ERROR 1146 (42S02): Table 'digikam.PrivCheck' doesn't exist
MariaDB [digikam]> CREATE TABLE IF NOT EXISTS PrivCheck (id INT) ENGINE InnoDB;
ERROR 1813 (HY000): Tablespace for table '`digikam`.`PrivCheck`' exists. Please
DISCARD the tablespace before IMPORT

But that didn't seem to do anything either.

Thoughts?

-- 
You are receiving this mail because:
You are watching all bug changes.

Reply via email to