vBulletin 3.x Table 'forum.vbseo_serviceupdate' doesn't exist

[nypua]

Database error in vBulletin 3.8.6:

Invalid SQL:
INSERT INTO vbseo_serviceupdate
(s_threadid, s_updated)
VALUES
('29253', 0);

MySQL Error   : Table 'forum.vbseo_serviceupdate' doesn't exist
Error Number  : 1146
Request Date  : Thursday, December 16th 2010 @ 01:36:30 AM
Error Date    : Thursday, December 16th 2010 @ 01:36:30 AM
Script        : http://i-max.vn/forum/newthread.php?do=postthread&f=47
Referrer      : http://i-max.vn/forum/newthread.php?do=newthread&f=47
IP Address    : 222.255.237.60
Username      : Lion
Classname     : vB_Database
MySQL Version : 5.1.53-enterprise-gpl-pro

Please help me fix, i've reinstall 2 many times but can't fix my problem.
Im use: "vBSEO 3.5.2 + vBSEO Search Engine XML Sitemap 3.0 Gold Released"

[Oleg Ignatiuk]

Hello,

please try to reinstall vBSEO xml product file in vB admincp.

[nypua]

Hello,

please try to reinstall vBSEO xml product file in vB admincp.

Hi,
Yes! I do, but it can't fix my problem.

[nypua]

I try to make table manual, but i got this:

[Err] 1005 - Can't create table 'forum.vbseo_serviceupdate' (errno: 121)
[Err] CREATE TABLE `vbseo_serviceupdate` (
  `s_threadid` int(10) NOT NULL,
  `s_updated` tinyint(4) NOT NULL DEFAULT '0',
  `s_dateline` int(10) NOT NULL,
  `s_type` tinyint(4) NOT NULL DEFAULT '0',
  KEY `s_updated` (`s_updated`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
[Msg] Finished - Unsuccessfully
--------------------------------------------------

[Oleg Ignatiuk]

Please open a ticket with ftp/admincp access for troubleshooting.

[nypua]

Thank for your help, i've fix it!
Make new forum install with vbSEO, go to MySQL data folder copy file vbseo_serviceupdate.frm to forum MySQL data folder. Then use phpMyadmin to drop vbseo_serviceupdate table and reinstall vbSEO again.

[Oleg Ignatiuk]

I'm glad you got it working!