Ask your WordPress questions! Pay money and get answers fast! (more info)

Cannot login, error appearing on site

Hi I'm getting the following error on the wp web site and I cannot seem to login to the back end or recover my password.

WordPress database error: [Table 'eionb_arvnew.wp_users' doesn't exist]
SELECT * FROM wp_users WHERE ID = '1'

Any thoughts?

Best wishes
Eoin

Answers (4)

2015-06-05

Arnav Joy answers:

have you updated theme or did something?


Eoin comments:

no nothing

2015-06-05

Hariprasad answers:

Hi,

Check your database prefix. Make sure it is "wp_".

What change you recently did in wp site?


Eoin comments:

ok - but can't login


Hariprasad comments:

Login to your phpmyadmin to ccheck it. or just check wp-config.php for the $table_prefix.

/* MySQL database table prefix. */
$table_prefix = 'wp_';

2015-06-05

mattp answers:

You may have a corrupted database. Have you got a backup of you database at all? If you have got a backup of the database I would recommend that you try replacing it with the backup copy.


Eoin comments:

not sure I'll check :(

2015-06-05

Shoeb mirza answers:

You need repairing the database...


Log in to your phpMyAdmin:

https://www.yourdomain/phpMyAdmin/index.php

Go to Databases

https://www.yourdomain/phpMyAdmin/server_databases.php

Click on your data base

Check all

At the bottom right drop down click on repair database


Eoin comments:

Thanks - I'll try!


Eoin comments:

Tried it but no joy.