Users table missing error

ab9db · Post by **ab9db** » Sun Apr 27, 2008 10:33 am

The following is the basic SRT
Your board's URL: http://www.arsenal-land.co.uk/forum
Version of phpBB3:
Was this a fresh install or a(n) update/upgrade/conversion (please be specific)? Updated from phpBB 3 beta releases via phpBB 2 upgrade
Was this an install through your host? No
MODs you have installed: None
When the problem started: Today (27-04-08)

Additionally, you may wish to provide the following (where applicable)
Template(s) used: Default
Language(s) used: English
Version of PHP used: 5.2.5
Database and version used:

SQL ERROR [ mysql4 ]

Table 'arseland_phpBB3.phpbb_users' doesn't exist [1146]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.

karlsemple · Post by **karlsemple** » Sun Apr 27, 2008 10:34 am

Is the table actually present in the database is your browse using phpmyadmin?

ab9db · Post by **ab9db** » Sun Apr 27, 2008 10:39 am

No it doesn't appear to be there, there are 56 tables listed though which I believe is the correct number?

Two tables list 'users' in the name, '_acl_users' and '_user_group'

karlsemple · Post by **karlsemple** » Sun Apr 27, 2008 10:41 am

ab9db wrote:No it doesn't appear to be there, there are 56 tables listed though which I believe is the correct number?

Two tables list 'users' in the name, '_acl_users' and '_user_group'

There should be more tables than that, have you restored a database backup at some point? Have you been messing the database for any reason.

ab9db · Post by **ab9db** » Sun Apr 27, 2008 10:44 am

No I haven't accessed it at all recently, I guess a backup database is needed to repair this?

karlsemple · Post by **karlsemple** » Sun Apr 27, 2008 10:47 am

ab9db wrote:No I haven't accessed it at all recently, I guess a backup database is needed to repair this?

Well yes if you have a valid recent database backup, the question though is how did half of your database go missing?

ab9db · Post by **ab9db** » Sun Apr 27, 2008 10:51 am

How many tables should there be?

Is it 96?

karlsemple · Post by **karlsemple** » Sun Apr 27, 2008 10:54 am

I am sure it is something like 62....

ab9db · Post by **ab9db** » Sun Apr 27, 2008 10:59 am

Ow not quite half then, it seems my other site databases are corrupted/affected too.

www.arsenal-land.co.uk

Including the main site CMS.

karlsemple · Post by **karlsemple** » Sun Apr 27, 2008 11:01 am

ab9db wrote:Ow not quite half then, it seems my other site databases are corrupted/affected too.

http://www.arsenal-land.co.uk

Including the main site CMS.

if you are missing the users table it might as well be all of them..... check with the host to make sure the server has not been compromised in some way.

ab9db · Post by **ab9db** » Sun Apr 27, 2008 11:04 am

Support ticket requested at hosts, thanks for the rapid response

Cheers

Darren

ab9db · Post by **ab9db** » Sun Apr 27, 2008 11:06 am

Server crash at fault,

Hosts are dealing with issue.

Thanks
Darren

karlsemple · Post by **karlsemple** » Sun Apr 27, 2008 11:07 am

ab9db wrote:Server crash at fault,

Hosts are dealing with issue.

Thanks
Darren

glad you got a response from them as to what the issue is, I hope now that your hosts have a raid configuration and make regular backups so they can restore your data as it should be

advertisements