26 June 2015, 5:48

Running the Mahara 15.04 upgrade, PHP spilled its guts. This is not dissimilar to an error we got previously when attempting to run Mahara 1.4.We're running Windows 8/R2 with IIS 7.5, MySQL 5.4, and the errors started coming after an upgrade to PHP 5.5.26.

Error message below. What am I looking at? Thanks in advance.

================================================

[WAR] fb (lib\errors.php:747) Failed to get a recordset: mysqli error: [1054: Unknown column 'logo' in 'field list'] in EXECUTE("SELECT "logo" FROM "institution" WHERE "name" = 'mahara' ")

[WAR] fb (lib\errors.php:747) Command was: SELECT "logo" FROM "institution" WHERE "name" = ? and values was (mahara)
Call stack (most recent first):
* log_message("Failed to get a recordset: mysqli error: [1054: Un...", 8, true, true) at E:\www\inetwork\lib\errors.php:97
* log_warn("Failed to get a recordset: mysqli error: [1054: Un...") at E:\www\inetwork\lib\errors.php:747
* SQLException->__construct("Failed to get a recordset: mysqli error: [1054: Un...") at E:\www\inetwork\lib\dml.php:480
* get_recordset_sql("SELECT "logo" FROM "institution" WHERE "name" = ?...", array(size 1)) at E:\www\inetwork\lib\dml.php:791
* get_field_sql("SELECT "logo" FROM "institution" WHERE "name" = ?...", array(size 1)) at E:\www\inetwork\lib\dml.php:779
* get_field("institution", "logo", "name", "mahara") at E:\www\inetwork\lib\web.php:1098
* Theme->header_logo() at E:\www\inetwork\lib\web.php:516
* smarty() at E:\www\inetwork\index.php:88

[WAR] fb (lib\web.php:3335) include_once(E:\www\inetwork\lib\htmlpurifiercustom/YouTubeIframe.php): failed to open stream: No such file or directory
Call stack (most recent first):
* log_message("include_once(E:\www\inetwork\lib\htmlpurifiercusto...", 8, true, true, "E:\www\inetwork\lib\web.php", 3335) at E:\www\inetwork\lib\errors.php:441
* error(2, "include_once(E:\www\inetwork\lib\htmlpurifiercusto...", "E:\www\inetwork\lib\web.php", 3335, array(size 4)) at E:\www\inetwork\lib\web.php:3335
* get_htmlpurifier_custom_filters() at E:\www\inetwork\lib\web.php:3335
* get_htmlpurifier_custom_filters() at E:\www\inetwork\lib\web.php:3385
* clean_html("<h1>Welcome to Fayette's iNetwork</h1>
<p>...a se...") at \\OURSERVER\MAHARADATA\dwoo\compile\aqua\E-\www\inetwork\theme\raw\templates\index.tpl.d17.php:10
* include("\\OURSERVER\MAHARADATA\dwoo\compile\aqua\E-\ww...") at E:\www\inetwork\lib\dwoo\dwoo\Dwoo\Core.php:374
* Dwoo_Core->get(object(Dwoo_Template_File), array(size 38)) at E:\www\inetwork\lib\dwoo\mahara\Dwoo_Mahara.php:123
* Dwoo_Mahara->fetch("index.tpl") at E:\www\inetwork\lib\dwoo\mahara\Dwoo_Mahara.php:107
* Dwoo_Mahara->display("index.tpl") at E:\www\inetwork\index.php:108

[WAR] fb (lib\web.php:3335) include_once(): Failed opening 'E:\www\inetwork\lib\htmlpurifiercustom/YouTubeIframe.php' for inclusion (include_path='E:\www\inetwork\lib\htmlpurifier;E:\www\inetwork\lib\;E:\www\inetwork\lib\pear/;.;C:\php\pear')
Call stack (most recent first):
* log_message("include_once(): Failed opening 'E:\www\inetwork\li...", 8, true, true, "E:\www\inetwork\lib\web.php", 3335) at E:\www\inetwork\lib\errors.php:441
* error(2, "include_once(): Failed opening 'E:\www\inetwork\li...", "E:\www\inetwork\lib\web.php", 3335, array(size 4)) at E:\www\inetwork\lib\web.php:3335
* get_htmlpurifier_custom_filters() at E:\www\inetwork\lib\web.php:3335
* get_htmlpurifier_custom_filters() at E:\www\inetwork\lib\web.php:3385
* clean_html("<h1>Welcome to Fayette's iNetwork</h1>
<p>...a se...") at \\OURSERVER\MAHARADATA\dwoo\compile\aqua\E-\www\inetwork\theme\raw\templates\index.tpl.d17.php:10
* include("\\OURSERVER\MAHARADATA\dwoo\compile\aqua\E-\ww...") at E:\www\inetwork\lib\dwoo\dwoo\Dwoo\Core.php:374
* Dwoo_Core->get(object(Dwoo_Template_File), array(size 38)) at E:\www\inetwork\lib\dwoo\mahara\Dwoo_Mahara.php:123
* Dwoo_Mahara->fetch("index.tpl") at E:\www\inetwork\lib\dwoo\mahara\Dwoo_Mahara.php:107
* Dwoo_Mahara->display("index.tpl") at E:\www\inetwork\index.php:108

30 June 2015, 1:14

OK, well, my tech support person has reduced the error down to the following. Since it seems to be generated by the theme, is there a way of changing the theme through the database? Or should I add the noted field to that table, and hope for the best?

[WAR] 3b (lib\errors.php:747) Failed to get a recordset: mysqli error: [1054: Unknown column 'logo' in 'field list'] in EXECUTE("SELECT "logo" FROM "institution"  WHERE "name" = 'mahara' ")[WAR] 3b (lib\errors.php:747) Command was: SELECT "logo" FROM "institution"  WHERE "name" = ?  and values was (mahara)Call stack (most recent first):  * log_message("Failed to get a recordset: mysqli error: [1054: Un...", 8, true, true) at E:\www\inetwork\lib\errors.php:97  * log_warn("Failed to get a recordset: mysqli error: [1054: Un...") at E:\www\inetwork\lib\errors.php:747  * SQLException->__construct("Failed to get a recordset: mysqli error: [1054: Un...") at E:\www\inetwork\lib\dml.php:480  * get_recordset_sql("SELECT "logo" FROM "institution"  WHERE "name" = ?...", array(size 1)) at E:\www\inetwork\lib\dml.php:791  * get_field_sql("SELECT "logo" FROM "institution"  WHERE "name" = ?...", array(size 1)) at E:\www\inetwork\lib\dml.php:779  * get_field("institution", "logo", "name", "mahara") at E:\www\inetwork\lib\web.php:1098  * Theme->header_logo() at E:\www\inetwork\lib\web.php:516  * smarty() at E:\www\inetwork\index.php:88