I really want to setup a surf server on gmod, I am using steamcmd to set it up but everytime I join I get this error "Disconnect: The server can't load essential data! If you can, contact an admin to make him identify the issue: Missing SQLite tables (gmod_admins and gmod_bans) on No MySQL setup! (Use the correct sv.db or SQL queries)." Anyone know how to fix this? I don't really know how to use MySQL with steamcmd
u need to setup sql
Congratulations, thats not helpful. If he needs to setup sql then what should he do? Throw some links to tutorials or helpful resources out there so he can fix it and anyone who googles the question can fix it also
[QUOTE=Exho;48470646]Congratulations, thats not helpful. If he needs to setup sql then what should he do? Throw some links to tutorials or helpful resources out there so he can fix it and anyone who googles the question can fix it also[/QUOTE]
why dont u
Without knowing which gamemode you have it'll be pretty difficult to guide you through a setup. Is the gamemode that you have open source/free?
[QUOTE=tyguy;48470847]why dont u[/QUOTE]
I know nothing about SQL in Garry's Mod so I would've given information if I had it, I was telling you to give it because you attempted to try to answer his question. Don't be a complete moron please
[QUOTE=Exho;48472012]I know nothing about SQL in Garry's Mod so I would've given information if I had it, I was telling you to give it because you attempted to try to answer his question. Don't be a complete moron please[/QUOTE]
I simply tried to give as much information as I could to help him. I didn't know anything about the issue but I wanted to try (and clearly fail) to be a bit helpful.
Anyway, try loading the mysql file if it came with the gamemode (it probably did)
[QUOTE=Adzter;48471046]Without knowing which gamemode you have it'll be pretty difficult to guide you through a setup. Is the gamemode that you have open source/free?[/QUOTE]
Its free, heres the link [url]http://facepunch.com/showthread.php?t=1448806[/url] I looked at the tutorials but they were all about bhop, not surf
[QUOTE=RussiaMan420;48472864]Its free, heres the link [url]http://facepunch.com/showthread.php?t=1448806[/url] I looked at the tutorials but they were all about bhop, not surf[/QUOTE]
Did the gamemode come with a .db file?
I checked the gamemode out it seems it requires a little bit of setting up, check out the README.txt at:
Release_v1.05.zip\Gamemodes\Flow Network - All gamemodes\Flow Network - Skill Surf\README.txt
If you've already setup the lua files then it simply requires you to copy the sv.db file that's provided:
[quote]
I think that's about it. Make sure the sv.db database is prepared with the content in the /Database folder included in this release
You can also use the provided sv.db (rename it, though). There is a clean version and a populated one, but this already has around 9k saved times. It doesn't have the bot files of those times, since they're pretty big.
[/quote]
So go to the following folder inside the Flow download:
Release_v1.05.zip\Gamemodes\Flow Network - All gamemodes\Flow Network - Skill Surf\Database\SQLite
And copy "sv (for clean no MySQL server).db" into your server's main garrysmod folder, renaming it to just "sv.db". The folder that has the addons, cfg, materials, models, etc. There should already be one there but remember to back yours up, you'll lose certain data like pointshop, etc.
EDIT: Oh and missed this part:
[quote]
If you don't own a MySQL database and just want a single server with local bans etc, go to core_data.lua and set SQL.Use on line 2 to false
[/quote]
EDIT2: Bear in mind this is only if you want to locally save all your data, if you're wanting to use a MySQL database I'd carefully read through the README.txt, I just explained the simplest way to get it up and running.
[QUOTE=Adzter;48472974]I checked the gamemode out it seems it requires a little bit of setting up, check out the README.txt at:
Release_v1.05.zip\Gamemodes\Flow Network - All gamemodes\Flow Network - Skill Surf\README.txt
If you've already setup the lua files then it simply requires you to copy the sv.db file that's provided:
So go to the following folder inside the Flow download:
Release_v1.05.zip\Gamemodes\Flow Network - All gamemodes\Flow Network - Skill Surf\Database\SQLite
And copy "sv (for clean no MySQL server).db" into your server's main garrysmod folder, renaming it to just "sv.db". The folder that has the addons, cfg, materials, models, etc. There should already be one there but remember to back yours up, you'll lose certain data like pointshop, etc.
EDIT: Oh and missed this part:
EDIT2: Bear in mind this is only if you want to locally save all your data, if you're wanting to use a MySQL database I'd carefully read through the README.txt, I just explained the simplest way to get it up and running.[/QUOTE]
Ok I got all that set up but where do I put Structure and essential data (For No MySQL).sql?
[QUOTE=RussiaMan420;48473657]Ok I got all that set up but where do I put Structure and essential data (For No MySQL).sql?[/QUOTE]
Someone can correct me if I'm wrong but I think that's just for if you want to import it in to your current sv.db, does everything work correctly at the moment with what you've setup?
[QUOTE=Adzter;48473725]Someone can correct me if I'm wrong but I think that's just for if you want to import it in to your current sv.db, does everything work correctly at the moment with what you've setup?[/QUOTE]
The maps aren't setup properly with !rtv and how do you set zones to end and spawn in?
[editline]17th August 2015[/editline]
Also how do I setup bots and change the jumppack
[QUOTE=RussiaMan420;48476066]The maps aren't setup properly with !rtv and how do you set zones to end and spawn in?
[editline]17th August 2015[/editline]
Also how do I setup bots and change the jumppack[/QUOTE]
Gravious' guide tells you EXACTLY what to do.
Instead of using the bhop folder, use the surf folder, and you're done.
Also to setup zones use !admin (That you will have access to if you set MySQL up correctly
You don't "set up" bots, you do !bot record and then if you get #1 the bot records, then !bot save to save it (It will also autosave when the map changes due to rtv/timer done, but NOT when you force change it through the admin panel)
And I have no idea wtf a jump pack is doing on a surf server...
Essential files are in release_v1.05(Or whatever the zip is called)\Essential Files
[QUOTE=JasonMan34;48476363]Gravious' guide tells you EXACTLY what to do.
Instead of using the bhop folder, use the surf folder, and you're done.
Also to setup zones use !admin (That you will have access to if you set MySQL up correctly
You don't "set up" bots, you do !bot record and then if you get #1 the bot records, then !bot save to save it (It will also autosave when the map changes due to rtv/timer done, but NOT when you force change it through the admin panel)
And I have no idea wtf a jump pack is doing on a surf server...
Essential files are in release_v1.05(Or whatever the zip is called)\Essential Files[/QUOTE]
!admin doenst work, and the jump pack is for easy surf, i want an option to disable it.
He made a youtube video JUST for the people that had problems setting it up.........
[QUOTE=RussiaMan420;48479671]!admin doenst work, and the jump pack is for easy surf, i want an option to disable it.[/QUOTE]
[QUOTE=JasonMan34;48476363]use !admin (That you will have access to [B]if you set MySQL up correctly[/B])
[/QUOTE]
sers
[B]Hello[/B]
Pls Help ME!
[IMG]http://www.bilder-upload.eu/upload/59fc6d-1461333667.png[/IMG]
[QUOTE=GuRux3.de;50180970][Generic guy that can't read previous comments][/QUOTE]
[B]*facepalm*[/B]
Ignoring the bump, I'll just quote what I said before:
[QUOTE=JasonMan34;48476363]Gravious' guide tells you EXACTLY what to do.
Instead of using the bhop folder, use the surf folder, and you're done.
Also to setup zones use !admin (That you will have access to if you set MySQL up correctly)
Essential files are in release_v1.05(Or whatever the zip is called)\Essential Files[/QUOTE]
Honestly, a fucking monkey could set up a server properly following his guide. I got super pissed because it was SO SLOW, it was like he was making the guide for people that don't even know what G-Mod is.
at a few maps , it is so sry my Englisch
surf_nostromo
[IMG]http://www.bilder-upload.eu/upload/d9513c-1461390771.png[/IMG]
map change
surf_utopia_njv
[IMG]http://www.bilder-upload.eu/upload/5e4f4b-1461390809.png[/IMG]
[QUOTE=JasonMan34;50181002][B]*facepalm*[/B]
Ignoring the bump, I'll just quote what I said before:
Honestly, a fucking monkey could set up a server properly following his guide. I got super pissed because it was SO SLOW, it was like he was making the guide for people that don't even know what G-Mod is.[/QUOTE]
[QUOTE=JasonMan34;50181002][B]*facepalm*[/B]
Ignoring the bump, I'll just quote what I said before:
Honestly, a fucking monkey could set up a server properly following his guide. I got super pissed because it was SO SLOW, it was like he was making the guide for people that don't even know what G-Mod is.[/QUOTE]
Going a little to far there, when you were new, I'm sure you had problems. This guy just signed up and doesn't know much english, give him a break.
But seriously, read the guide.
[QUOTE=Mikey Howell;50186207]Going a little to far there, when you were new, I'm sure you had problems. This guy just signed up and doesn't know much english, give him a break.
But seriously, read the guide.[/QUOTE]
I understand that some people might have it harder, and some of my first threads on this forum is in the Dev Discussion for things retardedly easy. However, I didn't have a complete video tutorial covering every single aspect of my problems to look at. Now if you follow everything he does EXACTLY (Not touching a single aspect not included in the video) - Then everything WILL work. However, if you skip any step or do anything that he doesn't speak about - something might not work, which is understandable. Since he literally just said "Pls Help ME!", I assume he either did something wrong (In which case he should go to the video, he'll get faster, better help than here) or he meddled with something and he didn't say it.
Sorry, you need to Log In to post a reply to this thread.