ATutor

Learning Management Tools







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


cannotaccess database after installation


  • 2016-01-21 11:00:29

    cannotaccess database after installation

    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, Centos 5
    ATutor version - 2.2.1
    Patch #s applied -
    ATutor theme name - Default
    PHP version -
    MySQL version -
    Webserver & version -
    Copies of error messages -
    Changes to default settings -
    Web browser being used - Firefox
    I installed successfull the latest stableversion of ATutor on my server and When I wanted to login I got the following error message:
    Warning: Invalid argument supplied for foreach() in /home3/slobodan/public_html/atutor/include/lib/output.inc.php on line 288

    Please advise.

  • 2016-01-21 11:24:17

    Re: cannotaccess database after installation

    I checked in admin details about installation and found teh following info

    Database:
    0.52 MB
    Disk Usage:
    0.09 MB
    Courses:
    0
    Users:
    1
    ATutor Version:
    2.2(unknown - 2016-01-21 10:22:01). Check Latest Version.
    PHP Version:
    5.4.45
    MySQL Version:
    5.5.42-37.1
    OS:
    Linux 3.12.41-77.ELK6.x86_64

    Well, databse is there. It is strange that I am constantkly prompted that there is no database although it exists and installation went successfully.

  • 2016-01-21 11:36:05

    Re: cannotaccess database after installation

    Are there any special characters in the database name or the database password? If so, that may be the problem. Use only numbers, letters, underscores, and dashes.

  • 2016-01-21 11:39:12

    Re: cannotaccess database after installation

    Also check the apache and php error logs.

    Which version are you working with. The lastest stable is 2.2, though I'm guessing you are working with the 2.2.1 release candidate.

  • 2016-01-21 11:48:07

    Re: cannotaccess database after installation

    hello,

    Only characters and numbers are used. There are no any other symbols. I use the latest stable version 2.2
    Thanks

  • 2016-01-21 11:55:26

    Re: cannotaccess database after installation

    Please see attach. so you can see message that I receive.
    the url of atutor installation is:
    http/://slobodansoftverzaskole.org/atutor

    Thanks,
    veki

  • 2016-01-21 12:08:30

    Re: cannotaccess database after installation

    The messages you see are likely caused by some other error that is occurring.
    You'll probably need to look in the php error log for any db connection related messages.

  • 2016-01-21 12:51:54

    Re: cannotaccess database after installation

    Hello, I checked account and I found that there are no user defined apache handlers.
    There is no any log file in public_html folder. My hosting comnpany told me that log file would be created if tehre were errors. WHat next to xheck?
    Thanks,
    veki

  • 2016-01-21 12:59:56

    Re: cannotaccess database after installation

    I found in /atutor folder error.log and I found the following:
    [21-Jan-2016 11:54:54 America/Chicago] Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '='
    SQL: SELECT L.* FROM AT_language_text L, AT_language_pages P WHERE L.language_code="en" AND L.term=P.term AND P.page="/login.php" ORDER BY L.variable ASC
    [21-Jan-2016 11:54:54 America/Chicago] PHP Warning: Invalid argument supplied for foreach() in /home3/slobodan/public_html/atutor/include/lib/output.inc.php on line 288
    I guess clue is there/ please advise whT I have to fix.

  • 2016-01-21 13:43:30

    Re: cannotaccess database after installation

    I have had chat with administrators from hosting company and they told me that connection with database is OK. They suggested that there must be something in coding. Please advise

  • 2016-01-21 13:54:43

    Re: cannotaccess database after installation

    I found solution. I changed the encoding for the AT_language_text table to utf8_unicode_ci directly in login.php file.
    Maybe you can think on mechanism that will manage such issues.
    Can I mark this thread as solved?

  • 2016-01-21 14:07:31

    Re: cannotaccess database after installation

    Curious. The everything should be set to UTF8 during installation.

    What exactly did you change in the login.php file?

  • 2016-01-21 15:07:45

    Re: cannotaccess database after installation

    Sorry, maybe I mistyped. As you see two tables AT_language text and AT_language_pages have connection with login.php For some reason they have had different collations and they were conflicting with other collations. I changed that and there was no conflicting collations anymore. I do not have idea why that happenned.

  • 2016-01-21 16:41:03

    Re: cannotaccess database after installation

    After issuing SQL command
    ALTER TABLE AT_language_pages CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci
    the table had identical collation with other tables and system works.
    I do not know why the table has got different collation.
    However, small glitch is solved.