Forums | Mahara Community

Support /
Upgrade Problem 1.1.1 using MySQL 5.1.32


anonymous profile picture
Deleted user
Posts: 13

09 March 2009, 5:56 PM

I'm moving this here from the News Forum, where it overstayed its welcome!

Attempting to upgrade from 1.0.9 to 1.1.1.  Testing it on a clone of the 1.0.9 db called "mahara111".  Using MySQL 5.1.32.  usr Root=0;

Still get the following message:

 Could not execute command: CREATE TABLE "mah_artefact_access_role" ( role VARCHAR(255) NOT NULL, artefact INTEGER NOT NULL REFERENCES "mah_artefact"(id), can_view SMALLINT NOT NULL, can_edit SMALLINT NOT NULL, can_republish SMALLINT NOT NULL );

Call stack (most recent first):
  • execute_sql("CREATE TABLE {artefact_access_role} (
    ..."
    ) at /Library/WebServer/Documents/mahara111/lib/db/upgrade.php:270
  • xmldb_core_upgrade("2008040218") at /Library/WebServer/Documents/mahara111/lib/upgrade.php:271
  • upgrade_core(object(stdClass)) at /Library/WebServer/Documents/mahara111/admin/upgrade.json.php:71
anonymous profile picture
Deleted user
Posts: 808

09 March 2009, 7:35 PM

Hi Dave,

Thanks for confirming the root id problem.  I think I'll add something to the upgrade to change root's id to 0 if it isn't already.

I'm not sure why you're getting the next problem though.  Unfortunately the installer message doesn't say why the sql command failed, but if you could post the more detailed message from your logs then we may be able to work it out.

Richard.

anonymous profile picture
Deleted user
Posts: 13

12 March 2009, 12:21 PM

Well, we're making it a little further throught the alphabetical list of tables.  Here's the lastest installer error, which occurs whether or not I've set FOREIGN_KEY_CHECKS=0 from the command line:

core       1.0.9      1.1.2      :
( Could not execute command: CREATE TABLE mah_grouptype_event_subscription ( id BIGINT(10) NOT NULL auto_increment, plugin VARCHAR(255) NOT NULL, event VARCHAR(50) NOT NULL, callfunction VARCHAR(255) NOT NULL, CONSTRAINT PRIMARY KEY (id), CONSTRAINT mah_grouevensubs_plu_fk FOREIGN KEY (plugin) REFERENCES mah_grouptype_installed (name), CONSTRAINT mah_grouevensubs_eve_fk FOREIGN KEY (event) REFERENCES mah_event_type (name) )TYPE=innodb

Call stack (most recent first):

    * execute_sql("CREATE TABLE mah_grouptype_event_subscription ( ...", true) at /Library/WebServer/Documents/mahara112/lib/dml.php:1360
    * execute_sql_arr(array(size 4), true, true) at /Library/WebServer/Documents/mahara112/lib/ddl.php:599
    * create_table(object(XMLDBTable)) at /Library/WebServer/Documents/mahara112/lib/db/upgrade.php:368
    * xmldb_core_upgrade("2008040218") at /Library/WebServer/Documents/mahara112/lib/upgrade.php:271
    * upgrade_core(object(stdClass)) at /Library/WebServer/Documents/mahara112/admin/upgrade.json.php:71

 And here's the version of the error report from the apache error logs:

[Thu Mar 12 11:11:13 2009] [error] [WAR] 49 (lib/errors.php:663)     plugin VARCHAR(255) NOT NULL,
[Thu Mar 12 11:11:13 2009] [error] [WAR] 49 (lib/errors.php:663) event VARCHAR(50) NOT NULL,
[Thu Mar 12 11:11:13 2009] [error] [WAR] 49 (lib/errors.php:663) callfunction VARCHAR(255) NOT NULL,
[Thu Mar 12 11:11:13 2009] [error] [WAR] 49 (lib/errors.php:663) CONSTRAINT PRIMARY KEY (id),
[Thu Mar 12 11:11:13 2009] [error] [WAR] 49 (lib/errors.php:663) CONSTRAINT mah_grouevensubs_plu_fk FOREIGN KEY (plugin) REFERENCES mah_grouptype_installed (name),
[Thu Mar 12 11:11:13 2009] [error] [WAR] 49 (lib/errors.php:663) CONSTRAINT mah_grouevensubs_eve_fk FOREIGN KEY (event) REFERENCES mah_event_type (name)
[Thu Mar 12 11:11:13 2009] [error] [WAR] 49 (lib/errors.php:663) )TYPE=innodb
[Thu Mar 12 11:11:13 2009] [error] Call stack (most recent first):
[Thu Mar 12 11:11:13 2009] [error] * log_message("Could not execute command: CREATE TABLE mah_groupt...", 8, true, true) at /Library/WebServer/Documents/mahara112/lib/errors.php:90
[Thu Mar 12 11:11:13 2009] [error] * log_warn("Could not execute command: CREATE TABLE mah_groupt...") at /Library/WebServer/Documents/mahara112/lib/errors.php:663
[Thu Mar 12 11:11:13 2009] [error] * SQLException->__construct("Could not execute command: CREATE TABLE mah_groupt...") at /Library/WebServer/Documents/mahara112/lib/dml.php:129
[Thu Mar 12 11:11:13 2009] [error] * execute_sql("CREATE TABLE mah_grouptype_event_subscription (
[Thu Mar 12 11:11:13 2009] [error] ...", true) at /Library/WebServer/Documents/mahara112/lib/dml.php:1360
[Thu Mar 12 11:11:13 2009] [error] * execute_sql_arr(array(size 4), true, true) at /Library/WebServer/Documents/mahara112/lib/ddl.php:599
[Thu Mar 12 11:11:13 2009] [error] * create_table(object(XMLDBTable)) at /Library/WebServer/Documents/mahara112/lib/db/upgrade.php:368
[Thu Mar 12 11:11:13 2009] [error] * xmldb_core_upgrade("2008040218") at /Library/WebServer/Documents/mahara112/lib/upgrade.php:271
[Thu Mar 12 11:11:13 2009] [error] * upgrade_core(object(stdClass)) at /Library/WebServer/Documents/mahara112/admin/upgrade.json.php:71
[Thu Mar 12 11:11:13 2009] [error]

 

anonymous profile picture
Deleted user
Posts: 1643

12 March 2009, 4:53 PM

Hi - is there more to the error log than that? It looks like you grabbed it from about half way through.
anonymous profile picture
Deleted user
Posts: 13

13 March 2009, 1:54 PM

Tried it again.  This looks like all the relevant lines from the apache error log:

[Fri Mar 13 12:49:11 2009] [error] [DBG] ce (lib/db/upgrade.php:163) GROUP TYPE REFACTOR
[Fri Mar 13 12:49:11 2009] [error] [DBG] ce (lib/db/upgrade.php:174) Migrating group SLAIN (1)
[Fri Mar 13 12:49:11 2009] [error] [DBG] ce (lib/db/upgrade.php:185) * new group type is standard
[Fri Mar 13 12:49:11 2009] [error] [DBG] ce (lib/db/upgrade.php:222) * marked appropriate users as being members
[Fri Mar 13 12:49:11 2009] [error] [DBG] ce (lib/db/upgrade.php:212) * marked user 37 as having the admin role
[Fri Mar 13 12:49:11 2009] [error] [DBG] ce (lib/db/upgrade.php:174) Migrating group Singularity and Multiplicity (2)
[Fri Mar 13 12:49:11 2009] [error] [DBG] ce (lib/db/upgrade.php:185) * new group type is course
[Fri Mar 13 12:49:11 2009] [error] [DBG] ce (lib/db/upgrade.php:222) * marked appropriate users as being members
[Fri Mar 13 12:49:11 2009] [error] [DBG] ce (lib/db/upgrade.php:222) * marked appropriate users as being tutors
[Fri Mar 13 12:49:11 2009] [error] [DBG] ce (lib/db/upgrade.php:212) * marked user 25 as having the admin role
[Fri Mar 13 12:49:11 2009] [error] [DBG] ce (lib/db/upgrade.php:174) Migrating group TEST Singularity and Multiplicity.deleted.1236101190 (3)
[Fri Mar 13 12:49:11 2009] [error] [DBG] ce (lib/db/upgrade.php:185) * new group type is standard
[Fri Mar 13 12:49:11 2009] [error] [DBG] ce (lib/db/upgrade.php:222) * marked appropriate users as being members
[Fri Mar 13 12:49:11 2009] [error] [DBG] ce (lib/db/upgrade.php:212) * marked user 25 as having the admin role
[Fri Mar 13 12:49:11 2009] [error] [DBG] ce (lib/db/upgrade.php:174) Migrating group TEST Casting and Carving (4)
[Fri Mar 13 12:49:11 2009] [error] [DBG] ce (lib/db/upgrade.php:185) * new group type is course
[Fri Mar 13 12:49:11 2009] [error] [DBG] ce (lib/db/upgrade.php:222) * marked appropriate users as being members
[Fri Mar 13 12:49:11 2009] [error] [DBG] ce (lib/db/upgrade.php:222) * marked appropriate users as being tutors
[Fri Mar 13 12:49:11 2009] [error] [DBG] ce (lib/db/upgrade.php:212) * marked user 48 as having the admin role
[Fri Mar 13 12:49:11 2009] [error] [DBG] ce (lib/db/upgrade.php:174) Migrating group Casting and Carving Fall 2008 (5)
[Fri Mar 13 12:49:11 2009] [error] [DBG] ce (lib/db/upgrade.php:185) * new group type is course
[Fri Mar 13 12:49:11 2009] [error] [DBG] ce (lib/db/upgrade.php:222) * marked appropriate users as being members
[Fri Mar 13 12:49:11 2009] [error] [DBG] ce (lib/db/upgrade.php:222) * marked appropriate users as being tutors
[Fri Mar 13 12:49:11 2009] [error] [DBG] ce (lib/db/upgrade.php:212) * marked user 25 as having the admin role
[Fri Mar 13 12:49:11 2009] [error] [DBG] ce (lib/db/upgrade.php:174) Migrating group Wood and Metal Construction Fall 2008 (6)
[Fri Mar 13 12:49:11 2009] [error] [DBG] ce (lib/db/upgrade.php:185) * new group type is course
[Fri Mar 13 12:49:11 2009] [error] [DBG] ce (lib/db/upgrade.php:222) * marked appropriate users as being members
[Fri Mar 13 12:49:11 2009] [error] [DBG] ce (lib/db/upgrade.php:222) * marked appropriate users as being tutors
[Fri Mar 13 12:49:11 2009] [error] [DBG] ce (lib/db/upgrade.php:212) * marked user 25 as having the admin role
[Fri Mar 13 12:49:11 2009] [error] [DBG] ce (lib/db/upgrade.php:174) Migrating group ISA240 Fall 2008 (7)
[Fri Mar 13 12:49:11 2009] [error] [DBG] ce (lib/db/upgrade.php:185) * new group type is standard
[Fri Mar 13 12:49:11 2009] [error] [DBG] ce (lib/db/upgrade.php:222) * marked appropriate users as being members
[Fri Mar 13 12:49:11 2009] [error] [DBG] ce (lib/db/upgrade.php:212) * marked user 123 as having the admin role
[Fri Mar 13 12:49:11 2009] [error] [DBG] ce (lib/db/upgrade.php:174) Migrating group ISA 241 (8)
[Fri Mar 13 12:49:11 2009] [error] [DBG] ce (lib/db/upgrade.php:185) * new group type is standard
[Fri Mar 13 12:49:11 2009] [error] [DBG] ce (lib/db/upgrade.php:222) * marked appropriate users as being members
[Fri Mar 13 12:49:11 2009] [error] [DBG] ce (lib/db/upgrade.php:212) * marked user 311 as having the admin role
[Fri Mar 13 12:49:11 2009] [error] [DBG] ce (lib/db/upgrade.php:174) Migrating group Visual Dynamics 2 T/T 12:30 - 3:20 (9)
[Fri Mar 13 12:49:11 2009] [error] [DBG] ce (lib/db/upgrade.php:185) * new group type is standard
[Fri Mar 13 12:49:11 2009] [error] [DBG] ce (lib/db/upgrade.php:222) * marked appropriate users as being members
[Fri Mar 13 12:49:11 2009] [error] [DBG] ce (lib/db/upgrade.php:212) * marked user 373 as having the admin role
[Fri Mar 13 12:49:11 2009] [error] [DBG] ce (lib/db/upgrade.php:174) Migrating group Visual Dynamics 2 T/T 3:30 - 6:20 (10)
[Fri Mar 13 12:49:11 2009] [error] [DBG] ce (lib/db/upgrade.php:185) * new group type is standard
[Fri Mar 13 12:49:11 2009] [error] [DBG] ce (lib/db/upgrade.php:222) * marked appropriate users as being members
[Fri Mar 13 12:49:11 2009] [error] [DBG] ce (lib/db/upgrade.php:212) * marked user 373 as having the admin role
[Fri Mar 13 12:49:11 2009] [error] [DBG] ce (lib/db/upgrade.php:174) Migrating group Foundations - Honors Group (11)
[Fri Mar 13 12:49:11 2009] [error] [DBG] ce (lib/db/upgrade.php:185) * new group type is standard
[Fri Mar 13 12:49:11 2009] [error] [DBG] ce (lib/db/upgrade.php:222) * marked appropriate users as being members
[Fri Mar 13 12:49:11 2009] [error] [DBG] ce (lib/db/upgrade.php:212) * marked user 360 as having the admin role
[Fri Mar 13 12:49:11 2009] [error] [DBG] ce (lib/db/upgrade.php:174) Migrating group test.deleted.1233702045 (12)
[Fri Mar 13 12:49:11 2009] [error] [DBG] ce (lib/db/upgrade.php:185) * new group type is standard
[Fri Mar 13 12:49:11 2009] [error] [DBG] ce (lib/db/upgrade.php:222) * marked appropriate users as being members
[Fri Mar 13 12:49:11 2009] [error] [DBG] ce (lib/db/upgrade.php:212) * marked user 360 as having the admin role
[Fri Mar 13 12:49:11 2009] [error] [DBG] ce (lib/db/upgrade.php:174) Migrating group Test group (13)
[Fri Mar 13 12:49:11 2009] [error] [DBG] ce (lib/db/upgrade.php:185) * new group type is standard
[Fri Mar 13 12:49:11 2009] [error] [DBG] ce (lib/db/upgrade.php:222) * marked appropriate users as being members
[Fri Mar 13 12:49:11 2009] [error] [DBG] ce (lib/db/upgrade.php:212) * marked user 2 as having the admin role
[Fri Mar 13 12:49:11 2009] [error] [DBG] ce (lib/db/upgrade.php:174) Migrating group Construction: Metal & Wood Spring 2009.deleted.1236099503 (14)
[Fri Mar 13 12:49:11 2009] [error] [DBG] ce (lib/db/upgrade.php:185) * new group type is course
[Fri Mar 13 12:49:11 2009] [error] [DBG] ce (lib/db/upgrade.php:222) * marked appropriate users as being members
[Fri Mar 13 12:49:11 2009] [error] [DBG] ce (lib/db/upgrade.php:222) * marked appropriate users as being tutors
[Fri Mar 13 12:49:11 2009] [error] [DBG] ce (lib/db/upgrade.php:212) * marked user 14 as having the admin role
[Fri Mar 13 12:49:11 2009] [error] [DBG] ce (lib/db/upgrade.php:174) Migrating group Construction: Metal & Wood Spring 2009.deleted.1236099625 (15)
[Fri Mar 13 12:49:11 2009] [error] [DBG] ce (lib/db/upgrade.php:185) * new group type is course
[Fri Mar 13 12:49:11 2009] [error] [DBG] ce (lib/db/upgrade.php:222) * marked appropriate users as being members
[Fri Mar 13 12:49:11 2009] [error] [DBG] ce (lib/db/upgrade.php:222) * marked appropriate users as being tutors
[Fri Mar 13 12:49:11 2009] [error] [DBG] ce (lib/db/upgrade.php:212) * marked user 14 as having the admin role
[Fri Mar 13 12:49:11 2009] [error] [DBG] ce (lib/db/upgrade.php:174) Migrating group Wood & Metal Construction Spring 2009 (16)
[Fri Mar 13 12:49:11 2009] [error] [DBG] ce (lib/db/upgrade.php:185) * new group type is course
[Fri Mar 13 12:49:11 2009] [error] [DBG] ce (lib/db/upgrade.php:222) * marked appropriate users as being members
[Fri Mar 13 12:49:11 2009] [error] [DBG] ce (lib/db/upgrade.php:222) * marked appropriate users as being tutors
[Fri Mar 13 12:49:11 2009] [error] [DBG] ce (lib/db/upgrade.php:212) * marked user 25 as having the admin role
[Fri Mar 13 12:49:11 2009] [error] [DBG] ce (lib/db/upgrade.php:174) Migrating group ISA_2009 (17)
[Fri Mar 13 12:49:11 2009] [error] [DBG] ce (lib/db/upgrade.php:185) * new group type is standard
[Fri Mar 13 12:49:11 2009] [error] [DBG] ce (lib/db/upgrade.php:222) * marked appropriate users as being members
[Fri Mar 13 12:49:11 2009] [error] [DBG] ce (lib/db/upgrade.php:212) * marked user 417 as having the admin role
[Fri Mar 13 12:49:16 2009] [error] [DBG] ce (lib/dml.php:127) mysql error: [1005: Can't create table 'mahara112.mah_grouptype_event_subscription' (errno: 150)] in adodb_throw(CREATE TABLE mah_grouptype_event_subscription (
[Fri Mar 13 12:49:16 2009] [error] [DBG] ce (lib/dml.php:127) id BIGINT(10) NOT NULL auto_increment,
[Fri Mar 13 12:49:16 2009] [error] [DBG] ce (lib/dml.php:127) plugin VARCHAR(255) NOT NULL,
[Fri Mar 13 12:49:16 2009] [error] [DBG] ce (lib/dml.php:127) event VARCHAR(50) NOT NULL,
[Fri Mar 13 12:49:16 2009] [error] [DBG] ce (lib/dml.php:127) callfunction VARCHAR(255) NOT NULL,
[Fri Mar 13 12:49:16 2009] [error] [DBG] ce (lib/dml.php:127) CONSTRAINT PRIMARY KEY (id),
[Fri Mar 13 12:49:16 2009] [error] [DBG] ce (lib/dml.php:127) CONSTRAINT mah_grouevensubs_plu_fk FOREIGN KEY (plugin) REFERENCES mah_grouptype_installed (name),
[Fri Mar 13 12:49:16 2009] [error] [DBG] ce (lib/dml.php:127) CONSTRAINT mah_grouevensubs_eve_fk FOREIGN KEY (event) REFERENCES mah_event_type (name)
[Fri Mar 13 12:49:16 2009] [error] [DBG] ce (lib/dml.php:127) )TYPE=innodb, )
[Fri Mar 13 12:49:16 2009] [error] [DBG] ce (lib/dml.php:127) Command was: CREATE TABLE mah_grouptype_event_subscription (
[Fri Mar 13 12:49:16 2009] [error] [DBG] ce (lib/dml.php:127) id BIGINT(10) NOT NULL auto_increment,
[Fri Mar 13 12:49:16 2009] [error] [DBG] ce (lib/dml.php:127) plugin VARCHAR(255) NOT NULL,
[Fri Mar 13 12:49:16 2009] [error] [DBG] ce (lib/dml.php:127) event VARCHAR(50) NOT NULL,
[Fri Mar 13 12:49:16 2009] [error] [DBG] ce (lib/dml.php:127) callfunction VARCHAR(255) NOT NULL,
[Fri Mar 13 12:49:16 2009] [error] [DBG] ce (lib/dml.php:127) CONSTRAINT PRIMARY KEY (id),
[Fri Mar 13 12:49:16 2009] [error] [DBG] ce (lib/dml.php:127) CONSTRAINT mah_grouevensubs_plu_fk FOREIGN KEY (plugin) REFERENCES mah_grouptype_installed (name),
[Fri Mar 13 12:49:16 2009] [error] [DBG] ce (lib/dml.php:127) CONSTRAINT mah_grouevensubs_eve_fk FOREIGN KEY (event) REFERENCES mah_event_type (name)
[Fri Mar 13 12:49:16 2009] [error] [DBG] ce (lib/dml.php:127) )TYPE=innodb
[Fri Mar 13 12:49:16 2009] [error] [WAR] ce (lib/errors.php:663) Could not execute command: CREATE TABLE mah_grouptype_event_subscription (
[Fri Mar 13 12:49:16 2009] [error] [WAR] ce (lib/errors.php:663) id BIGINT(10) NOT NULL auto_increment,
[Fri Mar 13 12:49:16 2009] [error] [WAR] ce (lib/errors.php:663) plugin VARCHAR(255) NOT NULL,
[Fri Mar 13 12:49:16 2009] [error] [WAR] ce (lib/errors.php:663) event VARCHAR(50) NOT NULL,
[Fri Mar 13 12:49:16 2009] [error] [WAR] ce (lib/errors.php:663) callfunction VARCHAR(255) NOT NULL,
[Fri Mar 13 12:49:16 2009] [error] [WAR] ce (lib/errors.php:663) CONSTRAINT PRIMARY KEY (id),
[Fri Mar 13 12:49:16 2009] [error] [WAR] ce (lib/errors.php:663) CONSTRAINT mah_grouevensubs_plu_fk FOREIGN KEY (plugin) REFERENCES mah_grouptype_installed (name),
[Fri Mar 13 12:49:16 2009] [error] [WAR] ce (lib/errors.php:663) CONSTRAINT mah_grouevensubs_eve_fk FOREIGN KEY (event) REFERENCES mah_event_type (name)
[Fri Mar 13 12:49:16 2009] [error] [WAR] ce (lib/errors.php:663) )TYPE=innodb
[Fri Mar 13 12:49:16 2009] [error] Call stack (most recent first):
[Fri Mar 13 12:49:16 2009] [error] * log_message("Could not execute command: CREATE TABLE mah_groupt...", 8, true, true) at /Library/WebServer/Documents/mahara112a/lib/errors.php:90
[Fri Mar 13 12:49:16 2009] [error] * log_warn("Could not execute command: CREATE TABLE mah_groupt...") at /Library/WebServer/Documents/mahara112a/lib/errors.php:663
[Fri Mar 13 12:49:16 2009] [error] * SQLException->__construct("Could not execute command: CREATE TABLE mah_groupt...") at /Library/WebServer/Documents/mahara112a/lib/dml.php:129
[Fri Mar 13 12:49:16 2009] [error] * execute_sql("CREATE TABLE mah_grouptype_event_subscription (
[Fri Mar 13 12:49:16 2009] [error] ...", true) at /Library/WebServer/Documents/mahara112a/lib/dml.php:1360
[Fri Mar 13 12:49:16 2009] [error] * execute_sql_arr(array(size 4), true, true) at /Library/WebServer/Documents/mahara112a/lib/ddl.php:599
[Fri Mar 13 12:49:16 2009] [error] * create_table(object(XMLDBTable)) at /Library/WebServer/Documents/mahara112a/lib/db/upgrade.php:368
[Fri Mar 13 12:49:16 2009] [error] * xmldb_core_upgrade("2008040218") at /Library/WebServer/Documents/mahara112a/lib/upgrade.php:271
[Fri Mar 13 12:49:16 2009] [error] * upgrade_core(object(stdClass)) at /Library/WebServer/Documents/mahara112a/admin/upgrade.json.php:71

 

anonymous profile picture
Deleted user
Posts: 1643

14 March 2009, 6:37 AM

Hi - annoyingly, MySQL hasn't provided a decent error message Frown. Do you have access to a MySQL shell? Could you run that query manually, and then run SHOW ENGINE innodb STATUS;, and see what error message shows up?

The query:

CREATE TABLE mah_grouptype_event_subscription (
id BIGINT(10) NOT NULL auto_increment,
plugin VARCHAR(255) NOT NULL,
event VARCHAR(50) NOT NULL,
callfunction VARCHAR(255) NOT NULL,
CONSTRAINT PRIMARY KEY (id),
CONSTRAINT mah_grouevensubs_plu_fk FOREIGN KEY (plugin) REFERENCES mah_grouptype_installed (name),
CONSTRAINT mah_grouevensubs_eve_fk FOREIGN KEY (event) REFERENCES mah_event_type (name)
)TYPE=innodb
anonymous profile picture
Deleted user
Posts: 13

18 March 2009, 2:21 PM

Here it is:

InnoDB
===================================== 090318 13:19:31 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 59 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 1463, signal count 1452 Mutex spin waits 0, rounds 17242, OS waits 190 RW-shared spins 1608, OS waits 778; RW-excl spins 546, OS waits 416 ------------------------ LATEST FOREIGN KEY ERROR ------------------------ 090318 13:19:21 Error in foreign key constraint of table mahara112/mah_grouptype_event_subscription: FOREIGN KEY (event) REFERENCES mah_event_type (name) )TYPE=innodb: Cannot find an index in the referenced table where the referenced columns appear as the first columns, or column types in the table and the referenced table do not match for constraint. Note that the internal storage type of ENUM and SET changed in tables created with >= InnoDB-4.1.12, and such columns in old tables cannot be referenced by such columns in new tables. See http://dev.mysql.com/doc/refman/5.1/en/innodb-foreign-key-constraints.html for correct foreign key definition. ------------ TRANSACTIONS ------------ Trx id counter 0 313830 Purge done for trx's n:o < 0 313820 undo n:o < 0 0 History list length 17 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 0, not started, OS thread id 39394304 MySQL thread id 66172, query id 5812536 localhost root SHOW ENGINE innodb STATUS -------- FILE I/O -------- I/O thread 0 state: waiting for i/o request (insert buffer thread) I/O thread 1 state: waiting for i/o request (log thread) I/O thread 2 state: waiting for i/o request (read thread) I/O thread 3 state: waiting for i/o request (write thread) Pending normal aio reads: 0, aio writes: 0, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 5412 OS file reads, 30216 OS file writes, 21673 OS fsyncs 0.02 reads/s, 16384 avg bytes/read, 0.02 writes/s, 0.02 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- size 1, free list len 0, seg size 2, 47 inserts, 47 merged recs, 28 merges Hash table size 34679, node heap has 1 buffer(s) 0.00 hash searches/s, 0.49 non-hash searches/s --- LOG --- Log sequence number 0 265190139 Log flushed up to 0 265190139 Last checkpoint at 0 265184886 0 pending log writes, 0 pending chkp writes 19887 log i/o's done, 0.02 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 22347402; in additional pool allocated 1048576 Dictionary memory allocated 2486632 Buffer pool size 512 Free buffers 1 Database pages 510 Modified db pages 13 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages read 6380, created 2587, written 22881 0.02 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 995 / 1000 -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 1 read views open inside InnoDB Main thread id 33807872, state: sleeping Number of rows inserted 540429, updated 3696, deleted 266, read 2579451 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================

 

anonymous profile picture
Deleted user
Posts: 1643

18 March 2009, 6:37 PM

Right, that is saying that there is no key on the mah_event_type table, which is strange because I certainly have one - it's the primary key:

 mahara-1-1-stable=# \d mh_event_type 
        Table "public.mh_event_type"
 Column |         Type          | Modifiers 
--------+-----------------------+-----------
 name   | character varying(50) | not null
Indexes:
    "mh_eventype_nam_pk" PRIMARY KEY, btree (name)


Could you please paste the output of "DESCRIBE mah_event_type"?

anonymous profile picture
Deleted user
Posts: 13

20 March 2009, 10:33 AM

Here's the output of "DESCRIBE mah_event_type":

 

Field Type Null Key Default Extra
name varchar(50) NO PRI NULL

 

anonymous profile picture
Deleted user
Posts: 13

20 March 2009, 4:20 PM

This week it's become clear that there's something wrong with our 1.0.9 installation, which may be leading to the problems with the upgrade.  Recently the members of groups no longer appear on the "Find Groups" page; a logged-in person's name no longer appears above the small profile icon -- just "()", and a person's profile is mostly blank. 

 Is there any way to start with a fresh installation of 1.1.2, and then import selected users/artefacts/views into it from an old installation?

26 results