Server : LiteSpeed System : Linux server 3.10.0-1160.90.1.el7.x86_64 #1 SMP Thu May 4 15:21:22 UTC 2023 x86_64 User : alsaif ( 1057) PHP Version : 7.4.33 Disable Function : show_source,posix_kill,posix_mkfifo,posix_getpwuid,posix_setpgid,posix_setsid,posix_setuid,posix_setgid,posix_seteuid,posix_setegid,posix_uname Directory :  /home/alsaif/public_html/administrator/components/com_sppagebuilder/sql/updates/mysql/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

-- 3.7.10

ALTER TABLE `#__spmedia` MODIFY `created_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00';
ALTER TABLE `#__spmedia` MODIFY `modified_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00';
ALTER TABLE `#__sppagebuilder` MODIFY `created_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00';
ALTER TABLE `#__sppagebuilder` MODIFY `modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00';
ALTER TABLE `#__sppagebuilder` MODIFY `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00';
ALTER TABLE `#__sppagebuilder_sections` MODIFY `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00';
ALTER TABLE `#__sppagebuilder_addons` MODIFY `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00';


UPDATE `#__spmedia` SET `created_on` = '0000-00-00 00:00:00' WHERE `created_on` = NULL;
UPDATE `#__spmedia` SET `modified_on` = '0000-00-00 00:00:00' WHERE `modified_on` = NULL;

UPDATE `#__sppagebuilder` SET `created_on` = '0000-00-00 00:00:00' WHERE `created_on` = NULL;
UPDATE `#__sppagebuilder` SET `modified` = '0000-00-00 00:00:00' WHERE `modified` = NULL;
UPDATE `#__sppagebuilder` SET `checked_out_time` = '0000-00-00 00:00:00' WHERE `checked_out_time` = NULL;

UPDATE `#__sppagebuilder_sections` SET `created` = '0000-00-00 00:00:00' WHERE `created` = NULL;
UPDATE `#__sppagebuilder_addons` SET `created` = '0000-00-00 00:00:00' WHERE `created` = NULL;