Open WangShuXian6 opened 1 year ago
Nothing here?, i got the same problem :D, want to revive this, :D
Error Code: 1067. Invalid default value for 'DateRead' 0.000 sec
It looks like SQL server is newer than one which was used when dumping. You have to fix SQLs by hand
Strict mode prevents SQL file to import. Execute SQL as such to disable it.
SET GLOBAL sql_mode = '';
DatabaseManager: error Server failed to connect to the database server
The Saga server is misconfigured or SQL server is not running.
You was rite i downgrade to 5.7 mysql now is working, but now i have something new,
############################################################################# Saga Authtentication Server starting on: 9/30/2024 10:23:24 AM OS Information: Microsoft Windows NT 6.2.9200.0 Number of Processors: 12 CLR Version: 2.0.50727.9179 Working set: 22118400 OS Bit Version: 64 Bit ############################################################################# Calling initialize-event on factories & managers: verbose HostContext Calling beforequery-event on factories & managers: verbose HostContext Calling afterquery-event on factories & managers: verbose HostContext Calling onload-event on factories & managers: verbose HostContext database: ïnfo Populating database pool with connections Calling loaded-event on factories & managers: verbose HostContext "Saga.Authentication.exe",Information,0,"Client create starting timeout session",,,,,,, Network: Connection accepted from: 127.0.0.1:53518 "Saga.Authentication.exe",Error,0,"Session was not found: 0",,,,,,, Network: Connection accepted from: 127.0.0.1:53523 Database: error The given key was not present in the dictionary. ############################################################################# A unhandeld exception was thrown CLR is terminating
System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.
at Saga.Authentication.Data.Mysql.MysqlProvider.GetWorldInformation()
at Saga.Authentication.Data.Mysql.MysqlProvider.Saga.Authentication.Utils.Definitions.Misc.IDatabase.GetWorldInformation()
at Saga.Managers.Database.GetWorldInformation() in d:\saga-revised-master\Saga.Authentication\Managers\Managers.Database.cs:line 128
at Saga.Authentication.ServerManager2..ctor() in d:\saga-revised-master\Saga.Authentication\ServerManager.cs:line 27
at Saga.Authentication.ServerManager2.get_Instance() in d:\saga-revised-master\Saga.Authentication\ServerManager.cs:line 20
at Saga.Map.Client.InternalClient.CM_WORLDINSTANCE(CMSG_WORLDINSTANCE cpkt) in d:\saga-revised-master\Saga.Authentication\Network\InternalClient\InternalClient Characters.cs:line 240
at Saga.Map.Client.InternalClient.ProcessPacket(Byte[]& body) in d:\saga-revised-master\Saga.Authentication\Network\InternalClient\InternalClient-Core.cs:line 70
at Saga.Shared.NetworkCore.Client.<>cDisplayClass2.
System.NullReferenceException: Object reference not set to an instance of an object.
at Saga.Map.Client.InternalClient.CM_WORLDINSTANCE(CMSG_WORLDINSTANCE cpkt) in d:\saga-revised-master\Saga.Authentication\Network\InternalClient\InternalClient Characters.cs:line 276
at Saga.Map.Client.InternalClient.ProcessPacket(Byte[]& body) in d:\saga-revised-master\Saga.Authentication\Network\InternalClient\InternalClient-Core.cs:line 70
at Saga.Shared.NetworkCore.Client.<>cDisplayClass2.
I check the proof is ok, i dont know where look at now, this cause the auth crash and its new never happened before for me.
try this:
INSERT INTO `list_worlds` (`Id`, `Name`, `Proof`) VALUES (1, '"'"'SAGA'"'"', '"'"'E10ADC3949BA59ABBE56E057F20F883E'"'"');
I managed to get server working at old Ubuntu 16.04, but now it's something wrong with client (maybe nvidia drivers/ direct x / wine version) - characters and mobs aren't visible.
If You make it work let us know to login and test it for like 3 to 5 years ok ?
El mié., 2 de oct. de 2024 2:34 p. m., Dmitry @.***> escribió:
try this:
INSERT INTO
list_worlds
(Id
,Name
,Proof
) VALUES (1, '"'"'SAGA'"'"', '"'"'E10ADC3949BA59ABBE56E057F20F883E'"'"');I managed to get server working at old Ubuntu 16.04, but now it's something wrong with client (maybe nvidia drivers/ direct x / wine version)
- characters and mobs aren't visible. Screenshot.from.2024-10-02.23-07-18.png (view on web) https://github.com/user-attachments/assets/05595d14-fcaa-4c10-a40b-48e5fc41775f Screenshot.from.2024-10-02.23-07-29.png (view on web) https://github.com/user-attachments/assets/9cefaff1-84d7-473e-aa70-6916dd4af8b4 Screenshot.from.2024-10-02.23-27-47.png (view on web) https://github.com/user-attachments/assets/b1bcd167-7398-493f-a3a2-40cbc8ae2ade
— Reply to this email directly, view it on GitHub https://github.com/JulienGrv/saga-revised/issues/36#issuecomment-2389647640, or unsubscribe https://github.com/notifications/unsubscribe-auth/ACMZVBUPW5JU2JPIIPS36XDZZRKEFAVCNFSM6AAAAABPCKCEY6VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDGOBZGY2DONRUGA . You are receiving this because you are subscribed to this thread.Message ID: @.***>
try this:
INSERT INTO `list_worlds` (`Id`, `Name`, `Proof`) VALUES (1, '"'"'SAGA'"'"', '"'"'E10ADC3949BA59ABBE56E057F20F883E'"'"');
I managed to get server working at old Ubuntu 16.04, but now it's something wrong with client (maybe nvidia drivers/ direct x / wine version) - characters and mobs aren't visible. !
Nothing, @loentar can we chat? i want to revive it and want to host the server too lets set it up, warcold @ g m a i l . c o m.
@warcold if you want to revive it you have to have some knowledge on C#, because to get it running on newer OS the project needs for upgrade. Also, even if you get server running, there are lots of bugs and non-implemented cases which should be fixed before you go public. As far I remember, there were issues like: wrong enemy facing, no exp points in party, many of skills aren't working as expected, some mobs are underwater or underground, ship to Prontera doesn't work, missing wrap points as well as missing entrance to Prontera dungeon, errors in quests, missing auction implementation and many other unimplemented things.
If I have time, I'll try to upgrade to newer .NET/mono in my fork, but other things may be too complicated.
P.S.: You can write me to the gmail.com or Telegram. login is the same as here
windows 11 x64
版本 Windows 11 企业版 版本 22H2 安装日期 2023/4/27 操作系统版本 22621.1992 体验 Windows Feature Experience Pack 1000.22644.1000.0
mysql version
D:\project\RO2\saga-revised\Database\Mysql\list_maildata.sql
19:59:59 CREATE TABLE IF NOT EXISTS
list_maildata
(MailId
int(10) unsigned NOT NULL AUTO_INCREMENT,Sender
varchar(32) NOT NULL,Receiptent
varchar(32) NOT NULL,Date
datetime NOT NULL,IsRead
tinyint(1) unsigned NOT NULL DEFAULT '0',IsChecked
tinyint(1) unsigned NOT NULL DEFAULT '0',Topic
varchar(128) DEFAULT NULL,Message
text,Attachment
tinyblob,Zeny
int(10) unsigned NOT NULL DEFAULT '0',DateRead
datetime DEFAULT '0000-00-00 00:00:00',IsOutbox
tinyint(3) unsigned NOT NULL DEFAULT '1',IsInbox
tinyint(3) unsigned NOT NULL DEFAULT '0',IsPending
tinyint(3) unsigned NOT NULL DEFAULT '1', PRIMARY KEY (MailId
), KEYSender
(Sender
), KEYReciever
(Receiptent
) ) Error Code: 1067. Invalid default value for 'DateRead' 0.000 secSaga.Authentication.log.csv
Saga.Gateway.log.csv
Saga.Map.log.csv