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

Sitebuilder 4.0.0 Error: Undefined property defaultSiteFamilyId in object SB_ORM_Plan

Discussion in 'Sitebuilder 4.0 for Linux' started by isabel.estevao, Oct 4, 2007.

  1. isabel.estevao

    isabel.estevao Guest

    0
     
    Hi,

    The problem with locale table was broken links but I have another error when I try to access sitebuilder.

    Internal SiteBuilder error.
    File: /usr/local/sitebuilder/include/Base/ORM/Object.php; Line: 162
    Message: Undefined property defaultSiteFamilyId in object SB_ORM_Plan; Code: 0

    Any ideas?
     
  2. SibProgrammer

    SibProgrammer Regular Pleskian Staff Member

    29
     
    Joined:
    Nov 21, 2004
    Messages:
    342
    Likes Received:
    15
    Please provide the output of:
    select id from site_familia;

    And:
    select default_site_family_id from plan;

    Possible broken link is in the 'plan' table.
     
  3. isabel.estevao

    isabel.estevao Guest

    0
     
    I've received the following output :

    mysql> select id from site_familia;
    +----+
    | id |
    +----+
    | 1 |
    | 2 |
    | 3 |
    +----+

    mysql> select default_site_family_id from plan;

    ERROR 1054 (42S22): Unknown column 'default_site_family_id' in 'field list'
     
  4. isabel.estevao

    isabel.estevao Guest

    0
     
    Hi,

    I've just added the default_site_family_id field in plan table through the following sql command and it works.

    mysql> alter table plan ADD `default_site_family_id` int(11) default null;

    mysql> update plan set default_site_family_id = 1;

    After having fixed this error I've got the following error:

    Internal SiteBuilder error.
    File: /usr/local/sitebuilder/include/Zend/Zend/Db/Adapter/Abstract.php; Line: 156
    Message: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'sitebuilder3.plan_site_family' doesn't exist; Code: 42S02

    It seems that I do not have plan_site_family table.
    How this is possible? Any ideas?
     
  5. Dmitry Frantsev

    Dmitry Frantsev Golden Pleskian

    28
    57%
    Joined:
    Sep 19, 2005
    Messages:
    1,911
    Likes Received:
    0
    I'm posting my 'plan_site_family' table:

    CREATE TABLE `plan_site_family` (
    `id` int(11) NOT NULL auto_increment,
    `plan_id` int(11) NOT NULL default '0',
    `site_family_id` int(11) NOT NULL default '0',
    PRIMARY KEY (`id`),
    UNIQUE KEY `site_family_id_plan_id` (`site_family_id`,`plan_id`),
    KEY `plan_id` (`plan_id`),
    KEY `site_family_id` (`site_family_id`)
    ) ENGINE=MyISAM DEFAULT CHARSET=utf8;


    INSERT INTO `plan_site_family` VALUES (1,1,1),(2,1,2),(3,1,3),(4,2,1),(5,2,2),(6,2,3),(7,3,1),(8,3,2),(9,3,3),(10,4,1),(11,4,2),(12,4,3),(
    13,5,1),(14,5,2),(15,5,3),(16,6,1),(17,6,2),(18,6,3),(19,7,1),(20,7,2),(21,7,3),(22,8,1),(23,8,2),(24,8,3),(25,9,1),(26,9,2),(27,9,3),(28,
    10,1),(29,10,2),(30,10,3),(31,11,1),(32,11,2),(33,11,3),(34,12,1),(35,12,2),(36,12,3),(37,13,1),(38,13,2),(39,13,3),(40,14,1),(41,14,2),(4
    2,14,3),(43,15,1),(44,15,2),(45,15,3),(46,16,1),(47,16,2),(48,16,3),(49,17,1),(50,17,2),(51,17,3),(52,18,1),(53,18,2),(54,18,3),(55,19,1),
    (56,19,2),(57,19,3),(58,20,1),(59,20,2),(60,20,3),(61,21,1),(62,21,2),(63,21,3),(64,22,1),(65,22,2),(66,22,3),(67,23,1),(68,23,2),(69,23,3
    ),(78,26,3),(77,26,2),(76,26,1);

    If this is fresh installation and you do not have sites on it, it is better to re-install Sitebuilder to make sure that everything created correctly.
     
  6. SibProgrammer

    SibProgrammer Regular Pleskian Staff Member

    29
     
    Joined:
    Nov 21, 2004
    Messages:
    342
    Likes Received:
    15
    Guys! This is a wrong way! As I can see, your upgrade of the database has been failed. So you must repeat the upgrade. Don't perform manual alterations of SB database.
     
Loading...