Forums | Mahara Community

Support /
Core Installation error in XAMPP-windows XP3


Zit campus's profile picture
Posts: 1

27 October 2011, 4:42 AM

Help me to solve installation problem. when i am installing in xampp on windows platform, the core installation shows the error given below. how to solve it. The clear image is also pasted here. plz help me.

Could not execute command: CREATE TABLE maha_config ( field VARCHAR(255) NOT NULL, value TEXT, CONSTRAINT PRIMARY KEY (field) )ENGINE=innodb

Call stack (most recent first):
  • execute_sql("CREATE TABLE maha_config ( field VARCHAR(255) ...", true) at G:\xampp\htdocs\mahara\lib\dml.php:1394
  • execute_sql_arr(array(size 118)) at G:\xampp\htdocs\mahara\lib\ddl.php:566
  • install_from_xmldb_file("G:\xampp\htdocs\mahara/lib/db/install.xml") at G:\xampp\htdocs\mahara\lib\upgrade.php:297
  • upgrade_core(object(stdClass)) at G:\xampp\htdocs\mahara\admin\upgrade.json.php:94

Richard Mansfield's profile picture
Posts: 808

27 October 2011, 3:41 PM

This sometimes happens if you're trying to install Mahara into a database from a previous installation failure.

I'd recommend dropping and recreating your database and trying again.  If you get a different error, let us know.

A post by Deleted user was deleted

sandra mayorga's profile picture
Posts: 1

01 February 2012, 11:08 PM

Hi Zit campus,

Please, you found some solution to the problem? I have the same error, but for me just reloading the browser show the message. In this wiki (http://recursostic.educacion.es/observatorio/web/es/software/software-educativo/971-instalacion-de-mahara-en-local?start=6) talk about the error, but it is not important.

Please help me, thanks!!!

10 February 2012, 10:33 AM

Re : Could not execute command CREATE TABLE config

 

During the installation http://localhost/mahara/htdocs/admin/upgrade.php

for the core

I had the error message stating : « Could not execute command » CREATE TABLE , with table « config ».

 

First, I followed the advice here, as given by Jonathan :

https://mahara.org/interaction/forum/topic.php?id=131

increasing the resource limits in the php.ini

max_execution_time = 120     ; Maximum execution time of each script, in seconds

and

memory_limit = 256M 

 

Then, I created a new database, as Richard has adviced :

https://mahara.org/interaction/forum/topic.php?id=4114

 

Successfully installed Mahara!

 

Thanks.

5 results