Support Forums
ATutor Bug Reports
upgrade: cannot alter database
You must be signed-in to post.
| Author | Subject | |
|---|---|---|
| Page: 1 | 2 | ||
vegard | Subject: upgrade: cannot alter database |  |
| 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 | Subject: Re: upgrade: cannot alter database | |
| Does the mysql user have table alter permissions? Posted: 2008-07-03 07:35:42 | ||
| ||
| vegard | Subject: Re: upgrade: cannot alter database | |
| 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 | Subject: Re: upgrade: cannot alter database | |
| 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 | Subject: Re: upgrade: cannot alter database | |
| 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 | Subject: Re: upgrade: cannot alter database | |
| 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 | Subject: Re: upgrade: cannot alter database | |
| Pl1 is now ready to download. Posted: 2008-07-03 11:26:31 | ||
| ||
| cindy | Subject: Re: upgrade: cannot alter database | |
| 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 | Subject: Re: upgrade: cannot alter database | |
thanks a lot - successfully upgraded atutor.no as well as our production server, great work guys and gals!  Posted: 2008-07-04 05:14:19 | ||
| ||
marklee | Subject: Re: upgrade: cannot alter database | |
| 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 | Subject: Re: upgrade: cannot alter database | |
| 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 | Subject: Re: upgrade: cannot alter database | |
| 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 | Subject: Re: upgrade: cannot alter database | |
| 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 | Subject: Re: upgrade: cannot alter database | |
| hi mark, what's your mysql version? Posted: 2009-06-01 09:54:10 | ||
| ||
| marklee | Subject: Re: upgrade: cannot alter database | |
| 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.