Jump to content

Recommended Posts

Posted

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

  • Upvote 1
  • 7 years later...
Posted (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: Documentation

#1067 - Invalid default value for 'Inquiry_Time'

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

SOLVED

by disabling sql strict mode (NO_ZERO_DATE.)

Edited by NakedWolf
Problem solved

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...