Thread: HeidiSQL help
View Single Post
  #1  
Old 06-12-2010, 03:01 PM
Mentole
Sarnak
 
Join Date: Jun 2010
Posts: 41
Default HeidiSQL help

Well trying this guide http://www.eqemulator.net/wiki/wikka.php?wakka=ValesEQ but I am having trouble with this part:


"11) Setting up the world server. Here's the sql file to make the world server entry.
INSERT INTO `tblworldserverregistration` (`ServerID`, `ServerLongName`, `ServerTagDescription`, `ServerShortName`, `ServerListTypeID`, `ServerLastLoginDate`, `ServerLastIPAddr`, `ServerAdminID`, `Note`) VALUES ('1', 'NameOfServer', 'ServerTagDescription', 'ShortNameOfServer', '2', NULL, NULL, '1', NULL);


Edit after VALUES, the following:
NameOfServer is the actual name of the server.
ShortNameOfServer is the shortname for client files in your game directory (i.e. UI_Soandso_ShortNameOfServer.ini).
ServerTagDescription is what you will see in parenthesis after the server's name - i.e. NameOfServer(Come and have fun!)
The number 2 signifies what kind of server it is. 1 = Legends, 2 = Preferred, 3 = Standard. "

Everytime I try to install it to HeidiSQL I get this error

"SQL Error (1364): Field 'ServerTrusted' doesn't have a default value"

Can anyone help me with this please? Not even sure if I am doing it right this part of the guide is real vague on these instructions.
Reply With Quote