ATutor

Learning Management Tools







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


Installing Tutor on CentOS 7 server


  • 2017-01-08 10:26:28

    Installing Tutor on CentOS 7 server

    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:

    [i][ the_follow_errors_occurred ]

    [ AT_ERROR_DB_QUERY ] [/i]

    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,
    Paul:(

  • 2017-01-08 15:54:12

    Re: Installing Tutor on CentOS 7 server

    See if the answer on StackOverflow helps. There is probably a timezone setting missing, or misset, in php.ini

    http://stackoverflow.com/questions/16765158/date-it-is-not-safe-to-rely-on-the-systems-timezone-settings

  • 2017-01-08 17:40:26

    Re: Installing Tutor on CentOS 7 server

    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: http://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: http://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

  • 2017-01-08 17:51:14

    Re: Installing Tutor on CentOS 7 server

    It would then seem like the error is because MySQL is set to strict mode, added in MySQL v5.7+

    http://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.

  • 2017-01-08 17:57:57

    Re: Installing Tutor on CentOS 7 server

    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.