ATutor

Learning Management Tools


  1. Home



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


Inherited a broken Atutor install



  • 2015-01-30 12:49:05

    Inherited a broken Atutor install

    If you are asking for help, provide lots of detail so problems can be reproduced.

    Things to describe:
    Operating system ATutor is installed on - Linux 2.6.18-308.24.1.el5PAE
    ATutor version - 1.4.2
    Patch #s applied - Uknown
    ATutor theme name -
    PHP version - 5.3.29
    MySQL version -
    Webserver & version -
    Copies of error messages - See below
    Changes to default settings -
    Web browser being used -Chrome

    Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /home/madd/public_html/courses/install/include/ustep2.php on line 62

    Hello ATutor:

    I come here with cap firmly in hand.

    I inherited a broken ATutor install at

    http://www.maddcanadatraining.ca/courses/

    I am trying to upgrade the install from 1.4.2. to 2.0 since the web host could no longer support 1.4.2.

    I am stuck at Step 2 with the error message above and a list of tables that it could not create. I check the MySQL user and it has all the rights required.

    If you can provide any guidance, that would be appreciated.

    Fraser


  • 2015-01-31 14:57:40

    Re: Inherited a broken Atutor install

    Can you please confirm the exact version you are upgrading to.

    The upgrade may be failing because it is not finding English language. You may need to reinstall the english language pack.
    http://atutor.ca/atutor/translate/index.php

    Also try using a different browser.


  • 2015-02-02 11:18:08

    Re: Inherited a broken Atutor install

    Hello Greg:

    Thanks for the reply.

    I downloaded 2.1 from Sourceforge.

    I tried unsuccessfully to upload the language pack. I'll try and run the SQL.

    Here's the error from Step 2 -

    Error
    Table languages creation failed.
    Table language_pages creation failed.
    Table backups creation failed.
    Table forums_courses creation failed.
    Table forums_subscriptions creation failed.
    Table tests_questions_assoc creation failed.
    Table tests_questions_categories creation failed.
    Table tests_questions alteration failed.
    Table tests_questions alteration failed.
    Table groups creation failed.
    Table tests_groups creation failed.
    Table tests alteration failed.
    Table backups alteration failed.
    Table member_track creation failed.
    Table admin_log creation failed.
    Table master_list creation failed.
    Table admin_log alteration failed.
    Table groups_types creation failed.
    Table groups alteration failed.
    Table groups alteration failed.
    Table forums_groups creation failed.
    Table reading_list creation failed.
    Table external_resources creation failed.
    Table file_storage_groups creation failed.
    Table assignments creation failed.
    Table mail_queue creation failed.
    Table blog_posts_comments creation failed.
    Table resource_categories alteration failed.
    Table links_categories alteration failed.
    Table resource_links alteration failed.
    Table links alteration failed.
    Table admin_log alteration failed.
    Table backups alteration failed.
    Table blog_posts_comments alteration failed.
    Table member_track alteration failed.
    Table tests_questions_assoc alteration failed.
    Table admin_log alteration failed.
    Table backups alteration failed.
    Table blog_posts_comments alteration failed.
    Table groups alteration failed.
    Table mail_queue alteration failed.
    Table reading_list alteration failed.
    Table external_resources alteration failed.
    Table groups alteration failed.


  • 2015-02-02 12:20:30

    Re: Inherited a broken Atutor install

    Installing a language pack should not generate these errors so I'm guess you did not use the admin's language manager.

    These errors would appear to be the result of trying to create table that already exist if you are trying to install over a previous attempt.

    Or, if this is a fresh install, the mysql user does not have the necessary permissions. Be sure the mysql user has create database and table privileges, and table alter privileges.


  • 2015-02-02 12:53:36

    Re: Inherited a broken Atutor install

    Correct. Those errors were from Step 2 of an installation (2.1 over an existing 1.4.2).

    If I wanted to engage services, would purchasing a single support ticket from -

    http://www.atutor.ca/services/

    be the proper course of action?

    Thanks,

    Fraser


  • 2015-02-02 13:08:42

    Re: Inherited a broken Atutor install

    An upgrade is typically three tickets, though this may need your system admin to upgrade if the mysql user does not have enough permission, which would appear to be the case.

    Did you create a backup of the database before attempting to upgrade?

    Is there a reason for choosing 2.1 rather than 2.2?

    If you send the shell and ATutor login details to "info AT atutor dot ca" we'll take a look first to see if we are able to upgrade without your sysadmin.


  • 2015-02-02 13:16:33

    Re: Inherited a broken Atutor install

    No. No back up. Naturally.

    I tried 2.2 and the install said it was a no-go - too big a leap from 1.4.2.

    I'll work on getting Shell access.


  • 2015-02-02 13:26:42

    Re: Inherited a broken Atutor install

    Control p[anel access would also be helpful, if you have one.


  • 2015-02-02 14:01:35

    Re: Inherited a broken Atutor install

    I've sent you an email to the address mentioned above.