[Question] Ascent Crash 0x004CDEF9?

[violator]

I have the latest Ascent rev 3034, Also the latest NCDB rev 855...

Is there a Logon or World update I'm missing?

....I also have tried rev3004 off of Steph's Corner.

[Lakelog]

I had the following error before, getting a little help of Steph. The problem is, I think, that your Database is outdated compared to your version of Ascent. Download one of the latest databases, say for an example Norwegian Elite 4.0 since it was newly released. If that doesn't work, then not do I know.

[violator]

I found out why, Just worried as to how to fix....

My problem lies in the Logon/Character DB I have the structure was changed and now my toon/accounts are out of date...

Now, Since there only is about 25-50 people on the server I don't think it will be a death sentence to update the tables...I just gotta know how...

If anyone has a easy way to update from Ascent rev ~2499 up to the latest Logon/Toon structure much +Rep will get given!


...Sadly enough I totally missed this one...And I don't have the time to learn/fix it with school and people doing stuff where I live so.... On top of trying to release my first repack =/ ....

Life complexities!

[Lakelog]

You can just download an up-to-date database, execute it into another database, not the one you are using for your server, and copy&paste the up to date Logon/Character tables.

[violator]

You can just download an up-to-date database, execute it into another database, not the one you are using for your server, and copy&paste the up to date Logon/Character tables.

Well its the facts that its in the Toon table of the Logon database which has such things like ...

  `guid` int(10) unsigned NOT NULL,
  `acct` int(10) unsigned NOT NULL,
  `name` varchar(21) collate utf8_unicode_ci NOT NULL,
  `race` tinyint(3) unsigned NOT NULL,
  `class` tinyint(3) unsigned NOT NULL,
  `gender` tinyint(3) unsigned NOT NULL,
  `custom_faction` int(10) unsigned NOT NULL default '0',
  `level` tinyint(3) unsigned NOT NULL,
  `xp` int(10) unsigned NOT NULL,
  `exploration_data` longtext collate utf8_unicode_ci NOT NULL,
  `skills` longtext collate utf8_unicode_ci NOT NULL,
  `watched_faction_index` int(10) unsigned NOT NULL default '0',
  `selected_pvp_title` int(10) unsigned NOT NULL default '0',
  `available_pvp_titles` int(10) unsigned NOT NULL default '0',
  `gold` int(10) unsigned NOT NULL default '0',
  `ammo_id` int(10) unsigned NOT NULL default '0',
  `available_prof_points` tinyint(3) unsigned NOT NULL default '0',
  `available_talent_points` tinyint(3) unsigned NOT NULL default '0',
  `current_hp` int(10) unsigned NOT NULL default '0',
  `current_power` int(10) unsigned NOT NULL default '0',
  `pvprank` tinyint(3) unsigned NOT NULL default '0',
  `bytes` int(10) unsigned NOT NULL default '0',
  `bytes2` int(10) unsigned NOT NULL default '0',
  `player_flags` int(10) unsigned NOT NULL default '0',
  `player_bytes` int(10) unsigned NOT NULL default '0',
  `positionX` float NOT NULL default '0',
  `positionY` float NOT NULL default '0',
  `positionZ` float NOT NULL default '0',
  `orientation` float NOT NULL default '0',
  `mapId` int(10) unsigned NOT NULL default '0',
  `zoneId` int(10) unsigned NOT NULL default '0',
  `taximask` longtext collate utf8_unicode_ci NOT NULL,
  `banned` int(40) NOT NULL,
  `banReason` varchar(50) collate utf8_unicode_ci NOT NULL default '',
  `timestamp` int(10) unsigned NOT NULL default '0',
  `online` tinyint(3) unsigned NOT NULL default '0',
  `bindpositionX` float NOT NULL default '0',
  `bindpositionY` float NOT NULL default '0',
  `bindpositionZ` float NOT NULL default '0',
  `bindmapId` int(10) unsigned NOT NULL default '0',
  `bindzoneId` int(10) unsigned NOT NULL default '0',
  `isResting` tinyint(3) unsigned NOT NULL default '0',
  `restState` tinyint(3) unsigned NOT NULL default '0',
  `restTime` int(10) unsigned NOT NULL default '0',
  `playedtime` longtext collate utf8_unicode_ci NOT NULL,
  `deathstate` tinyint(3) unsigned NOT NULL default '0',
  `TalentResetTimes` int(10) unsigned NOT NULL default '0',
  `first_login` tinyint(3) unsigned NOT NULL default '0',
  `forced_rename_pending` tinyint(3) unsigned NOT NULL default '0',
  `arenaPoints` int(10) unsigned NOT NULL default '0',
  `totalstableslots` int(10) unsigned NOT NULL default '0',
  `instance_id` int(10) unsigned NOT NULL default '0',
  `entrypointmap` int(10) unsigned NOT NULL default '0',
  `entrypointx` float NOT NULL default '0',
  `entrypointy` float NOT NULL default '0',
  `entrypointz` float NOT NULL default '0',
  `entrypointo` float NOT NULL default '0',
  `entrypointinstance` int(10) unsigned NOT NULL default '0',
  `taxi_path` int(10) unsigned NOT NULL default '0',
  `taxi_lastnode` int(10) unsigned NOT NULL default '0',
  `taxi_mountid` int(10) unsigned NOT NULL default '0',
  `transporter` int(10) unsigned NOT NULL default '0',
  `transporter_xdiff` float NOT NULL default '0',
  `transporter_ydiff` float NOT NULL default '0',
  `transporter_zdiff` float NOT NULL default '0',
  `spells` longtext collate utf8_unicode_ci NOT NULL,
  `deleted_spells` longtext collate utf8_unicode_ci NOT NULL,
  `reputation` longtext collate utf8_unicode_ci NOT NULL,
  `actions` longtext collate utf8_unicode_ci NOT NULL,
  `auras` longtext collate utf8_unicode_ci NOT NULL,
  `finished_quests` longtext collate utf8_unicode_ci NOT NULL,
  `honorPointsToAdd` int(11) NOT NULL,
  `killsToday` int(10) unsigned NOT NULL default '0',
  `killsYesterday` int(10) unsigned NOT NULL default '0',
  `killsLifeTime` int(10) unsigned NOT NULL default '0',
  `honorToday` int(10) unsigned NOT NULL default '0',
  `honorYesterday` int(10) unsigned NOT NULL default '0',
  `honorPoints` int(10) unsigned NOT NULL default '0',
  `difficulty` int(10) unsigned NOT NULL default '0',

Thats a few new added sections, and not fun one to try and figure out what to input into them.... =D

[Etherealamd]

If anyone has a easy way to update from Ascent rev ~2499 up to the latest Logon/Toon structure much +Rep will get given!




Life complexities!

I would definatly give rep for an easy update from ascent rev ~2499...

[Steph]

There's no easy account importer. Best you can do is to grab the newest version from the SVN, or from my link, and make any changes between the two manually.

You could also dump your tables and reimport them to the new structure.

Finally, hell, it's a private server. If people want the latest cores and patches, they risk losing their gear. No warranty should come with a private server, neither implied or promised - you cant possibly keep everything up to date without putting in some hard work.

[Etherealamd]

There's no easy account importer. Best you can do is to grab the newest version from the SVN, or from my link, and make any changes between the two manually.

You could also dump your tables and reimport them to the new structure.

So what your saying is I can upload just the structure of norwiegiens V4 then I can upload the data from my old db, but then how would I upload the rest of norwiegiens database into the structure?

[Steph]

Here's the best free advice you are going to get. Im not taking this out on you, but several people over the last couple of days have had these same problems - to be honest, Im not having them with this release. So what I suggest is this.

If you need 2.3.2 for live, leave your game installed.

If you want to play with private servers also, install World of Warcraft again to a different folder, and upgrade to 2.3.0, and use Knaur's repack with Ascent 2.8 stable.

There's going to be problems with ascent and the latest patch for at least the next couple of weeks. I would suggest to anyone wanting to use private servers only, or indeed to use private and live, to have a second install of WoW at 2.3.0 until the next stable branch of ascent is released.

I'll be putting this post on my corner as well.

[violator]

You could also dump your tables and reimport them to the new structure.

Well, With the major updates to the structure it seems to be painstakingly impossible....

But, on top of school...My own private server and trying to release my database w/ mall and just the mall....I'm swamped but I am gonna try to make a guide on how to update the ~2499 structure to the ~3000 structure...