[Mahara-contributors] [Bug 1230042] Re: Changing page layout not working
Can you please look into this, Bob? ** Changed in: mahara Assignee: (unassigned) = Robert Lyon (robertl-9) -- 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/1230042 Title: Changing page layout not working Status in Mahara ePortfolio: New Bug description: Master mysql php5 Ubuntu When trying to change the pagelayout, this error is orinted to the browser: Mahara: Site unavailable A nonrecoverable error occurred. This probably means you have encountered a bug in the system Apache error log reads this: [Tue Sep 24 21:10:05 2013] [error] [client 127.0.0.1] [WAR] e9 (lib/errors.php:752) Failed to get a recordset: mysqli error: [1054: Unknown column 'layoutmenuorder' in 'where clause'] in EXECUTE(SELECT id, id FROM view_layout WHERE layoutmenuorder 0 AND iscustom = 0 ORDER BY layoutmenuorder ), referer: http://localhost/mahara/htdocs/view/blocks.php?id=6 [Tue Sep 24 21:10:05 2013] [error] [client 127.0.0.1] [WAR] e9 (lib/errors.php:752) Command was: SELECT id, id FROM view_layout WHERE layoutmenuorder 0 AND iscustom = 0 ORDER BY layoutmenuorder , referer: http://localhost/mahara/htdocs/view/blocks.php?id=6 [Tue Sep 24 21:10:05 2013] [error] [client 127.0.0.1] Call stack (most recent first):, referer: http://localhost/mahara/htdocs/view/blocks.php?id=6 [Tue Sep 24 21:10:05 2013] [error] [client 127.0.0.1] * log_message(Failed to get a recordset: mysqli error: [1054: Un..., 8, true, true) at /var/www/mahara/htdocs/lib/errors.php:109, referer: http://localhost/mahara/htdocs/view/blocks.php?id=6 [Tue Sep 24 21:10:05 2013] [error] [client 127.0.0.1] * log_warn(Failed to get a recordset: mysqli error: [1054: Un...) at /var/www/mahara/htdocs/lib/errors.php:752, referer: http://localhost/mahara/htdocs/view/blocks.php?id=6 [Tue Sep 24 21:10:05 2013] [error] [client 127.0.0.1] * SQLException-__construct(Failed to get a recordset: mysqli error: [1054: Un...) at /var/www/mahara/htdocs/lib/dml.php:492, referer: http://localhost/mahara/htdocs/view/blocks.php?id=6 [Tue Sep 24 21:10:05 2013] [error] [client 127.0.0.1] * get_recordset_sql(SELECT id, id FROM view_layout WHERE layoutmenuo..., array(size 0)) at /var/www/mahara/htdocs/lib/dml.php:448, referer: http://localhost/mahara/htdocs/view/blocks.php?id=6 [Tue Sep 24 21:10:05 2013] [error] [client 127.0.0.1] * get_recordset_select(view_layout, layoutmenuorder 0 AND iscustom = 0, array(size 0), layoutmenuorder, id, id, , ) at /var/www/mahara/htdocs/lib/dml.php:621, referer: http://localhost/mahara/htdocs/view/blocks.php?id=6 [Tue Sep 24 21:10:05 2013] [error] [client 127.0.0.1] * get_records_select_assoc(view_layout, layoutmenuorder 0 AND iscustom = 0, array(size 0), layoutmenuorder, id, id) at /var/www/mahara/htdocs/view/layout.php:60, referer: http://localhost/mahara/htdocs/view/blocks.php?id=6 [Tue Sep 24 21:10:05 2013] [error] [client 127.0.0.1] , referer: http://localhost/mahara/htdocs/view/blocks.php?id=6 [Tue Sep 24 21:10:05 2013] [error] [client 127.0.0.1] [WAR] e9 (lib/dml.php:492) Failed to get a recordset: mysqli error: [1054: Unknown column 'layoutmenuorder' in 'where clause'] in EXECUTE(SELECT id, id FROM view_layout WHERE layoutmenuorder 0 AND iscustom = 0 ORDER BY layoutmenuorder ), referer: http://localhost/mahara/htdocs/view/blocks.php?id=6 [Tue Sep 24 21:10:05 2013] [error] [client 127.0.0.1] [WAR] e9 (lib/dml.php:492) Command was: SELECT id, id FROM view_layout WHERE layoutmenuorder 0 AND iscustom = 0 ORDER BY layoutmenuorder , referer: http://localhost/mahara/htdocs/view/blocks.php?id=6 [Tue Sep 24 21:10:05 2013] [error] [client 127.0.0.1] Call stack (most recent first):, referer: http://localhost/mahara/htdocs/view/blocks.php?id=6 [Tue Sep 24 21:10:05 2013] [error] [client 127.0.0.1] * get_recordset_sql(SELECT id, id FROM view_layout WHERE layoutmenuo..., array(size 0)) at /var/www/mahara/htdocs/lib/dml.php:448, referer: http://localhost/mahara/htdocs/view/blocks.php?id=6 [Tue Sep 24 21:10:05 2013] [error] [client 127.0.0.1] * get_recordset_select(view_layout, layoutmenuorder 0 AND iscustom = 0, array(size 0), layoutmenuorder, id, id, , ) at /var/www/mahara/htdocs/lib/dml.php:621, referer: http://localhost/mahara/htdocs/view/blocks.php?id=6 [Tue Sep 24 21:10:05 2013] [error] [client 127.0.0.1] * get_records_select_assoc(view_layout, layoutmenuorder 0 AND iscustom = 0, array(size 0), layoutmenuorder, id, id) at /var/www/mahara/htdocs/view/layout.php:60, referer: http://localhost/mahara/htdocs/view/blocks.php?id=6 [Tue Sep 24 21:10:05 2013] [error] [client 127.0.0.1] , referer: http://localhost/mahara/htdocs/view/blocks.php?id=6 To manage notifications about this bug go
[Mahara-contributors] [Bug 1230042] Re: Changing page layout not working
Hi Dirk, Yesterday we pushed a patch to fix an issue when upgrading from older versions to the 1.8dev branch (master) in relation to view layouts. Part of this fix was the creation of a new table 'layoutmenuorder' - which looks to be missing from your instance. As the change was to a non-released branch we didn't give an upgrade path to the change. As you should only be using the 1.8dev for testing at this stage you will need to either - drop and recreate your database and install Mahara again - this will create all the right tables for you (easiest option). or - look at the htdocs/lib/db/upgrade.php script for the part about flexible layouts and try to manually do the changes described there. Cheers Robert -- 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/1230042 Title: Changing page layout not working Status in Mahara ePortfolio: New Bug description: Master mysql php5 Ubuntu When trying to change the pagelayout, this error is orinted to the browser: Mahara: Site unavailable A nonrecoverable error occurred. This probably means you have encountered a bug in the system Apache error log reads this: [Tue Sep 24 21:10:05 2013] [error] [client 127.0.0.1] [WAR] e9 (lib/errors.php:752) Failed to get a recordset: mysqli error: [1054: Unknown column 'layoutmenuorder' in 'where clause'] in EXECUTE(SELECT id, id FROM view_layout WHERE layoutmenuorder 0 AND iscustom = 0 ORDER BY layoutmenuorder ), referer: http://localhost/mahara/htdocs/view/blocks.php?id=6 [Tue Sep 24 21:10:05 2013] [error] [client 127.0.0.1] [WAR] e9 (lib/errors.php:752) Command was: SELECT id, id FROM view_layout WHERE layoutmenuorder 0 AND iscustom = 0 ORDER BY layoutmenuorder , referer: http://localhost/mahara/htdocs/view/blocks.php?id=6 [Tue Sep 24 21:10:05 2013] [error] [client 127.0.0.1] Call stack (most recent first):, referer: http://localhost/mahara/htdocs/view/blocks.php?id=6 [Tue Sep 24 21:10:05 2013] [error] [client 127.0.0.1] * log_message(Failed to get a recordset: mysqli error: [1054: Un..., 8, true, true) at /var/www/mahara/htdocs/lib/errors.php:109, referer: http://localhost/mahara/htdocs/view/blocks.php?id=6 [Tue Sep 24 21:10:05 2013] [error] [client 127.0.0.1] * log_warn(Failed to get a recordset: mysqli error: [1054: Un...) at /var/www/mahara/htdocs/lib/errors.php:752, referer: http://localhost/mahara/htdocs/view/blocks.php?id=6 [Tue Sep 24 21:10:05 2013] [error] [client 127.0.0.1] * SQLException-__construct(Failed to get a recordset: mysqli error: [1054: Un...) at /var/www/mahara/htdocs/lib/dml.php:492, referer: http://localhost/mahara/htdocs/view/blocks.php?id=6 [Tue Sep 24 21:10:05 2013] [error] [client 127.0.0.1] * get_recordset_sql(SELECT id, id FROM view_layout WHERE layoutmenuo..., array(size 0)) at /var/www/mahara/htdocs/lib/dml.php:448, referer: http://localhost/mahara/htdocs/view/blocks.php?id=6 [Tue Sep 24 21:10:05 2013] [error] [client 127.0.0.1] * get_recordset_select(view_layout, layoutmenuorder 0 AND iscustom = 0, array(size 0), layoutmenuorder, id, id, , ) at /var/www/mahara/htdocs/lib/dml.php:621, referer: http://localhost/mahara/htdocs/view/blocks.php?id=6 [Tue Sep 24 21:10:05 2013] [error] [client 127.0.0.1] * get_records_select_assoc(view_layout, layoutmenuorder 0 AND iscustom = 0, array(size 0), layoutmenuorder, id, id) at /var/www/mahara/htdocs/view/layout.php:60, referer: http://localhost/mahara/htdocs/view/blocks.php?id=6 [Tue Sep 24 21:10:05 2013] [error] [client 127.0.0.1] , referer: http://localhost/mahara/htdocs/view/blocks.php?id=6 [Tue Sep 24 21:10:05 2013] [error] [client 127.0.0.1] [WAR] e9 (lib/dml.php:492) Failed to get a recordset: mysqli error: [1054: Unknown column 'layoutmenuorder' in 'where clause'] in EXECUTE(SELECT id, id FROM view_layout WHERE layoutmenuorder 0 AND iscustom = 0 ORDER BY layoutmenuorder ), referer: http://localhost/mahara/htdocs/view/blocks.php?id=6 [Tue Sep 24 21:10:05 2013] [error] [client 127.0.0.1] [WAR] e9 (lib/dml.php:492) Command was: SELECT id, id FROM view_layout WHERE layoutmenuorder 0 AND iscustom = 0 ORDER BY layoutmenuorder , referer: http://localhost/mahara/htdocs/view/blocks.php?id=6 [Tue Sep 24 21:10:05 2013] [error] [client 127.0.0.1] Call stack (most recent first):, referer: http://localhost/mahara/htdocs/view/blocks.php?id=6 [Tue Sep 24 21:10:05 2013] [error] [client 127.0.0.1] * get_recordset_sql(SELECT id, id FROM view_layout WHERE layoutmenuo..., array(size 0)) at /var/www/mahara/htdocs/lib/dml.php:448, referer: http://localhost/mahara/htdocs/view/blocks.php?id=6 [Tue Sep 24 21:10:05 2013] [error] [client 127.0.0.1] * get_recordset_select(view_layout, layoutmenuorder 0 AND
[Mahara-contributors] [Bug 1230042] Re: Changing page layout not working
Thanks. I dropped database and its fine now. Thanks -- 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/1230042 Title: Changing page layout not working Status in Mahara ePortfolio: New Bug description: Master mysql php5 Ubuntu When trying to change the pagelayout, this error is orinted to the browser: Mahara: Site unavailable A nonrecoverable error occurred. This probably means you have encountered a bug in the system Apache error log reads this: [Tue Sep 24 21:10:05 2013] [error] [client 127.0.0.1] [WAR] e9 (lib/errors.php:752) Failed to get a recordset: mysqli error: [1054: Unknown column 'layoutmenuorder' in 'where clause'] in EXECUTE(SELECT id, id FROM view_layout WHERE layoutmenuorder 0 AND iscustom = 0 ORDER BY layoutmenuorder ), referer: http://localhost/mahara/htdocs/view/blocks.php?id=6 [Tue Sep 24 21:10:05 2013] [error] [client 127.0.0.1] [WAR] e9 (lib/errors.php:752) Command was: SELECT id, id FROM view_layout WHERE layoutmenuorder 0 AND iscustom = 0 ORDER BY layoutmenuorder , referer: http://localhost/mahara/htdocs/view/blocks.php?id=6 [Tue Sep 24 21:10:05 2013] [error] [client 127.0.0.1] Call stack (most recent first):, referer: http://localhost/mahara/htdocs/view/blocks.php?id=6 [Tue Sep 24 21:10:05 2013] [error] [client 127.0.0.1] * log_message(Failed to get a recordset: mysqli error: [1054: Un..., 8, true, true) at /var/www/mahara/htdocs/lib/errors.php:109, referer: http://localhost/mahara/htdocs/view/blocks.php?id=6 [Tue Sep 24 21:10:05 2013] [error] [client 127.0.0.1] * log_warn(Failed to get a recordset: mysqli error: [1054: Un...) at /var/www/mahara/htdocs/lib/errors.php:752, referer: http://localhost/mahara/htdocs/view/blocks.php?id=6 [Tue Sep 24 21:10:05 2013] [error] [client 127.0.0.1] * SQLException-__construct(Failed to get a recordset: mysqli error: [1054: Un...) at /var/www/mahara/htdocs/lib/dml.php:492, referer: http://localhost/mahara/htdocs/view/blocks.php?id=6 [Tue Sep 24 21:10:05 2013] [error] [client 127.0.0.1] * get_recordset_sql(SELECT id, id FROM view_layout WHERE layoutmenuo..., array(size 0)) at /var/www/mahara/htdocs/lib/dml.php:448, referer: http://localhost/mahara/htdocs/view/blocks.php?id=6 [Tue Sep 24 21:10:05 2013] [error] [client 127.0.0.1] * get_recordset_select(view_layout, layoutmenuorder 0 AND iscustom = 0, array(size 0), layoutmenuorder, id, id, , ) at /var/www/mahara/htdocs/lib/dml.php:621, referer: http://localhost/mahara/htdocs/view/blocks.php?id=6 [Tue Sep 24 21:10:05 2013] [error] [client 127.0.0.1] * get_records_select_assoc(view_layout, layoutmenuorder 0 AND iscustom = 0, array(size 0), layoutmenuorder, id, id) at /var/www/mahara/htdocs/view/layout.php:60, referer: http://localhost/mahara/htdocs/view/blocks.php?id=6 [Tue Sep 24 21:10:05 2013] [error] [client 127.0.0.1] , referer: http://localhost/mahara/htdocs/view/blocks.php?id=6 [Tue Sep 24 21:10:05 2013] [error] [client 127.0.0.1] [WAR] e9 (lib/dml.php:492) Failed to get a recordset: mysqli error: [1054: Unknown column 'layoutmenuorder' in 'where clause'] in EXECUTE(SELECT id, id FROM view_layout WHERE layoutmenuorder 0 AND iscustom = 0 ORDER BY layoutmenuorder ), referer: http://localhost/mahara/htdocs/view/blocks.php?id=6 [Tue Sep 24 21:10:05 2013] [error] [client 127.0.0.1] [WAR] e9 (lib/dml.php:492) Command was: SELECT id, id FROM view_layout WHERE layoutmenuorder 0 AND iscustom = 0 ORDER BY layoutmenuorder , referer: http://localhost/mahara/htdocs/view/blocks.php?id=6 [Tue Sep 24 21:10:05 2013] [error] [client 127.0.0.1] Call stack (most recent first):, referer: http://localhost/mahara/htdocs/view/blocks.php?id=6 [Tue Sep 24 21:10:05 2013] [error] [client 127.0.0.1] * get_recordset_sql(SELECT id, id FROM view_layout WHERE layoutmenuo..., array(size 0)) at /var/www/mahara/htdocs/lib/dml.php:448, referer: http://localhost/mahara/htdocs/view/blocks.php?id=6 [Tue Sep 24 21:10:05 2013] [error] [client 127.0.0.1] * get_recordset_select(view_layout, layoutmenuorder 0 AND iscustom = 0, array(size 0), layoutmenuorder, id, id, , ) at /var/www/mahara/htdocs/lib/dml.php:621, referer: http://localhost/mahara/htdocs/view/blocks.php?id=6 [Tue Sep 24 21:10:05 2013] [error] [client 127.0.0.1] * get_records_select_assoc(view_layout, layoutmenuorder 0 AND iscustom = 0, array(size 0), layoutmenuorder, id, id) at /var/www/mahara/htdocs/view/layout.php:60, referer: http://localhost/mahara/htdocs/view/blocks.php?id=6 [Tue Sep 24 21:10:05 2013] [error] [client 127.0.0.1] , referer: http://localhost/mahara/htdocs/view/blocks.php?id=6 To manage notifications about this bug go to:
[Mahara-contributors] [Bug 1230042] Re: Changing page layout not working
Hi Dirk Ok, I'll mark the bug as invalid ** Changed in: mahara Status: New = Invalid -- 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/1230042 Title: Changing page layout not working Status in Mahara ePortfolio: Invalid Bug description: Master mysql php5 Ubuntu When trying to change the pagelayout, this error is orinted to the browser: Mahara: Site unavailable A nonrecoverable error occurred. This probably means you have encountered a bug in the system Apache error log reads this: [Tue Sep 24 21:10:05 2013] [error] [client 127.0.0.1] [WAR] e9 (lib/errors.php:752) Failed to get a recordset: mysqli error: [1054: Unknown column 'layoutmenuorder' in 'where clause'] in EXECUTE(SELECT id, id FROM view_layout WHERE layoutmenuorder 0 AND iscustom = 0 ORDER BY layoutmenuorder ), referer: http://localhost/mahara/htdocs/view/blocks.php?id=6 [Tue Sep 24 21:10:05 2013] [error] [client 127.0.0.1] [WAR] e9 (lib/errors.php:752) Command was: SELECT id, id FROM view_layout WHERE layoutmenuorder 0 AND iscustom = 0 ORDER BY layoutmenuorder , referer: http://localhost/mahara/htdocs/view/blocks.php?id=6 [Tue Sep 24 21:10:05 2013] [error] [client 127.0.0.1] Call stack (most recent first):, referer: http://localhost/mahara/htdocs/view/blocks.php?id=6 [Tue Sep 24 21:10:05 2013] [error] [client 127.0.0.1] * log_message(Failed to get a recordset: mysqli error: [1054: Un..., 8, true, true) at /var/www/mahara/htdocs/lib/errors.php:109, referer: http://localhost/mahara/htdocs/view/blocks.php?id=6 [Tue Sep 24 21:10:05 2013] [error] [client 127.0.0.1] * log_warn(Failed to get a recordset: mysqli error: [1054: Un...) at /var/www/mahara/htdocs/lib/errors.php:752, referer: http://localhost/mahara/htdocs/view/blocks.php?id=6 [Tue Sep 24 21:10:05 2013] [error] [client 127.0.0.1] * SQLException-__construct(Failed to get a recordset: mysqli error: [1054: Un...) at /var/www/mahara/htdocs/lib/dml.php:492, referer: http://localhost/mahara/htdocs/view/blocks.php?id=6 [Tue Sep 24 21:10:05 2013] [error] [client 127.0.0.1] * get_recordset_sql(SELECT id, id FROM view_layout WHERE layoutmenuo..., array(size 0)) at /var/www/mahara/htdocs/lib/dml.php:448, referer: http://localhost/mahara/htdocs/view/blocks.php?id=6 [Tue Sep 24 21:10:05 2013] [error] [client 127.0.0.1] * get_recordset_select(view_layout, layoutmenuorder 0 AND iscustom = 0, array(size 0), layoutmenuorder, id, id, , ) at /var/www/mahara/htdocs/lib/dml.php:621, referer: http://localhost/mahara/htdocs/view/blocks.php?id=6 [Tue Sep 24 21:10:05 2013] [error] [client 127.0.0.1] * get_records_select_assoc(view_layout, layoutmenuorder 0 AND iscustom = 0, array(size 0), layoutmenuorder, id, id) at /var/www/mahara/htdocs/view/layout.php:60, referer: http://localhost/mahara/htdocs/view/blocks.php?id=6 [Tue Sep 24 21:10:05 2013] [error] [client 127.0.0.1] , referer: http://localhost/mahara/htdocs/view/blocks.php?id=6 [Tue Sep 24 21:10:05 2013] [error] [client 127.0.0.1] [WAR] e9 (lib/dml.php:492) Failed to get a recordset: mysqli error: [1054: Unknown column 'layoutmenuorder' in 'where clause'] in EXECUTE(SELECT id, id FROM view_layout WHERE layoutmenuorder 0 AND iscustom = 0 ORDER BY layoutmenuorder ), referer: http://localhost/mahara/htdocs/view/blocks.php?id=6 [Tue Sep 24 21:10:05 2013] [error] [client 127.0.0.1] [WAR] e9 (lib/dml.php:492) Command was: SELECT id, id FROM view_layout WHERE layoutmenuorder 0 AND iscustom = 0 ORDER BY layoutmenuorder , referer: http://localhost/mahara/htdocs/view/blocks.php?id=6 [Tue Sep 24 21:10:05 2013] [error] [client 127.0.0.1] Call stack (most recent first):, referer: http://localhost/mahara/htdocs/view/blocks.php?id=6 [Tue Sep 24 21:10:05 2013] [error] [client 127.0.0.1] * get_recordset_sql(SELECT id, id FROM view_layout WHERE layoutmenuo..., array(size 0)) at /var/www/mahara/htdocs/lib/dml.php:448, referer: http://localhost/mahara/htdocs/view/blocks.php?id=6 [Tue Sep 24 21:10:05 2013] [error] [client 127.0.0.1] * get_recordset_select(view_layout, layoutmenuorder 0 AND iscustom = 0, array(size 0), layoutmenuorder, id, id, , ) at /var/www/mahara/htdocs/lib/dml.php:621, referer: http://localhost/mahara/htdocs/view/blocks.php?id=6 [Tue Sep 24 21:10:05 2013] [error] [client 127.0.0.1] * get_records_select_assoc(view_layout, layoutmenuorder 0 AND iscustom = 0, array(size 0), layoutmenuorder, id, id) at /var/www/mahara/htdocs/view/layout.php:60, referer: http://localhost/mahara/htdocs/view/blocks.php?id=6 [Tue Sep 24 21:10:05 2013] [error] [client 127.0.0.1] , referer: http://localhost/mahara/htdocs/view/blocks.php?id=6 To manage notifications about this bug go to: