SQL Issue

[carbonemt]

Great plugins guys. Really excited to get this going.

However, I ran into an issue and im not really sure what its trying to tell me:

DataTables warning: table id=LeaderBoardTable - An SQL error occurred: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'leadwelc_stats.stats' doesn't exist

I checked the tables and there are only users and servers. Nothing else. Any advice?

Thank you for your time

[APet74]

Hi Cory, thank you for the interest in our plugin. We'd be happy to assist you.

The first error is related to data tables, it is nothing to worry about because it is caused by the second error. You said you only see users and servers in your database structure, those are the only tables this plugin creates. the table leadwelc_stats.stats should be the table generated by the rankme plugin install on the CS:GO server. I will show you a picture of what I mean and how it looks filled out.

Here is a picture of my database, (Database) you can see I have users, servers, and rankme tables, those are the tables I want to be used by this plugin. The servers and users table are generated by running the installer and the rankme table is generated by the CS:GO server. Here is what I would enter in the setup (install/install.php) (Install)

Let me know if there is anything that needs to be cleared up or any way I can be of assistance.

[carbonemt]

wow fast response! thank you.

So basically, my settings for the CSGO plugin are not correct and thats why the table isnt being created, thus the error?

[APet74]

Yes, is the plugin working on the CS:GO server, for instance, is it saving stats? If you get a kill and type !rank will it show the proper stats?

[carbonemt]

Well it did before i changed the mysql. When I made that 1, it stopped working.

[APet74]

By changing the mySQL are talking about changing it to a new server? Or what exactly changed?

[carbonemt]

In the kento.rankme.cfg, I change rankme_mysql to 1

after that, plugin wont load on the server. When I change it back to 0, it works fine, but nothing communicates with the website.

in the database.cfg I added the rankme database connection information.

[kennyLtv]

Do you have any errors in your sourcemod logs?

[carbonemt]

Not that I can find and when I use the sm_help, the commands show up, but they dont work.

[kennyLtv]

Try checking addons/sourcemod/logs I think. To see if you have an error_ something log file I believe.

[carbonemt]

No sir. No errors in there. I also opened up the 2 most recent. None are showing any errors. Rankme verision appears though, but like i said, it doesnt response on the server with rankme_mysql is 1. Which is really weird that would break the plugin.

[kennyLtv]

It's weird to me that it breaks when you set it to 1 and doesn't generate a log of some sort for the failure. Are you able to view the console logs to see if during startup if throws an error?

[APet74]

I was going to say, from my point of view I would check that the connection info added database.cfg is correct but if it was wrong there should be an error thrown.

[carbonemt]

Ok good news. I had // on the port. I removed that and now its working with mysql 1.

However, now I get a 500 error on the website. http://fearthelordgaming.com/stats, but my actual website is fine. This is a weird issue lol

and ya no error logs.

[APet74]

Is there an error_log generated in any of the folders on your website?

[carbonemt]

I cant find one, no

[carbonemt]

I lied. all the errors are in the crash log

[carbonemt]

`------------------------------------------------ -------------------Next Entry-------------------

---

-------------------Next Entry-------------------

Error parsing BotProfile.db - unknown attribute 'Rank' Error parsing BotProfile.db - unknown attribute 'Rank' Error parsing BotProfile.db - unknown attribute 'Rank' Error parsing BotProfile.db - unknown attribute 'Rank' Error parsing BotProfile.db - unknown attribute 'Rank' Error parsing BotProfile.db - unknown attribute 'Rank' Initializing Steam libraries for secure Internet server Logging into Steam gameserver account with logon token '066877B4xxxxxxxxxxxxxxxxxxxxxxxx' L 11/02/2017 - 09:40:00: "GOTV<2><>" connected, address "" PutClientInServer: no info_player_start on level L 11/02/2017 - 09:40:00: "GOTV<2><>" entered the game GOTV[0] broadcast active. Connection to Steam servers successful. Public IP is 216.52.25.160. Assigned persistent gameserver Steam ID [G:1:1635027]. VAC secure mode is activated. GC Connection established for server version 598, instance idx 1 Host state 5 at Thu Nov 2 09:41:53 2017 -- SIGTERM received, forcing immediate shutdown. L 11/02/2017 - 09:41:53: "GOTV<2><>" disconnected (reason "Server shutting down")

-------------------Next Entry-------------------

Commentary: Could not find commentary data file 'maps/de_dust_commentary.txt'. Error parsing BotProfile.db - unknown attribute 'Rank' Error parsing BotProfile.db - unknown attribute 'Rank' Error parsing BotProfile.db - unknown attribute 'Rank' Error parsing BotProfile.db - unknown attribute 'Rank' Error parsing BotProfile.db - unknown attribute 'Rank' Error parsing BotProfile.db - unknown attribute 'Rank' Error parsing BotProfile.db - unknown attribute 'Rank' Error parsing BotProfile.db - unknown attribute 'Rank' Initializing Steam libraries for secure Internet server Logging into Steam gameserver account with logon token '066877B4xxxxxxxxxxxxxxxxxxxxxxxx' L 11/02/2017 - 09:42:03: "GOTV<2><>" connected, address "" PutClientInServer: no info_player_start on level L 11/02/2017 - 09:42:03: "GOTV<2><>" entered the game GOTV[0] broadcast active. Connection to Steam servers successful. Public IP is 216.52.25.160. Assigned persistent gameserver Steam ID [G:1:1635027]. VAC secure mode is activated. GC Connection established for server version 598, instance idx 1

-------------------Next Entry-------------------

Error parsing BotProfile.db - unknown attribute 'Rank' Error parsing BotProfile.db - unknown attribute 'Rank' Error parsing BotProfile.db - unknown attribute 'Rank' Error parsing BotProfile.db - unknown attribute 'Rank' Error parsing BotProfile.db - unknown attribute 'Rank' Error parsing BotProfile.db - unknown attribute 'Rank' Error parsing BotProfile.db - unknown attribute 'Rank' Initializing Steam libraries for secure Internet server Logging into Steam gameserver account with logon token '066877B4xxxxxxxxxxxxxxxxxxxxxxxx' L 11/02/2017 - 09:45:25: "GOTV<2><>" connected, address "" PutClientInServer: no info_player_start on level L 11/02/2017 - 09:45:25: "GOTV<2><>" entered the game GOTV[0] broadcast active. Connection to Steam servers successful. Public IP is 216.52.25.160. Assigned persistent gameserver Steam ID [G:1:1635027]. VAC secure mode is activated. GC Connection established for server version 598, instance idx 1 Host state 5 at Thu Nov 2 09:46:46 2017 -- SIGTERM received, forcing immediate shutdown.

-------------------Next Entry-------------------

Error parsing BotProfile.db - unknown attribute 'Rank' Error parsing BotProfile.db - unknown attribute 'Rank' Error parsing BotProfile.db - unknown attribute 'Rank' Error parsing BotProfile.db - unknown attribute 'Rank' Error parsing BotProfile.db - unknown attribute 'Rank' Error parsing BotProfile.db - unknown attribute 'Rank' Error parsing BotProfile.db - unknown attribute 'Rank' Initializing Steam libraries for secure Internet server Logging into Steam gameserver account with logon token '066877B4xxxxxxxxxxxxxxxxxxxxxxxx' L 11/02/2017 - 09:46:58: "GOTV<2><>" connected, address "" PutClientInServer: no info_player_start on level L 11/02/2017 - 09:46:58: "GOTV<2><>" entered the game GOTV[0] broadcast active. Connection to Steam servers successful. Public IP is 216.52.25.160. Assigned persistent gameserver Steam ID [G:1:1635027]. VAC secure mode is activated. GC Connection established for server version 598, instance idx 1 Host state 5 at Thu Nov 2 10:08:45 2017 -- SIGTERM received, forcing immediate shutdown.

-------------------Next Entry-------------------

Error parsing BotProfile.db - unknown attribute 'Rank' Error parsing BotProfile.db - unknown attribute 'Rank' Error parsing BotProfile.db - unknown attribute 'Rank' Error parsing BotProfile.db - unknown attribute 'Rank' Error parsing BotProfile.db - unknown attribute 'Rank' Error parsing BotProfile.db - unknown attribute 'Rank' Error parsing BotProfile.db - unknown attribute 'Rank' Initializing Steam libraries for secure Internet server Logging into Steam gameserver account with logon token '066877B4xxxxxxxxxxxxxxxxxxxxxxxx' L 11/02/2017 - 10:08:50: "GOTV<2><>" connected, address "" PutClientInServer: no info_player_start on level L 11/02/2017 - 10:08:50: "GOTV<2><>" entered the game GOTV[0] broadcast active. Connection to Steam servers successful. Public IP is 216.52.25.160. Assigned persistent gameserver Steam ID [G:1:1635027]. VAC secure mode is activated. GC Connection established for server version 598, instance idx 1 Host state 5 at Thu Nov 2 10:11:22 2017 -- SIGTERM received, forcing immediate shutdown.

-------------------Next Entry-------------------

L 11/02/2017 - 10:16:41: "Duffy<6>" switched from team to L 11/02/2017 - 10:16:41: "Martin<8>" disconnected (reason "Kicked by Console") L 11/02/2017 - 10:16:41: "Martin<8>" switched from team to L 11/02/2017 - 10:16:41: "Shawn<7>" disconnected (reason "Kicked by Console") L 11/02/2017 - 10:16:41: "Shawn<7>" switched from team to L 11/02/2017 - 10:16:41: "Calvin<10>" disconnected (reason "Kicked by Console") L 11/02/2017 - 10:16:41: "Calvin<10>" switched from team to L 11/02/2017 - 10:16:41: "Chris<9>" disconnected (reason "Kicked by Console") L 11/02/2017 - 10:16:41: "Chris<9>" switched from team to L 11/02/2017 - 10:16:41: "Perry<12>" disconnected (reason "Kicked by Console") L 11/02/2017 - 10:16:41: "Perry<12>" switched from team to L 11/02/2017 - 10:16:41: "Andy<11>" disconnected (reason "Kicked by Console") L 11/02/2017 - 10:16:41: "Andy<11>" switched from team to L 11/02/2017 - 10:16:41: "Dean<13>" disconnected (reason "Kicked by Console") L 11/02/2017 - 10:16:41: "Dean<13>" switched from team to Game will not start until both teams have players. -> Reservation cookie 0: reason reserved(yes), clients(no), reservationexpires(0.00) Server is hibernating L 11/02/2017 - 10:16:46: "GOTV<2>" disconnected (reason "Punting bot, server is hibernating") Game will not start until both teams have players.

-------------------Next Entry-------------------

Commentary: Could not find commentary data file 'maps/de_dust_commentary.txt'. Error parsing BotProfile.db - unknown attribute 'Rank' Error parsing BotProfile.db - unknown attribute 'Rank' Error parsing BotProfile.db - unknown attribute 'Rank' Error parsing BotProfile.db - unknown attribute 'Rank' Error parsing BotProfile.db - unknown attribute 'Rank' Error parsing BotProfile.db - unknown attribute 'Rank' Error parsing BotProfile.db - unknown attribute 'Rank' Error parsing BotProfile.db - unknown attribute 'Rank' Initializing Steam libraries for secure Internet server Logging into Steam gameserver account with logon token '066877B4xxxxxxxxxxxxxxxxxxxxxxxx' L 11/02/2017 - 10:17:40: "GOTV<2><>" connected, address "" PutClientInServer: no info_player_start on level L 11/02/2017 - 10:17:40: "GOTV<2><>" entered the game GOTV[0] broadcast active. Connection to Steam servers successful. Public IP is 216.52.25.160. Assigned persistent gameserver Steam ID [G:1:1635027]. VAC secure mode is activated. GC Connection established for server version 598, instance idx 1

-------------------Next Entry-------------------

L 11/02/2017 - 10:21:11: "Dennis<11>" purchased "galilar" L 11/02/2017 - 10:21:12: "Calvin<10>" [63 1448 32] killed "Jason<9>" [-962 1463 64] with "p90" L 11/02/2017 - 10:21:16: "Nate<5>" purchased "ump45" L 11/02/2017 - 10:21:16: "Nate<5>" purchased "decoy" L 11/02/2017 - 10:21:16: "Jason<9>" purchased "ump45" L 11/02/2017 - 10:21:16: "Jason<9>" purchased "hegrenade" L 11/02/2017 - 10:21:21: "Harold<12>" [-522 1382 32] killed "Dustin<4>" [-1013 1478 64] with "mp9" L 11/02/2017 - 10:21:23: "Jenssen<6>" [-800 1354 16] killed "Josh<8>" [-1003 1441 64] with "hkp2000" L 11/02/2017 - 10:21:23: "Harold<12>" assisted killing "Josh<8>" L 11/02/2017 - 10:21:26: "Dennis<11>" [101 2147 0] killed "Calvin<10>" [-105 1799 78] with "galilar" L 11/02/2017 - 10:21:30: Starting Freeze period L 11/02/2017 - 10:21:30: World triggered "Match_Start" on "de_dust" L 11/02/2017 - 10:21:30: Team playing "CT": Fear the Lord L 11/02/2017 - 10:21:30: "Jason<9>" triggered "Got_The_Bomb" L 11/02/2017 - 10:21:35: World triggered "Round_Start" Daedious: !admin L 11/02/2017 - 10:21:50: "Daedious<3>" say "!admin" Host state 4 at Thu Nov 2 10:21:57 2017 -- SIGTERM received, forcing immediate shutdown. L 11/02/2017 - 10:21:57: [META] Loaded 0 plugins (1 already loaded)

-------------------Next Entry-------------------

L 11/02/2017 - 10:27:21: "Andy<10>" switched from team to L 11/02/2017 - 10:27:21: "Keith<11>" disconnected (reason "Kicked by Console") L 11/02/2017 - 10:27:21: "Keith<11>" switched from team to L 11/02/2017 - 10:27:21: "Jenssen<12>" disconnected (reason "Kicked by Console") L 11/02/2017 - 10:27:21: "Jenssen<12>" switched from team to L 11/02/2017 - 10:27:21: "Ian<13>" disconnected (reason "Kicked by Console") L 11/02/2017 - 10:27:21: "Ian<13>" switched from team to L 11/02/2017 - 10:27:21: "Colin<4>" disconnected (reason "Kicked by Console") L 11/02/2017 - 10:27:21: "Colin<4>" switched from team to L 11/02/2017 - 10:27:21: "Jason<5>" disconnected (reason "Kicked by Console") L 11/02/2017 - 10:27:21: "Jason<5>" switched from team to L 11/02/2017 - 10:27:21: "Duffy<6>" disconnected (reason "Kicked by Console") L 11/02/2017 - 10:27:21: "Duffy<6>" switched from team to L 11/02/2017 - 10:27:21: "Yahn<9>" disconnected (reason "Kicked by Console") L 11/02/2017 - 10:27:21: "Yahn<9>" switched from team to Game will not start until both teams have players. -> Reservation cookie 0: reason reserved(yes), clients(no), reservationexpires(0.00) Server is hibernating L 11/02/2017 - 10:27:26: "GOTV<2>" disconnected (reason "Punting bot, server is hibernating") Game will not start until both teams have players.

-------------------Next Entry-------------------

L 11/02/2017 - 10:34:05: "Chris<9>" purchased "ump45" L 11/02/2017 - 10:34:05: "Chris<9>" purchased "hegrenade" L 11/02/2017 - 10:34:09: World triggered "Round_Start" L 11/02/2017 - 10:34:45: "Jerry<12>" threw flashbang [-912 604 -172] flashbang entindex 137) L 11/02/2017 - 10:34:45: "Wyatt<5>" blinded for 0.13 by "Jerry<12>" from flashbang entindex 137 L 11/02/2017 - 10:34:45: "Alfred<6>" blinded for 2.81 by "Jerry<12>" from flashbang entindex 137 L 11/02/2017 - 10:34:45: "Ethan<8>" blinded for 0.12 by "Jerry<12>" from flashbang entindex 137 L 11/02/2017 - 10:34:45: "Chris<9>" blinded for 0.13 by "Jerry<12>" from flashbang entindex 137 L 11/02/2017 - 10:34:45: "Jerry<12>" blinded for 2.83 by "Jerry<12>" from flashbang entindex 137 L 11/02/2017 - 10:34:54: "Wyatt<5>" threw hegrenade [-1375 1405 2] L 11/02/2017 - 10:34:55: "Ethan<8>" triggered "Dropped_The_Bomb" L 11/02/2017 - 10:34:55: "Alfred<6>" [-1063 1198 -192] killed "Ethan<8>" [-1221 1044 -116] with "aug" L 11/02/2017 - 10:34:57: "Chris<9>" threw hegrenade [-1350 1469 -157] L 11/02/2017 - 10:34:58: "Chris<9>" [-1440 1443 -160] killed "Jerry<12>" [-1105 1342 -128] with "ump45" (headshot) L 11/02/2017 - 10:34:58: "Grant<11>" assisted killing "Jerry<12>" L 11/02/2017 - 10:35:04: "Jon<4>" [-900 1290 35] killed "Steve<7>" [-931 1111 -121] with "g3sg1" L 11/02/2017 - 10:35:06: "Grant<11>" triggered "Got_The_Bomb" Host state 4 at Thu Nov 2 10:35:07 2017 -- SIGTERM received, forcing immediate shutdown. L 11/02/2017 - 10:35:07: [META] Loaded 0 plugins (1 already loaded)

-------------------Next Entry-------------------

CT bot spawned outside of a buy zone (-124, -1264, 64) CT bot spawned outside of a buy zone (370, -1272, 48) L 11/02/2017 - 10:44:21: World triggered "Round_Start" L 11/02/2017 - 10:44:41: "Tom<19>" [477 -796 64] killed "Duffy<15>" [505 -605 184] with "hkp2000" L 11/02/2017 - 10:44:53: "Norm<18>" [400 -214 -176] killed "Dennis<16>" [-337 -357 -130] with "glock" L 11/02/2017 - 10:44:54: "Martin<20>" [205 148 -116] killed "Tim<21>" [-309 304 -112] with "glock" L 11/02/2017 - 10:44:59: "Norm<18>" [398 -22 -176] killed "Tom<19>" [101 188 96] with "glock" L 11/02/2017 - 10:44:59: "Martin<20>" assisted killing "Tom<19>" L 11/02/2017 - 10:45:05: "Josh<14>" [-308 253 117] killed "Steve<17>" [187 604 128] with "hkp2000" L 11/02/2017 - 10:45:08: "Wyatt<13>" [-544 4 176] killed "Josh<14>" [-309 266 177] with "glock" (headshot) L 11/02/2017 - 10:45:08: "Steve<17>" assisted killing "Josh<14>" L 11/02/2017 - 10:45:47: "Martin<20>" [-532 -529 -6] killed "Daedious<3>" [-376 -1148 128] with "glock" (headshot) L 11/02/2017 - 10:45:47: Team "TERRORIST" triggered "SFUI_Notice_Terrorists_Win" (CT "2") (T "3") L 11/02/2017 - 10:45:47: Team "CT" scored "2" with "5" players L 11/02/2017 - 10:45:47: Team "TERRORIST" scored "3" with "5" players L 11/02/2017 - 10:45:47: World triggered "Round_End" Host state 4 at Thu Nov 2 10:45:51 2017 -- SIGTERM received, forcing immediate shutdown. Bad SetLocalOrigin(573.185913,-322.742523,17597.128906) on predicted_viewmodel L 11/02/2017 - 10:45:52: [META] Loaded 0 plugins (1 already loaded)

-------------------Next Entry-------------------

L 11/02/2017 - 11:30:25: "Chris<52>" switched from team to L 11/02/2017 - 11:30:25: "Matt<53>" disconnected (reason "Kicked by Console") L 11/02/2017 - 11:30:25: "Matt<53>" switched from team to Bad SetLocalOrigin(-905.820312,1791.779541,30327.951172) on predicted_viewmodel L 11/02/2017 - 11:30:25: "Tim<51>" disconnected (reason "Kicked by Console") L 11/02/2017 - 11:30:25: "Tim<51>" switched from team to L 11/02/2017 - 11:30:25: "Martin<55>" disconnected (reason "Kicked by Console") L 11/02/2017 - 11:30:25: "Martin<55>" switched from team to L 11/02/2017 - 11:30:25: "Henry<54>" disconnected (reason "Kicked by Console") L 11/02/2017 - 11:30:25: "Henry<54>" switched from team to L 11/02/2017 - 11:30:25: "Brandon<56>" disconnected (reason "Kicked by Console") L 11/02/2017 - 11:30:25: "Brandon<56>" switched from team to L 11/02/2017 - 11:30:25: "Gary<57>" disconnected (reason "Kicked by Console") L 11/02/2017 - 11:30:25: "Gary<57>" switched from team to L 11/02/2017 - 11:30:25: "Calvin<50>" disconnected (reason "Kicked by Console") L 11/02/2017 - 11:30:25: "Calvin<50>" switched from team to Game will not start until both teams have players. Host state 5 at Thu Nov 2 11:30:29 2017 -- SIGTERM received, forcing immediate shutdown. L 11/02/2017 - 11:30:29: [META] Loaded 0 plugins (1 already loaded)

-------------------Next Entry-------------------

L 11/02/2017 - 11:50:34: "Norm<39>" [-444 16 171] killed "Paul<38>" [-288 -529 128] with "glock" L 11/02/2017 - 11:50:34: "Brandon<31>" assisted killing "Paul<38>" L 11/02/2017 - 11:50:35: "Mark<33>" [-372 -1014 64] killed "Bill<32>" [-360 -877 128] with "hkp2000" L 11/02/2017 - 11:50:35: "Paul<38>" assisted killing "Bill<32>" CT bot spawned outside of a buy zone (370, -1272, 48) CT bot spawned outside of a buy zone (-376, -1148, 64) CT bot spawned outside of a buy zone (-124, -1264, 64) Terrorist bot spawned outside of a buy zone (32, -576, -175) L 11/02/2017 - 11:50:46: "Dean<35>" [-196 -1260 64] killed "Brandon<31>" [297 -21 224] with "hkp2000" (headshot) Terrorist bot spawned outside of a buy zone (362, 1164, 64) L 11/02/2017 - 11:50:54: Starting Freeze period L 11/02/2017 - 11:50:54: World triggered "Match_Start" on "ar_baggage" L 11/02/2017 - 11:50:54: Team playing "CT": Fear the Lord L 11/02/2017 - 11:50:59: World triggered "Round_Start" L 11/02/2017 - 11:51:07: "Brandon<31>" [338 321 93] killed "Calvin<36>" [577 -75 240] with "glock" L 11/02/2017 - 11:51:17: "Martin<37>" [400 547 64] killed "Paul<38>" [225 658 128] with "glock" L 11/02/2017 - 11:51:21: "Dean<35>" [576 -71 176] killed "Brandon<31>" [334 37 225] with "hkp2000" Host state 4 at Thu Nov 2 11:51:24 2017 -- SIGTERM received, forcing immediate shutdown. L 11/02/2017 - 11:51:24: [META] Loaded 0 plugins (1 already loaded)

-------------------Next Entry-------------------

L 11/02/2017 - 12:08:01: "Henry<24>" switched from team to L 11/02/2017 - 12:08:01: "Jenssen<26>" disconnected (reason "Kicked by Console") L 11/02/2017 - 12:08:01: "Jenssen<26>" switched from team to L 11/02/2017 - 12:08:01: "Bill<25>" disconnected (reason "Kicked by Console") L 11/02/2017 - 12:08:01: "Bill<25>" switched from team to L 11/02/2017 - 12:08:01: "Scott<23>" disconnected (reason "Kicked by Console") L 11/02/2017 - 12:08:01: "Scott<23>" switched from team to L 11/02/2017 - 12:08:02: "Greg<28>" disconnected (reason "Kicked by Console") L 11/02/2017 - 12:08:02: "Greg<28>" switched from team to L 11/02/2017 - 12:08:02: "Duffy<27>" disconnected (reason "Kicked by Console") L 11/02/2017 - 12:08:02: "Duffy<27>" switched from team to L 11/02/2017 - 12:08:02: "Perry<30>" disconnected (reason "Kicked by Console") L 11/02/2017 - 12:08:02: "Perry<30>" switched from team to L 11/02/2017 - 12:08:02: "Jason<29>" disconnected (reason "Kicked by Console") L 11/02/2017 - 12:08:02: "Jason<29>" switched from team to Game will not start until both teams have players. -> Reservation cookie 0: reason reserved(yes), clients(no), reservationexpires(0.00) Server is hibernating L 11/02/2017 - 12:08:06: "GOTV<2>" disconnected (reason "Punting bot, server is hibernating") Game will not start until both teams have players.

-------------------Next Entry-------------------

L 11/05/2017 - 21:12:48: "Orange<155>" disconnected (reason "Disconnect") L 11/05/2017 - 21:12:48: "Orange<155>" switched from team to Dropped Orange from server: Disconnect Daedious: ok maybe one more knife round L 11/05/2017 - 21:12:49: "Daedious<189>" say "ok maybe one more knife round" L 11/05/2017 - 21:12:50: "Little Piece<167>" disconnected (reason "Disconnect") L 11/05/2017 - 21:12:50: "Little Piece<167>" switched from team to Dropped Little Piece from server: Disconnect L 11/05/2017 - 21:12:54: "Daedious<189>" disconnected (reason "Disconnect") L 11/05/2017 - 21:12:54: "Daedious<189>" triggered "Dropped_The_Bomb" L 11/05/2017 - 21:12:54: "Daedious<189>" switched from team to Game will not start until both teams have players. Dropped Daedious from server: Disconnect -> Reservation cookie 0: reason reserved(yes), clients(no), reservationexpires(0.00) Server is hibernating L 11/05/2017 - 21:12:59: "GOTV<142>" disconnected (reason "Punting bot, server is hibernating") Game will not start until both teams have players. Host state 5 at Mon Nov 6 15:48:01 2017 -- SIGTERM received, forcing immediate shutdown. L 11/06/2017 - 15:48:01: [META] Loaded 0 plugins (1 already loaded)

-------------------Next Entry-------------------

Error parsing BotProfile.db - unknown attribute 'Rank' Error parsing BotProfile.db - unknown attribute 'Rank' Error parsing BotProfile.db - unknown attribute 'Rank' Error parsing BotProfile.db - unknown attribute 'Rank' Error parsing BotProfile.db - unknown attribute 'Rank' Error parsing BotProfile.db - unknown attribute 'Rank' Initializing Steam libraries for secure Internet server Logging into Steam gameserver account with logon token '066877B4xxxxxxxxxxxxxxxxxxxxxxxx' L 11/06/2017 - 15:48:07: "GOTV<2><>" connected, address "" PutClientInServer: no info_player_start on level L 11/06/2017 - 15:48:07: "GOTV<2><>" entered the game GOTV[0] broadcast active. Connection to Steam servers successful. Public IP is 216.52.25.160. Assigned persistent gameserver Steam ID [G:1:1635027]. VAC secure mode is activated. GC Connection established for server version 598, instance idx 1 Host state 5 at Mon Nov 6 15:59:20 2017 -- SIGTERM received, forcing immediate shutdown. L 11/06/2017 - 15:59:20: [META] Loaded 0 plugins (1 already loaded)

-------------------Next Entry-------------------

L 11/06/2017 - 17:14:05: "Wyatt<16>" disconnected (reason "Kicked by Console") L 11/06/2017 - 17:14:05: "Wyatt<16>" switched from team to L 11/06/2017 - 17:14:05: "Paul<19>" disconnected (reason "Kicked by Console") L 11/06/2017 - 17:14:05: "Paul<19>" switched from team to L 11/06/2017 - 17:14:05: "Doug<18>" disconnected (reason "Kicked by Console") L 11/06/2017 - 17:14:05: "Doug<18>" triggered "Dropped_The_Bomb" L 11/06/2017 - 17:14:05: "Doug<18>" switched from team to L 11/06/2017 - 17:14:05: "Calvin<20>" disconnected (reason "Kicked by Console") L 11/06/2017 - 17:14:05: "Calvin<20>" switched from team to L 11/06/2017 - 17:14:05: "Brandon<21>" disconnected (reason "Kicked by Console") L 11/06/2017 - 17:14:05: "Brandon<21>" switched from team to L 11/06/2017 - 17:14:05: "Irving<23>" disconnected (reason "Kicked by Console") L 11/06/2017 - 17:14:05: "Irving<23>" switched from team to L 11/06/2017 - 17:14:05: "Grant<22>" disconnected (reason "Kicked by Console") L 11/06/2017 - 17:14:05: "Grant<22>" switched from team to Game will not start until both teams have players. -> Reservation cookie 0: reason reserved(yes), clients(no), reservationexpires(0.00) Server is hibernating L 11/06/2017 - 17:14:10: "GOTV<13>" disconnected (reason "Punting bot, server is hibernating") Game will not start until both teams have players.

-------------------Next Entry-------------------

L 11/06/2017 - 23:32:13: "Harold<5>" disconnected (reason "Kicked by Console") L 11/06/2017 - 23:32:13: "Harold<5>" switched from team to L 11/06/2017 - 23:32:13: "Brandon<7>" disconnected (reason "Kicked by Console") L 11/06/2017 - 23:32:13: "Brandon<7>" switched from team to L 11/06/2017 - 23:32:13: "Duffy<10>" disconnected (reason "Kicked by Console") L 11/06/2017 - 23:32:13: "Duffy<10>" switched from team to L 11/06/2017 - 23:32:13: "Ron<8>" disconnected (reason "Kicked by Console") L 11/06/2017 - 23:32:13: "Ron<8>" switched from team to L 11/06/2017 - 23:32:13: "Andy<12>" disconnected (reason "Kicked by Console") L 11/06/2017 - 23:32:13: "Andy<12>" switched from team to L 11/06/2017 - 23:32:13: "Jon<11>" disconnected (reason "Kicked by Console") L 11/06/2017 - 23:32:13: "Jon<11>" switched from team to Game will not start until both teams have players. -> Reservation cookie 0: reason reserved(yes), clients(no), reservationexpires(0.00) Server is hibernating L 11/06/2017 - 23:32:18: "GOTV<2>" disconnected (reason "Punting bot, server is hibernating") Game will not start until both teams have players. Host state 5 at Tue Nov 7 09:35:32 2017 -- SIGTERM received, forcing immediate shutdown. L 11/07/2017 - 09:35:32: [META] Loaded 0 plugins (1 already loaded)

-------------------Next Entry-------------------

Error parsing BotProfile.db - unknown attribute 'Rank' Error parsing BotProfile.db - unknown attribute 'Rank' Error parsing BotProfile.db - unknown attribute 'Rank' Error parsing BotProfile.db - unknown attribute 'Rank' L 11/07/2017 - 10:48:12: "GOTV<85><>" connected, address "" PutClientInServer: no info_player_start on level L 11/07/2017 - 10:48:12: "GOTV<85><>" entered the game L 11/07/2017 - 10:48:12: "Daedious<86><>" connected, address "" Client "Daedious" connected (97.102.171.146:27005). L 11/07/2017 - 10:48:12: World triggered "Round_Start" GOTV[0] broadcast active. L 11/07/2017 - 10:48:13: "Daedious<86><>" STEAM USERID validated L 11/07/2017 - 10:48:15: "Daedious<86><>" disconnected (reason "Disconnect") Dropped Daedious from server: Disconnect L 11/07/2017 - 10:48:17: server_cvar: "sm_nextmap" "cs_office" L 11/07/2017 - 10:48:17: [randomcycle.smx] RandomCycle has chosen cs_office for the nextmap. -> Reservation cookie 0: reason reserved(yes), clients(no), reservationexpires(0.00) Server is hibernating L 11/07/2017 - 10:48:20: "GOTV<85>" disconnected (reason "Punting bot, server is hibernating") Game will not start until both teams have players. `

[carbonemt]

but thats probably not what you're looking for

[APet74]

That is your game server crash log, we are looking for the web server error_log. Usually, it is in the working directory of the file that crashed, so check your public_html/stats/ folder for an error_log and also check folders like Control or Views and make sure you don't see one.

[carbonemt]

ohh. Im sorry bout that. I can not find an error log.

[APet74]

is there a config.php that is made?

[carbonemt]

yes. The stats worked before, except that it wasnt being imported. Once I change the //port to port, thats when I got the 500 error on the website

[APet74]

Check the config and make sure that all the database connections look correct. There should be some different connection strings.

[carbonemt]

I checked them. they all look good. Im going to re-install and try that.

[APet74]

Ok, also if your mySQL is not on default port add it in by using the following convention. mysql:host=localhost;port=3307;dbname=testdb, basically just add a ;port=####; in the config.php

[carbonemt]

reinstall didnt work and port didnt either. this is interesting.

[APet74]

Is your SQL server on the same host as your website. There is a chance that communication between the two is blocked when it was working earlier, did any of the data from the databases show up? Like your servers, you entered?

[carbonemt]

Ya the database received the rankme table and I am inside of it. the website is on the same server as the database. Its using cpanel so I am using localhost.

[APet74]

That sounds good and correct. What is your PHP version?

[carbonemt]

PHP7

[APet74]

can you add a file called phpVersion.php and inside just add

<?php phpinfo(); ?>

[carbonemt]

done

[APet74]

Ahh.... See how that errors out too? I believe this may be a permissions error.

[carbonemt]

I still see the 500 error.

[carbonemt]

ohhhh I see what you mean.

[APet74]

Does your permissions look the the following: Picture

Base folder should be 0755

[carbonemt]

BOOOM fixed! Permission was set to 777. changing it to 755 worked.

Thanks for you help!!!

[APet74]

Very good, glad to be of assistance, let us know if there is anything ever that can be done to improve it. We're always happy to help.