MySQL Error 1054: Unknown column 'thread.threadid' in 'on...

[berry172]

Hello! MYSQL error is : MySQL Error 1054: Unknown column 'thread.threadid' in 'on clause'

s_mysql.lua:

username = get( "root" ) or "root" 
password = get( "asd" ) or "asd" 
db = get( "mta" ) or "mta" 
host = get( "127.0.0.1" ) or "127.0.0.1" 
port = tonumber( get( "3306" ) ) or 3306 

connection.lua:

-- connection settings 
local hostname = get( "hostname" ) or "127.0.0.1" 
local username = get( "username" ) or "root" 
local password = get( "password" ) or "asd" 
local database = get( "database" ) or "mta" 
local port = tonumber( get( "port" ) ) or 3306 

settings.xml:

<settings> 
    <setting name="@mysql.username" value="root"/> 
    <setting name="@mysql.password" value="asd"/> 
    <setting name="@mysql.database" value="mta"/> 
    <setting name="@mysql.hostname" value="127.0.0.1"/> 
    <setting name="@mysql.port" value="3306"/> 
</settings> 

Please help me! I'm using mta_mysql.dll ))

[Anderl]

Showing the code where this happen would help.

[Wei]

username = get( "username" ) or "root" 
password = get( "password" ) or "asd" 
db = get( "database" ) or "mta" 
host = get( "hostname" ) or "127.0.0.1" 
port = tonumber( get( "3306" ) ) or 3306 
  

try using localhost instead of 127.0.0.1

[Anderl]

username = get( "username" ) or "root" 
password = get( "password" ) or "asd" 
db = get( "database" ) or "mta" 
host = get( "hostname" ) or "127.0.0.1" 
port = tonumber( get( "3306" ) ) or 3306 
  

try using localhost instead of 127.0.0.1

It has nothing to do with that error.