19 April 2010, 5:44

Hi,

I am using:

* Debian

*Apache/2.2.9

* PHP/5.2.6-1

* MySql 5.0.51a

I try to upgrade from Mahara 1.0.6 to 1.2.4. It does not work --> see image

Does anybody has an idea for a solution?

19 April 2010, 6:41

Could not execute command: ALTER TABLE "group" ADD grouptype CHARACTER VARYING(20)

Call stack (most recent first):

• execute_sql("ALTER TABLE {group} ADD grouptype CHARACTER VARYIN...") at/var/www/mahara_upgrade/mahara/lib/db/upgrade.php:167

I have just looked into my database. There is a field "grouptype" at table group. It is varchar(20) .

What does VARYIN mean? Why is there the error message?

19 April 2010, 16:59

Hi Michael,

I'm not sure why that column would already be there, but my guess is that you've had a previous upgrade fail halfway through.  Is that possible?  Unfortunately if you are using MySQL then you need to restore your database (and dataroot) from backup in between upgrade attempts, otherwise you can end up with a half-upgraded database that's very difficult to deal with.

R.