mahara-contributors team mailing list archive

Thread
Date
[Bug 1436672] Re: Upgrade from Mahara 1.1 -> 15.04 doesn't work

To: mahara-contributors@xxxxxxxxxxxxxxxxxxx
From: Aaron Wells <1436672@xxxxxxxxxxxxxxxxxx>
Date: Thu, 26 Mar 2015 05:30:14 -0000
Reply-to: Bug 1436672 <1436672@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx
To replicate:

1. Check out 1.1_STABLE
2. Run the web-based installer.
3. Check out master or 15.04_STABLE
4. Attempt to run the web-based upgrader

** Summary changed:

- Upgrade from Mahara 1.1 -> 15.04 doesn't work
+ Upgrade from Mahara 1.4 -> 15.04 doesn't work

** Description changed:

- If I try to upgrade from Mahara 1.1 to 15.04 through the web interface,
- I can't do so. Loading up the main /index.php page presents me with a
- blank "Site unavailable" error page, and no way to click through to the
- upgrade screen. Even if I navigate directly to /admin/upgrade.php, it
- also shows Site Unavailable.
+ If I try to upgrade from Mahara 1.4 (or earlier) to 15.04 through the
+ web interface, I can't do so. Loading up the main /index.php page
+ presents me with a blank "Site unavailable" error page, and no way to
+ click through to the upgrade screen. Even if I navigate directly to
+ /admin/upgrade.php, it also shows Site Unavailable.
  
  Using git bisect, I traced the cause to commit
  90a1c4294cc29181d474093420a172ab01bd1d1a, which is the patch for Bug
  1408473, "Upload 'no institution' site logo through admin ->
  institution"
  
  In the Apache logs, I see this error:
  
-  [WAR] f2 (lib/errors.php:747) Failed to get a recordset: postgres8 error: [-1: ERROR:  column "logo" does not exist
-  [WAR] f2 (lib/errors.php:747) LINE 1: SELECT "logo" FROM "institution"  WHERE "name" =  $1
-  [WAR] f2 (lib/errors.php:747)                ^] in EXECUTE("SELECT "logo" FROM "institution"  WHERE "name" = ? ")
-  [WAR] f2 (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: postgres8 error: [-1: E...", 8, true, true) at /home/aaronw/www/mahara/htdocs/lib/errors.php:97
-    * log_warn("Failed to get a recordset: postgres8 error: [-1: E...") at /home/aaronw/www/mahara/htdocs/lib/errors.php:747
-    * SQLException->__construct("Failed to get a recordset: postgres8 error: [-1: E...") at /home/aaronw/www/mahara/htdocs/lib/dml.php:480
-    * get_recordset_sql("SELECT "logo" FROM "institution"  WHERE "name" = ?...", array(size 1)) at /home/aaronw/www/mahara/htdocs/lib/dml.php:791
-    * get_field_sql("SELECT "logo" FROM "institution"  WHERE "name" = ?...", array(size 1)) at /home/aaronw/www/mahara/htdocs/lib/dml.php:779
-    * get_field("institution", "logo", "name", "mahara") at /home/aaronw/www/mahara/htdocs/lib/web.php:1055
-    * Theme->header_logo() at /home/aaronw/www/mahara/htdocs/lib/web.php:502
-    * smarty() at /home/aaronw/www/mahara/htdocs/admin/upgrade.php:32
-  
-  [WAR] f2 (lib/dml.php:480) Failed to get a recordset: postgres8 error: [-1: ERROR:  column "logo" does not exist
-  [WAR] f2 (lib/dml.php:480) LINE 1: SELECT "logo" FROM "institution"  WHERE "name" =  $1
-  [WAR] f2 (lib/dml.php:480)                ^] in EXECUTE("SELECT "logo" FROM "institution"  WHERE "name" = ? ")
-  [WAR] f2 (lib/dml.php:480) Command was: SELECT "logo" FROM "institution"  WHERE "name" = ?  and values was (mahara)
-  Call stack (most recent first):
-    * get_recordset_sql("SELECT "logo" FROM "institution"  WHERE "name" = ?...", array(size 1)) at /home/aaronw/www/mahara/htdocs/lib/dml.php:791
-    * get_field_sql("SELECT "logo" FROM "institution"  WHERE "name" = ?...", array(size 1)) at /home/aaronw/www/mahara/htdocs/lib/dml.php:779
-    * get_field("institution", "logo", "name", "mahara") at /home/aaronw/www/mahara/htdocs/lib/web.php:1055
-    * Theme->header_logo() at /home/aaronw/www/mahara/htdocs/lib/web.php:502
-    * smarty() at /home/aaronw/www/mahara/htdocs/admin/upgrade.php:32
-  
-  [WAR] f2 (lib/errors.php:747) Failed to get a recordset: postgres8 error: [-1: ERROR:  column "logo" does not exist
-  [WAR] f2 (lib/errors.php:747) LINE 1: SELECT "logo" FROM "institution"  WHERE "name" =  $1
-  [WAR] f2 (lib/errors.php:747)                ^] in EXECUTE("SELECT "logo" FROM "institution"  WHERE "name" = ? ")
-  [WAR] f2 (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: postgres8 error: [-1: E...", 8, true, true) at /home/aaronw/www/mahara/htdocs/lib/errors.php:97
-    * log_warn("Failed to get a recordset: postgres8 error: [-1: E...") at /home/aaronw/www/mahara/htdocs/lib/errors.php:747
-    * SQLException->__construct("Failed to get a recordset: postgres8 error: [-1: E...") at /home/aaronw/www/mahara/htdocs/lib/dml.php:480
-    * get_recordset_sql("SELECT "logo" FROM "institution"  WHERE "name" = ?...", array(size 1)) at /home/aaronw/www/mahara/htdocs/lib/dml.php:791
-    * get_field_sql("SELECT "logo" FROM "institution"  WHERE "name" = ?...", array(size 1)) at /home/aaronw/www/mahara/htdocs/lib/dml.php:779
-    * get_field("institution", "logo", "name", "mahara") at /home/aaronw/www/mahara/htdocs/lib/web.php:1055
-    * Theme->header_logo() at /home/aaronw/www/mahara/htdocs/lib/web.php:502
-    * smarty(array(size 0), array(size 0), array(size 0), array(size 1)) at /home/aaronw/www/mahara/htdocs/lib/errors.php:576
-    * MaharaException->handle_exception() at /home/aaronw/www/mahara/htdocs/lib/errors.php:467
-    * exception(object(SQLException)) at Unknown:0
-  
-  [WAR] f2 (lib/errors.php:585) Exception thrown by smarty call while handling exception
-  Call stack (most recent first):
-    * log_message("Exception thrown by smarty call while handling exc...", 8, true, true) at /home/aaronw/www/mahara/htdocs/lib/errors.php:97
-    * log_warn("Exception thrown by smarty call while handling exc...") at /home/aaronw/www/mahara/htdocs/lib/errors.php:585
-    * MaharaException->handle_exception() at /home/aaronw/www/mahara/htdocs/lib/errors.php:467
-    * exception(object(SQLException)) at Unknown:0
+  [WAR] f2 (lib/errors.php:747) Failed to get a recordset: postgres8 error: [-1: ERROR:  column "logo" does not exist
+  [WAR] f2 (lib/errors.php:747) LINE 1: SELECT "logo" FROM "institution"  WHERE "name" =  $1
+  [WAR] f2 (lib/errors.php:747)                ^] in EXECUTE("SELECT "logo" FROM "institution"  WHERE "name" = ? ")
+  [WAR] f2 (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: postgres8 error: [-1: E...", 8, true, true) at /home/aaronw/www/mahara/htdocs/lib/errors.php:97
+    * log_warn("Failed to get a recordset: postgres8 error: [-1: E...") at /home/aaronw/www/mahara/htdocs/lib/errors.php:747
+    * SQLException->__construct("Failed to get a recordset: postgres8 error: [-1: E...") at /home/aaronw/www/mahara/htdocs/lib/dml.php:480
+    * get_recordset_sql("SELECT "logo" FROM "institution"  WHERE "name" = ?...", array(size 1)) at /home/aaronw/www/mahara/htdocs/lib/dml.php:791
+    * get_field_sql("SELECT "logo" FROM "institution"  WHERE "name" = ?...", array(size 1)) at /home/aaronw/www/mahara/htdocs/lib/dml.php:779
+    * get_field("institution", "logo", "name", "mahara") at /home/aaronw/www/mahara/htdocs/lib/web.php:1055
+    * Theme->header_logo() at /home/aaronw/www/mahara/htdocs/lib/web.php:502
+    * smarty() at /home/aaronw/www/mahara/htdocs/admin/upgrade.php:32
+ 
+  [WAR] f2 (lib/dml.php:480) Failed to get a recordset: postgres8 error: [-1: ERROR:  column "logo" does not exist
+  [WAR] f2 (lib/dml.php:480) LINE 1: SELECT "logo" FROM "institution"  WHERE "name" =  $1
+  [WAR] f2 (lib/dml.php:480)                ^] in EXECUTE("SELECT "logo" FROM "institution"  WHERE "name" = ? ")
+  [WAR] f2 (lib/dml.php:480) Command was: SELECT "logo" FROM "institution"  WHERE "name" = ?  and values was (mahara)
+  Call stack (most recent first):
+    * get_recordset_sql("SELECT "logo" FROM "institution"  WHERE "name" = ?...", array(size 1)) at /home/aaronw/www/mahara/htdocs/lib/dml.php:791
+    * get_field_sql("SELECT "logo" FROM "institution"  WHERE "name" = ?...", array(size 1)) at /home/aaronw/www/mahara/htdocs/lib/dml.php:779
+    * get_field("institution", "logo", "name", "mahara") at /home/aaronw/www/mahara/htdocs/lib/web.php:1055
+    * Theme->header_logo() at /home/aaronw/www/mahara/htdocs/lib/web.php:502
+    * smarty() at /home/aaronw/www/mahara/htdocs/admin/upgrade.php:32
+ 
+  [WAR] f2 (lib/errors.php:747) Failed to get a recordset: postgres8 error: [-1: ERROR:  column "logo" does not exist
+  [WAR] f2 (lib/errors.php:747) LINE 1: SELECT "logo" FROM "institution"  WHERE "name" =  $1
+  [WAR] f2 (lib/errors.php:747)                ^] in EXECUTE("SELECT "logo" FROM "institution"  WHERE "name" = ? ")
+  [WAR] f2 (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: postgres8 error: [-1: E...", 8, true, true) at /home/aaronw/www/mahara/htdocs/lib/errors.php:97
+    * log_warn("Failed to get a recordset: postgres8 error: [-1: E...") at /home/aaronw/www/mahara/htdocs/lib/errors.php:747
+    * SQLException->__construct("Failed to get a recordset: postgres8 error: [-1: E...") at /home/aaronw/www/mahara/htdocs/lib/dml.php:480
+    * get_recordset_sql("SELECT "logo" FROM "institution"  WHERE "name" = ?...", array(size 1)) at /home/aaronw/www/mahara/htdocs/lib/dml.php:791
+    * get_field_sql("SELECT "logo" FROM "institution"  WHERE "name" = ?...", array(size 1)) at /home/aaronw/www/mahara/htdocs/lib/dml.php:779
+    * get_field("institution", "logo", "name", "mahara") at /home/aaronw/www/mahara/htdocs/lib/web.php:1055
+    * Theme->header_logo() at /home/aaronw/www/mahara/htdocs/lib/web.php:502
+    * smarty(array(size 0), array(size 0), array(size 0), array(size 1)) at /home/aaronw/www/mahara/htdocs/lib/errors.php:576
+    * MaharaException->handle_exception() at /home/aaronw/www/mahara/htdocs/lib/errors.php:467
+    * exception(object(SQLException)) at Unknown:0
+ 
+  [WAR] f2 (lib/errors.php:585) Exception thrown by smarty call while handling exception
+  Call stack (most recent first):
+    * log_message("Exception thrown by smarty call while handling exc...", 8, true, true) at /home/aaronw/www/mahara/htdocs/lib/errors.php:97
+    * log_warn("Exception thrown by smarty call while handling exc...") at /home/aaronw/www/mahara/htdocs/lib/errors.php:585
+    * MaharaException->handle_exception() at /home/aaronw/www/mahara/htdocs/lib/errors.php:467
+    * exception(object(SQLException)) at Unknown:0

-- 
You received this bug notification because you are a member of Mahara
Contributors, which is subscribed to Mahara.
Matching subscriptions: Subscription for all Mahara Contributors -- please ask on #mahara-dev or mahara.org forum before editing or unsubscribing it!
https://bugs.launchpad.net/bugs/1436672

Title:
  Upgrade from Mahara 1.4 -> 15.04 doesn't work

Status in Mahara ePortfolio:
  Confirmed
Status in Mahara 15.04 series:
  Confirmed
Status in Mahara 15.10 series:
  Confirmed

Bug description:
  If I try to upgrade from Mahara 1.4 (or earlier) to 15.04 through the
  web interface, I can't do so. Loading up the main /index.php page
  presents me with a blank "Site unavailable" error page, and no way to
  click through to the upgrade screen. Even if I navigate directly to
  /admin/upgrade.php, it also shows Site Unavailable.

  Using git bisect, I traced the cause to commit
  90a1c4294cc29181d474093420a172ab01bd1d1a, which is the patch for Bug
  1408473, "Upload 'no institution' site logo through admin ->
  institution"

  In the Apache logs, I see this error:

   [WAR] f2 (lib/errors.php:747) Failed to get a recordset: postgres8 error: [-1: ERROR:  column "logo" does not exist
   [WAR] f2 (lib/errors.php:747) LINE 1: SELECT "logo" FROM "institution"  WHERE "name" =  $1
   [WAR] f2 (lib/errors.php:747)                ^] in EXECUTE("SELECT "logo" FROM "institution"  WHERE "name" = ? ")
   [WAR] f2 (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: postgres8 error: [-1: E...", 8, true, true) at /home/aaronw/www/mahara/htdocs/lib/errors.php:97
     * log_warn("Failed to get a recordset: postgres8 error: [-1: E...") at /home/aaronw/www/mahara/htdocs/lib/errors.php:747
     * SQLException->__construct("Failed to get a recordset: postgres8 error: [-1: E...") at /home/aaronw/www/mahara/htdocs/lib/dml.php:480
     * get_recordset_sql("SELECT "logo" FROM "institution"  WHERE "name" = ?...", array(size 1)) at /home/aaronw/www/mahara/htdocs/lib/dml.php:791
     * get_field_sql("SELECT "logo" FROM "institution"  WHERE "name" = ?...", array(size 1)) at /home/aaronw/www/mahara/htdocs/lib/dml.php:779
     * get_field("institution", "logo", "name", "mahara") at /home/aaronw/www/mahara/htdocs/lib/web.php:1055
     * Theme->header_logo() at /home/aaronw/www/mahara/htdocs/lib/web.php:502
     * smarty() at /home/aaronw/www/mahara/htdocs/admin/upgrade.php:32

   [WAR] f2 (lib/dml.php:480) Failed to get a recordset: postgres8 error: [-1: ERROR:  column "logo" does not exist
   [WAR] f2 (lib/dml.php:480) LINE 1: SELECT "logo" FROM "institution"  WHERE "name" =  $1
   [WAR] f2 (lib/dml.php:480)                ^] in EXECUTE("SELECT "logo" FROM "institution"  WHERE "name" = ? ")
   [WAR] f2 (lib/dml.php:480) Command was: SELECT "logo" FROM "institution"  WHERE "name" = ?  and values was (mahara)
   Call stack (most recent first):
     * get_recordset_sql("SELECT "logo" FROM "institution"  WHERE "name" = ?...", array(size 1)) at /home/aaronw/www/mahara/htdocs/lib/dml.php:791
     * get_field_sql("SELECT "logo" FROM "institution"  WHERE "name" = ?...", array(size 1)) at /home/aaronw/www/mahara/htdocs/lib/dml.php:779
     * get_field("institution", "logo", "name", "mahara") at /home/aaronw/www/mahara/htdocs/lib/web.php:1055
     * Theme->header_logo() at /home/aaronw/www/mahara/htdocs/lib/web.php:502
     * smarty() at /home/aaronw/www/mahara/htdocs/admin/upgrade.php:32

   [WAR] f2 (lib/errors.php:747) Failed to get a recordset: postgres8 error: [-1: ERROR:  column "logo" does not exist
   [WAR] f2 (lib/errors.php:747) LINE 1: SELECT "logo" FROM "institution"  WHERE "name" =  $1
   [WAR] f2 (lib/errors.php:747)                ^] in EXECUTE("SELECT "logo" FROM "institution"  WHERE "name" = ? ")
   [WAR] f2 (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: postgres8 error: [-1: E...", 8, true, true) at /home/aaronw/www/mahara/htdocs/lib/errors.php:97
     * log_warn("Failed to get a recordset: postgres8 error: [-1: E...") at /home/aaronw/www/mahara/htdocs/lib/errors.php:747
     * SQLException->__construct("Failed to get a recordset: postgres8 error: [-1: E...") at /home/aaronw/www/mahara/htdocs/lib/dml.php:480
     * get_recordset_sql("SELECT "logo" FROM "institution"  WHERE "name" = ?...", array(size 1)) at /home/aaronw/www/mahara/htdocs/lib/dml.php:791
     * get_field_sql("SELECT "logo" FROM "institution"  WHERE "name" = ?...", array(size 1)) at /home/aaronw/www/mahara/htdocs/lib/dml.php:779
     * get_field("institution", "logo", "name", "mahara") at /home/aaronw/www/mahara/htdocs/lib/web.php:1055
     * Theme->header_logo() at /home/aaronw/www/mahara/htdocs/lib/web.php:502
     * smarty(array(size 0), array(size 0), array(size 0), array(size 1)) at /home/aaronw/www/mahara/htdocs/lib/errors.php:576
     * MaharaException->handle_exception() at /home/aaronw/www/mahara/htdocs/lib/errors.php:467
     * exception(object(SQLException)) at Unknown:0

   [WAR] f2 (lib/errors.php:585) Exception thrown by smarty call while handling exception
   Call stack (most recent first):
     * log_message("Exception thrown by smarty call while handling exc...", 8, true, true) at /home/aaronw/www/mahara/htdocs/lib/errors.php:97
     * log_warn("Exception thrown by smarty call while handling exc...") at /home/aaronw/www/mahara/htdocs/lib/errors.php:585
     * MaharaException->handle_exception() at /home/aaronw/www/mahara/htdocs/lib/errors.php:467
     * exception(object(SQLException)) at Unknown:0

To manage notifications about this bug go to:
https://bugs.launchpad.net/mahara/+bug/1436672/+subscriptions
References

[Bug 1436672] [NEW] Upgrade from Mahara 1.4 -> 15.04 doesn't work
From: Aaron Wells, 2015-03-26