What's new

[NEW VERSION] 4.3.4 Blizzlike Cataclysm - v.7 - [EmuCoach Official Cataclysm Repack]

kamui2040

Silver Supporter
Veteran Member
132
2014
6
Really awesome thread design, congrats.
Don't forget to post bugs in the Bug Report section people.
(Although maybe a bug tracker page would be better?)
 

redvengance1

Gold Supporter
Veteran Member
Verified Member
40
2014
1
I'm kind of stuck in a dilemma. I have downloaded V3 and it works great, but I want to somehow get all my characters from V2 migrated over, and I've tried many different methods without any luck. Don't get me wrong, the characters all appear, but they're naked and have no bags/anything in their inventory whatsoever. I spent a lot of time into getting geared with full gems/enchants on multiple sets, and I would hate to have to do that all over again. Is there a possible way to completely move the characters over?
 

ExO

Admin
5,119
2014
1,640
Thanks for the feedback guys!

@redvengance1,

I understand your point, and I know a few others also asked about this. I could explain it with a wall of text, but I think creating a video would be the best thing. I'll try to create one asap (like a day or so) if that fits?
 

redvengance1

Gold Supporter
Veteran Member
Verified Member
40
2014
1
Thanks for the feedback guys!

@redvengance1,

I understand your point, and I know a few others also asked about this. I could explain it with a wall of text, but I think creating a video would be the best thing. I'll try to create one asap (like a day or so) if that fits?

Yes that would be great! I have no problem with waiting, I just don't want to go through the trouble of re-making 11 characters lol. It's very time consuming and boring, plus I have my server opened so a few of my friends can play on it, and they'd be happy too. Take your time with it, I understand you must be very busy especially with after JUST releasing the new version.
 

vhero

Hero To The People
Silver Supporter
Veteran Member
72
2015
36
Location
Manchester, England
I'm kind of stuck in a dilemma. I have downloaded V3 and it works great, but I want to somehow get all my characters from V2 migrated over, and I've tried many different methods without any luck. Don't get me wrong, the characters all appear, but they're naked and have no bags/anything in their inventory whatsoever. I spent a lot of time into getting geared with full gems/enchants on multiple sets, and I would hate to have to do that all over again. Is there a possible way to completely move the characters over?

http://www.emucoach.com/showthread....harImport-Character-Converter-importer-EN-GER

works like a charm. Just start v2 sql server and backup all accounts to a template (make sure you have cata selected) then start the v3 sql server and import template into database (again selevet cataclysm). Worked perfect for me. Also make sure in your client folder you have deleted your cache folder THIS IS IMPORTANT!
 
Last edited:

redvengance1

Gold Supporter
Veteran Member
Verified Member
40
2014
1
http://www.emucoach.com/showthread....harImport-Character-Converter-importer-EN-GER

works like a charm. Just start v2 sql server and backup all accounts to a template (make sure you have cata selected) then start the v3 sql server and import template into database (again selevet cataclysm). Worked perfect for me. Also make sure in your client folder you have deleted your cache folder THIS IS IMPORTANT!

I actually tried that last night, but for some reason I keep getting an error from it. I can provide a link to a screenshot of it.
http://imgur.com/2JXHxDX
 

redvengance1

Gold Supporter
Veteran Member
Verified Member
40
2014
1
hmm you added anything to your database? Like a custom script thats modified it?

Well I did put in a few SQL queries so worgen could be played as paladins and shamans, but that's about it, besides a bunch of custom items which I doubt would affect it at all. I could probably try with a vanilla database and see if that gives me problems or not as well.

[Edit] - Yes, even with a vanilla database that's unmodified still gives me the same error.
 
Last edited:

vhero

Hero To The People
Silver Supporter
Veteran Member
72
2015
36
Location
Manchester, England
Well I did put in a few SQL queries so worgen could be played as paladins and shamans, but that's about it, besides a bunch of custom items which I doubt would affect it at all. I could probably try with a vanilla database and see if that gives me problems or not as well.

[Edit] - Yes, even with a vanilla database that's unmodified still gives me the same error.

Okay either 1 of two things can be wrong either you need to install .net framework which should could fix the issue as that's a .net framework error OR something else is interfering with the app. If you cannot get it fixed if you zip up your v2 database (your entire _server folder) and upload to mega.co.nz ill download it for you and use the app to backup all your accounts and transfer to a template for you or even a v3 server if you wish I dont mind.

But you should try to get problem fixed in case you ever need to use again in future.
 

redvengance1

Gold Supporter
Veteran Member
Verified Member
40
2014
1
Okay either 1 of two things can be wrong either you need to install .net framework which should could fix the issue as that's a .net framework error OR something else is interfering with the app. If you cannot get it fixed if you zip up your v2 database (your entire _server folder) and upload to mega.co.nz ill download it for you and use the app to backup all your accounts and transfer to a template for you or even a v3 server if you wish I dont mind.

But you should try to get problem fixed in case you ever need to use again in future.

Okay, I tried pretty much everything. I already have .NET Framework 4.5.2 installed, but it does not want to work still. I uploaded my database to Mega, however.

https://mega.co.nz/#!IcUxTIJI!pA0zgMX8_ZbiOqmulpg5EW4CbmF_UmLOPxCVmg4sAFA

If you can get my characters/accounts converted over I would be highly grateful!
 

ExO

Admin
5,119
2014
1,640
Another way to keep the accounts/characters:
Small tutorial:

Make a backup/dump of auth & character database from V.2, open V.3 MySQL, delete auth & character database, execute your dumped auth & character database from V.2 that you just made a backup of, (keep the V3 world server though)
When you are done executing the auth & character database run this query into your auth database:

-- Auth database
ALTER TABLE account_banned DROP COLUMN realm;

And this into your character database:
-- Char database
ALTER TABLE `characters` ADD `currentPetSlot` smallint(2) NOT NULL DEFAULT 0 AFTER `grantableLevels`;

And this in your character database (AHBot):
http://pastebin.com/Nve6NY2E

And it should be working just fine.
Let me know though!
 

vhero

Hero To The People
Silver Supporter
Veteran Member
72
2015
36
Location
Manchester, England
Okay, I tried pretty much everything. I already have .NET Framework 4.5.2 installed, but it does not want to work still. I uploaded my database to Mega, however.

https://mega.co.nz/#!IcUxTIJI!pA0zgMX8_ZbiOqmulpg5EW4CbmF_UmLOPxCVmg4sAFA

If you can get my characters/accounts converted over I would be highly grateful!

You may have to try exos method I am getting the same error as you it seems you modified something with an sql hack and the program just doesnt like it. Maybe a new table or a value in a table that shouldn't be there is causing it because you added something either way exos method is going to be your only way i'm afraid.
 

redvengance1

Gold Supporter
Veteran Member
Verified Member
40
2014
1
@ExO

I used that method and I keep getting an error whenever I try to execute the AHBot query. I'm really not too sure what to do from here. I think I might have to wait for you to make that video so I can get a visual idea of what to do, cause I think I might just be doing this wrong.
 

ExO

Admin
5,119
2014
1,640
@ExO

I used that method and I keep getting an error whenever I try to execute the AHBot query. I'm really not too sure what to do from here. I think I might have to wait for you to make that video so I can get a visual idea of what to do, cause I think I might just be doing this wrong.

Which error do you get upon executing the AHBot query? Well, you are almost finished with the steps, just need this one solved.
 

redvengance1

Gold Supporter
Veteran Member
Verified Member
40
2014
1
Alright, well first it tells me that the table auctionhousebot already exists, so I proceeded to delete it, then it gave me this... http://imgur.com/7kxIlOm

It also recreates the AHBot table, but nothing happens. When I try to startup the worlserver this happens.. http://imgur.com/k44HkVU
I really don't know what to do about it.
 

ExO

Admin
5,119
2014
1,640
Alright, well first it tells me that the table auctionhousebot already exists, so I proceeded to delete it, then it gave me this... http://imgur.com/7kxIlOm

It also recreates the AHBot table, but nothing happens. When I try to startup the worlserver this happens.. http://imgur.com/k44HkVU
I really don't know what to do about it.

Well the last posted error is because you haven't executed:
-- Char database
ALTER TABLE `characters` ADD `currentPetSlot` smallint(2) NOT NULL DEFAULT 0 AFTER `grantableLevels`;

Run it into your character database and it should work just fine.
 

redvengance1

Gold Supporter
Veteran Member
Verified Member
40
2014
1
Well the last posted error is because you haven't executed:
-- Char database
ALTER TABLE `characters` ADD `currentPetSlot` smallint(2) NOT NULL DEFAULT 0 AFTER `grantableLevels`;

Run it into your character database and it should work just fine.

Okay that's my mistake, I thought I had executed that script but I just did and now the worldserver seems to start up perfectly without any issues at all, until this happens - http://imgur.com/LjFkRd9
 
Top