Raised This Month: $12 Target: $400
 3% 

[Any][MySQL] tVip (2.3 | 04-04-21) - The simplest to use Vip Manager


Post New Thread Reply   
 
Thread Tools Display Modes
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
shadow1
Junior Member
Join Date: Jan 2018
Old 12-05-2019 , 09:06   Re: [Any][MySQL] tVip (2.2 | 05-03-19) - The simplest to use Vip Manager
Reply With Quote #222

Code:
L 12/05/2019 - 12:47:26: SourceMod error session started
L 12/05/2019 - 12:47:26: Info (map "de_mirage") (file "/home/csgo1/addons/sourcemod/logs/errors_20191205.log")
L 12/05/2019 - 12:47:26: [SM] Exception reported: Invalid index -1 (count: 1)
L 12/05/2019 - 12:47:26: [SM] Blaming: tVip_ReservedSlots.smx
L 12/05/2019 - 12:47:26: [SM] Call stack trace:
L 12/05/2019 - 12:47:26: [SM]   [0] ArrayList.Get
L 12/05/2019 - 12:47:26: [SM]   [1] Line 303, D:\Servers\csgo\csgo\addons\sourcemod\scripting\tVip_ReservedSlots.sp::KickMethod
L 12/05/2019 - 12:47:26: [SM]   [2] Line 207, D:\Servers\csgo\csgo\addons\sourcemod\scripting\tVip_ReservedSlots.sp::StartSlotReservationCheck
L 12/05/2019 - 12:47:26: [SM]   [3] Line 133, D:\Servers\csgo\csgo\addons\sourcemod\scripting\tVip_ReservedSlots.sp::tVip_OnClientLoadedPost
L 12/05/2019 - 12:47:26: [SM]   [5] Call_Finish
L 12/05/2019 - 12:47:26: [SM]   [6] Line 490, C:\Users\ziegl\Dropbox\SourcePawnSP\Products\tVIP\tVip\tVip.sp::SQLCheckVIPQuery
Any help?
shadow1 is offline
Notifications
AlliedModders Donor
Join Date: Oct 2015
Old 12-05-2019 , 19:56   Re: [Any][MySQL] tVip (2.2 | 05-03-19) - The simplest to use Vip Manager
Reply With Quote #223

Quote:
Originally Posted by shadow1 View Post
Code:
L 12/05/2019 - 12:47:26: SourceMod error session started
L 12/05/2019 - 12:47:26: Info (map "de_mirage") (file "/home/csgo1/addons/sourcemod/logs/errors_20191205.log")
L 12/05/2019 - 12:47:26: [SM] Exception reported: Invalid index -1 (count: 1)
L 12/05/2019 - 12:47:26: [SM] Blaming: tVip_ReservedSlots.smx
L 12/05/2019 - 12:47:26: [SM] Call stack trace:
L 12/05/2019 - 12:47:26: [SM]   [0] ArrayList.Get
L 12/05/2019 - 12:47:26: [SM]   [1] Line 303, D:\Servers\csgo\csgo\addons\sourcemod\scripting\tVip_ReservedSlots.sp::KickMethod
L 12/05/2019 - 12:47:26: [SM]   [2] Line 207, D:\Servers\csgo\csgo\addons\sourcemod\scripting\tVip_ReservedSlots.sp::StartSlotReservationCheck
L 12/05/2019 - 12:47:26: [SM]   [3] Line 133, D:\Servers\csgo\csgo\addons\sourcemod\scripting\tVip_ReservedSlots.sp::tVip_OnClientLoadedPost
L 12/05/2019 - 12:47:26: [SM]   [5] Call_Finish
L 12/05/2019 - 12:47:26: [SM]   [6] Line 490, C:\Users\ziegl\Dropbox\SourcePawnSP\Products\tVIP\tVip\tVip.sp::SQLCheckVIPQuery
Any help?
This isn't the reserved slots plugin thread
Notifications is offline
shadow1
Junior Member
Join Date: Jan 2018
Old 12-07-2019 , 23:21   Re: [Any][MySQL] tVip (2.2 | 05-03-19) - The simplest to use Vip Manager
Reply With Quote #224

Quote:
Originally Posted by Notifications View Post
This isn't the reserved slots plugin thread
Sorry, but these both plugins works with each other, and this plugin involved in this error so thats why i posted here also.
shadow1 is offline
Notifications
AlliedModders Donor
Join Date: Oct 2015
Old 12-08-2019 , 13:40   Re: [Any][MySQL] tVip (2.2 | 05-03-19) - The simplest to use Vip Manager
Reply With Quote #225

Quote:
Originally Posted by shadow1 View Post
Sorry, but these both plugins works with each other, and this plugin involved in this error so thats why i posted here also.
It's like that because they work together, but it looks as if the person isn't in the server as line 490 is the finish to
Code:
	//Check if the user is still ingame
	if (isValidClient(client)) {
		while (SQL_FetchRow(hndl)) {
			setFlags(client);
		}
	}
	
	Call_StartForward(g_hForward_OnClientLoadedPost);
	Call_PushCell(client);
	Call_Finish();
So, from the looks of it - Reserved tried kicking someone no longer in the server
Notifications is offline
flashing
Senior Member
Join Date: Jul 2019
Location: India
Old 01-12-2020 , 21:10   Re: [Any][MySQL] tVip (2.2 | 05-03-19) - The simplest to use Vip Manager
Reply With Quote #226

i cant add vip by minutes typing this
sm_addvip "STEAM_1:0:0000000" 60 "Totenfluch" 1

still add 60 months of vip instead of 60 minutes
flashing is offline
Sincronic
Senior Member
Join Date: Dec 2018
Old 01-20-2020 , 21:19   Re: [Any][MySQL] tVip (2.2 | 05-03-19) - The simplest to use Vip Manager
Reply With Quote #227

This plugin is working ?

Quote:
Errors:
tVip.smx (tVIP): Error detected in plugin startup (see error logs)
Sincronic is offline
Stropy
Senior Member
Join Date: Feb 2016
Old 01-21-2020 , 09:16   Re: [Any][MySQL] tVip (2.2 | 05-03-19) - The simplest to use Vip Manager
Reply With Quote #228

Quote:
Originally Posted by Sincronic View Post
This plugin is working ?
Yes, it is. Check the error logs like it tells you to do and it will most likely help you a lot. If not, write again and include the error.
Stropy is offline
Sincronic
Senior Member
Join Date: Dec 2018
Old 01-21-2020 , 12:52   Re: [Any][MySQL] tVip (2.2 | 05-03-19) - The simplest to use Vip Manager
Reply With Quote #229

Quote:
Originally Posted by Stropy View Post
Yes, it is. Check the error logs like it tells you to do and it will most likely help you a lot. If not, write again and include the error.
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"
Sincronic is offline
flashing
Senior Member
Join Date: Jul 2019
Location: India
Old 01-21-2020 , 12:56   Re: [Any][MySQL] tVip (2.2 | 05-03-19) - The simplest to use Vip Manager
Reply With Quote #230

Quote:
Originally Posted by Sincronic View Post
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;

Last edited by flashing; 01-21-2020 at 13:05.
flashing is offline
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 09:37.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode