21 January 2009, 12:51

Hello,

Using the git version, I'm getting this error on the web-based install:

Could not execute command: CREATE TABLE ma_host ( wwwroot VARCHAR(255) NOT NULL, name VARCHAR(80) NOT NULL, institution VARCHAR(255) NOT NULL, ipaddress VARCHAR(39) NOT NULL, portno BIGINT(10) NOT NULL DEFAULT 80, appname VARCHAR(20) NOT NULL, publickey TEXT NOT NULL DEFAULT '', publickeyexpires BIGINT(10) NOT NULL, deleted TINYINT(1) NOT NULL DEFAULT 0, lastconnecttime BIGINT(10) NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (wwwroot), CONSTRAINT ma_host_ins_fk FOREIGN KEY (institution) REFERENCES ma_institution (name), CONSTRAINT ma_host_app_fk FOREIGN KEY (appname) REFERENCES ma_application (name) )TYPE=innodb

Call stack (most recent first):

• execute_sql("CREATE TABLE ma_host (
• 
  wwwroot VARCHAR(255) NO...", true) at /var/www/html/mahara/lib/dml.php:1360
• execute_sql_arr(array(size 216)) at /var/www/html/mahara/lib/ddl.php:565
• install_from_xmldb_file("/var/www/html/mahara/lib/db/install.xml") at /var/www/html/mahara/lib/upgrade.php:265
• upgrade_core(object(stdClass)) at /var/www/html/mahara/admin/upgrade.json.php:71

Some details:

mysql  Ver 14.12 Distrib 5.0.45, for redhat-linux-gnu (x86_64) using readline 5.0

PHP 5.1.6 (cli) (built: Nov 12 2008 11:22:53)
Copyright (c) 1997-2006 The PHP Group
Zend Engine v2.1.0, Copyright (c) 1998-2006 Zend Technologies
    with eAccelerator v0.9.5.3, Copyright (c) 2004-2006 eAccelerator, by eAccelerator

Any help appreciated. I've tried changing the db character set from/to UTF-8 but it still fails.

Thank you

21 January 2009, 20:53