ATutor

Learning Management Tools


  1. Home



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


Creating another Administrator



  • 2008-12-08 14:47:21

    Creating another Administrator

    Operating system ATutor is installed on - Linux 2.6.24.3-grsec-sg1
    ATutor version - 1.6.1
    Patch #s applied - 01 through 12
    ATutor theme name -
    PHP version - 5.2.5
    MySQL version - 4.1.22-standard-log
    Webserver & version -

    Hello - I am new to Atutor and I am loving it.

    My site is hosted at Site Ground.

    I am trying to ad another Administrator, but I get the following error message each time I try:

    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'privileges, last_login) VALUES ('superman_42',' at line 7


  • 2008-12-08 15:15:38

    Re: Creating another Administrator

    Hi, can you confirm something with me please. Open up admin/admins/create.php
    line 102, line 119

    does it say
    `privileges`,

    or
    privileges,


    Thanks.


  • 2008-12-08 17:55:15

    Re: Creating another Administrator

    privileges


  • 2008-12-09 09:50:34

    Re: Creating another Administrator

    I believe some old versions of mysql breaks on sensitive keywords like privileges, it requires backquotes around them.

    Please apply patch 13 and let me know if the problem persists. Thanks.


    -harris


  • 2008-12-09 12:01:11

    Re: Creating another Administrator

    Patch 13 worked.

    I really appreciate your assistance.