After Upgrading Mysql Table USER error

ℹ️ Support
1

Hello,

after upgrading from older versions to the lattest, checking database , the table :
user phplist_user_user
is red flagged.

How I can fix it

Thank you

2

You could try using PHPMyadmin and entering:

REPAIR TABLE phplist_user_user;
3

Thank you for your answer.
I have little experience with PHPMyadmin .
I don’t know were to put the command string.

4

This is just thrown together but it should work.
Copy the code below and paste it in a new file.
Edit lines 5-8 to have your information.
save the file as reptable.php
Upload it to your web server.
Browse to the file and it will automatically run. (http://www.mysite.com/reptable.php)
After a few seconds it will tell you to go see if it worked.
Don’t forget to delete the file from your web server when you’re done.

<?php

//    REPAIRS A BAD TABLE IN YOUR DATABASE

$servername = "mydomain.com";    //ENTER YOUR DOMAIN NAME
$username = "mydbusername";        //ENTER YOUR DATABASE USERNAME
$password = "mydbpassword";        //ENTER YOUR DATABASE PASSWORD
$dbname = "mydbname";            //ENTER YOUR DATABASE NAME

$conn = mysqli_connect($servername, $username, $password, $dbname);

if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
} else {
    $query = "REPAIR TABLE phplist_user_user;";
    mysqli_query($conn, $query);
    echo "Done<br />Go see if it worked";
    };
mysqli_close($conn);

?>
5

Thank you .
I tried but i didn’t work due to some server security configuration.
So I ask help to the server maintanance team.
I’m waitng for the response