ToxicRevolution / CSGORankMeWeb

Web interface for Rank Me CSGO Stat tracking plugin
https://Toxicrevolution.net
MIT License
30 stars 10 forks source link

Weird Database Issue #46

Closed punkstarharis closed 6 years ago

punkstarharis commented 6 years ago

im having this issue (attaching screenshot) already made database with the name of Ranking but idk why this happening capture

TandelK commented 6 years ago

What is the table name in your Database of having all the ranks?

punkstarharis commented 6 years ago

just made a database with the name of ranking from database wizard there is no table option in database wizard

punkstarharis commented 6 years ago

server is also crashing with this error capture

TandelK commented 6 years ago

What version of RankMe are you using ? Kento or the Old CSGO Version which was mainly developed for CS:S . Also i dont see any errors here . There are 2 notifications from different plugins 1 is from weapons.smx which i think is Skins Plugin which is removing data of old players from the Database for keeping space on your System and also second one is GEOIP which is database of IPs which basically tells you whenever someone connects from where did they join.

punkstarharis commented 6 years ago

Kento, downloaded from github

TandelK commented 6 years ago

Did you use it once in the server even ? Or just without even starting RankMe in the server you tried installing this panel ?

TandelK commented 6 years ago

Check your Databases.cfg file and make sure you have "rankme" area and db name should be there and check the database what table has it created

punkstarharis commented 6 years ago

rankme was working fine without webpanel its showing ranks and topplayers but when i use webpanel server keep crashing

TandelK commented 6 years ago

Might be due to limits of SQL Server you are using . Also the user you use for connecting SQL to Webpanel does it has all access to that Database?

punkstarharis commented 6 years ago

yes full access to database and database have 2 tables auto created users, servers

punkstarharis commented 6 years ago

already rankme and database details in database.cfg im also using sourceban and its working fine without any issues

TandelK commented 6 years ago

i see they should already have rankme table which is not there. Do you see that databases.cfg rankme "" has the same database name as per the one you are connecting to webpanel ?

punkstarharis commented 6 years ago

yes everything is ok there

TandelK commented 6 years ago

PM me Steam : TandelK

punkstarharis commented 6 years ago

ADDED YOU - [A]zonic ' steelseries

kennyLtv commented 6 years ago

Did you get this resolved? Also, we don't edit anything on your server so it is unlikely that the web panel is causing your server to crash.

punkstarharis commented 6 years ago

its not solved yet, do you have any solution how to make it run

punkstarharis commented 6 years ago

i wanted to use it badly is there any complete tut availible? maybe i have did something wrong that's why its causing errors

kennyLtv commented 6 years ago

There is not a complete tutorial available I hope to in the next month or so release a new system that should make the whole web panel better. Usually, we see this error when there is an issue in the database configuration. Is the base table for your rankme install rankme?

punkstarharis commented 6 years ago

there is no rankme table i thought it will be created automatically image

kennyLtv commented 6 years ago

Ok so like I suspected. Those 2 tables (servers & users) are created by our web panel for the services it provides. The rankme table would be created by the server plugin. So if you haven't connected a rankme server to the database that is why you get that error. The plugin will generate the rankme table for us to read.

kennyLtv commented 6 years ago

The game server should generate the rankme table structure. Does the game server plugin error or have you connected to the game server?

kennyLtv commented 6 years ago

Also, you may want to change your password if that is actually it.

punkstarharis commented 6 years ago

gameserver is keep crashing and in the logs its only show some geoip errors

punkstarharis commented 6 years ago

41807542-8bc252e2-76e9-11e8-8b07-90ff17c1035a

kennyLtv commented 6 years ago

I'm not sure, you must have some sort of misconfiguration error on your game server side. We don't interact with the game server at all. Sadly there isn't a lot I can do to help you because our web panel can't make your server crash. I would suggest double checking your plugin install. Please let us know if you have any further issues with the web panel itself.

punkstarharis commented 6 years ago

Thanks for your time and help it was my database issue and now i have tried another database from different website and its working fine now thanks again and i will be waiting for new webpanel