Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-6224

Syntax error creating tables on install

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 1.6, 1.6.1, 1.6.2, 1.6.3, 1.6.4, 1.7, 1.7.1
    • Fix Version/s: 1.7.2, 1.8, 1.9
    • Component/s: Installation, Other
    • Labels:
      None
    • Environment:
      Linux
    • Database:
      MySQL
    • Affected Branches:
      MOODLE_16_STABLE, MOODLE_17_STABLE
    • Fixed Branches:
      MOODLE_17_STABLE, MOODLE_18_STABLE, MOODLE_19_STABLE

      Description

      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:

      (successful creation)

      MySQL ERROR:

      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??

      Thank You

      Steve

        Attachments

          Activity

            People

            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Fix Release Date:
                30/Mar/07