SHO_LS Crashes

[veveto]

im having trouble with getting my server to work i download SHO server files from this forum but its not what harry12 released

[MentaL]

[Kingdom Rose]

Hmm i am not sure but i think its caused from a database issue btw Halla.

[veveto]

still couldnt figure it out im using msql 2000 i executed all sql's without any errors

[veveto]

ok guys solved the problem thanks to henriques but im stuck at downloading avatars list and this error pops up at SHO_WS

SQLSTATE:42S02, Áø´ÜÁ¤º¸:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'tblGS_AVATAR'.

SQLSTATE:42S02, Áø´ÜÁ¤º¸:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'tblGS_AVATAR'.

Query ERROR:: SQLSTATE:42S02, [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'tblGS_AVATAR'.


SQLSTATE:42S02, Áø´ÜÁ¤º¸:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'tblWS_VAR'.

SQLSTATE:42S02, Áø´ÜÁ¤º¸:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'tblWS_VAR'.

SQL Exec ERROR:: UPDATE WORLD_VAR SQLSTATE:42S02, [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'tblWS_VAR'.

any ideas?

[Raven0123]

You're missing the tblWS_VAR table in the database. You kinda need that to login to the game server

[veveto]

thanks for your help my server is up :)

[Kingdom Rose]

Just curious how did you fix the login server issue ? might as well answer that for the people who encountered the same exact problem.

[henriques]

Just curious how did you fix the login server issue ? might as well answer that for the people who encountered the same exact problem.

I tried to help you correct the error of the LS, but as I also could not fix I sent the Login Server I did, that works seamlessly with the SHO servers.

- - - Updated - - -

Just curious how did you fix the login server issue ? might as well answer that for the people who encountered the same exact problem.

Oh, actually were two problems, the first one is in the post image is because of null fields on database (username or password), then the Login Server returns error, but otherwise it is very dangerous to use the SHO Login server if you want a server safe..