[Help Thread] Please post your questions here.

10/04/2017 18:00 thefear511#6511
Hi guys i need help x.x

[Only registered and activated users can see links. Click Here To Register...]
this happened after I edited a couple of NPCS in Npcresource, i edited only periodic tables :)

can anyone please help me ?
10/04/2017 18:35 ThunderNikk#6512
Did you check your server services?
10/04/2017 18:47 thefear511#6513
Quote:
Originally Posted by ThunderNikk View Post
Did you check your server services?
me ? no where can i find those ? knowing that server was running perfectly fine before i edited NPCresource
10/04/2017 21:50 ThunderNikk#6514
MSSQL configuration manager

Services
10/05/2017 02:18 thefear511#6515
Quote:
Originally Posted by ThunderNikk View Post
MSSQL configuration manager

Services
hey I justed reinstalled MySQL cuz I fucked up my username and it worked. thx anyways ^^ I hope people benefit from this solution in future, cuz I did some googling before and saw a lot of people have it but no correct solution.
10/05/2017 02:45 ThunderNikk#6516
Well reinstalling MSSQL is the long way around a user name but if you think it helps to report that here as a solution then thank you at least for the reply on what you did.

But how did just an NPC resource edit have anything to do with your user name?
10/05/2017 03:50 thefear511#6517
Quote:
Originally Posted by ThunderNikk View Post
Well reinstalling MSSQL is the long way around a user name but if you think it helps to report that here as a solution then thank you at least for the reply on what you did.

But how did just an NPC resource edit have anything to do with your user name?
well, last 2 things I did were editing that table and messing around with sysadmin properties.

was all good even after I messed around with sysadmin and permissions, so I didn't think its the reason, well just reinstalled SQL instead of digging more deep took like 20minutes xD x.x
10/05/2017 14:01 Charliefoxtrott#6518
What is the SQL-table for the altar of the goddess in database? And/Or what lua/sp is used? (Both for items only.)
10/06/2017 02:51 thefear511#6519
Quote:
Originally Posted by ThunderNikk View Post
MSSQL configuration manager

Services
Hey again , damn i got this issue again after i changed my sa password
And i dont want to reinstall mysql cuz i have important data ☹
Could you please tell me what to do in the services ?

Quote:
Originally Posted by Charliefoxtrott View Post
What is the SQL-table for the altar of the goddess in database? And/Or what lua/sp is used? (Both for items only.)
Its a script in ect_functions
10/06/2017 03:31 ThunderNikk#6520
If you changed sa password in the database did you change in in your .opt files?

I believe there are 2 different password encryption tools for the .opt files depending on whether you are working with the 9.1 files or the older file releases.

Make sure you use the correct encryption tool.

This is probably not a down service issue but more likely an .opt file issue since you have changed the database user access. The .opt files need that same access change.
10/06/2017 03:48 thefear511#6521
Quote:
Originally Posted by ThunderNikk View Post
If you changed sa password in the database did you change in in your .opt files?

I believe there are 2 different password encryption tools for the .opt files depending on whether you are working with the 9.1 files or the older file releases.

Make sure you use the correct encryption tool.

This is probably not a down service issue but more likely an .opt file issue since you have changed the database user access. The .opt files need that same access change.
Hey im using 7.2 files , i used Des generator (encryptor) . I had couple of sucessful password changes that didnt break the auth but that was waay long back like 3 weeks
Does this look suspicious ?
[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]
10/06/2017 04:07 ThunderNikk#6522
Yeah start those 2 server services that are not running.
10/06/2017 04:45 thefear511#6523
Quote:
Originally Posted by ThunderNikk View Post
Yeah start those 2 server services that are not running.
[Only registered and activated users can see links. Click Here To Register...]

I think auth was running with them disabled no? Is there a rappelz related topic i can take instructions from to how i can activate them ? Microsoft puts al lot of junk into their topics 💔🐌
10/06/2017 05:02 ThunderNikk#6524
have you tried restarting our computer?
10/06/2017 14:17 thefear511#6525
Quote:
Originally Posted by ThunderNikk View Post
have you tried restarting our computer?
https://imgur.com/UZsgCri
I did , and also i did compress auth opt and gameserver opt after every edit .

As you can see now the error message changed after i changed Pc language.