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!

[Faiz]

On 1/17/2023 at 10:46 PM, Emistry said:

you may change the default  value of your SQL table.

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

 

@Emistry just provide the 1st solution. You have to edit main.sql and look for:

 

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 CURRENT_TIMESTAMP,
  PRIMARY KEY (`world_name`, `account_id`, `char_id`)
) ENGINE=MyISAM;

Replace CURRENT_TIMESTAMP to this: 

'0000-00-00 00:00:00'

And it will be like this: 

  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',

Solved.

Or you can use 2nd solution from @chatterboy which will be like this.

 

  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,

datetime to timestamp. Solved. Both methods are working just fine.

 

If you're using CentOS 7, the problem persists, and the above method will solve the issue. There is no issue with Debian for now.