06 May 2020, 7:19

Skins are very popular on my instance and after my recent upgrade it appears they no longer work.

[WAR] ab (skin/style.php:82) Undefined index: view_block_header_font
Call stack (most recent first):
* log_message("Undefined index: view_block_header_font", 8, true, true, "/var/www/skin/style.php", 82) at /var/www/lib/errors.php:521
* error(8, "Undefined index: view_block_header_font", "/var/www/skin/style.php", 82, array(size 68)) at /var/www/skin/style.php:82

[WAR] ab (lib/errors.php:859) Failed to get a recordset: postgres8 error: [-2: ERROR: syntax error at or near "LIMIT"
[WAR] ab (lib/errors.php:859) LINE 1: SELECT * FROM "skin_fonts" WHERE "name" = ? LIMIT 2
[WAR] ab (lib/errors.php:859) ^] in EXECUTE("SELECT * FROM "skin_fonts" WHERE "name" = ? LIMIT 2")Command was: SELECT * FROM "skin_fonts" WHERE "name" = ?
Call stack (most recent first):
* log_message("Failed to get a recordset: postgres8 error: [-2: E...", 8, true, true) at /var/www/lib/errors.php:95
* log_warn("Failed to get a recordset: postgres8 error: [-2: E...") at /var/www/lib/errors.php:859
* SQLException->__construct("Failed to get a recordset: postgres8 error: [-2: E...") at /var/www/lib/dml.php:540
* get_recordset_sql("SELECT * FROM "skin_fonts" WHERE "name" = ? ", false, -1, 2) at /var/www/lib/dml.php:359
* get_record_sql("SELECT * FROM "skin_fonts" WHERE "name" = ? ", array(size 0), 1) at /var/www/lib/dml.php:328
* get_record("skin_fonts", "name", null) at /var/www/lib/skin.php:584
* Skin::get_css_font_family_from_font_name(null) at /var/www/skin/style.php:82

[WAR] ab (lib/dml.php:540) Failed to get a recordset: postgres8 error: [-2: ERROR: syntax error at or near "LIMIT"
[WAR] ab (lib/dml.php:540) LINE 1: SELECT * FROM "skin_fonts" WHERE "name" = ? LIMIT 2
[WAR] ab (lib/dml.php:540) ^] in EXECUTE("SELECT * FROM "skin_fonts" WHERE "name" = ? LIMIT 2")Command was: SELECT * FROM "skin_fonts" WHERE "name" = ?
Call stack (most recent first):
* get_recordset_sql("SELECT * FROM "skin_fonts" WHERE "name" = ? ", false, -1, 2) at /var/www/lib/dml.php:359
* get_record_sql("SELECT * FROM "skin_fonts" WHERE "name" = ? ", array(size 0), 1) at /var/www/lib/dml.php:328
* get_record("skin_fonts", "name", null) at /var/www/lib/skin.php:584
* Skin::get_css_font_family_from_font_name(null) at /var/www/skin/style.php:82

[WAR] ab (lib/pieforms/pieform.php:1617) Pieform element login_login_password wants to add headdata to the page, but it's too late. Build your form before generating the page.
Call stack (most recent first):
* log_message("Pieform element login_login_password wants to add ...", 8, true, true) at /var/www/lib/errors.php:95
* log_warn("Pieform element login_login_password wants to add ...") at /var/www/lib/pieforms/pieform.php:1617
* Pieform->build_element_html(array(size 10)) at /var/www/lib/pieforms/pieform.php:724
* Pieform->build() at /var/www/lib/pieforms/pieform.php:173
* Pieform::process(array(size 7)) at /var/www/lib/mahara.php:5441
* pieform(array(size 7)) at /var/www/auth/lib.php:2493
* auth_generate_login_form() at /var/www/lib/web.php:175
* smarty(array(size 0), array(size 0), array(size 0), array(size 1)) at /var/www/lib/errors.php:682
* MaharaException->handle_exception() at /var/www/lib/errors.php:547
* exception(object(SQLException)) at Unknown:0

06 May 2020, 10:59

Hi Patric,

Ah there looks to be an issue with using skins in the old format in 19.10+ sites

I've added a patch to fix this issue in master

https://reviews.mahara.org/#/c/10957/

Once that passes there will be a patch for 19.10 / 20.04

But if you need this fixed now one thing you can do is simply edit / save the skin again and it will be updated

Cheers

Robert