The database is not ready for Media Cleaner. The scan will not work

  • Resolved Hedo

    (@hedo)


    6 years, 6 months ago

    Hello, when I try in localhost to start the reset in the mysql log, I get this error.

    I am using XAMMP 7.2.5.

    2018-06-04 16:30:42 37440 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2018-06-04 16:30:42 37440 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).

    I was interested in the PRO version of your plugin but I have doubts that it can work in localhost by having this error.

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author Jordy Meow

    (@tigroumeow)

    6 years, 6 months ago

    Hi,

    Actually, it’s not really an issue with the plugin, it seems more like a MySQL old bug (but why do you have it now?). I also have never heard of this issue from any of my users. Are you maybe also running Apache/MySQL on Windows?

    Just a guess, but you could open the core.php file of my plugin, look for references to “VARCHAR” and replace them by “VARBINARY”. I have no idea why it would work but the error message is cryptic. Who knows, that might help… and my plugin would work anyway. But it shouldn’t be that, technically, it should really be a VARCHAR.

    Thread Starter Hedo

    (@hedo)

    6 years, 6 months ago

    yes, i’m using mysql (with xammp) on win10.

    I try to make the fix you indicated to me

    Plugin Author Jordy Meow

    (@tigroumeow)

    6 years, 6 months ago

    Seems like this could happen on Windows, yeah. If this fix works for you, I will actually modify the plugin this way, I checked and it’s fine to do so 🙂

    Thread Starter Hedo

    (@hedo)

    6 years, 6 months ago

    unfortunately it does not work, it keeps giving me the same error in the log 🙁

    Plugin Author Jordy Meow

    (@tigroumeow)

    6 years, 6 months ago

    Unfortunately, that’s too tricky 🙁 There is no error in the current code to create the tables in the DB, for sure.

    You could try to install the plugin on a live install, with a real hosting service, I am pretty sure you wouldn’t have this issue. You local install has a little issue, and it would be nice to know why… but I am not a MySQL expert, I know how to use it, but this kind of error is difficult to understand, especially that I cannot reproduce it 🙁

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘The database is not ready for Media Cleaner. The scan will not work’ is closed to new replies.