Main.sql and error

[Alliance]

Hi anyone know how to fix this?

 

 

[MatanzaLH]

Hi 

You need to update your phpmyadmin to the latest version.

 

Edited January 16, 2023 by MatanzaLH

[Akbare]

5 hours ago, MatanzaLH said:

Hi 

You need to update your phpmyadmin to the latest version.

 

I tried to import via command also error is there a solution

[Emistry]

you may change the default  value of your SQL table.

...datetime NOT NULL DEFAULT '0000-00-00 00:00:00',

 

[AncestralPrivates]

 

 

Any solution for this error?

[Akbare]

On 4/4/2023 at 2:21 AM, AncestralPrivates said:

 

 

Any solution for this error?

just excute

CREATE TABLE IF NOT EXISTS `party_bookings` (
  `world_name` varchar(32) NOT NULL,
  `account_id` int(11) unsigned NOT NULL,
  `char_id` int(11) unsigned NOT NULL,
  `char_name` varchar(23) NOT NULL,
  `purpose` smallint(5) unsigned NOT NULL DEFAULT '0',
  `assist` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `damagedealer` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `healer` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `tanker` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `minimum_level` smallint(5) unsigned NOT NULL,
  `maximum_level` smallint(5) unsigned NOT NULL,
  `comment` varchar(255) NOT NULL DEFAULT '',
  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`world_name`, `account_id`, `char_id`)
) ENGINE=MyISAM;

 

[chatterboy]

Other sol:

Palitan mo lods yong datetime into timestamp

Rok on!