Article ID: 6052, created on Feb 18, 2009, last review on Aug 12, 2014

  • Applies to:
  • Plesk Sitebuilder 4.2 for Linux/Unix

Symptoms

Parallels Plesk Sitebuilder has been upgraded to 4.2 from an older version and the application looks well after upgrade. However the following error is shown when try to publish a site:

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.wysiwyg_image' doesn't exist; Code: 42S02

Resolution

Complete upgrading of Parallels Plesk Sitebuilder as advised in this article: http://kb.sp.parallels.com/en/5472. 

If the problem still persists, the tables should be created manually. During upgrading procedure creation of tables wysiwyg_image and wysiwyg_crop_image failed because of inconvenient content of table sitebuilder3.task.
The problem has been fixed in upgrading procedure since version 4.5.

To fix the issue for Parallels Plesk Sitebuilder version 4.2.x you may create the tables manually. To create the tables you should login to mysql as administrator first:

~# mysql -uADMIN -pADMIN.PASS sitebuilder3

Where ADMIN and ADMIN.PASS are user and password for mysql administrator.

Run the following queries to create the tables:

CREATE TABLE `wysiwyg_image` (
  `id` int(11) NOT NULL auto_increment,
  `site_id` int(11) NOT NULL default '0',
  `src` varchar(255) default '',
  `external_id` int(11) NOT NULL default '0',
  `is_purchased` int(1) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `image_key` (`id`,`site_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf

CREATE TABLE `wysiwyg_crop_image` (
  `id` int(11) NOT NULL auto_increment,
  `wysiwyg_image_id` int(11) NOT NULL default '0',
  `src` varchar(255) default '',
  `crop_left` int(4) NOT NULL default '0',
  `crop_top` int(4) NOT NULL default '0',
  `crop_width` int(4) NOT NULL default '0',
  `crop_height` int(4) NOT NULL default '0',
  `width` int(4) NOT NULL default '0',
  `height` int(4) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8

Additional information

Name of Sitebuilder database may differ. You may get it name using Sitebuilder utility sb_config:

~# /usr/local/bin/sb_config --help | grep db_name
 --sb_db_name         Sitebuilder database name [sitebuilder3]
~#

ea6a61e571a858aa6019ceb068ea403a fad6dc0c8e983c17ae70a51ac7952cd0 d055be4fdc562a8ecb8e6d0bf419f946 ab881cb3d56878b5e1f6f0473a841f71 56797cefb1efc9130f7c48a7d1db0f0c

Email subscription for changes to this article
Save as PDF