31 August 2009, 23:49

We have customized theme to suit our organization's branding requirement. Apart from this no other customization is done.

It seems that we have to re-code the theme as current theme structure is changed drastically. Since 1.0.4 we were able to maintain these theme changes through SVN:Merge. But now I think reapplying the customisation is only way. This is really time wasting option  !

- Error log -

[Tue Sep 01 14:48:23 2009] [error] [client 192.168.158.1] [WAR] 8d (lib/errors.php:694) Failed to get a recordset: mysql error: [1054: Unknown column 'suspended' in 'where clause'] in EXECUTE("SELECT COUNT(*) FROM "institution" WHERE "registerallowed" = 1 AND "suspended" = 0 ")
[Tue Sep 01 14:48:23 2009] [error] [client 192.168.158.1] [WAR] 8d (lib/errors.php:694) Command was: SELECT COUNT(*) FROM "institution" WHERE "registerallowed" = ? AND "suspended" = ? and values was (1,0)
[Tue Sep 01 14:48:23 2009] [error] [client 192.168.158.1] Call stack (most recent first):
[Tue Sep 01 14:48:23 2009] [error] [client 192.168.158.1] * log_message("Failed to get a recordset: mysql error: [1054: Unk...", 8, true, true) at /var/www/eport/lib/errors.php:105
[Tue Sep 01 14:48:23 2009] [error] [client 192.168.158.1] * log_warn("Failed to get a recordset: mysql error: [1054: Unk...") at /var/www/eport/lib/errors.php:694
[Tue Sep 01 14:48:23 2009] [error] [client 192.168.158.1] * SQLException->__construct("Failed to get a recordset: mysql error: [1054: Unk...") at /var/www/eport/lib/dml.php:449
[Tue Sep 01 14:48:23 2009] [error] [client 192.168.158.1] * get_recordset_sql("SELECT COUNT(*) FROM "institution" WHERE "registe...", array(size 2)) at /var/www/eport/lib/dml.php:246
[Tue Sep 01 14:48:23 2009] [error] [client 192.168.158.1] * count_records_sql("SELECT COUNT(*) FROM "institution" WHERE "registe...", array(size 2)) at /var/www/eport/lib/dml.php:212
[Tue Sep 01 14:48:23 2009] [error] [client 192.168.158.1] * count_records("institution", "registerallowed", 1, "suspended", 0) at /var/www/eport/auth/lib.php:1478
[Tue Sep 01 14:48:23 2009] [error] [client 192.168.158.1] * auth_generate_login_form() at /var/www/eport/lib/web.php:472
[Tue Sep 01 14:48:23 2009] [error] [client 192.168.158.1] * smarty() at /var/www/eport/index.php:47
[Tue Sep 01 14:48:23 2009] [error] [client 192.168.158.1]
[Tue Sep 01 14:48:23 2009] [error] [client 192.168.158.1] [WAR] 8d (lib/dml.php:449) Failed to get a recordset: mysql error: [1054: Unknown column 'suspended' in 'where clause'] in EXECUTE("SELECT COUNT(*) FROM "institution" WHERE "registerallowed" = 1 AND "suspended" = 0 ")
[Tue Sep 01 14:48:23 2009] [error] [client 192.168.158.1] [WAR] 8d (lib/dml.php:449) Command was: SELECT COUNT(*) FROM "institution" WHERE "registerallowed" = ? AND "suspended" = ? and values was (1,0)
[Tue Sep 01 14:48:23 2009] [error] [client 192.168.158.1] Call stack (most recent first):
[Tue Sep 01 14:48:23 2009] [error] [client 192.168.158.1] * get_recordset_sql("SELECT COUNT(*) FROM "institution" WHERE "registe...", array(size 2)) at /var/www/eport/lib/dml.php:246
[Tue Sep 01 14:48:23 2009] [error] [client 192.168.158.1] * count_records_sql("SELECT COUNT(*) FROM "institution" WHERE "registe...", array(size 2)) at /var/www/eport/lib/dml.php:212
[Tue Sep 01 14:48:23 2009] [error] [client 192.168.158.1] * count_records("institution", "registerallowed", 1, "suspended", 0) at /var/www/eport/auth/lib.php:1478
[Tue Sep 01 14:48:23 2009] [error] [client 192.168.158.1] * auth_generate_login_form() at /var/www/eport/lib/web.php:472
[Tue Sep 01 14:48:23 2009] [error] [client 192.168.158.1] * smarty() at /var/www/eport/index.php:47
[Tue Sep 01 14:48:23 2009] [error] [client 192.168.158.1]

01 September 2009, 0:35

Hi - those errors don't look related to the theme. It looks like you missed a patch somewhere along the way that added the 'suspended' column to the institution table..

Regarding the themes - please check out these two wiki documents:

•  http://wiki.mahara.org/Customising/Themes/1.2
•  http://wiki.mahara.org/Customising/Themes/Migrating_themes_from_1.1_to_1.2

 

01 September 2009, 0:49

I was testing that upgrade works with the custom theme or not. When the custom theme was enabled the upgrade hungs.

As I  changed the custome theme to default the upgrade worked like a charm.

I tried with same merged code and same database so I don't think I missed something...I have checked this.

 

 

 

 

01 September 2009, 3:29

Hm, strange. I thought we were forcing the system to use the default theme while upgrading anyway. Maybe we should double check this.

01 September 2009, 0:59

Yes unfortunately there really is no easy way to move to 1.2 with a custom theme -- it will most likely be painful.  But if you are going put lots of work into upgrading your theme for 1.2 I would recommend that you wait until the next 1.2 beta is released, because the raw theme is still being changed by the designers right now.

10 October 2009, 4:02

Thanks Richard,

this fixed it for me.

 

Dirk