Quote:
L 10/25/2019 - 17:43:55: [tVip.smx] Table 'l2p_csgo.tVip' doesn't exist
L 10/25/2019 - 17:43:55: [SM] Exception reported: Invalid query Handle 0 (error: 4) L 10/25/2019 - 17:43:55: [SM] Blaming: tVip.smx
|
Config is set as should be, MariaDB Upgraded to the latest.
Yes, i did run
SET SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES'; / SET SQL_MODE='ALLOW_INVALID_DATES';
Nothing has changed.
I can confirm that the settings are there.
https://prnt.sc/po4ajn
I also catch this in the error log
Quote:
L 10/25/2019 - 18:17:17: [tVip.smx] Invalid default value for 'enddate'
|
Totenfluch came up with the solution:
Create database yourself which is not that hard:
Code:
CREATE TABLE IF NOT EXISTS `tVip` (
`Id` bigint(20) NOT NULL AUTO_INCREMENT,
`timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`playername` varchar(36) COLLATE utf8_bin NOT NULL,
`playerid` varchar(20) COLLATE utf8_bin NOT NULL,
`enddate` timestamp NOT NULL DEFAULT '2000-01-01 20:20:20',
`admin_playername` varchar(36) COLLATE utf8_bin NOT NULL,
`admin_playerid` varchar(20) COLLATE utf8_bin NOT NULL,
PRIMARY KEY (`Id`),
UNIQUE KEY `playerid` (`playerid`)
) ENGINE = InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;