Forums | Mahara Community
Problem installing failes at Could not execute command: CREATE TABLE mah_config ( field VARCHAR(255)
13 October 2010, 8:29
This is my first time in the forums, I appreciate any time you have to help me on this, I have went through the forums to no avail.
After a few hours battling with CentOS & open_basedir I got hit with a new error :
Could not execute command: CREATE TABLE mah_config ( field VARCHAR(255) NOT NULL, value TEXT, CONSTRAINT PRIMARY KEY (field) )ENGINE=innodb
Call stack (most recent first):
execute_sql("CREATE TABLE mah_config ( field VARCHAR(255) N...", true) at /var/www/vhosts/belfasthigh.wholeschoolvle.com/httpdocs/mahara/lib/dml.php:1406
execute_sql_arr(array(size 223)) at /var/www/vhosts/belfasthigh.wholeschoolvle.com/httpdocs/mahara/lib/ddl.php:566
install_from_xmldb_file("/var/www/vhosts/belfasthigh.wholeschoolvle.com/htt...") at /var/www/vhosts/belfasthigh.wholeschoolvle.com/httpdocs/mahara/lib/upgrade.php:297
upgrade_core(object(stdClass)) at /var/www/vhosts/belfasthigh.wholeschoolvle.com/httpdocs/mahara/admin/upgrade.json.php:93
I have cleared out the database, several times with no joy.
Plesk9Any help would be much appreciated.
14 October 2010, 6:42
Maybe your DB-user doesn't have the rights to create the table.
I usually create my Mahara MySQL DB with the following commands
and haven't had any problems:
CREATE DATABASE mahara CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;
GRANT ALL ON mahara.* to 'mahara'@'localhost' IDENTIFIED BY '<your passwd>';
of course, you can change the names, etc.
21 October 2010, 4:57
Thanks for your reply, I had given my Database user full privilages to the Database, I just went ahead and used PostgreSQL for Mahara, this work without a problem.