I use mudevs s20 and i get error "Internal Server Error [500]" how to solve it please?
05-19-2025 04:22:27.225500 #### PDOException: SQLSTATE[HY000]: General error: 20018 Invalid column name 'ip'. [20018] (severity 16) [CREATE PROCEDURE [dbo].[WZ_CONNECT_MEMB]
@uid varchar(20),
@server varchar(20),
@uip varchar(20),
@hwid varchar(100)
AS
BEGIN
BEGIN TRANSACTION
SET NOCOUNT ON
IF EXISTS (SELECT memb___id FROM MEMB_STAT WITH (READUNCOMMITTED) WHERE memb___id = @uid)
BEGIN
UPDATE MEMB_STAT SET ip = @uip, connectstat = 1, servername = @server, ConnectTM = (GETDATE()), HWID = @hwid WHERE memb___id = @uid
END
ELSE
BEGIN
INSERT INTO MEMB_STAT (memb___id,ip,connectstat,servername,hwid) VALUES (@uid, @uip, 1, @server, @hwid)
END
IF EXISTS (SELECT account FROM [dmncms].dbo.DmN_IP_Log WITH (READUNCOMMITTED) WHERE account = @uid AND ip = @uip)
BEGIN
UPDATE [dmncms].dbo.DmN_IP_Log SET last_connected = (GETDATE()), login_type = 0 WHERE account = @uid AND ip = @uip
END
ELSE
BEGIN
INSERT INTO [dmncms].dbo.DmN_IP_Log (account, ip, last_connected) VALUES (@uid, @uip,GETDATE())
END
IF(@@Error <> 0 )
ROLLBACK TRANSACTION
ELSE
COMMIT TRANSACTION
SET NOCOUNT OFF
END] in /home/axionzuq/public_html/application/libraries/DBEngines/pdo_dblib.php:79
Stack trace:
#0 /home/axionzuq/public_html/application/libraries/DBEngines/pdo_dblib.php(79): PDO->query('CREATE PROCEDUR...')
#1 /home/axionzuq/public_html/setup/application/models/model.setup.php(320): pdo_dblib->query('CREATE PROCEDUR...')
#2 /home/axionzuq/public_html/setup/application/controllers/controller.setup.php(443): Msetup->insert_sql_data('CREATE PROCEDUR...', 'account')
#3 /home/axionzuq/public_html/system/router.class.php(102): setup->step9()
#4 /home/axionzuq/public_html/setup/index.php(32): router->route(Object(request))
#5 {main}