Trouble starting server

pfyon · #1 05-03-2010, 11:20 AM

Code:

FROM tblWorldServerRegistration AS WSR

means it's using the name WSR instead of the long one for the purpose of this query. I had the same issue with the loginserver and mysql queries failing, so I tried executing the query through a mysql command line to get the more descriptive error.

kameko · #2 05-03-2010, 03:14 PM

hmm... well, that makes sense then. Can yuo tell me where in the source code you see that ? I have my own Windows server compiled from the same code, using the exact same db.... and I have no problems.

So somewhere it seems like a linux issue. Like I said, this is the exact same source code.

in my db tblWorldServerRegistration is all lower case., Maybe the difference in case is a problem...

I'll look into it more while I wait for a reply here

Thanks,

Kameko

Shiny151 · #3 05-03-2010, 03:20 PM

I'm having this exact same issue on a Windows server.

**gaeorn** · #4 05-03-2010, 03:53 PM

Make sure the login server DB matches the version of the login server code you are using or that query will fail. There was a field added in the tblWorldServerRegistration table along the way. You can add that field by sourcing in utils/sql/svn/1379_loginserver_trusted_server.sql in the proper database.