The classroom-schema.sql too has the same issue.
ALTER TABLE `classroom`.`crs_class` CHANGE `created_date` `created_date` DATETIME DEFAULT '2000-01-01 00:00:00' NOT NULL;
ALTER TABLE `classroom`.`crs_lesson` CHANGE `created_date` `created_date` DATETIME DEFAULT '2000-01-01 00:00:00' NOT NULL;
ALTER TABLE `classroom`.`crs_room` CHANGE `created_date` `created_date` DATETIME DEFAULT '2000-01-01 00:00:00' NOT NULL;
ALTER TABLE `classroom`.`crs_schedule` CHANGE `created_date` `created_date` DATETIME DEFAULT '2000-01-01 00:00:00' NOT NULL;
ALTER TABLE `classroom`.`crs_schedule_hdr` CHANGE `created_date` `created_date` DATETIME DEFAULT '2000-01-01 00:00:00' NOT NULL;
ALTER TABLE `classroom`.`crs_student` CHANGE `created_date` `created_date` DATETIME DEFAULT '2000-01-01 00:00:00' NOT NULL;
ALTER TABLE `classroom`.`crs_subject` CHANGE `created_date` `created_date` DATETIME DEFAULT '2000-01-01 00:00:00' NOT NULL;
ALTER TABLE `classroom`.`crs_teacher` CHANGE `created_date` `created_date` DATETIME DEFAULT '2000-01-01 00:00:00' NOT NULL;
There are still several references in the code to '0000-00-00 00:00:00' like in
$fieldvalue == '0000-00-00 00:00:00'
in both sql and .inc files,
Will NULL values (and empty checks) be useful and how do earlier (Pre 5.6) MySQL DBs be managed?
Scripts that generate PHP pages too should be taken into account.
[Updated on: Sun, 16 April 2017 06:54]
Report message to a moderator
Radicore Forum
Search
Help
Members
Register
Login
Home
