MantisBT

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0005802ATutorInstallationpublic2017-06-18 06:502017-09-24 17:43
Reporterdanidemi 
Assigned To 
PrioritynormalSeveritymajorReproducibilityalways
StatusnewResolutionopen 
PlatformOSOS Version
Product Version2.2.2 
Target VersionFixed in Version 
Summary0005802: During installation tables are reported by ATutor as created, even when they are not.
DescriptionI installed ATutor 2.2.2 on mysql 5.7.18.

The installation is reported as completely correct by ATutor.
In fact this is the list of tables it repors...

Table AT_admin_log created successfully.
Table AT_admins created successfully.
Table AT_assignments created successfully.
Table AT_auto_enroll created successfully.
Table AT_auto_enroll_courses created successfully.
Table AT_backups created successfully.
Table AT_basiclti_content created successfully.
Table AT_basiclti_tools created successfully.
Table AT_blog_posts created successfully.
Table AT_blog_posts_comments created successfully.
Table AT_blog_subscription created successfully.
Table AT_calendar_bookmark created successfully.
Table AT_calendar_events created successfully.
Table AT_calendar_google_sync created successfully.
Table AT_calendar_notification created successfully.
Table AT_config created successfully.
Table AT_content created successfully.
Table AT_content_forums_assoc created successfully.
Table AT_content_prerequisites created successfully.
Table AT_content_tests_assoc created successfully.
Table AT_course_access created successfully.
Table AT_course_cats created successfully.
Table AT_course_enrollment created successfully.
Table AT_course_stats created successfully.
Table AT_courses created successfully.
Table AT_external_resources created successfully.
Table AT_faq_entries created successfully.
Table AT_faq_topics created successfully.
Table AT_feeds created successfully.
Table AT_fha_student_tools created successfully.
Table AT_file_storage_groups created successfully.
Table AT_files created successfully.
Table AT_files_comments created successfully.
Table AT_folders created successfully.
Table AT_forums created successfully.
Table AT_forums_accessed created successfully.
Table AT_forums_courses created successfully.
Table AT_forums_groups created successfully.
Table AT_forums_subscriptions created successfully.
Table AT_forums_threads created successfully.
Table AT_glossary created successfully.
Table AT_grade_scales created successfully.
Table AT_grade_scales_detail created successfully.
Table AT_gradebook_detail created successfully.
Table AT_gradebook_tests created successfully.
Table AT_groups created successfully.
Table AT_groups_members created successfully.
Table AT_groups_types created successfully.
Table AT_guests created successfully.
Table AT_handbook_notes created successfully.
Table AT_instructor_approvals created successfully.
Table AT_language_pages created successfully.
Table AT_language_text created successfully.
Table AT_languages created successfully.
Table AT_links created successfully.
Table AT_links_categories created successfully.
Table AT_mail_queue created successfully.
Table AT_master_list created successfully.
Table AT_member_login_attempt created successfully.
Table AT_member_track created successfully.
Table AT_members created successfully.
Table AT_messages created successfully.
Table AT_messages_sent created successfully.
Table AT_modules created successfully.
Table AT_myown_patches created successfully.
Table AT_myown_patches_dependent created successfully.
Table AT_myown_patches_files created successfully.
Table AT_news created successfully.
Table AT_oauth_client_servers created successfully.
Table AT_oauth_client_tokens created successfully.
Table AT_pa_album_comments created successfully.
Table AT_pa_albums created successfully.
Table AT_pa_course_album created successfully.
Table AT_pa_groups created successfully.
Table AT_pa_photo_comments created successfully.
Table AT_pa_photos created successfully.
Table AT_patches created successfully.
Table AT_patches_files created successfully.
Table AT_patches_files_actions created successfully.
Table AT_polls created successfully.
Table AT_polls_members created successfully.
Table AT_primary_resources created successfully.
Table AT_primary_resources_types created successfully.
Table AT_reading_list created successfully.
Table AT_related_content created successfully.
Table AT_resource_types created successfully.
Table AT_secondary_resources created successfully.
Table AT_secondary_resources_types created successfully.
Table AT_social_activities created successfully.
Table AT_social_application_settings created successfully.
Table AT_social_applications created successfully.
Table AT_social_friend_requests created successfully.
Table AT_social_friends created successfully.
Table AT_social_groups created successfully.
Table AT_social_groups_activities created successfully.
Table AT_social_groups_board created successfully.
Table AT_social_groups_invitations created successfully.
Table AT_social_groups_members created successfully.
Table AT_social_groups_requests created successfully.
Table AT_social_groups_types created successfully.
Table AT_social_member_additional_information created successfully.
Table AT_social_member_contact created successfully.
Table AT_social_member_education created successfully.
Table AT_social_member_personal created successfully.
Table AT_social_member_position created successfully.
Table AT_social_member_representation created successfully.
Table AT_social_member_track created successfully.
Table AT_social_member_websites created successfully.
Table AT_social_members_applications created successfully.
Table AT_social_privacy_preferences created successfully.
Table AT_social_user_settings created successfully.
Table AT_tests created successfully.
Table AT_tests_answers created successfully.
Table AT_tests_groups created successfully.
Table AT_tests_questions created successfully.
Table AT_tests_questions_assoc created successfully.
Table AT_tests_questions_categories created successfully.
Table AT_tests_results created successfully.
Table AT_themes created successfully.
Table AT_users_online created successfully.

But then, I check the content of the db and several tables are not there!
ATutor reports 120 tables as successfully created, but the db containes only 103 tables.

Some examples of missing tables are...

* AT_admins
* AT_assignments
* AT_language_text

I tried to pin point the problem, so I executed manually this script.

CREATE TABLE `admins` (
   `login` VARCHAR( 30 ) NOT NULL default '',
   `password` VARCHAR( 40 ) NOT NULL default '',
   `real_name` VARCHAR( 120 ) NOT NULL default '',
   `email` VARCHAR( 50 ) NOT NULL default '',
   `language` varchar(5) NOT NULL default '',
   `privileges` MEDIUMINT UNSIGNED NOT NULL default 0,
   `last_login` TIMESTAMP NOT NULL default 0,
   PRIMARY KEY ( `login` )
) ENGINE = MyISAM;

found in ATutor-atutor_2_2_2/include/install/db/atutor_schema.sql.

That's what I got from mysql...

0001067 - Invalid default value for 'last_login'

Steps To ReproduceStart a 5.7.18 container with this line...

docker run -e MYSQL_ROOT_PASSWORD=rootpwd --name mysql -p3306:3306 -d mysql:5.7.18

Then start a new ATutor 2.2.2 installation on it.
TagsNo tags attached.
Affects version2.0.3
SVN Revision#
Attached Files

- Relationships

-  Notes
(0007648)
danidemi (reporter)
2017-06-18 06:59

Ok, I investigated a little more.

It seems that mysql 5.7.18 enabled some sort of "strict" mode!

If I execute

SELECT @@SQL_MODE

I got

ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

The problem could be this NO_ZERO_IN_DATE option.

Here I place some references for you:

* https://dba.stackexchange.com/questions/112633/invalid-default-value-mysql-5-7-for-timestamp-field [^]

* https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html#sqlmode_no_zero_date [^]

* https://stackoverflow.com/questions/9192027/invalid-default-value-for-create-date-timestamp-field [^]

Please, contact me back if you need further help.
(0007649)
danidemi (reporter)
2017-06-18 07:12

One last comment, I tried with the mysql 5.6 mysql image and it worked flawlessly. So ATutor 2.2.2 seems to be absolutely not compatible with mysql 5.7
(0007652)
greg (administrator)
2017-09-24 17:43

Aware of the problem with mysql 5.7. Will likely wait a version before fixing this. A major revision required to deal with al the 0000 datetime and timestamp fields.

- Issue History
Date Modified Username Field Change
2017-06-18 06:50 danidemi New Issue
2017-06-18 06:59 danidemi Note Added: 0007648
2017-06-18 07:12 danidemi Note Added: 0007649
2017-09-24 17:43 greg Note Added: 0007652


Copyright © 2000 - 2017 MantisBT Team
Powered by Mantis Bugtracker