Utility: E-Inquiry

[Emistry]

File Name: E-Inquiry

File Submitter: Emistry

File Submitted: 29 Jul 2012

File Category: Utilities

Content Author: Emistry

This is a NPC that enable Players to Write a Message and send to GM Team.

GM Team are allow to reply to the Messages written by Players.

There will be notification upon login if there is any New Messages.

Make sure you have loaded this SQL Table before the NPC is used in your Server.

CREATE TABLE IF NOT EXISTS `E-Inquiry` (
`ID` bigint(20) unsigned NOT NULL auto_increment,
`Sender_ID` int(11) unsigned NOT NULL default '0',
`Sender_Name` varchar(30) NOT NULL default '',
`Title` text,
`Message` text,
`Status` tinyint(2) NOT NULL default '0',
`Inquiry_Time` datetime NOT NULL default '0000-00-00 00:00:00',
`Reply` text,
`Reply_Time` datetime NOT NULL default '0000-00-00 00:00:00',
`Reply_Name` varchar(30) NOT NULL default '',
PRIMARY KEY  (`ID`)
) ENGINE=MyISAM;

Topic Detail :

http://rathena.org/b..._140#entry99947

---

Click here to download this file

[NakedWolf]

How to fix this ...???
CREATE TABLE IF NOT EXISTS `E-Inquiry` (
	`ID` bigint(20) unsigned NOT NULL auto_increment,
	`Sender_ID` int(11) unsigned NOT NULL default '0',
	`Sender_Name` varchar(30) NOT NULL default '',
	`Title` text,
	`Message` text,
	`Status` tinyint(2) NOT NULL default '0',
	`Inquiry_Time` datetime NOT NULL default '0000-00-00 00:00:00',
	`Reply` text,
	`Reply_Time` datetime NOT NULL default '0000-00-00 00:00:00',
	`Reply_Name` varchar(30) NOT NULL default '',
	PRIMARY KEY  (`ID`)
) ENGINE=MyISAM

 

MySQL said: 

#1067 - Invalid default value for 'Inquiry_Time'

--------------------------------------------------------------------------------------------------------------

SOLVED

by disabling sql strict mode (NO_ZERO_DATE.)

Edited May 11, 2020 by NakedWolf
Problem solved