Community Forums

ATutor Support

Installing Tutor on CentOS 7 server


You must be signed-in to post.

AuthorSubject
 
Page: 1
PWither2
error_log_and_created.txt
Subject: Installing Tutor on CentOS 7 serverQuote 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 - CentOS 7
ATutor version - 2.2.2
ATutor theme name -N/A
PHP version -5.6.29
MySQL version - 5.7.17
Webserver & version - Apache 2.4.6

After following the installation instructions for new installation, I get to the first log-in screen I see the following text:

[ the_follow_errors_occurred ]

[ AT_ERROR_DB_QUERY ]


When I looked at the error_log, it tells me that three tables are missing from the schema:
* themes
* language_text
* courses

It also says it doesn't like the use of the date() function because the time zone hasn't been set.

What is odd is that when I go through the installation process, it reports that the three tables were successfully created. But when I go to MySQL they don't exist.

I have attached a text document with my error log first and then the text showing what tables were created.

Is the installation process creating the tables, then dropping them?

Help please!

Cheers,
Paulfrown
Posted: 2017-01-08 10:26:28
greg

Avatar for greg
Subject: Re: Installing Tutor on CentOS 7 serverQuote this post in your reply
See if the answer on StackOverflow helps. There is probably a timezone setting missing, or misset, in php.ini

stackoverflow.com/questions/16765158/date-it-is-not-safe-to-rely-on-the-systems-timezone-settings
Posted: 2017-01-08 15:54:12
PWither2
Subject: Re: Installing Tutor on CentOS 7 serverQuote this post in your reply
For some reason the system seems to be creating and then dropping these tables:
- admins
- language_text
- members
- courses

By going through the install sql scripts I was able to go in and separated recreate these tables, which seemed to eliminate the errors, however, there continue to be issues:

* [Sun Jan 08 17:14:06.152733 2017] [:error] [pid 6136] [client ::1:38442] Incorrect date value: '0000-00-00' for column 'dob' at row 1\nSQL: INSERT INTO AT_members (member_id, login, password, email, website, first_name, second_name, last_name, dob, gender, address, postal, city, province, country, phone, status,preferences, creation_date, language, inbox_notify, private_email, last_login) VALUES (NULL,'PaulW','c7blahblahblah4d','pwithier2@blah.net','','Paul','','Wither2','0000-00-00','n', '','','','','', '',3,'', NOW(),'en', 0, 1, '0000-00-00 00:00:00'), referer: localhost/ATutor/install/install.php
* [Sun Jan 08 17:17:49.245195 2017] [:error] [pid 31043] [client ::1:38470] PHP Warning: require(/var/www/html/ATutor/themes/../themes//theme.cfg.php): failed to open stream: No such file or directory in /var/www/html/ATutor/include/vitals.inc.php on line 314, referer: localhost/ATutor/login.php?submit=%C2%BB+Log-in%21

I did notice the follow errors when I was creating these tables from your scripts:

- When creating date fields, it rejected default dates of “0000-00-00” required something like “1950-01-01’
- When creating timestamp field is required a date after “1970-01-01”

Adding the tables got me further along, but the system still didn't create an account for me. It did create an administrator's account, however.

Cheers,
PW
Posted: 2017-01-08 17:40:26
greg

Avatar for greg
Subject: Re: Installing Tutor on CentOS 7 serverQuote this post in your reply
It would then seem like the error is because MySQL is set to strict mode, added in MySQL v5.7+

stackoverflow.com/questions/36374335/error-in-mysql-when-setting-default-value-for-date-or-datetime/36374690#36374690

We'll make a note of it, and work a fix into the next release.
Posted: 2017-01-08 17:51:14
greg

Avatar for greg
Subject: Re: Installing Tutor on CentOS 7 serverQuote this post in your reply
In the meantime, disable strict mode as described in the stackoverflow post, and you should be good to go.

The next release is at least a couple months away.
Posted: 2017-01-08 17:57:57
 
Page: 1

You must be signed-in to post.

Related Articles