Community Forums

ATutor Bug Reports

Fresh installation - Database error message


You must be signed-in to post.

AuthorSubject
 
Page: 1
hakangur
Subject: Fresh installation - Database error messageQuote this post in your reply
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
ATutor version - 2.2
Patch #s applied - None
ATutor theme name - Default theme
PHP version - 5.5
MySQL version - 5.1.61
Webserver & version - server4.hostinger.de
Copies of error messages - See below.
Changes to default settings - None
Web browser being used - Chrome, Explorer
...and anything else relevant -

Hello,

I downloaded the latest stable version today and uploaded the zipped file as-is to the server. In my first attempt, I moved all the files from ATutor directory to the root and installed with no problem at all. However, I encountered two error messages:

Warning: Invalid argument supplied for foreach() in /home/u489532240/public_html/ATutor/include/lib/output.inc.php on line 288

and

The following errors occurred:
ATutor was unable to access the database. If the problem persists, please report this to an Administrator with this date reference (03/18/2015 10:15:31 am)

I applied all the patches but the messages were still there. I removed all the files and installed ATutor again, this time without changing the original location of the files. The problem persists. I checked the Forum and found similar problems reported, but they are all related with upgrading and, honestly, I failed to see a workable solution suggested - perhaps because of the fact that I am not a coder.

Any suggestion is appreciated. By the way, if anyone should like to see the problem themselves, the address is www.openwebucation.com.

Best regards.
Posted: 2015-03-18 06:33:12
greg

Avatar for greg
Subject: Re: Fresh installation - Database error messageQuote this post in your reply
The issue seems to be related to language, which might indicate a corruption in the language_text table somewhere. Here's where thing are breaking down.


https://github.com/atutor/ATutor/blob/master/include/lib/output.inc.php#L288-L304

A few things you could try:

Install another language using the admin's Language Manager, then switch to the new language and see if the error message goes away. If it does, grab a copy of the English, delete the old English using the Language Manager, then reinstall with the downloaded English language pack.

Language packs
www.atutor.ca/atutor/translate/index.php

Or, you could enable debugging by setting AT_DEVEL to "1" at the top of the include/vital.inc.php file. Then in the code surrounding the block identified above, use the debug() function to output the values for the $_template variable, and other variable in the _AT() function.

e.g.
debug($_template);

You may be able to scan through the output looking for missing or suspitus looking language, with broken characters in it. If you find any, you can use the Translation admin's Translation to retype the language. (enabled by setting AT_DEVEL_TRANSLATE variable to "1" in vitals.inc.php)

You could also try adjusting the Cache Lifetime value to "0" temporarily and see if that fixes the problem. If it does, your server time/date may not be correct, in which case you might ask you system administrator to reset it.

You could also look at https://www.atutorspaces.com for a hosted version of ATutor.
Posted: 2015-03-18 09:37:12
awan_kinton
Subject: Re: Fresh installation - Database error messageQuote this post in your reply
hy greg sorry for bumping old thread
yesterday i intal atutor on localhost and its work 100%,
then i try to instal on server, with your instruction like extract tar.gz at server, then instal it.
i have same problem as hankangur.

-----
the problem is :


Warning: Invalid argument supplied for foreach() in /home/u397155400/public_html/include/lib/output.inc.php on line 288

The following errors occurred:

ATutor was unable to access the database. If the problem persists, please report this to an Administrator with this date reference (04/16/2017 06:00:39 am)
-------

i was trying upload another language but its always fail, and import a language directly from the ATutor.ca website it same fail to.

now i cant change the date, cant register new user, cant.

---
this is my test work

tp-edu.tk
user : admin
pas : admin
---

sorry to have many questions,

---
ATutor Version:
2.2.2(unknown - 2017-04-16 06:00:39). Check Latest Version.
PHP Version:
5.6.21
MySQL Version:
10.1.22-MariaDB
OS:
Linux 3.2.55-grsec
---

thankyou...
Posted: 2017-04-16 02:16:01
greg

Avatar for greg
Subject: Re: Fresh installation - Database error messageQuote this post in your reply
You would need to trace the source of the problem using the debug() function as described above.

My guess is the anguage pack you are trying to upload is broken.
Posted: 2017-04-16 10:29:00
awan_kinton
Subject: Re: Fresh installation - Database error messageQuote this post in your reply
It looks like a mistake from my dbserv,

I check in phpMyAdmin me all collation using utf8_unicode_ci
at post cindy here
www.atutor.ca/view/3/24113/1.html

ATutor using utf8_general_ci.

Then
i export the database, next find and replace all utf8_unicode_ci to utf8_general_ci
next i delete all sql on phpMyAdmin.
finally i import my sql file that has been edited to the server.
Taraa its work like a charm.

btw thanks for answering many of my questions Greg smile
Posted: 2017-04-16 11:39:59
 
Page: 1

You must be signed-in to post.

Related Articles