Advertisement:

anyway to recreate "yabbse_attachments" table in myphpadmin?

Aloittaja axa, maaliskuu 09, 2005, 01:50:55 IP

« edellinen - seuraava »

axa

im not too familiar with myphpadmin but it appears my yabbse db is broken because this table is missing.

when attempting to access the database i get the following error

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



So I am in myphpadmin and when going to this table i get.


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

Error

SQL-query : 

SHOW FIELDS FROM `yabbse_attachments` FROM `rezi`

MySQL said:


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



Is there anyway I can (i dont know) recreate this table or something to fix this issue?

I apologize im not super familiar with myphpadmin

any help will be greatly appreciated

axa

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(8) unsigned NOT NULL default '0',
  PRIMARY KEY (ID_ATTACH),
  UNIQUE ID_MEMBER (ID_MEMBER, ID_ATTACH),
  KEY ID_MSG (ID_MSG)
)

Advertisement: