Sitebuilder 4.0.0 Error: Undefined property defaultSiteFamilyId in object SB_ORM_Plan

[isabel.estevao]

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?

 

[SibProgrammer]

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.

 

[isabel.estevao]

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'

 

[isabel.estevao]

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?

 

[Dmitry Frantsev]

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.

 

[SibProgrammer]

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.