version no for 1.4_STABLE 
 1.4.1testing (2011061003)
version no for master
 1.5.0dev (2011062100)

merge base between branches
 b3177ad2355306faea9a8e2ca9fd79afae12706a
version no for merge base
 1.4.0alpha2dev (2011051700)

Basically, the upgrade doesn't run the if statements in lib/db/upgrade.db with 
the following version nos
(taken from git diff 1.4_STABLE..master htdocs/lib/db/upgrade.php)
2011051300 - delete wwwroot
2011052400 - ctime in view access
2011053100 - default quota for institutions
2011053101 - group quota
2011060700 - retain view access on copy, and cronjob for sitemap (should be in 
seperate one...)
2011060701 - set onlineuserssideblockmaxusers to 10, and add showonlineusers 
field to institutions

This will be a difficult one, and will get worse when 1.4_STABLE version
no is bumped

What I suggest for now
- bump version no on master, add all the stuff it might of missed (making sure 
to test whether it has been done already or not...)
- in future, when we bump version no on 1.4_STABLE, we need to check if 
anything will be missed on the upgrade, and bump masters version to add in 
stuff that may not be done



** Changed in: mahara
   Importance: Undecided => High

** Changed in: mahara
    Milestone: None => 1.5.0

** Changed in: mahara
   Importance: High => Critical

** Changed in: mahara
       Status: New => Triaged

-- 
You received this bug notification because you are a member of Mahara
Contributors, which is subscribed to Mahara.
https://bugs.launchpad.net/bugs/800917

Title:
  upgrade from 1.4_STABLE to master breaks

Status in Mahara ePortfolio:
  Triaged

Bug description:
  When upgrading from 1.4_STABLE to master, certain errors are made.

  During the upgrade process, the following DBG message is given
  [DBG] ae (lib/ddl.php:486) Function find_index_name called on an index 
usr_fir_ix with no columns.  Attempting match on index names of all indexes on 
usr without columns.

  After login, the following errors are shown
  2011/06/23 10:09:07 [error] 12309#0: *4434 FastCGI sent in stderr: "[WAR] 96 
(lib/errors.php:745) Failed to get a recordset: postgres7 error: [-1: ERROR:  
column i.showonlineusers does not exist
  [WAR] 96 (lib/errors.php:745) LINE 1: 
...dentid,u.staff,u.admin,i.theme,i.registerallowed, i.showonli...
  [WAR] 96 (lib/errors.php:745)                                                 
             ^] in EXECUTE("
  [WAR] 96 (lib/errors.php:745)         SELECT 
u.institution,FLOOR(EXTRACT(EPOCH FROM ctime)) AS ctime,FLOOR(EXTRACT(EPOCH 
FROM u.expiry)) AS 
membership_expiry,u.studentid,u.staff,u.admin,i.theme,i.registerallowed, 
i.showonlineusers,i.allowinstitutionpublicviews
  [WAR] 96 (lib/errors.php:745)         FROM "usr_institution" u INNER JOIN 
"institution" i ON u.institution = i.name
  [WAR] 96 (lib/errors.php:745)         WHERE u.usr = ? ORDER BY i.priority 
DESC")
  [WAR] 96 (lib/errors.php:745) Command was: 
  [WAR] 96 (lib/errors.php:745)         SELECT 
u.institution,FLOOR(EXTRACT(EPOCH FROM ctime)) AS ctime,FLOOR(EXTRACT(EPOCH 
FROM u.expiry)) AS 
membership_expiry,u.studentid,u.staff,u.admin,i.theme,i.registerallowed, 
i.showonlineusers,i.allowinstitutionpublicviews
  [WAR] 96 (lib/errors.php:745)         FROM "usr_institution" u INNER JOIN 
"institution" i ON u.institution = i.name
  [WAR] 96 (lib/errors.php:745)         WHERE u.usr = ? ORDER BY i.priority 
DESC and values was (1)
  Call stack (most recent first):
    * log_message("Failed to get a recordset: postgres7 error: [-1: E...", 8, 
true, true) at /home/hugh/src/mahara/mahara/htdocs/lib/errors.php:109
    * log_warn("Failed to get a recordset: postgres7 error: [-1: E...") at 
/home/hugh/src/mahara/mahara/htdocs/lib/errors.php:745
    * SQLException->__construct("Failed to get a recordset: postgres7 error: 
[-1: E...") at /home/hugh/src/mahara/mahara/htdocs/lib/dml.php:484
    * get_recordset_sql("
          SELECT u.institution,FLOOR(EXTRACT(EPOCH ...", array(size 1), "", "") 
at /home/hugh/src/mahara/mahara/htdocs/lib/dml.php:650
    * get_records_sql_assoc("
          SELECT u.institution,F
  2011/06/23 10:09:07 [error] 12309#0: *4434 FastCGI sent in stderr: "licviews
  [WAR] 96 (lib/dml.php:484)         FROM "usr_institution" u INNER JOIN 
"institution" i ON u.institution = i.name
  [WAR] 96 (lib/dml.php:484)         WHERE u.usr = ? ORDER BY i.priority DESC 
and values was (1)
  Call stack (most recent first):
    * get_recordset_sql("
          SELECT u.institution,FLOOR(EXTRACT(EPOCH ...", array(size 1), "", "") 
at /home/hugh/src/mahara/mahara/htdocs/lib/dml.php:650
    * get_records_sql_assoc("
          SELECT u.institution,FLOOR(EXTRACT(EPOCH ...", array(size 1)) at 
/home/hugh/src/mahara/mahara/htdocs/lib/user.php:1267
    * load_user_institutions("1") at 
/home/hugh/src/mahara/mahara/htdocs/auth/user.php:804
    * User->reset_institutions() at 
/home/hugh/src/mahara/mahara/htdocs/auth/user.php:1302
    * LiveUser->reset_institutions() at 
/home/hugh/src/mahara/mahara/htdocs/auth/user.php:1183
    * LiveUser->authenticate(object(stdClass), "1") at 
/home/hugh/src/mahara/mahara/htdocs/auth/user.php:1058
    * LiveUser->login("admin", "aY1sea'th0") at 
/home/hugh/src/mahara/mahara/htdocs/auth/lib.php:1151
    * login_submit(object(Pieform), array(size 6)) at Unknown:0
    * call_user_func_array("login_submit", array(size 2)) at 
/home/hugh/src/mahara/mahara/htdocs/lib/pieforms/pieform.php:512
    * Pieform->__construct(array(size 8)) at 
/home/hugh/src/mahara/mahara/htdocs/auth/lib.php:478
    * auth_setup() at /home/hugh/src/mahara/mahara/htdocs/init.php:268
    * require("/home/hugh/src/mahara/mahara/htdocs/init.php") at 
/home/hugh/src/mahara/mahara/htdocs/index.php:32

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

_______________________________________________
Mailing list: https://launchpad.net/~mahara-contributors
Post to     : mahara-contributors@lists.launchpad.net
Unsubscribe : https://launchpad.net/~mahara-contributors
More help   : https://help.launchpad.net/ListHelp

Reply via email to