DB Error: "Index post-tag is corrupted"

[tek-aevl]

DB Error,

Index post-tag is corrupted

would turning it ("#tags") off and on again fix this it? LOL

[AlfredSK]

That's a very vague issue description. I can only guess that an index of that table is damaged.

If so, you can recreate the index by optimizing the table.

mysqloptimize dbname tablename

[tek-aevl]

Well, I attempted to do this, but I guess I am not sure how to via, shell...

[tek-aevl]

In mysql, or from cli?

[MrPetovan]

I think it is a CLI command. You may have to provide your database credentials by using the additional arguments -u <username> -p.

What is the original error message in full?

[tek-aevl]

I got this>
``SELECT cid FROM `post-tag` WHERE (`cid` =
This is in many of the DBerror logs, with a different ^ number, same limit of 1.

I thought I posted this yesterday, but it didn't post. I have many things going on, all at once, so sorry for the delay's.

[MrPetovan]

So from the MySQL console:
> OPTIMIZE `post-tag`;

From the command line:
$ mysqloptimize -u <username> -p <database> "post-tag"

[schmaker]

I can confirm it happened to me too. MariaDB optimize command fixed the issue.

[tek-aevl]

I am not seeing this error anymore, however I think my search for tags is now broken.

[tek-aevl]

So from the MySQL console: > OPTIMIZE `post-tag`;

From the command line: $ mysqloptimize -u <username> -p <database> 'post-tag'`

Seems to be working.
But this from the MySQL console: > OPTIMIZE TABLE 'post-tag';
to be exact.

[tek-aevl]

Aww, Found this again!!!

[tek-aevl]

Fixed.

[tek-aevl]

Thanks So much!