Kilandor

Pzt, 27 Tem 2009 23:12:41 -0000

Is a problem with your SQL server. I would have suggested check/repair from phpmyadmin.

Sounds like something happened and it became corrupt.

Try selecting all the tables and check, and if any error's repair. I'm guessing PM doesn't show still. So as far as I know your only solution will be to contact your webhost, as the problem isn't with cotonti or the query.

The problem is its trying to save the table but for some reason it can't create/write too the file it needs (likely a permission problem or something of the sorts).

biro

Pzt, 27 Tem 2009 22:17:51 -0000

got an error at the begining saying PM table damaged and should be fixed i removed it and when i try to run this query

CREATE TABLE `sed_pm` (
  `pm_id` int(11) unsigned NOT NULL auto_increment,
  `pm_state` tinyint(2) NOT NULL default '0',
  `pm_date` int(11) NOT NULL default '0',
  `pm_fromuserid` int(11) NOT NULL default '0',
  `pm_fromuser` varchar(100) collate utf8_unicode_ci NOT NULL,
  `pm_touserid` int(11) NOT NULL default '0',
  `pm_title` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `pm_text` text collate utf8_unicode_ci NOT NULL,
  `pm_html` text collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`pm_id`),
  KEY `pm_fromuserid` (`pm_fromuserid`),
  KEY `pm_touserid` (`pm_touserid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

i get Error writing file './a3392578_1/sed_pm.frm' (Errcode: 28)

cotonti.com : CRTICAL

Kilandor

biro