ATutor

Learning Management Tools


  1. Home



Pages:1 2 3 4 5 6 7 8 9 10 11 12 13 14 15


Table assignments creation failed on upgrade



  • 2006-07-08 17:05:19

    Table assignments creation failed on upgrade

    ATutor Version: 1.5.3 (build unknown - 2006-07-08 17:57:22)
    Operating System: Darwin 8.7.0 Darwin Kernel Version 8.7.0: Fri May 26 15:20:53 PDT 2006; root:xnu-792.6.76.obj~1/RELEASE_PPC Power Macintosh
    Web Server: Apache/2.2.0 (Unix) PHP/5.1.2 mod_fastcgi/2.4.2 mod_ssl/2.2.0 OpenSSL/0.9.7i
    PHP Version: 5.1.2
    MySQL Version: 5.0.20a-standard

    Joel/Greg:

    I was able to do a fresh install, but not an upgrade (which is what I really need)

    Looks like you fixed this for new installs, but still not working for an upgade from 1.5.2 ... it looks like all is working fine in step 2 but the error is reported after it said the upgrade went ok ... can't move on to step 3.

    larry


  • 2006-07-08 17:25:10

    Re: Table assignments creation failed on upgrade

    Here's a more complete list on a subsequent try

    larry

    Table assignments creation failed.
    Table assignments creation failed.
    Table resource_categories alteration failed.
    Table links_categories alteration failed.
    Table links_categories alteration failed.
    Table resource_links alteration failed.
    Table links alteration failed.


  • 2006-07-08 18:53:19

    Re: Table assignments creation failed on upgrade

    Check to be sure your mysql account has Alter privileges. Add it if necessary.


  • 2006-07-08 20:48:05

    Re: Table assignments creation failed on upgrade

    Hi Greg

    The root@localhost account has full access to all of the databases

    cheers
    larry


  • 2006-07-09 06:18:41

    Re: Table assignments creation failed on upgrade

    Hi Greg

    The upgrade worked for the following configuration on my old box.
    Do you think the difference in mySQL versions might be the issue?

    If so, will it be safe to run on my new box with MySQL Version: 5.0.20a-standard?

    larry


    ATutor Version:
    1.5.3 (build unknown - 2006-07-09 07:05:34)
    Operating System:
    Darwin 7.9.0 Darwin Kernel Version 7.9.0: Wed Mar 30 20:11:17 PST 2005; root:xnu/xnu-517.12.7.obj~1/RELEASE_PPC Power Macintosh
    Web Server:
    Apache/2.0.52 (Unix) PHP/4.3.9 DAV/2
    PHP Version:
    4.3.9
    MySQL Version:
    4.0.21 Complete MySQL by Server Logistics


  • 2006-07-10 10:23:14

    Re: Table assignments creation failed on upgrade

    Can you check to see which of the links tables were created?


  • 2006-07-13 08:10:48

    Re: Table assignments creation failed on upgrade

    Hi Joel

    Just returned home from brain surgery ... I'm on the mend

    I reply to both of my threads in a couple of days

    larry


  • 2006-07-17 01:45:01

    Re: Table assignments creation failed on upgrade

    Hi greg,
    Thanks for all your help about my previous error on installing and upgrading 1.5 & 1.5.2. Now I want to upgrade from 1.5.2 to 1.5.3 and I have the following error on step 2. Please note that my mysql user has all privilages on all database and specially on atutor database. I have put error messages in below.

    Things to describe:
    operating system -Linux FC5
    version of ATutor -1.5.3
    versions of php -5.1.2
    version of mysq l -5.0.18
    webserver & version -apache/2.2.0 (fedora)
    copies of error messages -
    Error

    * Table AT_groups alteration failed.
    * Table AT_groups alteration failed.
    * Table AT_modules alteration failed.
    * Table AT_assignments creation failed.
    * Table AT_courses alteration failed.
    * Table AT_courses alteration failed.
    * Table AT_assignments creation failed.
    * Table AT_course_enrollment alteration failed.
    * Table AT_modules alteration failed.
    * Table AT_members alteration failed.
    * Table AT_members alteration failed.
    * Table AT_users_online alteration failed.
    * Table AT_members alteration failed.
    * Table AT_resource_categories alteration failed.
    * Table AT_links_categories alteration failed.
    * Table AT_links_categories alteration failed.
    * Table AT_resource_links alteration failed.
    * Table AT_links alteration failed.
    * Table AT_members alteration failed.
    * Table AT_handbook_notes alteration failed.
    changes to default settings -nothing
    web browser being used -mozilla
    and anything else relevant -
    in step 2 I get the following feedback:
    Feedback

    * Connected to database atutor successfully.
    * Table AT_groups_types already exists. Skipping.
    * Table AT_forums_groups already exists. Skipping.
    * Table AT_reading_list already exists. Skipping.
    * Table AT_external_resources already exists. Skipping.
    * Table AT_file_storage_groups already exists. Skipping.
    * Table AT_files already exists. Skipping.
    * Table AT_files_comments already exists. Skipping.
    * Table AT_folders already exists. Skipping.
    * Table AT_mail_queue already exists. Skipping.
    * Table AT_blog_posts already exists. Skipping.
    * Table AT_blog_posts_comments already exists. Skipping.
    * Successful update from version 1.5.2 to 1.5.3.
    * Table AT_language_text created successfully.


  • 2006-08-09 21:29:58

    Re: Table assignments creation failed on upgrade

    I think I found the problem .. but I need you to verify.

    This messed me around for a full day today!

    ----
    In the 1.5.2--> 1.5.3 update sql file, the following occurs:

    # assignments table
    CREATE TABLE `assignments` (
    `assignment_id` MEDIUMINT(6) UNSIGNED NOT NULL AUTO_INCREMENT,
    `course_id` MEDIUMINT UNSIGNED NOT NULL default '',
    `title` VARCHAR(60) NOT NULL default '',
    `assign_to` MEDIUMINT UNSIGNED DEFAULT 0,
    `date_due` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
    `date_cutoff` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
    `multi_submit` TINYINT DEFAULT '0',
    PRIMARY KEY (`assignment_id`),
    INDEX (`course_id`)
    ) TYPE = MYISAM;

    # --------------------------------------------------------


    ## assignment manager
    CREATE TABLE `assignments` (
    `assignment_id` MEDIUMINT(6) UNSIGNED NOT NULL AUTO_INCREMENT,
    `course_id` MEDIUMINT UNSIGNED NOT NULL default '',
    `title` VARCHAR(60) NOT NULL default '',
    `assign_to` MEDIUMINT UNSIGNED DEFAULT 0,
    `date_due` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
    `date_cutoff` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
    `multi_submit` TINYINT DEFAULT '0',
    PRIMARY KEY (`assignment_id`),
    INDEX (`course_id`)
    ) TYPE = MYISAM;

    =====
    In the schema.sql file:

    # --------------------------------------------------------
    # Table structure for table `assignments`
    # since 1.5.3

    CREATE TABLE `assignments` (
    `assignment_id` MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT,
    `course_id` MEDIUMINT UNSIGNED NOT NULL default 0,
    `title` VARCHAR(60) NOT NULL default '',
    `assign_to` MEDIUMINT UNSIGNED default 0,
    `date_due` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
    `date_cutoff` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
    `multi_submit` TINYINT DEFAULT '0',
    PRIMARY KEY (`assignment_id`),
    INDEX (`course_id`)
    ) TYPE = MYISAM;

    ======

    Should not the schema code not be in the update one (including the default value of 0 for the course_id in:
    `course_id` MEDIUMINT UNSIGNED NOT NULL default 0,

    Also, is not the second occurance in the update sql not an incorrect redundancy?

    thanks
    larry


  • 2006-08-10 08:15:31

    Re: Table assignments creation failed on upgrade

    thx Larry
    Yes, remove the second occurance of the assignments table.