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

Syntax error creating tables on install

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Critical
    • Resolution: Fixed
    • 1.6, 1.6.1, 1.6.2, 1.6.3, 1.6.4, 1.7, 1.7.1
    • 1.7.2, 1.8, 1.9
    • Installation, Other
    • None
    • Linux
    • MySQL
    • MOODLE_16_STABLE, MOODLE_17_STABLE
    • 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

            anthony Anthony Sukkar
            imported Imported
            Nobody Nobody
            Matteo Scaramuccia, Andrew Lyons, Huong Nguyen, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze, Adrian Greeve, Jake Dallimore, Mathew May, Mihail Geshoski, Sujith Haridasan
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:
              30/Mar/07