13 October 2010, 8:29

Hi,

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.

Mahara 1.3.2
CentOS 5
Plesk9Any help would be much appreciated.

Graham

14 October 2010, 6:42

Dear Graham,

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.

cheers

  jzimmer

21 October 2010, 4:57

Hi Jürgen,

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.

Thanks,

Graham