ATutor

Learning Management Tools







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


Admin user not logging in after upgrade to 151


  • 2005-08-17 09:49:23

    Admin user not logging in after upgrade to 151

    Could be just my upgrade but below are the error messages I get when trying to login as system admin.

    1. I successfully did the upgrade (renamed my old install folderatutor15) to a test site
    2. I tried logging in as admin for my site:
    http://10.0.1.4/atutor/login.php ... results below
    3. I tried logging in as admin for my site:
    http://10.0.1.4/atutor15/login.php ... success to the old install
    4. I then changed
    http://10.0.1.4/atutor15/admin/index.php in my url to
    http://10.0.1.4/atutor/admin/index.php .and I am at the admin section of my new install

    =============
    Errors from trying to tried log in as admin for my site:
    http://10.0.1.4/atutor/login.php


    Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /Library/Apache2/htdocs/atutor/login.php on line 102

    Warning: Cannot modify header information - headers already sent by (output started at /Library/Apache2/htdocs/atutor/login.php:102) in /Library/Apache2/htdocs/atutor/login.php on line 155

    Warning: Cannot modify header information - headers already sent by (output started at /Library/Apache2/htdocs/atutor/login.php:102) in /Library/Apache2/htdocs/ATutor/include/header.inc.php on line 17

    Warning: Cannot modify header information - headers already sent by (output started at /Library/Apache2/htdocs/atutor/login.php:102) in /Library/Apache2/htdocs/ATutor/include/classes/Language/Language.class.php on line 117

    ======

    cheers
    larry

    ====

    ATutor Version: 1.5.1 (build r5269 - 2005-08-16 12:59:49)
    Operating System: Darwin 7.9.0 Darwin Kernel Version 7.9.0: Wed Mar 30 20:11:17 PST 2005; root:xnu/xnu-517.12.7.obj~1/RELEASE_PPC Power Macintosh
    Web Server: Apache/2.0.52 (Unix) PHP/4.3.9 DAV/2
    PHP Version: 4.3.9
    MySQL Version: 4.0.21 Complete MySQL by Server Logistics

  • 2005-08-17 10:00:42

    upgrade

    it seems like your database isn't correct/hasn't been updated properly. did the upgrading process go smoothly? are you sure you're using the updated database?

  • 2005-08-17 10:14:53

    Upgrade to 1.5.1

    I believe so ... it added a couple of new tables ....

    I can login as any user

    I'll trash the upgrade and do it again .... will report back

    larry

  • 2005-08-17 10:23:32

    Re-Install

    This time:

    Connected to database atutor successfully.
    Table handbook_notes already exists. Skipping.
    Successful update from version 1.5 to 1.5.1.
    Table language_text created successfully.
    ===
    Same issue: It will not take the admin user/pass
    ===

    The following errors occurred:
    Invalid login/password combination.

    ==
    Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /Library/Apache2/htdocs/atutor/login.php on line 102

    Warning: Cannot modify header information - headers already sent by (output started at /Library/Apache2/htdocs/atutor/login.php:102) in /Library/Apache2/htdocs/atutor/login.php on line 155

    Warning: Cannot modify header information - headers already sent by (output started at /Library/Apache2/htdocs/atutor/login.php:102) in /Library/Apache2/htdocs/ATutor/include/header.inc.php on line 17

    Warning: Cannot modify header information - headers already sent by (output started at /Library/Apache2/htdocs/atutor/login.php:102) in /Library/Apache2/htdocs/ATutor/include/classes/Language/Language.class.php on line 117

    larry

  • 2005-08-17 11:15:56

    .

    are you using any special characters in your admin username or password?

  • 2005-08-17 13:18:42

    user/pass

    No Joel

    Admin user is a common word and password is a combination of letters and digits only

    (My personal instructor login does have a period in it though)

    larry

  • 2005-08-22 04:13:22

    Same problem with admin account

    I have the same problem after successfully upgrading from ATutor 1.5 to 1.5.1.

    Upgrade went smoothly but I can't log in with my admin account (other accounts work).

    The same error occurs also when trying to log in with an unexisting account...

    After looking at the source code for login.php, on line 99:

    $sql = "SELECT login, `privileges`, language FROM ".TABLE_PREFIX."admins WHERE login='$this_login' AND PASSWORD(password)=PASSWORD('$this_password') AND `privileges`>0";

    should be changed to:

    $sql = "SELECT login, `privileges` FROM ".TABLE_PREFIX."admins WHERE login='$this_login' AND PASSWORD(password)=PASSWORD('$this_password') AND `privileges`>0";

    Since the field "language" is not in the table AT_admins. This fixes the problems.

    I'm not sure this is the correct fix since maybe 1.5.1 was supposed to add a language column in the admins table.

  • 2005-08-22 10:24:36

    .

    Thanks.

    For some reason the language field was not included in the 1.5.1 upgrade SQL, although it does appear in the 1.5 schema.

  • 2005-08-24 07:39:17

    Me Too :(

    I\'ve got the exact same problem - The upgrade went fine, and all my users are fine - But I can\'t login to my admin account.

    I\'ve checked the admin details in SQL - Table at_admins shows the correct username, email address and password.

    I\'ve tried registering with the admin username - atutor reports that the username is already in use.

    I\'ve tried the password reminder - It reports that there is no user with that email address.

    Any ideas?

  • 2005-08-24 07:42:43

    :)

    I tried traguin's fix - That works.

  • 2005-09-08 13:56:47

    Me Too but :)

    Same as, I tried traguin's fix - That works.

  • 2005-10-01 01:38:13

    Admin account login problems with 1.5.1pl

    I\'m having trouble logging in with my admin account as well. My other accounts work fine. It\'s only the admin account that is problemating so far.

    Things to describe:
    operating system - Linux

    version of ATutor - 1.5.1pl

    versions of php - 4.3.11

    version of mysq l - 4.0.25-standard-log

    webserver & version - Apache 1.3.33 (Unix)

    copies of error messages -

    Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/kthulah/public_html/studyitonline/courses/ATutor153/login.php on line 102

    Warning: Cannot modify header information - headers already sent by (output started at /home/kthulah/public_html/studyitonline/courses/ATutor153/login.php:102) in /home/kthulah/public_html/studyitonline/courses/ATutor153/login.php on line 155

    Warning: Cannot modify header information - headers already sent by (output started at /home/kthulah/public_html/studyitonline/courses/ATutor153/login.php:102) in /home/kthulah/public_html/studyitonline/courses/ATutor153/include/header.inc.php on line 17

    Warning: Cannot modify header information - headers already sent by (output started at /home/kthulah/public_html/studyitonline/courses/ATutor153/login.php:102) in /home/kthulah/public_html/studyitonline/courses/ATutor153/include/classes/Language/Language.class.php on line 117

    changes to default settings - traguin\'s fix (which didn\'t work, or maybe I was shooting for the wrong problem)

    web browser being used - IE

    and anything else relevant - My admin username has an underscore in it. I don\'t know if that\'s the problem. The password is letters and numbers.

  • 2005-10-01 20:12:53

    Check admin table

    Check the admin table in the ATutor database to make sure your admin user exists there. If not recreate the user manually.

    Make sure there is no trailing space at the end of the login.php file (or any other file you may have edited). If there is delete it and check your editor's setting and set it to use Unix end of line characters. It will be a properties setting somewhere in the editor.

    What version did you upgrade from?

  • 2005-10-02 00:25:56

    Tired of fighting the thing

    I was using Wordpad as an editor, and didn't do anything to the end of the file...only the line that was supposed to be fixed, and as far as I know, there are not spaces at the end of it. I wouldn't know how to set Wordpad to use Unix ends of line characters.

    I checked the admin table already, and I am there. I was upgrading from 1.5

    I just got tired of fooling with the thing, and went back to 1.5. When I did that everything worked fine as before.

  • 2005-10-02 08:49:46

    Don't use Wordpad

    Using Wordpad could be the problem. Try a different plain text editor.

  • 2006-01-04 14:20:54

    Admin user not logging in after upgrade to 1.5.2

    A bug that I reported going from 1.5 to 1.5.1 in the summer has reared it's ugly head again in the script for 1.52. I could not login as an admin after updating my build to 1.5.2.

    I replaced line 105 in login.php with
    $sql = "SELECT login, `privileges` FROM ".TABLE_PREFIX."admins WHERE login='$this_login' AND PASSWORD(password)=PASSWORD('$this_password') AND `privileges`>0";

    and it did the trick

    larry

  • 2006-01-04 14:49:25

    Re: Admin user not logging in after upgrade to 1.5.2

    The problem is that you do not have the language field in your admin table. I would suggest adding that field as it appears in install/db/atutor_upgrade_1.5_to_1.5.1.sql:

    ALTER TABLE `admins` ADD `language` varchar(5) default '' NOT NULL AFTER `email` ;

    add the the correct table prefix to `admins`

  • 2006-01-04 15:02:54

    Re: Admin user not logging in after upgrade to 1.5.2

    I'm confused Joel

    I just went from 1.5.1 to 1.5.2

    Are you saying that the fix from the summer is not appropriate for the 1.5.2 update ... it did allow me admin access again

    larry

  • 2006-01-04 15:10:27

    Re: Admin user not logging in after upgrade to 1.5.2

    I just used Navicat to add the field to the admins table. Should there be anythingin the field for each admin?

    L

  • 2006-01-04 15:22:21

    Re: Admin user not logging in after upgrade to 1.5.2

    For some reason your upgrade to 1.5.1 did not include that `language` field.

    The language field is used for admins to specifiy their language preference the way regular accounts do.

    Try editing your admin profile and see if it all works as expected.