ATutor

cannotaccess database after installation

• vvucic
  

  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.

• vvucic
  

  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.

• greg
  

  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.

• greg
  

  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.

• vvucic
  

  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

• vvucic
  

  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

• greg
  

  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.

• vvucic
  

  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

• vvucic
  

  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.

• vvucic
  

  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

• vvucic
  

  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?

• greg
  

  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?

• vvucic
  

  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.

• vvucic
  

  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.