Game server crashing since update
Re: Game server crashing since update
I tried what you said and it throws the same error. However in the database it updates the mlvl and slvl fields just fine. I tried cleaning and building the search server again thinking that might help but it didnt.
Re: Game server crashing since update
Did you run the bat script to execute the updated char table?
Re: Game server crashing since update
I think I may be doing something wrong. WHen I backup my char data, I simply copy and paste the char .sql files to another location. After pulling, I paste them back in and run the batch file. Would this cause it to overwrite updates in those tables that were not in my old char tables? If so, how would I take my old char data and put it into the updated tables? Would my method not do this?
Edit:
My current tables have the fields that your query added though. It updates the mlvl and slvl fields fine in the DB, just keeps doing that error.
Edit:
My current tables have the fields that your query added though. It updates the mlvl and slvl fields fine in the DB, just keeps doing that error.
Re: Game server crashing since update
Honestly, I can't quite get the idea of how you do it.
What do you mean when you say you copy and paste the files to another location, or paste them in and run a batch file?
Basically, what this does is add the three columns to the proper tables. Two different tables. So the char_stats table should have mlvl & slvl after running it, and the chars table should have the campaign_allegiance column. However, you run this in the live database. So, you back up your table, that's fine, but you don't restore it unless there is another problem, because it will not have those columns.
But, you are saying those are there anyways, so it seems there isn't a problem on your implementation end. And, just to confirm, this error you are getting is in the game server? Can you post the log message? Or do you mean you get it when you run the batch file? Because it is single run only, so if you have already ran it, and you run it again, then it will throw errors because you are trying to add columns that are already in the database.
What do you mean when you say you copy and paste the files to another location, or paste them in and run a batch file?
Basically, what this does is add the three columns to the proper tables. Two different tables. So the char_stats table should have mlvl & slvl after running it, and the chars table should have the campaign_allegiance column. However, you run this in the live database. So, you back up your table, that's fine, but you don't restore it unless there is another problem, because it will not have those columns.
But, you are saying those are there anyways, so it seems there isn't a problem on your implementation end. And, just to confirm, this error you are getting is in the game server? Can you post the log message? Or do you mean you get it when you run the batch file? Because it is single run only, so if you have already ran it, and you run it again, then it will throw errors because you are trying to add columns that are already in the database.
Re: Game server crashing since update
The error comes up in the search server whenever I try /sea all in game. I tried to find a log for the search server but I only say one for connect and game server.
I'll try to explain the process I use easier. Before I do a pull to try and get the latest updates, I go in the sql folder and copy every char .sql file and put them in a folder away from my server, then do the pull. Afterwards I'll take the .sql files I copied before the pull, and paste them back into the sql folder. Then I use a batch file that imports all the .sql files in the sql folder into the dspdb databse in navicat lite. This is the only method I know of to re-implement character data, but I figured I was overwriting updated sql tables with the old ones when I just paste them back in the sql folder after pulling.
I'll try to explain the process I use easier. Before I do a pull to try and get the latest updates, I go in the sql folder and copy every char .sql file and put them in a folder away from my server, then do the pull. Afterwards I'll take the .sql files I copied before the pull, and paste them back into the sql folder. Then I use a batch file that imports all the .sql files in the sql folder into the dspdb databse in navicat lite. This is the only method I know of to re-implement character data, but I figured I was overwriting updated sql tables with the old ones when I just paste them back in the sql folder after pulling.
Re: Game server crashing since update
If you want please feel free to zip them and send to me on Dropbox. Pm me the info. No worries, your password is encrypted and I have no idea how to break that. Wouldn't matter much anyways unless your server was public.