Problema mysql

AnzZ0r · 26 Oct 2019, 17:15

*Problemă:nu pot sa rulez fisierele .sql in baza de date
Tipologie server:--
*Resursă folosită:sursa/metin2-martysama-t80329.html
*ServerFiles utilizat:martysama 6.5
*Syserr:

Poză:
*Detalii suplimentare:Folosesc mysql 5.5 si primesc eroare 1067 - Invalid default value for 'LimitDt' cand rulez fisierele sql in baza de date, am cautat pe net si si cica ar fii setat sql_mode sa nu puna 00.00.0000 la datile default sau ceva de genu asa ca m-am uitat in consola si nu am nimic in sql_mode,este gol, tot bat internetul de ieri in cautarea unei solutii si m-am gandit sa apelez si la voi.
Acesta este unun din fisierele pe care incerc sa-l rulez

SET FOREIGN_KEY_CHECKS=0;

DROP TABLE IF EXISTS `GameTime`;
CREATE TABLE `GameTime` (
`UserID` varchar(16) NOT NULL DEFAULT '',
`paymenttype` tinyint(2) NOT NULL DEFAULT '1',
`LimitTime` int(11) unsigned DEFAULT '0',
`LimitDt` datetime DEFAULT CURRENT_TIMESTAMP,
`Scores` int(11) DEFAULT '0',
PRIMARY KEY (`UserID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `GameTimeIP`;
CREATE TABLE `GameTimeIP` (
`ipid` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(128) DEFAULT NULL,
`ip` varchar(15) NOT NULL DEFAULT '000.000.000.000',
`startIP` int(11) NOT NULL DEFAULT '0',
`endIP` int(11) NOT NULL DEFAULT '255',
`paymenttype` tinyint(2) NOT NULL DEFAULT '1',
`LimitTime` int(11) NOT NULL DEFAULT '0',
`LimitDt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`readme` varchar(128) DEFAULT NULL,
PRIMARY KEY (`ipid`),
UNIQUE KEY `ip_uniq` (`ip`,`startIP`,`endIP`),
KEY `ip_idx` (`ip`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `GameTimeLog`;
CREATE TABLE `GameTimeLog` (
`login` varchar(16) DEFAULT NULL,
`type` enum('IP_FREE','FREE','IP_TIME','IP_DAY','TIME','DAY') DEFAULT NULL,
`logon_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`logout_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`use_time` int(11) unsigned DEFAULT NULL,
`ip` varchar(15) NOT NULL DEFAULT '000.000.000.000',
`server` varchar(56) NOT NULL DEFAULT '',
KEY `login_key` (`login`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `account`;
CREATE TABLE `account` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`login` varchar(16) NOT NULL DEFAULT '' COMMENT 'LOGIN_MAX_LEN=30',
`password` varchar(42) NOT NULL DEFAULT '' COMMENT 'PASSWD_MAX_LEN=16; default 45 size',
`social_id` varchar(7) NOT NULL DEFAULT '',
`email` varchar(100) NOT NULL DEFAULT '',
`securitycode` varchar(192) NOT NULL DEFAULT '',
`status` varchar(8) NOT NULL DEFAULT 'OK',
`availDt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`last_play` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`gold_expire` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`silver_expire` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`safebox_expire` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`autoloot_expire` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`fish_mind_expire` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`marriage_fast_expire` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`money_drop_rate_expire` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,

`real_name` varchar(16) DEFAULT '',
`question1` varchar(56) DEFAULT NULL,
`answer1` varchar(56) DEFAULT NULL,
`question2` varchar(56) DEFAULT NULL,
`answer2` varchar(56) DEFAULT NULL,
`cash` int(11) DEFAULT 0,
PRIMARY KEY (`id`),
UNIQUE KEY `login` (`login`) USING BTREE,
KEY `social_id` (`social_id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `block_exception`;
CREATE TABLE `block_exception` (
`login` varchar(16) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `iptocountry`;
CREATE TABLE `iptocountry` (
`IP_FROM` varchar(16) DEFAULT NULL,
`IP_TO` varchar(16) DEFAULT NULL,
`COUNTRY_NAME` varchar(56) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `string`;
CREATE TABLE `string` (
`name` varchar(64) NOT NULL DEFAULT '',
`text` text,
PRIMARY KEY (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO `block_exception` VALUES ('NONE');
INSERT INTO `iptocountry` VALUES ('0.0.0.0', '0.0.0.0', 'NONE');

AnzZ0r · 27 Oct 2019, 19:21

YouTube · 27 Oct 2019, 22:07

datetime nu accepta CURRENT_TIMESTAMP ca si valoare DEFAULT.
Ruleaza query de forma aceasta:

Cod: Selectaţi tot

SET FOREIGN_KEY_CHECKS=0;

DROP TABLE IF EXISTS `GameTime`;
CREATE TABLE `GameTime` (
`UserID` varchar(16) NOT NULL DEFAULT '',
`paymenttype` tinyint(2) NOT NULL DEFAULT '1',
`LimitTime` int(11) unsigned DEFAULT '0',
`LimitDt` timestamp DEFAULT CURRENT_TIMESTAMP,
`Scores` int(11) DEFAULT '0',
PRIMARY KEY (`UserID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

AnzZ0r · 29 Oct 2019, 02:22

Am schimbat datatime cu timestamp si a mers, dar nu o sa afecteze serverul in mod negativ pentru ca am schimbat acea valoare?

[ Postat de pe Android ] Imagine

Lion · 29 Oct 2019, 06:49

AnzZ0r scrie: ↑29 Oct 2019, 02:22 Am schimbat datatime cu timestamp si a mers, dar nu o sa afecteze serverul in mod negativ pentru ca am schimbat acea valoare?

[ Postat de pe Android ]

Nu..

[ Postat de pe Android ] Imagine

AnzZ0r · 29 Oct 2019, 11:57

Am inteles, multumesc.
Puteti da T/C

Lion · 29 Oct 2019, 12:23

Arhivat

[ Postat de pe Android ] Imagine

Problema mysql

Problema mysql crpyex,are cineva un mysql compatibil?

Problema Mysql -tmp/mysql.shock

problema mysql (mysql.sock)

Cine este conectat