tVip doesn't auto create MySQL table

[Ironman1M]

Hi, after installing the plugin ( and setting up the database CORRECTLY ) and restarting the server multiple times the plugin says after every sm_addvip this.
`> sm_addvip "STEAM_1:0:583422896" 1 "Testikos" 0 a

Added 0:583422896 as VIP for 1 Month
L 01/06/2021 - 09:05:35: [tvip.smx] Table 'sql_5922.tVip' doesn't exist
L 01/06/2021 - 09:05:35: [tvip.smx] Table 'sql_5922.tVip' doesn't existAnd at startup this> L 01/06/2021 - 09:04:54: [SM] Exception reported: Invalid query Handle 0 (error: 4)
L 01/06/2021 - 09:04:54: [SM] Blaming: tvip.smx
L 01/06/2021 - 09:04:54: [SM] Call stack trace:
L 01/06/2021 - 09:04:54: [SM] [0] SQL_FetchRow
L 01/06/2021 - 09:04:54: [SM] [1] Line 488, C:\Users\Charles\CloudStation\Documents\Perso\Dev\tVip-1\tVip.sp::SQLCheckVIPQuery`

[Totenfluch]

use the version provided here on github and compile the .sp yourself. Then you will see what part of the database setup you failed.

[Ironman1M]

I compiled it and still gives me this error on startup.
`> L 01/07/2021 - 22:59:08: [tvip.smx] Table 'sql_5922.tVip' doesn't exist

L 01/07/2021 - 22:54:55: [SM] Exception reported: Invalid query Handle 0 (error: 4)
L 01/07/2021 - 22:54:55: [SM] Blaming: tvip.smx
L 01/07/2021 - 22:54:55: [SM] Call stack trace:
L 01/07/2021 - 22:54:55: [SM] [0] SQL_FetchRow
L 01/07/2021 - 22:54:55: [SM] [1] Line 488, C:\Users\Charles\CloudStation\Documents\Perso\Dev\tVip-1\tVip.sp::SQLCheckVIPQuery`

[Ironman1M]

It should autocreate the table in MySQL but it just doesn't, instead it shows the error

[Totenfluch]

it should print another error before.

SetFailState("Error connecting to database: "%s"", error);

[Ironman1M]

Thew biggest problem here is that I don't know how to code plugins for CS:GO so I can't do it by myself.

[Ironman1M]

But as I already said, it kust looks like it cant create the MySQL database table but the plugin itself works fine.

[Totenfluch]

execute the mysql statement manually on your database to get the correct error

[Ironman1M]

I found the code I needed to execute on the database but now removing the vip's manually doesnt work

[ghost]

Im having the same issue here:
L 01/25/2021 - 12:17:57: [tVip.smx] Table 'db826.tVip' doesn't exist L 01/25/2021 - 12:17:57: [SM] Exception reported: Invalid query Handle 0 (error: 4) L 01/25/2021 - 12:17:57: [SM] Blaming: tVip.smx L 01/25/2021 - 12:17:57: [SM] Call stack trace: L 01/25/2021 - 12:17:57: [SM] [0] SQL_FetchRow L 01/25/2021 - 12:17:57: [SM] [1] Line 488, C:\Users\Charles\CloudStation\Documents\Perso\Dev\tVip-1\tVip.sp::SQLCheckVIPQuery

I installed the latest version of tVIP from the github.

Here you can see a screenshot of my SQL:

I also ran SET SQL_MODE='ALLOW_INVALID_DATES';
but sadly to no avail

[Ironman1M]

I had problem with this too, all you gotta do is run this on your database to create the table.

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;

[ghost]

I had problem with this too, all you gotta do is run this on your database to create the table.

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;

thanks wag1