Affects Version/s: 1.6, 1.6.1, 1.6.2, 1.6.3, 1.6.4, 1.7, 1.7.1
I am using a host with a remote database.
PHP version 4.4.2 & 5, MySQL version 5.0.22 & 4.1.2 with Zuse 4.3. using namesco as paid host server.
I have tried both MySQL version and tables halt after creation. Install stops after LAMS table. I bypassed the LAMS table by commenting out nusoap.php in /lib/setup. install moves onto Lesson tables (successful) then stops again. i've managed to get this error message:
mysql> explain CREATE TABLE mdl_lams ( id int(10) unsigned NOT NULL auto_increment, course int(10) unsigned NOT NULL default '0', name varchar(255) NOT NULL default '', introduction text NOT NULL default '', learning_session_id bigint(20) default '0', timemodified int(10) unsigned NOT NULL default '0', PRIMARY KEY (id), KEY course (course))COMMENT='LAMS activity';
ERROR 1064 (42000): 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 'CREATE TABLE mdl_lams ( id int(10) unsigned NOT NULL auto_increment, course in' at line 1
I've tried everything i can think of with little progress.
Install halts with no option to continue. I have a working version on another host, the only difference i can see is this one is on a remote database server not @localhost.
I've used both 4.1.2 & 5.0.22 versions of MySQL and PHP 4.4.2 & 5. same happens everytime.
Please help, i've been working on this for over a week.
I can also give login report if its needed??