Emistry Posted July 29, 2012 Posted July 29, 2012 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 1 Quote
NakedWolf Posted May 11, 2020 Posted May 11, 2020 (edited) 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 Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.