Errors during install
I got several database errors when I tried to install "MillionDollarScript":
Here's the output of the install: `Error: Invalid default value for 'ad_date'(
CREATE TABLE `ads` (
`ad_id` int(11) NOT NULL auto_increment,
`user_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL default '0',
`ad_date` datetime NOT NULL default '0000-00-00 00:00:00',
`order_id` int(11) default '0',
`banner_id` int(11) NOT NULL default '0',
`1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL default '',
`2` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL default '',
`3` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL default '',
PRIMARY KEY (`ad_id`)
) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci)
Error: Invalid default value for 'date_updated'(
CREATE TABLE `banners` (
`banner_id` int(11) NOT NULL auto_increment,
`grid_width` int(11) NOT NULL default '0',
`grid_height` int(11) NOT NULL default '0',
`days_expire` mediumint(9) default '0',
`price_per_block` float NOT NULL default '0',
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL default '',
`currency` char(3) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL default 'USD',
`publish_date` datetime default NULL,
`max_orders` int(11) NOT NULL default '0',
`block_width` int(11) NOT NULL default '10',
`block_height` int(11) NOT NULL default '10',
`grid_block` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`nfs_block` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`tile` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`usr_grid_block` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`usr_nfs_block` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`usr_ord_block` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`usr_res_block` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`usr_sel_block` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`usr_sol_block` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`max_blocks` int(11) NOT NULL default '0',
`min_blocks` int(11) NOT NULL default '0',
`date_updated` datetime NOT NULL default '0000-00-00 00:00:00',
`bgcolor` varchar(7) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL default '#FFFFFF',
`auto_publish` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL default 'N',
`auto_approve` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL default 'N',
`time_stamp` int(11) default NULL,
PRIMARY KEY (`banner_id`)
) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci)
Error: Table 'thefapdollarhomepage.banners' doesn't exist(
INSERT INTO `banners` VALUES (1, 100, 100, 1, 100, 'Million Pixels. (1000x1000)', 'USD', NULL, 1, 10, 10, 'iVBORw0KGgoAAAANSUhEUgAAAAoAAAAKCAIAAAACUFjqAAAAHklEQVR4nGO8cuUKA27AwsDAoK2tjUuaCY/W4SwNAJbvAxP1WmxKAAAAAElFTkSuQmCC', 'iVBORw0KGgoAAAANSUhEUgAAAAoAAAAKCAIAAAACUFjqAAAAFUlEQVR4nGP8//8/A27AhEduBEsDAKXjAxF9kqZqAAAAAElFTkSuQmCC', 'iVBORw0KGgoAAAANSUhEUgAAAHgAAAB4AQMAAAADqqSRAAAABlBMVEXW19b///9ZVCXjAAAAJklEQVR4nGNgQAP197///Y8gBpw/6r5R9426b9R9o+4bdd8wdB8AiRh20BqKw9IAAAAASUVORK5CYII=', 'iVBORw0KGgoAAAANSUhEUgAAAAoAAAAKCAIAAAACUFjqAAAAHklEQVR4nGO8cuUKA27AwsDAoK2tjUuaCY/W4SwNAJbvAxP1WmxKAAAAAElFTkSuQmCC', 'iVBORw0KGgoAAAANSUhEUgAAAAoAAAAKCAIAAAACUFjqAAAAFUlEQVR4nGP8//8/A27AhEduBEsDAKXjAxF9kqZqAAAAAElFTkSuQmCC', 'iVBORw0KGgoAAAANSUhEUgAAAAoAAAAKCAIAAAACUFjqAAAAFElEQVR4nGP83+DAgBsw4ZEbwdIAJ/sB02xWjpQAAAAASUVORK5CYII=', 'iVBORw0KGgoAAAANSUhEUgAAAAoAAAAKCAIAAAACUFjqAAAAE0lEQVR4nGP8/58BD2DCJzlypQF0BwISHGyJPgAAAABJRU5ErkJggg==', 'iVBORw0KGgoAAAANSUhEUgAAAAoAAAAKCAIAAAACUFjqAAAAE0lEQVR4nGNk+M+ABzDhkxy50gBALQETmXEDiQAAAABJRU5ErkJggg==', 'iVBORw0KGgoAAAANSUhEUgAAAAoAAAAKCAIAAAACUFjqAAAAEklEQVR4nGP8z4APMOGVHbHSAEEsAROxCnMTAAAAAElFTkSuQmCC', 500, 0, '2007-02-17 10:48:32', '#FFffFF', 'Y', 'Y', 1171775611))
Error: Invalid default value for 'order_date'(
CREATE TABLE `temp_orders` (
`session_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL default '',
`blocks` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`order_date` datetime NOT NULL default '0000-00-00 00:00:00',
`price` float NOT NULL default '0',
`quantity` int(11) NOT NULL default '0',
`banner_id` int(11) NOT NULL default '1',
`currency` char(3) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL default 'USD',
`days_expire` int(11) NOT NULL default '0',
`date_stamp` datetime default NULL,
`package_id` int(11) NOT NULL default '0',
`ad_id` int(11) default '0',
`block_info` LONGTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (`session_id`)
) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci)
Error: Invalid default value for 'date'(
CREATE TABLE `clicks` (
`banner_id` INT NOT NULL ,
`block_id` INT NOT NULL ,
`user_id` INT NOT NULL ,
`date` date NOT NULL default '0000-00-00',
`clicks` INT NOT NULL ,
PRIMARY KEY ( `banner_id` , `block_id` , `date` )
) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci)
Error: Invalid default value for 'order_date'(
CREATE TABLE `orders` (
`user_id` int(11) NOT NULL default '0',
`order_id` int(11) NOT NULL auto_increment,
`blocks` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`status` set('pending','completed','cancelled','confirmed','new','expired','deleted','renew_wait','renew_paid') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL default '',
`order_date` datetime NOT NULL default '0000-00-00 00:00:00',
`price` float NOT NULL default '0',
`quantity` int(11) NOT NULL default '0',
`banner_id` int(11) NOT NULL default '1',
`currency` char(3) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL default 'USD',
`days_expire` int(11) NOT NULL default '0',
`date_published` datetime default NULL,
`date_stamp` datetime default NULL,
`expiry_notice_sent` set('Y','N') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL default '',
`package_id` int(11) NOT NULL default '0',
`ad_id` int(11) default NULL,
`approved` set('Y','N') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL default 'N',
`published` set('Y','N') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL default '',
`subscr_status` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL default '',
`original_order_id` int(11) default NULL,
`previous_order_id` int(11) NOT NULL default '0',
PRIMARY KEY (`order_id`)
) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci)
Error: Invalid default value for 'date'(
CREATE TABLE `transactions` (
`transaction_id` int(11) NOT NULL auto_increment,
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`order_id` int(11) NOT NULL default '0',
`type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL default '',
`amount` float NOT NULL default '0',
`currency` char(3) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL default '',
`txn_id` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL default '',
`reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL default '',
`origin` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL default '',
PRIMARY KEY (`transaction_id`)
) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci)
Error: Invalid default value for 'SignupDate'(
CREATE TABLE `users` (
`ID` int(11) NOT NULL auto_increment,
`IP` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL default '',
`SignupDate` datetime NOT NULL default '0000-00-00 00:00:00',
`FirstName` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL default '',
`LastName` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL default '',
`Rank` int(11) NOT NULL default '1',
`Username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL default '',
`Password` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL default '',
`Email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL default '',
`Newsletter` int(11) NOT NULL default '1',
`Notification1` int(11) NOT NULL default '0',
`Notification2` int(11) NOT NULL default '0',
`Aboutme` longtext NOT NULL,
`Validated` int(11) NOT NULL default '0',
`CompName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL default '',
`login_date` datetime NOT NULL default '0000-00-00 00:00:00',
`logout_date` datetime NOT NULL default '0000-00-00 00:00:00',
`login_count` int(11) NOT NULL default '0',
`last_request_time` datetime NOT NULL default '0000-00-00 00:00:00',
`click_count` int(11) NOT NULL default '0',
`view_count` int(11) NOT NULL default '0',
PRIMARY KEY (`ID`),
UNIQUE KEY `Username` (`Username`)
) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci)
Error: Invalid default value for 'mail_date'(
CREATE TABLE `mail_queue` (
`mail_id` int(11) NOT NULL auto_increment,
`mail_date` datetime NOT NULL default '0000-00-00 00:00:00',
`to_address` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL default '',
`to_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL default '',
`from_address` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL default '',
`from_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL default '',
`subject` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL default '',
`message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`html_message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`attachments` set('Y','N') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL default '',
`status` set('queued','sent','error') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL default '',
`error_msg` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL default '',
`retry_count` smallint(6) NOT NULL default '0',
`template_id` int(11) NOT NULL default '0',
`att1_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL default '',
`att2_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL default '',
`att3_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL default '',
`date_stamp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`mail_id`)
) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci)
114 Operations Completed.`
I'm using XAMPP v3.2.4, with a new database and database user 'root', any suggestion? thanks!
DETAILS: Database client version: libmysql - mysqlnd 5.0.12-dev Server type: MariaDB PHP version: 7.3.27
Edited by Loris Simonetti