Forums | Mahara Community
Support
/
SQL-Error "adodb_throw" upgrading from 1.7.2
24 July 2015, 3:02
Hi,
upgrade from 1.7.2 stops with an SQL-Error:
"
Failed to get a recordset: mysqli error: [1054: Unknown column 'columns' in 'field list'] in adodb_throw(SELECT id, columns, widths FROM "view_layout" ORDER BY id , ) Command was: SELECT id, columns, widths FROM "view_layout" ORDER BY id
- get_recordset_sql("SELECT id, columns, widths FROM "view_layout" ORDE...", null) at /var/www/lib/dml.php:433
- get_recordset_select("view_layout", "", null, "id", "id, columns, widths", "", "") at /var/www/lib/dml.php:397
- get_recordset("view_layout", "", "", "id", "id, columns, widths", "", "") at /var/www/lib/dml.php:586
- get_records_array("view_layout", "", "", "id", "id, columns, widths") at /var/www/lib/db/upgrade.php:2440
- xmldb_core_upgrade("2013032209") at /var/www/lib/upgrade.php:297
- upgrade_core(object(stdClass)) at /var/www/admin/upgrade.json.php:79
"
Trying upgrading to other versions stops with the same error (only sligthly changed code-lines). First try was to 15.04, second to 1.9.7, third to 1.8.7 (all versions downloaded from launchpad) - always just that error above.
PHP-Version on server: 5.5.41-0ubuntu0.12.04.1 (Ubuntu)
phpinfo.php shows: 5.3.10-1ubuntu3.16
charset: UTF8
mysqlnd 5.0.8
Ubuntu precise (12.04.5 LTS) with Apache/2.2.22 (Ubuntu)
Thanks for anyones assistance!
Klaus
24 July 2015, 21:12
The problem is fixed now. Somehow the upgrade script got weired while the first error we got upgrading. Bug:
https://reviews.mahara.org/#/c/4749/2/htdocs/artefact/lib.php
After changing the lib.php the upgrade script hung as decribed above.
The reason were already changed database-entries and tables in the context "view_layout". Deleting that corrupt database and replacing it by the backup made before first upgrade try worked fine.
have a nice weekend!
Klaus