• Introducing WebPros Cloud - a fully managed infrastructure platform purpose-built to simplify the deployment of WebPros products !  WebPros Cloud enables you to easily deliver WebPros solutions — without the complexity of managing the infrastructure.
    Join the pilot program today!
  • The Horde component is removed from Plesk Installer. We recommend switching to another webmail software supported in Plesk.
  • The BIND DNS server has already been deprecated and removed from Plesk for Windows.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS. We strongly recommend transitioning to Microsoft DNS within the next 6 weeks, before the Plesk 18.0.70 release.

template database

O

om4knowledge

Guest
I'm running sb 4.2 on cent os (linux).

Where is my template database located?
I add a few templates that didn't work and I've heard I should clean up the tables in my database.

Thanks.
 
After new template is added you need to run:

# sb_config --update_templates

Tempalte should be prepared properly. All templates are stored in 'sitebuilder3.template' table:

mysql> desc sitebuilder3.template;
+-----------------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------------------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| code | varchar(32) | NO | UNI | | |
| name | varchar(32) | NO | | | |
| is_active | int(1) | NO | | 1 | |
| template_category_id | int(11) | NO | | 0 | |
| version | varchar(16) | NO | | | |
| defaults | varchar(128) | NO | | | |
| schemes | varchar(128) | NO | | | |
| header_upload_support | tinyint(1) | YES | | NULL | |
| keywords | text | YES | | NULL | |
+-----------------------+--------------+------+-----+---------+----------------+
10 rows in set (0.00 sec)
 
D,
I was told that if you manually remove a template you need to go into the db and clean up the table. I logged in as my primary user and I don't see the database in mysql admin.

As you know, your crew did my install. How can I clean up my database? Thanks for ALL your work. :)
 
After template is removed, template list should be updated with:

#sb_config --update_templates

For example, I want to delete 'zsk-20' template:

Appropriate record in database exists:
# mysql -uuser -ppassword sitebuilder3 -e "select * from template where code='zsk-20';"
+-----+--------+----------------------+-----------+----------------------+---------+---------------------------------+-------------------+-----------------------+----------+
| id | code | name | is_active | template_category_id | version | defaults | schemes | header_upload_support | keywords |
+-----+--------+----------------------+-----------+----------------------+---------+---------------------------------+-------------------+-----------------------+----------+
| 502 | zsk-20 | Photogallery company | 1 | 18 | 4.0.0 | logo.gif|headers1|buttons1|blue | green|blue|yellow | NULL | NULL |
+-----+--------+----------------------+-----------+----------------------+---------+---------------------------------+-------------------+-----------------------+----------+

Removing:

# rm -rf /usr/local/sitebuilder/htdocs/templates/zsk-20/

Updating database:

# sb_config --update_templates
Templates have been successfully updated

No records after update:
# mysql -uuser -ppassword sitebuilder3 -e "select * from template where code='zsk-20';"
#
 
D,
Your team did my install.
How can I find (or reset) the user and pass?
Thanks.
 
Back
Top