MuADMINS
Rozwiązania
Krótkie poprawki częstych problemów z serwerem, klientem i stroną MU Online, każda ze źródłem i datą. “Potwierdzone” oznacza, że osoba, która pytała, potwierdziła, że poprawka zadziałała.
1 rozwiązanie dla “ssms” w kategorii Strona WWW · Wyczyść
WebEngine CMS install keeps saying 'Could not connect to database (1)' with SQL Server 2008 and XAMPP (PDO ODBC), even though SSMS connects fine.
1. The thread found a conflict between SQL Server 2008 and WebEngine's connection. 2. Install a newer SQL Server (2012 worked for the topic starter; another user had 2019 working). 3. Res...
✓ Potwierdzone przez autora tematuRaGEZONE · 2023-10-06
Więcej odpowiedzi dla „ssms”
1 w: Strona WWW, 7 w innych kategoriach i plikach serwera:
I cannot delete a MU database in SQL Server Management Studio, it gives an error because it is in use. How do I remove it?
1. Stop DataServer, JoinServer, the editors and the web that use the database. 2. In Management Studio right click the database > Delete. 3. In the Delete Object window tick Close existin...
✓ Potwierdzone przez autora tematuTuServerMU · 2018-01-06SQL Server Management Studio shows "Value cannot be null. Parameter name: viewInfo" when opening Databases on the MU server. What causes it?
1. Check the free space on the drive where Windows, SQL Server and its temp folder live. 2. In this case the disk was full. 3. Free space: clear temp folders, old server logs and old back...
✓ Potwierdzone przez autora tematuTuServerMU · 2019-06-19New characters show 65535 kills and deaths.
1. Fix existing ones: UPDATE dbo.Character SET Kills=0 WHERE Kills=65535 and the same for Deads. 2. In SSMS design the Character table and set the Default Value of Kills and Deads to 0. 3...
✓ Potwierdzone przez autora tematuCreandoMU · 2020-08-20How do I give GoblinPoints each time a character resets (Season 6 MuEmu)?
1. In SSMS edit the procedure WZ_SetResetInfo. 2. Below the line that starts with UPDATE Character add UPDATE CashShopData SET GoblinPoint=GoblinPoint+100 WHERE AccountID=@Account. 3. Exe...
✓ Potwierdzone przez autora tematuCreandoMU · 2021-01-21The website always shows 2 players online even when the server is off
Stale rows in MEMB_STAT still say the accounts are connected. 1. Open Query Analyzer / SSMS on the MuOnline database. 2. Run UPDATE MEMB_STAT SET ConnectStat='0' WHERE ConnectStat>0. 3. R...
✓ Potwierdzone przez autora tematuDarksTeam · 2009-03-03SQL command to give credits to every account (DarksTeam 97d+99i)
1. Open SSMS / Query Analyzer on the MuOnline database. 2. For all accounts run UPDATE MEMB_CREDITS SET credits=credits+500. 3. For one account run UPDATE MEMB_CREDITS SET credits=credits...
✓ Potwierdzone przez autora tematuDarksTeam · 2021-12-28IGCN Season 13 files: how to give new characters a starting amount of zen.
1. In SSMS run on MuOnline a query that creates an INSERT trigger on dbo.Character (named Bonus in the thread). 2. The trigger reads the new Name from INSERTED and runs UPDATE Character S...
✓ Potwierdzone przez autora tematuTuServerMU · 2018-10-15



