template database

[om4knowledge]

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.

 

[Dmitry Frantsev]

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)

 

[om4knowledge]

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.

 

[Dmitry Frantsev]

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';"
#

 

[om4knowledge]

D,
Your team did my install.
How can I find (or reset) the user and pass?
Thanks.

 

[Dmitry Frantsev]

Default Sitebuilder administrator credentials are admin/admin. If it was an upgrade administrator password should not be changed. Anyway, you can find information about how to get/reset password here:

http://kb.odin.com/en/1184