[Ascent] character.account_data

[cloooned]

Hi

I tried to install after a 2 months break the new ascent release. There arent any errors when I started the login and world server. But when I try to create a new character, it doesnt work, the new character will be instantly deleted. The error is always the same, he cant find the table "account_data" in the character database.

So I looked up for some SQL Updates, but, there arent any updates which solves this problem. There is no Database inlcuding the table "account_data", why? Which database I should have installed?

Current version: Ascent 2303, NCDB 643 and CharacterDatabase FULL and Updated.

Thanks

[MentaL]

[ltglobal]

just upload updates...from ascent folder thats all ;)

[cloooned]

doesnt work, I cant upload all the updates, it wont generate this table.

Update: Character - Accounts (2075).sql

Error Code: 1050 - Table 'xyz' already exists and he wont generate this new table account_data...

[Samson123]

There was a problem in the sql update any way.I forget what it was but here is the fixed table.

CREATE TABLE `account_data` (
`acct` int(30) NOT NULL,
`uiconfig0` longtext,
`uiconfig1` longtext,
`uiconfig2` longtext,
`uiconfig3` longtext,
`uiconfig4` longtext,
`uiconfig5` longtext,
`uiconfig6` longtext,
`uiconfig7` longtext,
`uiconfig8` longtext,
PRIMARY KEY (`acct`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


also after i put this fix in my ascent.exe still shut's down after like 2-4 sec's

[gmaze]

that table is unofficial, which is why its not included.
it is a user created table....you could create whatever you want, as no structure is needed.

[markb]

Here is the full character table for ncdb 2.2. This also includes the account_data table which noone can find.

Free File & Image Hosting by SheitaN

[gmaze]

thats because it doesn't belong there
if you doubt me, below is link to ascentemu/wiki, where they post what tables belong where in a database. Search all you want, there will be no account_data table.
DatabaseStructure - Ascent Wiki