I have trying to install moodle for more than a week now but unfortunately no luck
In the xp it is all ok tell this screen
Setting up module tables |
Home » Setting up module tables |
choice
----- (mysql): CREATE TABLE mdl_choice ( id int(10) unsigned NOT NULL auto_increment, course int(10) unsigned NOT NULL default '0', name varchar(255) NOT NULL default '', text text NOT NULL, format tinyint(2) unsigned NOT NULL default '0', answer1 varchar(255) NOT NULL default 'Yes', answer2 varchar(255) NOT NULL default 'No', answer3 varchar(255) default NULL, answer4 varchar(255) default NULL, answer5 varchar(255) default NULL, answer6 varchar(255) default NULL, publish tinyint(2) unsigned NOT NULL default '0', release tinyint(2) unsigned NOT NULL default '0', allowupdate tinyint(2) unsigned NOT NULL default '0', showunanswered tinyint(2) unsigned NOT NULL default '0', timeopen int(10) unsigned NOT NULL default '0', timeclose int(10) unsigned NOT NULL default '0', timemodified int(10) unsigned NOT NULL default '0', PRIMARY KEY (id), UNIQUE KEY id (id), KEY course (course)) TYPE=MyISAM COMMENT='Available choices are stored here.' ----- 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'release tinyint(2) unsigned NOT NULL default '0', allowupdate tinyint(2) unsign' at line 1
choice
it gives me an error
Error
----- (mysql): CREATE TABLE mdl_choice_answers ( id int(10) unsigned NOT NULL auto_increment, choice int(10) unsigned NOT NULL default '0', userid int(10) unsigned NOT NULL default '0', answer tinyint(4) NOT NULL default '0', timemodified int(10) NOT NULL default '0', PRIMARY KEY (id), UNIQUE KEY id (id), KEY userid (userid), KEY choice (choice)) TYPE=MyISAM ----- 1050: Table 'mdl_choice_answers' already exists
ADODB_mysql._Execute(CREATE TABLE mdl_choice_answers ( id int(10) unsigned NOT NULL ..., false) % line 804, file: adodb.inc.php
ADODB_mysql.Execute(CREATE TABLE mdl_choice_answers ( id int(10) unsigned NOT NULL ...) % line 30, file: datalib.php
execute_sql(CREATE TABLE mdl_choice_answers ( id int(10) unsigned NOT NULL ...) % line 152, file: datalib.php
modify_database(C:\Inetpub\wwwroot\moodle/mod/choice/db/mysql.sql) % line 178, file: adminlib.php
upgrade_activity_modules(http://192.168.0.40:81/moodle/admin/index.php) % line 231, file: index.php
Error
----- (mysql): INSERT INTO mdl_log_display VALUES ('choice', 'view', 'choice', 'name') -----
Success
And keeps on coming back
i have given full permation to the batabase to public just in case it was a permation thing but no luck
using mysql 5
and php 5 on a xp
plz help thank you
