[Ascent] Character creation problem

[DK10016]

Hello. I KNOW this is posted in the FAQ, but it did not help me. Its 9:20AM right now and I havent slept yet. Im having some troubles and I'd really like some help!

My problem:

When I am building a new character and I press "Create", it takes me back to the character selection screen and my new character does not show up.

The FAQ says:

- Q: When I try to create a character, I click Create but nothing happens.
- A: Download the SQL Updates and run the one labeled (1786) Character - Characters.sql on the character DB.

My problem:

How do I "run" the .sql on the character DB?

The Server Guide says to update, this is what you do.
"Run each SQL update the same way that you imported the databases."

I imported the databases by clicking "Create Database", right clicking on the new database, "Restore from SQL Dump", and then selecting the .sql

That method did NOT work for updating the .sql. I right clicked the character database, clicked "Restore from SQL Dump, and then selected "(1786) Character - Characters.sql"

Thats obviously the wrong way to do it though, I guess.. It doesnt extract successfully anyways.

Anyways. If anyone could help me with this simple problem, that would be nice!

Thanks in advance =]

 

[DK10016]

Ugh, can I get some help here? It seems like I'm the only one with this problem.. If someone could just take a few minutes of their time to tell me how to do this, that would be great.

 

[beileroord]

U have the newest ascent all isnt it ?

then u need to look for the update inside de svn, ure also getting a message on ure console about some sql query ... isnt it ?

* some opcode corrections
* completely rewritten guild system. *NOTE* *BIG FUCKING NOTE* RUNNING THE SQL QUERIES IN THE UPDATE FOLDER WILL DESTROY YOUR GUILDS. I'll release a tool later to migrate existing databases over. For now its probably a better option not to use this.
* beginning of guild bank system
+ added some callback features for c++ scripters who want to use timed events
* changed onchat hook to a boolean return type

file needed is : trunk/sql/updates/2521_guilds.sql I guess U need


After re reading ure story I am not sure if u even got a filled character database ?
Might be usefull to get the Character DB (2.3.0 Full) from :

http://forum.ragezone.com/f114/ascent-server-files-last-update-12-7-07-a-324372/#post2805886

 

[DK10016]

I've decided to just use the "Wickedx2x Repack 2.3.0". I got it set up and working. Thanks for trying to help me though, but this is much easier

 

[Lazocar]

After re reading ure story I am not sure if u even got a filled character database ?
Might be usefull to get the Character DB (2.3.0 Full) from :

http://forum.ragezone.com/f114/ascent-server-files-last-update-12-7-07-a-324372/#post2805886

I have the same problem and i have full 2.3.0 character DB.
Maybe i need an older stable relese ,can you tell me what is the best working relese of Ascent.
Thanks!

 

[tanro]

Instructions for SQLyog
To "run" updates for sql right click your ascent database (the one you made for you server) and click update from SQL dump navigate to the folder the has your updates in it. Run the update by clicking open and then execute.

If you get an error then your allready update or something is going on I dont know about.

 

[Lazocar]

Instructions for SQLyog
To "run" updates for sql right click your ascent database (the one you made for you server) and click update from SQL dump navigate to the folder the has your updates in it. Run the update by clicking open and then execute.

If you get an error then your allready update or something is going on I dont know about.

Yes I've get an error!

 

[808lostboy]

use wickeds repack it works very well

 

[Digital727]

He's running the new unstable character database, Just look for a older rev.

 

[DK10016]

Thank you tanro, for the instructions. I will now be able to update files when needed =]

808lostboy: I agree. Wickeds pack works very well. I recommend this pack if you guys are still having problems.

 

[everwinter69]

i have the same character problem ...
where do i find wickeds pack ? i tryed emupedia , google and ragezone search but found nothing

 

[iNs@nE]

Simple solution. Once you create your character and it does not show up - alt + tab and go check your ascent.exe - it'll show you an SQL error about a missing table guild_data with the cells mentioned.

Just create this table using Navicat. As for the variable types set for the cells inside this table, you can get them from the character table coz that one too has the same cells. So viola - problem fixed... Works for me.

Else as said - just download wicked's pack.

i have the same character problem ...
where do i find wickeds pack ? i tryed emupedia , google and ragezone search but found nothing

You sure are blind mister.

 

[HalestormXV]

I have this same error except I get it with the wicked repack as well. Now I see what you are talking about insane with the guild.data thing missing. So how would I go about creating a table with as you said cells.. Do you have a simple step by step instruction for creating the table? Or does anyone else have a soultion for this problem i am having? Yes I have the 2.3DB Full.

 

[eag03]

i just got wickeds repack, and it works awsomely, untill i try to log in with my character, wow loads and then has a critical error.

help would be great please

thanks in advance

 

[Paco44]

Make a new character. You bugged that one.

 

[eag03]

thanks man, that awsome, it works now. one thing though, i made a new toon, a NE warrior and as soon as i loaded i was wearing 4/5 pieces of shammy T6 and my bag was full of nether drakes. also i cant lvl to lvl 70.