Hello I am trying to set up the Epidemic gamemode that was released here on Facepunch about 5 days ago. I have a MySQL connection established and everything is installed correctly. I imported the .sql file correctly too. However, it appears one thing keeps preventing characters and other data from being properly saved. The issue is that there isn't a "default value for Flags". I am not sure where to find or how to create a default value for MySQL to recognize. I was hoping someone here could help me out with this. My SCRDS console log is found below. If you would like a copy of the gamemode to look at, just go to the 'Gamemodes Addons and Releases' section. Thanks in advanced!
[CODE]
Console initialized.
ConVarRef mat_dxlevel doesn't point to an existing ConVar
Game.dll loaded for "Garry's Mod"
Initializing Steam libraries for Workshop..
WS: No +host_workshop_collection or it is invalid!
Adding Filesystem Addon 'c:\users\anthony\desktop\gmodserver\garrysmod\addons\ulib-master'
Adding Filesystem Addon 'c:\users\anthony\desktop\gmodserver\garrysmod\addons\ulx-master'
Changing gamemode to Epidemic (epidemic)
Unknown command "sv_defaultgamemode"
Network: IP 192.138.1.131, mode MP, dedicated Yes, ports 27015 SV / 27005 CL
Error loading cfg/trusted_keys_base.txt
Error loading cfg/pure_server_minimal.txt
PREP OK
///////////////////////////////
// Ulysses Library //
///////////////////////////////
// Loading... //
// shared/defines.lua //
// shared/misc.lua //
// shared/util.lua //
// shared/hook.lua //
// shared/table.lua //
// shared/player.lua //
// server/player.lua //
// shared/messages.lua //
// shared/commands.lua //
// server/concommand.lua //
// server/util.lua //
// shared/sh_ucl.lua //
// server/ucl.lua //
// server/phys.lua //
// server/player_ext.lua //
// server/entity_ext.lua //
// shared/plugin.lua //
// shared/cami_global.lua //
// shared/cami_ulib.lua //
// Load Complete! //
///////////////////////////////
[ULIB] Loading SHARED module: ulx_init.lua
///////////////////////////////
// ULX Admin Mod //
///////////////////////////////
// Loading... //
// sh_defines.lua //
// lib.lua //
// base.lua //
// sh_base.lua //
// log.lua //
// MODULE: slots.lua //
// MODULE: uteam.lua //
// MODULE: votemap.lua //
// MODULE: xgui_server.lua //
///////////////////////////////
// ULX GUI -- by Stickly Man //
///////////////////////////////
// Adding Main Modules.. //
// bans.lua //
// commands.lua //
// groups.lua //
// maps.lua //
// settings.lua //
// Adding Setting Modules.. //
// cl_apromote.lua //
// client.lua //
// server.lua //
// Adding Gamemode Modules.. //
// sandbox.lua //
// Loading Server Modules.. //
WARNING: Missing dependancy UTime/ULX/ULib APromote is now inactive.
// sv_apromote.lua //
// sv_bans.lua //
// sv_groups.lua //
// sv_maps.lua //
// sv_sandbox.lua //
// sv_settings.lua //
// XGUI modules added! //
///////////////////////////////
// MODULE: chat.lua //
// MODULE: fun.lua //
// MODULE: menus.lua //
// MODULE: rcon.lua //
// MODULE: teleport.lua //
// MODULE: user.lua //
// MODULE: userhelp.lua //
// MODULE: util.lua //
// MODULE: vote.lua //
// end.lua //
// Load Complete! //
///////////////////////////////
game.ConsoleCommand blocked! (exec)
game.ConsoleCommand blocked! (exec)
HTTP failed - ISteamHTTP isn't available!
Executing dedicated server config file server.cfg
Using map cycle file cfg/mapcycle.txt.
Nav File is wrong or something (4)
Initializing Steam libraries for secure Internet server
No account token specified; logging into anonymous game server account. (Use sv_setsteamaccount to login to a persistent account.)
Unknown command "sbox_plpldamage"
Unknown command "sbox_maxspawners"
Unknown command "sbox_maxturrets"
=== MYSQL CONNECTION ESTABLISHED ===
Invalid command entered. If you need help, please type "ulx help" in your console.
Invalid command entered. If you need help, please type "ulx help" in your console.
Invalid command entered. If you need help, please type "ulx help" in your console.
Writing cfg/banned_user.cfg.
Connection to Steam servers successful.
Public IP is 11.111.111.111.
Assigned anonymous gameserver Steam ID [A-1:2785089542(8591)].
VAC secure mode is activated.
Client "EFEX03" connected (192.138.1.131:27006).
SELECT * FROM epi_users WHERE SteamID = 'STEAM_0:0:40104176'
SUCC
INSERT INTO epi_users (SteamName, SteamID, IP, Date) VALUES ('EFEX03', 'STEAM_0:0:40104176', '192.138.1.131:27006', 'May-24-2017')
================================
MySQL Error: Field 'Flags' doesn't have a default value
!!!!!!!!!!!!!!!!!!!!!!
INSERT INTO epi_users (SteamName, SteamID, IP, Date) VALUES ('EFEX03', 'STEAM_0:0:40104176', '192.138.1.131:27006', 'May-24-2017')
================================!
SELECT id, Name FROM epi_characters WHERE SteamID = 'STEAM_0:0:40104176'
SUCC
SELECT id, Name FROM epi_characters WHERE SteamID = 'STEAM_0:0:40104176' AND id != 0
SUCC
SELECT id, Name FROM epi_characters WHERE SteamID = 'STEAM_0:0:40104176'
SUCC
1 = Survivor
2 = Antoniosasdasdasd
3 = 25
4 = dfgdfgdfgdfgdfgdfgdfgdfgdfg
5 = models/humans/modern/male_01_01.mdl
SELECT * FROM epi_characters WHERE Name = 'Antoniosasdasdasd' AND SteamID = 'STEAM_0:0:40104176'
SUCC
SELECT * FROM epi_characters WHERE Name = 'Antoniosasdasdasd' AND SteamID = 'STEAM_0:0:40104176'
SUCC
SELECT * FROM epi_characters WHERE Name = 'Antoniosasdasdasd' AND SteamID = 'STEAM_0:0:40104176'
SUCC
INSERT INTO epi_characters (SteamID, Class, Name, Age, PhysDesc, OriMdl) VALUES ('STEAM_0:0:40104176', 'Survivor', 'Antoniosasdasdasd', '25', 'dfgdfgdfgdfgdfgdfgdfgdfgdfg', 'models/humans/modern/male_01_01.mdl')
================================
MySQL Error: Field 'CharFlags' doesn't have a default value
!!!!!!!!!!!!!!!!!!!!!!
INSERT INTO epi_characters (SteamID, Class, Name, Age, PhysDesc, OriMdl) VALUES ('STEAM_0:0:40104176', 'Survivor', 'Antoniosasdasdasd', '25', 'dfgdfgdfgdfgdfgdfgdfgdfgdfg', 'models/humans/modern/male_01_01.mdl')
================================!
SELECT id FROM epi_characters WHERE Name = 'Antoniosasdasdasd' AND SteamID = 'STEAM_0:0:40104176'
SUCC
EFEX03 created ent weapon_m9lam
ServerLog: [ULX] EFEX03 created ent weapon_m9lam
[/CODE]
P.S: I just replaced my IP with 1s
are you using MySQLOO or tmysql4???
[sp] stupid things can probably be the answer to the problems... [/sp]
This should become with a sql file that you can run in your sql client to create tables
IIRC you can't create a table in the runtime, in case you don't have the databases, you should try to understand how it works and then create your own database
[QUOTE=Yoke;52271327]are you using MySQLOO or tmysql4???
[sp] stupid things can probably be the answer to the problems... [/sp][/QUOTE]
MySQL is the same with both, so it shouldn't matter
[QUOTE=gonzalolog;52271550]This should become with a sql file that you can run in your sql client to create tables
IIRC you can't create a table in the runtime, in case you don't have the databases, you should try to understand how it works and then create your own database[/QUOTE]
You can create and alter tables during runtime. Also considering the error is talking specifically about a column not having a default value, it sounds like it's an outdated database/sql file.
I'd suggest posting this in the thread about the gamemode.
I do have a MySQL server set up and a database that functions with the gamemode. I use the program Navicat to explore it. I successfully imported the sql file that came with the gamemode and 'CharFlags' is certainly a field in there. Therefore, it leads me to believe there isn't a default value set in the sql file itself that I imported. I am also using Mysqloo.
I don't know how the gamemode is handling that field (CharFlags), anyway try this:
- Go to navicat and open the database.
- Select the "epi_characters" table and modify it.
- Allow "NULL" values at "CharFlags" field.
Here you have an example using HeidiSQL:
(As you can see I have 11 fields from "id" to "is_admin" on my "account" table, you should do that only on "CharFlags" field at "epi_characters" table)
[IMG]http://i.imgur.com/zqFdcf9.png[/IMG]
Sorry, you need to Log In to post a reply to this thread.
