PDA

View Full Version : mysql error after restore


xtremeathlonxp
05-02-2003, 06:19 PM
I restored my site to the new server and here is the error I get

Database error in vBulletin :

Invalid SQL: SELECT template FROM template WHERE title='options'
mysql error: Can't find file: 'template.MYD' (errno: 2)

mysql error number: 1017

Date: Friday 02nd of May 2003 02:13:23 PM
Script: /
Referer:

grog6
05-02-2003, 06:31 PM
The table template is not in your database ;)

xtremeathlonxp
05-02-2003, 06:49 PM
template.myd is there and in the datatbase the table is there but when I open it says:
SQL desc `template` failed : Can't find file: 'template.MYD' (errno: 2)

filburt1
05-02-2003, 07:11 PM
Run the query:

REPAIR TABLE template;

xtremeathlonxp
05-02-2003, 08:10 PM
query gives no file error

filburt1
05-02-2003, 08:13 PM
Then ask your host for help.

xtremeathlonxp
05-02-2003, 08:24 PM
I am the host running this thing. I can't figure it out

Black Vivi
05-02-2003, 09:35 PM
have u tried the repair.php file in the extras with vB?
that tells you the error, if any.

xtremeathlonxp
05-02-2003, 10:20 PM
yes I get the same error

xtremeathlonxp
05-03-2003, 02:23 AM
its fixed now anyone know what version of php comes with gd2

filburt1
05-03-2003, 01:46 PM
4.3.0 and later.

xtremeathlonxp
05-03-2003, 01:55 PM
Thanks filburt1

BlackDeath
06-01-2003, 05:02 AM
this is the error im getting as well. can u tell me what you did to fix it? mine gets fixed but then a week later screws up again.

Erwin
06-01-2003, 05:57 AM
Can't find file: 'template.MYD'

You haven't uploaded the template table, or it's missing.

BlackDeath
06-01-2003, 07:25 AM
my error says thread.myd. its running ok now. we'll see how it goes.....if it messes up again, ill post the error.