Account error

Question

Account error

MegaWorldServer opened this issue 2 years ago · 12 comments

MegaWorldServer commented 2 years ago

A Database Error Occurred
Error Number: 1054

Unknown column 'SecurityLevel' in 'field list'

SELECT SecurityLevel AS gmlevel FROM account_access WHERE AccountId = '1'

Filename: C:/xampp/htdocs/modules/admin/models/Accounts_model.php

Line Number: 88

when you try to click on the account, it shows this

Answer 1 · 2023-07-11T13:20:21.000Z

A Database Error Occurred Error Number: 1054

Unknown column 'SecurityLevel' in 'field list'

SELECT SecurityLevel AS gmlevel FROM account_access WHERE AccountId = '1'

Filename: C:/xampp/htdocs/modules/admin/models/Accounts_model.php

Line Number: 88

when you try to click on the account, it shows this

Send an image of the auth database of the account_access table.
What is your source and what have you chosen as your emulator in realm?

Answer 2 · 2023-07-11T20:04:55.000Z

AzerothCore 3.3.5

Answer 3 · 2023-07-11T20:38:15.000Z

AzerothCore 3.3.5

you must select azeroth core for your realm.

go to admin panel
settings
realms tab
edit your realm
select Emulator Azeroth Core
save realm

Answer 4 · 2023-07-11T20:46:03.000Z

AzerothCore 3.3.5

you must select azeroth core for your realm.

go to admin panel

settings

realms tab

edit your realm

select Emulator Azeroth Core

save realm

I did so, initially I chose Azeroth Care SOAP, but after I did it, I began to knock out the error that is on the screenshot

Answer 5 · 2023-07-11T20:47:17.000Z

Connection is not established because the destination computer rejected the connection request
Although there are no problems with the connection

Answer 6 · 2023-07-11T20:51:38.000Z

AzerothCore 3.3.5

you must select azeroth core for your realm.

go to admin panel

settings

realms tab

edit your realm

select Emulator Azeroth Core

save realm

I did so, initially I chose Azeroth Care SOAP, but after I did it, I began to knock out the error that is on the screenshot

Send an image of Fusion database of realms table. (hide password of your databases in image)

Answer 7 · 2023-07-11T20:54:43.000Z

MegaWorldServer commented 2 years ago

Answer 8 · 2023-07-11T21:06:00.000Z

Connection is not established because the destination computer rejected the connection request
Although there are no problems with the connection

change hostname from localhost to 127.0.0.1. also in your database.php instead of putting localhost try putting 127.0.0.1. This works for most of cases.

Answer 9 · 2023-07-11T21:46:35.000Z

I've already tried everything, it doesn't help

Answer 10 · 2023-07-12T11:09:34.000Z

I've already tried everything, it doesn't help

Turn off db_debug.

Answer 11 · 2023-07-13T10:02:34.000Z

A PHP Error was encountered
Severity: Warning

Message: mysqli::real_connect(): (HY000/2002): Подключение не установлено, т.к. конечный компьютер отверг запрос на подключение

Filename: mysqli/mysqli_driver.php

Line Number: 211

Backtrace:

File: C:\xampp\htdocs\application\third_party\MX\Loader.php
Line: 141
Function: DB

File: C:\xampp\htdocs\application\models\Characters_model.php
Line: 35
Function: database

File: C:\xampp\htdocs\application\modules\sidebox_toppvp\models\Toppvp_model.php
Line: 10
Function: connect

File: C:\xampp\htdocs\application\modules\sidebox_toppvp\controllers\Toppvp.php
Line: 73
Function: getTopKillChars

File: C:\xampp\htdocs\application\libraries\Template.php
Line: 543
Function: view

File: C:\xampp\htdocs\application\libraries\Template.php
Line: 256
Function: loadSideboxes

File: C:\xampp\htdocs\application\libraries\Template.php
Line: 238
Function: handleNormalPage

File: C:\xampp\htdocs\application\modules\news\controllers\News.php
Line: 118
Function: view

File: C:\xampp\htdocs\application\modules\news\controllers\News.php
Line: 36
Function: displayPage

File: C:\xampp\htdocs\index.php
Line: 250
Function: require_once