mapserver error

[sietse11]

after moving my sql database to an online host im getting these errors

 

 

[Warning] itemdb_search: item id 22001  does not excist in item_db. using dummy data
 

[SQL]: DB error - Lost connection to MySQL server during query
[Debug] : at ..\src\map\mapreg_sql.c:163 - UPDATE 'mapreg' SET 'value'= '999999' wHERE 'varname '=' $ttranks' AND 'index' = 0

the warning i can fix by jus manually adding it to the database

 

the SQL thing is weird, I got it after placing my sqldatabase online so I rebuild the server made sure I didnt miss any sql updates( i think)

problem persists. and I dont like messing with the source code

Edited March 19, 2013 by sietse11

[Dastgir]

[Warning] itemdb_search: item id 22001  does not excist in item_db. using dummy data

 

This is because you don't have item id # 22001 and your players may have that item or (npc may be using that item)

 

 

[SQL]: DB error - Lost connection to MySQL server during query
[Debug] : at ..\src\map\mapreg_sql.c:163 - UPDATE 'mapreg' SET 'value'= '999999' wHERE 'varname '=' $ttranks' AND 'index' = 0
 

This is self-explanable error "  Edited March 19, 2013 by Dastgir

[sietse11]

the item id is in my item_db.txt

I think its just not in the sql update.

 

I am hosting rathena from home and sql is on my webhost.

This SQL error dissapeared after flux was able to update server status.

 

Now I get [info]: Closed connection from '212.1.212.#'     in the same intervals. So you are probably right about the connection time out.

I was worried I had some kind of error in my src files. But it looks like its just a return from fluxcp failing to get server status for the 1st hour my server is online.

 

If the warning message goes away after adding the item manually in the database Ill flag this as solved.

 

lol im blind, i confused 21001 with 22001 solved

Edited March 19, 2013 by sietse11