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

Terminatorr

Quote:

Originally Posted by Notifications

Check your log file and you'll find the problem

Hi, Here is the log error;

PHP Code:


			
L 02/14/2019 - 13:01:36: [SM] Exception reported: Invalid database Handle 0 (error: 4)

L 02/14/2019 - 13:01:36: [SM] Blaming: tVip.smx

L 02/14/2019 - 13:01:36: [SM] Call stack trace:

L 02/14/2019 - 13:01:36: [SM]   [0] SQL_SetCharset

L 02/14/2019 - 13:01:36: [SM]   [1] Line 56, C:\Users\ziegl\Dropbox\SourcePawnSP\Products\tVIP\tVip\tVip.sp::OnPluginStart

L 02/14/2019 - 13:01:36: [SM] Unable to load plugin "tVip.smx": Error detected in plugin startup

Niklavs

Code:

L 02/17/2019 - 14:33:58: [tVip.smx] Table 'tVip.tVip' doesn't exist
L 02/17/2019 - 14:33:58: [SM] Exception reported: Invalid query Handle 0 (error: 4)
L 02/17/2019 - 14:33:58: [SM] Blaming: tVip.smx
L 02/17/2019 - 14:33:58: [SM] Call stack trace:
L 02/17/2019 - 14:33:58: [SM]   [0] SQL_FetchRow
L 02/17/2019 - 14:33:58: [SM]   [1] Line 472, C:\Users\ziegl\Dropbox\SourcePawnSP\Products\tVIP\tVip\tVip.sp::SQLCheckVIPQuery

Help please someone!
It didn't even create tables for db

Totenfluch

Check your database.cfg and make sure it's setup like described in the main post.

Terminatorr

Quote:

Originally Posted by Totenfluch

Check your database.cfg and make sure it's setup like described in the main post.

It is exactly, like the main post, but i keep getting the mentioned error, i have other like sourcebans work fine with mysql.

Niklavs

Quote:

Originally Posted by Totenfluch

Check your database.cfg and make sure it's setup like described in the main post.

"tVip"
{
"driver" "default"
"host" "localhost"
"database" "tVip"
"user" "root"
"pass" "(private)"
//"timeout" "0"
"port" "3306"
}

Totenfluch · *Last edited by Totenfluch; 02-17-2019 at 09:18.*

Quote:

Originally Posted by Niklavs

Code:

"tVip"
{

driver" "default"
"host" "localhost"
"database" "tVip"
"user" "root"
"pass" "(private)"
//"timeout" "0"
"port" "3306"

}

Code:

"tVip"
{
"driver" "mysql"
"host" "webserverURL"
"database" "databasename"
"user" "databaseuser"
"pass" "dbpassword"
//"timeout" "0"
"port" "3306"
}

The driver has to be mysql...

Totenfluch

Quote:

Originally Posted by Terminatorr

It is exactly, like the main post, but i keep getting the mentioned error, i have other like sourcebans work fine with mysql.

doubt

Niklavs · *Last edited by Niklavs; 02-17-2019 at 09:55.*

Quote:

Originally Posted by Totenfluch

Code:

"tVip"
{
"driver" "mysql"
"host" "webserverURL"
"database" "databasename"
"user" "databaseuser"
"pass" "dbpassword"
//"timeout" "0"
"port" "3306"
}

The driver has to be mysql...

Won't change anything, but I did it:

Code:

"tVip"
{
"driver" "mysql"
"host" "localhost"
"database" "tVip"
"user" "root"
"pass" "******"
//"timeout" "0"
"port" "3306"
}

Still logs

Code:

L 02/17/2019 - 16:41:00: [tVip.smx] Table 'tVip.tVip' doesn't exist
L 02/17/2019 - 16:41:00: [SM] Exception reported: Invalid query Handle 0 (error: 4)
L 02/17/2019 - 16:41:00: [SM] Blaming: tVip.smx
L 02/17/2019 - 16:41:00: [SM] Call stack trace:
L 02/17/2019 - 16:41:00: [SM]   [0] SQL_FetchRow
L 02/17/2019 - 16:41:00: [SM]   [1] Line 472, C:\Users\ziegl\Dropbox\SourcePawnSP\Products\tVIP\tVip\tVip.sp::SQLCheckVIPQuery

+ didn't create any tables at db

May be you can add me on discord and help? Niklavs#5878
It's important for me to have this plugin.

Totenfluch

Quote:

Originally Posted by Niklavs

May be you can add me on discord and help? Niklavs#5878
It's important for me to have this plugin.

The solution to the problem was running

Code:

SET SQL_MODE='ALLOW_INVALID_DATES';

in mysql.

The Problem was an outdated mysql version that used
https://dev.mysql.com/doc/refman/5.7...e_no_zero_date

Version was 5.7.25 in ubuntu 16.04.2

plock

Hey Totenfluch. Can you update the .sp on your post? I believe it's outdated according to github.