Thứ Năm, 2 tháng 6, 2011

DB function failed with error number 145

1 – Go to MySQL PhpMyadmin Control Panel
FIRST OF ALL : MAKE PROPER BACKUP OF YOUR DATABASE !!!!
2 – Go and click on “SQL” near the top left corner of the page, and paste the following lines (below) into the empty text area :
DROP TABLE IF EXISTS `jos_session`;
CREATE TABLE `jos_session` (
`username` varchar(150) default ”,
`time` varchar(14) default ”,
`session_id` varchar(200) NOT NULL default ’0′,
`guest` tinyint(4) default ’1′,
`userid` int(11) default ’0′,
`usertype` varchar(50) default ”,
`gid` tinyint(3) unsigned NOT NULL default ’0′,
`client_id` tinyint(3) unsigned NOT NULL default ’0′,
`data` longtext,
PRIMARY KEY (`session_id`(64)),
KEY `whosonline` (`guest`,`usertype`),
KEY `userid` (`userid`),
KEY `time` (`time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
3 – Click on “Execute” or “Go” to execute the command.
Finally, come back to you site and that’s it !
Have a nice day !

Không có nhận xét nào:

Đăng nhận xét