Errcode: 2 ?

[axa]

Don't know what caused it, but now when attempting to access my board i get the following error

File '.\rezi\yabbse_attachments.MYD' not found (Errcode: 2)

any ideas?

[axa]

could the webhost have changed something to screw this up?

[Oldiesmann]

Basically, that means it can't find the MySQL data file for the yabbse_attachments table. You should probably talk to your host about this.

[axa]

thanks, my host is being very quick with fixing this... the darn thing was working perfectly last night.

[axa]

any ideas why my webhost says that he's tested it and everything works perfectly....

yet none of my users are able to get into it.

thanks?

[axa]

so now he thinks the database is corrupted...

crap.

is there anyway I can fix that?

[[Unknown]]

I'm afraid that's exactly what the error message means :/.  This is not a common error, nor anything SMF should have caused.

-[Unknown]

[axa]

yah, thats what im afraid of

i posted a separate thread regarding this question..

is there anyway I can recreate this table in myphpadmin?

do you think my db was hacked into?

[[Unknown]]

is there anyway I can recreate this table in myphpadmin?

Yes, but I hope you don't expect to keep your attachments :/.... try:

TRUNCATE TABLE yabbse_attachments;

What is phpMyAdmin?

do you think my db was hacked into?

No, but it's possible the server was.  MySQL, alone, shouldn't be able to CAUSE the error you're getting without other problems ocurring.

-[Unknown]

[axa]

yah, i dont care about the attachments... i backed them up already anyway...

so where do i try and use that command?

i know some things, but i have no experience with myphpadmin---
im browsing the messages table now to try and pull out setlist information

i really appreciate the help

[[Unknown]]

yah, i dont care about the attachments... i backed them up already anyway...

so where do i try and use that command?

i know some things, but i have no experience with myphpadmin---
im browsing the messages table now to try and pull out setlist information

i really appreciate the help

Please follow the link I posted above, which is there to answer such questions.

-[Unknown]

[axa]

okay i deleted the yabbse_attachments table..

now what is the SQL command to create the table?

i tried CREATE TABLE yabbse_attachments;

but there must be more to it cause i dont have any columns defined

[axa]

alright,

I ran

CREATE TABLE yabbse_attachments (
  ID_ATTACH int(11) unsigned NOT NULL auto_increment,
  ID_MSG int(10) unsigned NOT NULL default '0',
  ID_MEMBER int(10) unsigned NOT NULL default '0',
  filename tinytext NOT NULL default '',
  size int(10) unsigned NOT NULL default '0',
  downloads mediumint( unsigned NOT NULL default '0',
  PRIMARY KEY (ID_ATTACH),
  UNIQUE ID_MEMBER (ID_MEMBER, ID_ATTACH),
  KEY ID_MSG (ID_MSG)
)

and it appears to have fixed itself.

thank you