Upgrade Failed Table 'psa.NewsArticles' doesn't exist

[arazas]

I upgraded 7.5.4 to 8.0 bu its failed. Now when I login to Plesk it shows following error:

RROR: PleskMainDBException
MySQL query failed: Table 'psa.NewsArticles' doesn't exist

0: /usr/local/psa/admin/plib/common_func.php3:229
db_query(string 'select id, class, data from NewsArticles where id > 0 order by id')
1: /usr/local/psa/admin/plib/news/NewsManager.php:57
NewsManager->getArticles(integer '0')
2: /usr/local/psa/admin/plib/news/NewsManager.php:35
NewsManager->getNewArticles()
3: /usr/local/psa/admin/plib/class.Form.php:330
Form->assign()
4: /usr/local/psa/admin/plib/dashboard/DashboardForm.php:100
DashboardForm->assign(array, object of type UserAdmin)
5: /usr/local/psa/admin/plib/dashboard/DashboardLocation.php:56
DashboardLocation->access(string 'GET')
6: /usr/local/psa/admin/plib/UIPointer.php:423
UIPointer->access(string 'GET')
7: /usr/local/psa/admin/htdocs/plesk.php:14



and all my websites are redirecting to Sitebuilder page. Could you help me to fix the issues.

Why websites are responding to Sitebuilder page.

 

[simpliq_adi]

Hello,

Try to create manually that table, bellow is table structure from my server:

-- Table structure for table `NewsArticles`
--

DROP TABLE IF EXISTS `NewsArticles`;
CREATE TABLE `NewsArticles` (
`id` int(10) unsigned NOT NULL auto_increment,
`class` varchar(255) character set ascii collate ascii_bin NOT NULL default '',
`data` blob,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `NewsArticles`
--


/*!40000 ALTER TABLE `NewsArticles` DISABLE KEYS */;
LOCK TABLES `NewsArticles` WRITE;
INSERT INTO `NewsArticles` VALUES (1,'WhatsNew800',NULL);
UNLOCK TABLES;
/*!40000 ALTER TABLE `NewsArticles` ENABLE KEYS */;

Try to ran

/usr/local/psa/admin/sbin/websrvmng -av

this should fix that sitebuilder page issue.