search

Kxnrl / Store

Store plugin for Source Engine Games.
https://github.com/Kxnrl/Store
90 stars 44 forks source link

database table store_players has invalid column type for dates ? #148

Closed Nycrera closed 4 years ago

Nycrera commented 4 years ago

Hello, I am assuming that the plugin adds new players to the database table "store_players". But while doing so clients get kicked with the following message:

this happens for all of the players/clients. On server logs I get this error / debug message: "Error happened. Error: Out of range value for column 'date_of_join' at row 1" I assumed that INT(11) was problematic for a date and changed the column type of 'date_of_join' and 'date_of_last_join' to VARCHAR(20) which solved the problem. I just wanted to inform you about this bug. But then I still couldn't get it working anyway. This time clients were able to join the server with no problem but the command sm_store didn't produce any errors on server-side and nothing happens, basically. Here you can find my loaditem.php dump: [https://hastebin.com/raw/sevaqefife](https://hastebin.com/raw/sevaqefife) This is a fresh install. I added one parent and one item (weaponskin knife) for testing purposes with given SQL scripts. Any help is welcome.
Kxnrl commented 4 years ago

stable or master?

Nycrera commented 4 years ago

This bug occurred to me while using the stable.

ApollonV2K commented 4 years ago

@Kxnrl I just installed the plugin and I get this error. Do you have a solution?

Kxnrl commented 4 years ago

try master