Jump to ContentJump to Navigation/Login
` ` ` ` ` `

Login
[Register]

Subscribe to Updates

Occasional ATutor release updates


Services

Members Online

    (7 guests in past 15 min.)

    Web Accessibility Course

    Access Understanding Web Accessibility to learn about accessibility, or Register to take the course for FREE.

    Home > Forums > ATutor Bug Reports > upgrade: cannot alter database

    Support Forums

    ATutor Bug Reports

    upgrade: cannot alter database


    You must be signed-in to post.

    AuthorSubject
      Page: 1 | 2
    vegard

    Avatar for vegard
    		Subject: upgrade: cannot alter databaseQuote this post in your reply
    hi, I get this when trying to update Atutor from 1.6 to 1.6.1 on one of my servers:

    * Table AT_16_tests alteration failed.
    * Table AT_16_courses alteration failed.
    * Table AT_16_content alteration failed.
    * Table AT_16_courses alteration failed.

    I can install atutor from scratch on that server, so what can be the cause?

    server specs are:

    FreeBSD 6.2
    versions of php - 5.2.3
    version of mysql - 5.0.37
    webserver & version - Apache 2
    Posted: 2008-07-03 06:59:48
    greg

    Avatar for greg
    		Subject: Re: upgrade: cannot alter databaseQuote this post in your reply
    Does the mysql user have table alter permissions?
    Posted: 2008-07-03 07:35:42
    vegard

    Avatar for vegard
    		Subject: Re: upgrade: cannot alter databaseQuote this post in your reply
    yes, this is the full feedback:

    Feedback
    Connected to database [snip] successfully.
    Table AT_16_auto_enroll already exists. Skipping.
    Table AT_16_auto_enroll_courses already exists. Skipping.
    Table AT_16_members altered successfully.
    Table AT_16_patches already exists. Skipping.
    Table AT_16_patches_files already exists. Skipping.
    Table AT_16_patches_files_actions already exists. Skipping.
    Table AT_16_myown_patches already exists. Skipping.
    Table AT_16_myown_patches_dependent already exists. Skipping.
    Table AT_16_myown_patches_files already exists. Skipping.
    Table AT_16_courses altered successfully.
    Table AT_16_courses altered successfully.
    Table AT_16_language_text created successfully.


    Error
    Table AT_16_tests alteration failed.
    Table AT_16_courses alteration failed.
    Table AT_16_content alteration failed.
    Table AT_16_courses alteration failed.

    ..as you can see it alters some tables (AT_16_courses is altered twice, then the third stops it seems..)
    Posted: 2008-07-03 08:12:23
    cindy

    Avatar for cindy
    		Subject: Re: upgrade: cannot alter databaseQuote this post in your reply
    Hi Vegard,

    This is because the patches you installed on 1.6 have altered the table so the same alteration reports the error. These errors can be ignored.

    We will figure out a way to report it as normal process instead of error.

    Thanks.
    Posted: 2008-07-03 09:31:06
    vegard

    Avatar for vegard
    		Subject: Re: upgrade: cannot alter databaseQuote this post in your reply
    I see, but a problem here is that I have no way to get past step 2 in the upgrade process because of this. I can "try again", but not ignore it and move on..
    Posted: 2008-07-03 09:40:28
    cindy

    Avatar for cindy
    		Subject: Re: upgrade: cannot alter databaseQuote this post in your reply
    Yes, I understand.

    I just fixed this. We will do another bundle shortly. Could you wait a while and try with the new one? Thanks.
    Posted: 2008-07-03 10:07:57
    harris

    Avatar for harris
    		Subject: Re: upgrade: cannot alter databaseQuote this post in your reply
    Pl1 is now ready to download.
    Posted: 2008-07-03 11:26:31
    cindy

    Avatar for cindy
    		Subject: Re: upgrade: cannot alter databaseQuote this post in your reply
    Hi Vegard,

    After you upgrade successfully, can you install the patch 0001 in 1.6.1

    This fix a table structure bug introduced by patch 0002 in 1.6

    Thanks.
    Posted: 2008-07-03 12:05:39
    vegard

    Avatar for vegard
    		Subject: Re: upgrade: cannot alter databaseQuote this post in your reply
    thanks a lot - successfully upgraded atutor.no as well as our production server, great work guys and gals! smile
    Posted: 2008-07-04 05:14:19
    marklee

    Avatar for marklee
    		Subject: Re: upgrade: cannot alter databaseQuote this post in your reply
    Hi, I'm trying to upgrade from 1.5.3.3 to 1.62 on a Linux server.

    There's a problem creating some tables although others are created or altered, for eg: Table AT_language_text created successfully.

    However there's an error I can't figure out:

    Error

    * Table AT_auto_enroll creation failed.
    * Table AT_auto_enroll_courses creation failed.
    * Table AT_patches creation failed.
    * Table AT_patches_files creation failed.
    * Table AT_patches_files_actions creation failed.
    * Table AT_myown_patches creation failed.
    * Table AT_myown_patches_dependent creation failed.
    * Table AT_myown_patches_files creation failed.
    * Table AT_patches alteration failed.
    * Table AT_patches alteration failed.

    I can't continue the upgrade because I can't get past the "Retry" stage, which continuously fails.

    Any help will be appreciated.
    Posted: 2009-05-31 15:16:54
    greg

    Avatar for greg
    		Subject: Re: upgrade: cannot alter databaseQuote this post in your reply
    These are all new tables, so perhaps your database user does not have create table permissions. Have a look at your mysql settings.
    Posted: 2009-06-01 08:55:10
    marklee

    Avatar for marklee
    		Subject: Re: upgrade: cannot alter databaseQuote this post in your reply
    Hi Greg,

    That would be true if it hadn't created the other tables as seen above: Table AT_language_text created successfully.

    The upgrade is reading from the existing installation which created the original tables. Nothing about the account has changed.
    Posted: 2009-06-01 09:44:55
    marklee

    Avatar for marklee
    		Subject: Re: upgrade: cannot alter databaseQuote this post in your reply
    Here are the other results before the error:
    * Connected to database dblee(*1) successfully.
    * Table AT_tests_questions fields already exists. Skipping.
    * Table AT_tests fields already exists. Skipping.
    * Table AT_course_access already exists. Skipping.
    * Table AT_members fields already exists. Skipping.
    * Table AT_forums fields already exists. Skipping.
    * Table AT_messages_sent already exists. Skipping.
    * Table AT_content fields already dropped. Skipping.
    * Table AT_forums_threads fields already dropped. Skipping.
    * Table AT_tests_questions_assoc fields already dropped. Skipping.
    * Table AT_tests_results fields already exists. Skipping.
    * Table AT_tests_results fields already exists. Skipping.
    * Table AT_courses fields already exists. Skipping.
    * Table AT_tests_results fields already exists. Skipping.
    * Table AT_tests fields already exists. Skipping.
    * Table AT_admins altered successfully.
    * Table AT_tests fields already exists. Skipping.
    * Table AT_courses fields already exists. Skipping.
    * Table AT_members altered successfully.
    * Table AT_content fields already exists. Skipping.
    * Table AT_courses altered successfully.
    * Table AT_courses fields already dropped. Skipping.
    * Table AT_courses altered successfully.
    * Table AT_primary_resources already exists. Skipping.
    * Table AT_primary_resources_types already exists. Skipping.
    * Table AT_resource_types already exists. Skipping.
    * Table AT_secondary_resources already exists. Skipping.
    * Table AT_secondary_resources_types already exists. Skipping.
    * Table AT_content_tests_assoc already exists. Skipping.
    * Table AT_content fields already exists. Skipping.
    * Table AT_content fields already exists. Skipping.
    * Table AT_config altered successfully.
    * Table AT_grade_scales already exists. Skipping.
    * Table AT_grade_scales_detail already exists. Skipping.
    * Table AT_gradebook_tests already exists. Skipping.
    * Table AT_gradebook_detail already exists. Skipping.
    * Table AT_guests already exists. Skipping.
    * Table AT_tests_results altered successfully.
    * Table AT_tests fields already exists. Skipping.
    * Table AT_fha_student_tools already exists. Skipping.
    * Table AT_language_text created successfully.

    (*1)The database name has been changed above to not make it public.
    Posted: 2009-06-01 09:50:00
    harris

    Avatar for harris
    		Subject: Re: upgrade: cannot alter databaseQuote this post in your reply
    hi mark, what's your mysql version?
    Posted: 2009-06-01 09:54:10
    marklee

    Avatar for marklee
    		Subject: Re: upgrade: cannot alter databaseQuote this post in your reply
    This is what the installation detected: Found Version 5.0.18
    Posted: 2009-06-01 10:18:50
     Page: 1 | 2

    You must be signed-in to post.