1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

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

Discussion in 'Plesk for Linux - 8.x and Older' started by arazas, Mar 19, 2007.

  1. arazas

    arazas Guest

    0
     
    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.
     
  2. simpliq_adi

    simpliq_adi Guest

    0
     
    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.
     
Loading...