ATutor

problems with Upgrading from 202 to 22

• My1
  

  2015-06-24 04:47:57

  problems with Upgrading from 202 to 22

  well I have a problem with upgrading ATutor 2.0.2 to 2.2 I already did once in a test scenario to 2.1.1 and we found out lately that there's a new version and now we want to go to that. we migrated the files and db from the old server I think it was opensuse 9 to the new one (opensuse 12.3) which went well. then we made sure that the config files are corrrect with db pass and stuff and then we started the upgrade, selected the folder and continued and then we got an error with the db operations.
  
  
  Things to describe:
  Operating system ATutor is installed on - openSuse
  ATutor version - 2.0.2
  Patch #s applied - #01-#09
  ATutor theme name -
  versions of php - 5.5.9
  version of mysql - 5.6.16
  webserver & version - apache 2.4.7 (unix)
  Copies of error messages -
  Table AT_feeds alteration failed.
  Table AT_myown_patches alteration failed.
  Table AT_myown_patches_dependent alteration failed.
  Table AT_myown_patches_files alteration failed.
  Table AT_auto_enroll alteration failed.
  Table AT_auto_enroll_courses alteration failed.
  Table AT_gradebook_detail alteration failed.
  Table AT_social_member_contact alteration failed.
  Table AT_social_member_representation alteration failed.
  Table AT_oauth_client_servers alteration failed.
  Table AT_oauth_client_tokens alteration failed.
  Table AT_pa_albums alteration failed.
  Table AT_pa_album_comments alteration failed.
  Table AT_pa_photo_comments alteration failed.
  Table AT_modules alteration failed.
  Table AT_language_pages alteration failed.
  Table AT_language_pages alteration failed.
  Changes to default settings -
  Web browser being used - Firfox 38.0.5
  ...and anything else relevant -

• greg
  

  2015-06-24 09:29:50

  Re: problems with Upgrading from 2.0.2 to 2.2

  It would appear that the MySQL user does not have table Alter permissions.
  
  More about privileges can be found at:
  https://dev.mysql.com/doc/refman/5.6/en/privileges-provided.html

• My1
  

  2015-06-24 09:30:58

  Re: problems with Upgrading from 2.0.2 to 2.2

  I am using the root user for this, so I dont think that.

• greg
  

  2015-06-24 10:20:21

  Re: problems with Upgrading from 2.0.2 to 2.2

  Also check the ownership on the db files you moved to be sure they are owned by the mysql user. Those files should also have read/write permissions set for user and group (-rw-rw----)

• My1
  

  2015-06-24 10:34:20

  Re: problems with Upgrading from 2.0.2 to 2.2

  I dont think that's possible since I ex and imported the db using pna and stuff but i'll check...

• My1
  

  2015-06-25 01:36:05

  Re: problems with Upgrading from 2.0.2 to 2.2

  I did check, and there are no problems with editing the tables manually in phpmyadmin and as I said I am using the same user in pma and Atutor.

• My1
  

  2015-06-25 02:33:38

  Re: problems with Upgrading from 2.0.2 to 2.2

  as there is no edit button I have to not that a lot of the tables can be created and altered without problems. while the others (from the error message) have the problem.

• greg
  

  2015-06-25 09:08:48

  Re: problems with Upgrading from 2.0.2 to 2.2

  What did you end up doing to resolve the problem, to help others that may have experienced the same issue?

• My1
  

  2015-06-25 09:13:54

  Re: problems with Upgrading from 2.0.2 to 2.2

  oh lol, I thought I wrote that, probably forgot to send, or whatever.
  instead of directly going from 2.0.2 to 2.2 I went over 2.1.1, so I had
  2.0.2->2.1.1->2.2 upgrade after upgrade, but now I have another problem as described in the other thread (login problems).