[SOLVED] DB ERROR NEW UPDATE!

[Its me ZovkT 87]

anyone can help me ?

i become this error.  i make the DB complete New.

19:08:07    CREATE TABLE `clan` (   `id` int(11) UNSIGNED NOT NULL,   `name` varchar(64) NOT NULL,   `leader_uid` varchar(32) NOT NULL,   `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,   `insignia_texture` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8    Error Code: 1046. No database selected Select the default DB to be used by double-clicking its name in the SCHEMAS list in the sidebar.    0.000 sec

 

[Grim 183]

7 minutes ago, Its me ZovkT said:

No database selected

 

[WolfkillArcadia 758]

Grim, you are missing the create SCHEMA in the SQL code. It's trying to create a table on a SCHEMA that doesn't exist 

2 minutes ago, Grim said:

 

 

[MGTDB 956]

Create a new database called exile then execute the exile.sql there.

Also, to the op, make sure you're running at least MySQL 5.6 or higher as the new database syntax won't work with older versions.

Edited December 10, 2015 by MGTDB

[Verazon 0]

#1067 - Invalid default value for 'first_connect_at' 

What is up with that?

[WolfkillArcadia 758]

11 minutes ago, Verazon said:

#1067 - Invalid default value for 'first_connect_at' 

What is up with that?

 

17 minutes ago, MGTDB said:

make sure you're running at least MySQL 5.6 or higher as the new database syntax won't work with older versions.

 

[HeadRox 3]

Can anyone help me also with this? got same problem as posted above with:
CREATE TABLE `account` (
   `uid` varchar(32) NOT NULL,
   `clan_id` int(11) UNSIGNED DEFAULT NULL,
   `name` varchar(64) NOT NULL,
   `money` double NOT NULL DEFAULT '0',
   `score` int(11) NOT NULL DEFAULT '0',
   `kills` int(11) UNSIGNED NOT NULL DEFAULT '0',
   `deaths` int(11) UNSIGNED NOT NULL DEFAULT '0',
   `first_connect_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
   `last_connect_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
   `last_disconnect_at` datetime DEFAULT NULL,
   `total_connections` int(11) UNSIGNED NOT NULL DEFAULT '1'
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8Error Code: 1046. No database selected
 Select the default DB to be used by double-clicking its name in the SCHEMAS list in the sidebar.0.000 sec

Got latest version of MSQL / workbench 6.3.6

Edited June 11, 2016 by HeadRox

[Mezo 1264]

15 minutes ago, HeadRox said:

Can anyone help me also with this? got same problem as posted above with:
CREATE TABLE `account` (
   `uid` varchar(32) NOT NULL,
   `clan_id` int(11) UNSIGNED DEFAULT NULL,
   `name` varchar(64) NOT NULL,
   `money` double NOT NULL DEFAULT '0',
   `score` int(11) NOT NULL DEFAULT '0',
   `kills` int(11) UNSIGNED NOT NULL DEFAULT '0',
   `deaths` int(11) UNSIGNED NOT NULL DEFAULT '0',
   `first_connect_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
   `last_connect_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
   `last_disconnect_at` datetime DEFAULT NULL,
   `total_connections` int(11) UNSIGNED NOT NULL DEFAULT '1'
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8Error Code: 1046. No database selected
 Select the default DB to be used by double-clicking its name in the SCHEMAS list in the sidebar.0.000 sec

Got latest version of MSQL / workbench 6.3.6

Select a database on the left side that you want to execute the code on...

[HeadRox 3]

6 minutes ago, Taylor Swift said:

Select a database on the left side that you want to execute the code on...

You mean 'sakila, test or world' ?

[Mezo 1264]

5 minutes ago, HeadRox said:

You mean 'sakila, test or world' ?

Create a new one called "Exile"