View Single Post
ItsCEED
Member
Join Date: Jun 2016
Old 10-25-2019 , 11:40   Re: [Any][MySQL] tVip (2.2 | 05-03-19) - The simplest to use Vip Manager
Reply With Quote #221

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;

Last edited by ItsCEED; 10-25-2019 at 12:30.
ItsCEED is offline
Send a message via Skype™ to ItsCEED