SQLSTATE[HY000]

Justman10000

Hi, I wanted to set up Flarum again, but all I get is this:

Something went wrong: SQLSTATE[HY000]: General error: 130 Incorrect file format 'column_stats' (SQL: ALTER TABLE flarum_flags CHANGE time created_at DATETIME NOT NULL)

datlechin

Justman10000 General error: 130 Incorrect file format

Like this message

datlechin

What is your MySQL version?

Justman10000

datlechin

Server version: 10.5.15-MariaDB-0+deb11u1 Debian 11

Justman10000

@datlechin @luceos

Help

clarkwinkelmann

From this StackOverflow question it looks like it could be a broken table or index? https://stackoverflow.com/questions/4297592/how-to-fix-error-130-hy000-incorrect-file-format

You could try the repair SQL command as described in the thread.

However if it's a new install you could just drop the entire database and start from scratch. Did you already try multiple times?

Justman10000

clarkwinkelmann

Well, I already found out about the repair! It's kind of stupid! Repeatedly resetup the database tables brings the same error, it could work with Repair, but since the tables are always created again instead of checking whether they already exist, I always have to resetup the database tables, which achieves the effect described above!

clarkwinkelmann

What hosting are you using? You might want to contact their support. Maybe you have a faulty disk that corrupts the database regularly?

Justman10000

clarkwinkelmann

I virtualized Linux Debian 11 on my home PC... It runs on it

Justman10000

@datlechin @clarkwinkelmann

Lol? Now I have this:

Server version: 10.9.0-MDEV-20119-misc-MariaDB MariaDB Server

And it working easy? LOL?

datlechin

Justman10000 maybe the Server version: 10.5.15-MariaDB-0+deb11u1 Debian 11 version that not supported something like file format...

Justman10000

datlechin

File format?