Page 1 of 1

Users table missing error

Posted: Sun Apr 27, 2008 10:33 am
by ab9db
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.

Re: Users table missing error

Posted: Sun Apr 27, 2008 10:34 am
by karlsemple
Is the table actually present in the database is your browse using phpmyadmin?

Re: Users table missing error

Posted: Sun Apr 27, 2008 10:39 am
by ab9db
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'

Re: Users table missing error

Posted: Sun Apr 27, 2008 10:41 am
by karlsemple
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.

Re: Users table missing error

Posted: Sun Apr 27, 2008 10:44 am
by ab9db
No I haven't accessed it at all recently, I guess a backup database is needed to repair this?

Re: Users table missing error

Posted: Sun Apr 27, 2008 10:47 am
by karlsemple
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?

Re: Users table missing error

Posted: Sun Apr 27, 2008 10:51 am
by ab9db
How many tables should there be?

Is it 96?

Re: Users table missing error

Posted: Sun Apr 27, 2008 10:54 am
by karlsemple
I am sure it is something like 62....

Re: Users table missing error

Posted: Sun Apr 27, 2008 10:59 am
by ab9db
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. :cry:

Re: Users table missing error

Posted: Sun Apr 27, 2008 11:01 am
by karlsemple
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. :cry:

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.

Re: Users table missing error

Posted: Sun Apr 27, 2008 11:04 am
by ab9db
Support ticket requested at hosts, thanks for the rapid response

Cheers

Darren

Re: Users table missing error

Posted: Sun Apr 27, 2008 11:06 am
by ab9db
Server crash at fault,

Hosts are dealing with issue.

Thanks
Darren

Re: Users table missing error

Posted: Sun Apr 27, 2008 11:07 am
by karlsemple
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 :)