ATutor

Learning Management Tools


  1. Home



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


Table alteration



  • 2008-06-14 19:44:46

    Table alteration

    I know this has already been covered, but I'm getting the table alteration failed message. When I read the document that tells me how to fix this, I don't see the same things when I am in either
    MySQL or MyPhPAdmin. I looked at all the menus and features of these two programs and don't see anything about changing table permissions.

    Is there a simple, step-by-step document that describes how to do this, or could someone run me through the steps in such a way that I won't get lost?

    Thanks.

    Things to describe:
    operating system - Windows Vista Home Premium
    version of ATutor - Upgrading 1.5.3.3. to 1.6 stable.
    versions of php - 5.2.6
    version of mysq l - 5.0.45
    webserver & version - Apache 1.3
    copies of error messages -
    changes to default settings - none
    web browser being used - IE7
    and anything else relevant -


  • 2008-06-16 09:15:33

    Re: Table alteration

    Does your database user have permissions to alter table?
    go to phpmyadmin -> Privileges -> Edit Privileges


  • 2008-06-16 12:39:21

    Re: Table alteration

    This is where I get confused because my phpMyAdmin screen doesn't have a "Privileges" choice on the menu.

    I've attached a copy of what I get on my screen.


  • 2008-06-16 12:45:15

    Re: Table alteration

    Permissions are defined in the mysql database's users table


  • 2008-06-16 14:26:15

    Re: Table alteration

    I don't see a table named "users." Could it be one of the two I've enclosed screenshots of? They both seem to have priviliges turned on.


  • 2008-06-16 14:27:16

    Re: Table alteration

    Screen cap #2 from previous reply.


  • 2008-06-16 15:10:54

    Re: Table alteration

    Look a little harder. MySQL will not function without it.

    You do need to be a root users to see the table, in the "mysql" database. If you are not a root user, then a person who is will need to make the permission changes


  • 2008-07-01 19:51:38

    Re: Table alteration

    Greg - I got the following information back from my hosting company regarding the problem I've been having in updating to the 1.6 ATutor:

    Dear Customer,

    From looking at the code I see it is trying to use REPLACE INTO for SQL and that isn't allowed on the server.

    Thanks
    Brandon O.
    Scripting Specialist
    Hostmonster.com
    866.573.4678


    Is there anything that can be done to work around this?


  • 2008-07-01 20:04:01

    Re: Table alteration

    Here's another note I just recieved after threatening my hosting company:

    Dear Customer,

    If you switch the SQL to use Insert instead it should work but if you do not know how to do that. Then you have the company who made the script do it or higher someone to make it work.

    Thanks
    Brandon O.
    Scripting Specialist
    Hostmonster.com
    866.573.4678


  • 2008-07-02 09:00:23

    Re: Table alteration

    That's the first time I've heard of a provider disabling REPLACE into. It is very common in Web applications.

    There's really nothing we can do except suggest you have your provider make it available. It is used throughout ATutor, and throughout many other applications. There is no way to work around it.