Quote:
Originally Posted by Sincronic
The funny thing is that in my logs folder i don't find anything. Where i should search ?
My database config is corect.
Code:
"tVip"
{
"driver" "mysql"
"host" "xxxxxxxxxxxxxx"
"database" "xxxxxxxxxxxxxxx"
"user" "xxxxxxxxxxxxxxxxxxx"
"pass" "xxxxxxxxxxxx"
//"timeout" "0"
"port" "3306"
|
Errors will be in logs folder errorlog<d/m/y>
And make sure you have done the following:
SET SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
Make the required tables in the database:
Quote:
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;
|