SA-MP Forums Archive
Uploading DB help - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Uploading DB help (/showthread.php?tid=614111)


Uploading DB help - ctopha - 04.08.2016

Hello everybody, Now i face a problem while uploading my db files, and it is

Код:
SQL query:

-- --------------------------------------------------------
--
-- Table structure for table `pcp_news`
--
CREATE TABLE  `pcp_news` (

 `nw_id` INT( 11 ) NOT NULL ,
 `nw_title` VARCHAR( 24 ) NOT NULL ,
 `nw_body` LONGTEXT,
 `nw_sticked` TINYINT( 1 ) NOT NULL DEFAULT  '0',
 `nw_user` INT( 11 ) NOT NULL ,
 `nw_date` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE = MYISAM DEFAULT CHARSET = latin1;

MySQL said: Documentation

#1067 - Invalid default value for 'nw_dateSQL query:

-- --------------------------------------------------------
--
-- Table structure for table `pcp_news`
--
CREATE TABLE  `pcp_news` (

 `nw_id` INT( 11 ) NOT NULL ,
 `nw_title` VARCHAR( 24 ) NOT NULL ,
 `nw_body` LONGTEXT,
 `nw_sticked` TINYINT( 1 ) NOT NULL DEFAULT  '0',
 `nw_user` INT( 11 ) NOT NULL ,
 `nw_date` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE = MYISAM DEFAULT CHARSET = latin1;

MySQL said: Documentation

#1067 - Invalid default value for 'nw_date


Re: Uploading DB help - Konstantinos - 04.08.2016

You can only have CURRENT_TIMESTAMP as default value of DATETIME in mysql 5.6.5+ so either update or remove the default value.

Re: Uploading DB help - ctopha - 04.08.2016

Thanks, fixed