Community AlphaAlpha MUADMINS
TRTürkçe
Giriş yap
MuADMINS'teConfig ScannerDosyalarının zip'ini yükle: rate'ler, droplar, spotlar, limitlerAçMuADMINS'teDiscord'da buluşalımYardım iste, üzerinde çalıştığın şeyleri paylaş ve diğer sunucu sahipleriyle MU hakkında konuş.Aç

MuADMINS

Çözümler

Yaygın MU Online sunucu, client ve web sitesi sorunları için kısa düzeltmeler; her biri kaynağı ve tarihiyle. “Onaylanmış”, soruyu soran kişinin düzeltmenin işe yaradığını söylediği anlamına gelir.

184 çözüm “mssql no” için · Temizle

  1. Araçlar

    MuWeb 0.8 does not work with XAMPP on Windows 7 and SQL 2008 (php.ini edits do not help)

    1. MuWeb 0.8 needs an old PHP with the MSSQL functions: the newer XAMPP builds do not run it even after php.ini changes. 2. Install XAMPP 1.6.1 (not higher), configure php.ini as the MuWe...

    ✓ Konu sahibi tarafından onaylandıRaGEZONE · 2013-01-23
  2. Web sitesi

    Website registration says "Your Account Has Been Created Successfully" but nothing is saved in the database

    The fix given: add the MD5 extension to SQL Server and install the site with MD5 on. 1. Copy the MD5 dll for SQL Server (shared in the thread) into the MSSQL\Binn folder of SQL Server. 2....

    ✓ Konu sahibi tarafından onaylandıDarksTeam · 2008-11-28
  3. Web sitesi

    No MU website works on XAMPP (Windows 7 64-bit): SQL connection errors and php.ini extension errors although the extension is enabled

    1. Turn User Account Control (UAC) back on if you had disabled it. 2. Install XAMPP again (version 1.7.1, the one these old MSSQL based sites need). 3. Put the site back and test; the SQL...

    ✓ Konu sahibi tarafından onaylandıRaGEZONE · 2017-07-28
  4. Web sitesiS6

    MuCore install on a web host: after the serial number step, step_1 of the installer shows nothing (Season 6 repack)

    1. Open the MuCore configuration file that holds the database settings. 2. Find $core['connection_type'] = "MSSQL";. 3. Change the value to lower case: $core['connection_type'] = "mssql";...

    ✓ Konu sahibi tarafından onaylandıRaGEZONE · 2018-03-23
  5. Web sitesiany

    MuCore does not load on XAMPP 7.2.1.

    1. MuCore needs the old mssql PHP extension that newer XAMPP/PHP 7 no longer ships. 2. Use XAMPP 1.7.1 (old PHP with the mssql extension) for MuCore, or move to a CMS that supports PDO sq...

    ✓ Konu sahibi tarafından onaylandıTuServerMU · 2018-02-08
  6. Web sitesiany

    MuCore on XAMPP on the same VPS as SQL Server cannot connect to the database.

    1. Easiest: in the MuCore config.php change the connection type from MSSQL to ODBC. 2. Or open SQL Server Configuration Manager, enable TCP/IP and Named Pipes, and restart SQL Server. 3....

    ✓ Konu sahibi tarafından onaylandıTuServerMU · 2017-12-27
  7. AraçlarMuEmu / LouisSeason 6

    Cash Editor gives an error when editing credits, although the SQL user and password are set

    The cash table and column names in the editor config were wrong. 1. Open the editor config file (XTRMu in the thread). 2. [SQLConnection]: SQLHost = (local), SQLUser = your SQL user, SQLP...

    ✓ Konu sahibi tarafından onaylandıTUServerMU · 2020-07-10
  8. Sunucu kurulumu

    Replacing WZ_DISCONNECT_MEMB for MuCore gives 'Msg 468 ... Cannot resolve the collation conflict between Latin1_General_CS_AS and SQL_Latin1_General_CP1_CI_AS'

    1. The procedure compares memb___id from MEMB_INFO with memb___id from MEMB_STAT, and the two columns use different collations. 2. In SQL Server Management Studio set the same collation o...

    ✓ Konu sahibi tarafından onaylandıRaGEZONE · 2015-11-30
  9. Sunucu kurulumuIGCNS12

    IGCN Season 12: DataServer is not responding although TCP/IP is enabled in SQL Server

    1. Open DataServer.ini and check SQLServerName. 2. When SQL Server runs on the same machine use SQLServerName = (local) or the exact PC name as shown in SQL Server Management Studio (for...

    ✓ Konu sahibi tarafından onaylandıRaGEZONE · 2020-01-08
  10. Sunucu kurulumuMuEmu / LouisS4

    DataServer floods '[QueryManager] State (24000) ... [ODBC SQL Server Driver] Invalid' when a character gets PK status (MuEmu S4 with the Ferrarezi website)

    1. The cause was not ODBC: the Ferrarezi website adds a trigger Z_PK_HERO on dbo.Character that fires when PkCount changes, and its old version broke the DataServer queries. 2. In SQL Ser...

    ✓ Konu sahibi tarafından onaylandıRaGEZONE · 2018-04-09
  11. Web sitesiany

    WebEngine shows a PDOException with my SQL Server host, user and password on screen when the database is down. How do I hide it?

    1. The full stack trace is printed only because debug mode is turned on in your WebEngine configuration. 2. Turn debug mode off on the live site so visitors only see a generic error. 3. I...

    ✓ Sorun kaydında onaylandıGitHub (lautaroangelico/WebEngine) · 2017-08-10
  12. Sunucu kurulumuany

    After enabling TCP/IP in SQL Server for the web, DataServer, JoinServer and GameServerCS lost the database connection. How was it fixed?

    1. In SQL Server Configuration Manager keep Named Pipes and TCP/IP enabled for the instance. 2. Open the ODBC DSNs used by the server files. 3. Change the Server field from the LAN IP to...

    ✓ Konu sahibi tarafından onaylandıTuServerMU · 2020-05-23
  13. OynanışIGCNS12

    Lowering the stat limit from 65000 to 32000 with a SQL query on IGCN-based S12 files does not work in game.

    1. No SQL query is needed. 2. Edit MuServer/IGCData/IGC_PlayerInfo.xml and change the Max values per class (MaxStrenghtDW, MaxAgilityDW, MaxVitalityDW, MaxEnergyDW, MaxCommandDW and the s...

    ✓ Konu sahibi tarafından onaylandıTuServerMU · 2018-08-22
  14. Web sitesiany

    MVCore 1.17.1 and MuCore 1.8 on XAMPP 1.7.1 both fail to connect to SQL Server 2008 R2, even with Named Pipes enabled.

    1. SQL Server was installed as the named instance SQLEXPRESS, so there was no MSSQLSERVER default instance. 2. Reinstall SQL Server with the default instance (MSSQLSERVER) and keep the sa...

    ✓ Konu sahibi tarafından onaylandıTuServerMU · 2018-07-30
  15. Web sitesiany

    After replacing MuCore 1.0.8 with MVCore 1.17.1 on the host, the installer does not appear and the site cannot connect to SQL.

    1. Delete all old files in public_html (leftover MuCore files and config). 2. Upload MVCore again; the installer then opens. 3. Enter the SQL data in the installer; it connects normally.

    ✓ Konu sahibi tarafından onaylandıTuServerMU · 2018-06-03
  16. Web sitesiany

    WebEngine CMS on a web host cannot reach the SQL Server on a VPS: 'Could not connect to database (1)', even after opening port 1433 in the firewall and enabling TCP/IP.

    1. Check the usual items first: inbound rule for TCP 1433 in Windows Defender Firewall on the VPS, TCP/IP enabled in SQL Server Configuration Manager. 2. If it still fails, test whether t...

    ✓ Konu sahibi tarafından onaylandıRaGEZONE · 2025-02-12
  17. Web sitesiany

    After the VPS (SQL) IP changed, a WebEngine CMS 1.2.4 site hosted on a separate Linux server shows 'Connection to database failed (MuOnline)' and the installer says the install is already complete.

    1. Open includes/config/webengine.json and set "webengine_cms_installed": false, then upload it. 2. In the web host cPanel open PHP Selector and (re)enable pdo_dblib and pdo_sqlsrv. 3. Ru...

    ✓ Konu sahibi tarafından onaylandıRaGEZONE · 2024-02-16
  18. Web sitesiS6

    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...

    ✓ Konu sahibi tarafından onaylandıRaGEZONE · 2023-10-06
  19. Web sitesiany

    Installing WebEngine CMS 1.2.5 with the ODBC driver fails with '[ODBC SQL Server Driver] The data types varchar(max) and text are incompatible in the equal to operator'.

    1. Do not use the old ODBC SQL Server driver for the install. 2. Install the Microsoft PHP SQLSRV / PDO_SQLSRV drivers that match your PHP version and enable them in php.ini. 3. Restart A...

    ✓ Sorun kaydında onaylandıGitHub (lautaroangelico/WebEngine) · 2025-02-20
  20. Araçlar

    MFS Database Tool: the backup gives the same error as other backup managers, even with (local), Windows authentication or 127.0.0.1

    1. Connect to your SQL Server as usual (the tool supports SQL Server 2000 and 2008 style connections). 2. Do not pick the database with the drop down button: type the database name (for e...

    ✓ Konu sahibi tarafından onaylandıRaGEZONE · 2014-02-11

MuADMINS Community Alpha: ücretsiz, topluluk tarafından yapılıyor, aktif geliştirmede.