[Solved] No template applied to site

[jovo]

I upgraded from 1.3.1 to 1.4.1

I followed the instructions in UPGRADE.txt
- untar in separate directory
- copy contents over old root

After running the upgrade script I got the contents of the site but the template is not applied.
In the HTML no call to stylesheet.php is included

No errors in the errorlog

[alby]

After running the upgrade script I got the contents of the site but the template is not applied.
In the HTML no call to stylesheet.php is included

I think that you load template but no stylesheets
- re-run upgrade.php
- check with sqltools if you have assoc_order field in your [cms_]css_assoc table

Alby

[jovo]

No field assoc_order seen

This the layout of the table

Code: Select all

mysql> describe cms_css_assoc;
+---------------+-------------+------+-----+---------+-------+
| Field         | Type        | Null | Key | Default | Extra |
+---------------+-------------+------+-----+---------+-------+
| assoc_to_id   | int(11)     | YES  | MUL | NULL    |       |
| assoc_css_id  | int(11)     | YES  | MUL | NULL    |       |
| assoc_type    | varchar(80) | YES  |     | NULL    |       |
| create_date   | datetime    | YES  |     | NULL    |       |
| modified_date | datetime    | YES  |     | NULL    |       |
+---------------+-------------+------+-----+---------+-------+
5 rows in set (0.00 sec)

The database is upgraded to version 31

[jovo]

Your remark has put me on the right leg (a poorly translated Dutch saying)

The user in config.php did not have full control over the database. After changing I got my templates back again

Thanks.

[alby]

The user in config.php did not have full control over the database. After changing I got my templates back again

Upgrade have not update css_assoc table:
1. add a new field: assoc_order  int
or
2. put 29 in version table and re-run upgrade.php

Alby