[Ascent] Where are my characters?

Hi,
On my private server, I'm able to log in but whenever I try to make a character, I hit create but there aren't any characters on my character list. I can't use (1786) Character - Characters.sql because the character database is already updated with it.

Using:
WAMP5 (MySQL Server won't work)
SQLyog
Ascent 2458

This might be why:
http://i27.tinypic.com/de1ijk.png

Answer: you have an unknown column 'publicNote' missing in your characters table, right between timestamp and officerNote.

Maybe an idea do add it there?

Doesn't 'unknown column' mean that that column -is- there but the program can't make sense of it? Look in your DB with SQLyog or Navicat. If it is there, try dropping it (should probably backup the database first though, just in case). If not, add it.

I had a similar problem, the fix is just to add the column using SQLyog.

OK, I could really read the error that well. Thanks.

Do you know what datatype, length, etc. the publicNote field is?

or auswa100, can you export your characters table and send it to me? Also, which ascent build are you using, out of curiosity?

Bump.

They way to fix that is to apply the right sql updates to it depending on wat core ur using, it usually comes with the sql updates. Hope that helped

Quote:

---

Originally Posted by Vereux0

Hi,
On my private server, I'm able to log in but whenever I try to make a character, I hit create but there aren't any characters on my character list. I can't use (1786) Character - Characters.sql because the character database is already updated with it.

Using:
WAMP5 (MySQL Server won't work)
SQLyog
Ascent 2458

This might be why:
http://i27.tinypic.com/de1ijk.png

---

U USING 2456 REVISION, ANSD EXECUTING FILES FROM OLDER updates

SIMPLY EXECUTE UPDATES THAT CORRESPOND TO YOUR REVISIONS.

Quote:

---

Originally Posted by myil

They way to fix that is to apply the right sql updates to it depending on wat core ur using, it usually comes with the sql updates. Hope that helped

---

Ping time outs is due to you ISP connection and speed. it has no relation with your Core or Ascent revision

Quote:

---

Originally Posted by Vereux0

OK, I could really read the error that well. Thanks.

Do you know what datatype, length, etc. the publicNote field is?

or auswa100, can you export your characters table and send it to me? Also, which ascent build are you using, out of curiosity?

---

already using 3.6 revison which is more stable.

download a repack in my seg and you wont have any problems :0

Quote:

---

Originally Posted by aceindy

Answer: you have an unknown column 'publicNote' missing in your characters table, right between timestamp and officerNote.

Maybe an idea do add it there?

---

that collumn doesnt exist in 2.5+ revisions.

he is executing OLDER SQL files then his revsion

What is a good Ascent core & Database combo?
The newer ones pull up Command Prompt with "C:\Dokumente und Einstellungen\" then it crashes, or I get this:
http://i31.tinypic.com/qn8w8x.png

Quote:

---

Originally Posted by Vereux0

What is a good Ascent core & Database combo?
The newer ones pull up Command Prompt with "C:\Dokumente und Einstellungen\" then it crashes, or I get this:
http://i31.tinypic.com/qn8w8x.png

---

check my sig and your problem solved forever

Quote:

---

Originally Posted by rr2739

check my sig and your problem solved forever

---

OK. I downloaded it, but now this happens in logonserver:
http://i30.tinypic.com/kar0is.png

and realmserver:
http://i25.tinypic.com/2djupg.png
"moocow"? How do I change it to admin?

Also, what order am I supposed to open logonserver, ascent, and realmserver?

Bump.

Vereux0, don't use realmserver. Delete it. It's nothing right now.

You need to load up logonserver.exe, and then ascent.exe, and that's it.

Yeah, but both ascent and logonserver crash when I start them.

Well, I would say, get the latest version of Ascent and compile the source yourself.... But if you don't have or won't download Visual Studio, then just try a pre-compiled one that's stickied in this forum.

What version is the latest?

As of 04 February 2008, 10:15pm GMT time, 3681 is the latest.

Wow. Thanks for the fast reply.

Can you give me a link? I can't find it in the forums.

Had the same exact problem.

Asked a guy, download the sql updates, and do every single one of them.. For the world and the characters and it works :)

Quote:

---

Originally Posted by Vereux0

Can you give me a link? I can't find it in the forums.

---

Well, if you don't have a compiler don't bother, you won't be able to compile it without Visual Studio...... so you won't be able to get the latest latest...... use The newest one stickied in this forum.

It has all the same SQL updates anyway, so it doesn't matter. :)

Quote:

---

Originally Posted by rasta-raus

Had the same exact problem.

Asked a guy, download the sql updates, and do every single one of them.. For the world and the characters and it works :)

---

I can't. This comes up:
http://i26.tinypic.com/ct447.png

The error file is filled with "cannot find column "whatever" or "cannot drop column "whatever". Check that exists."

It seems like I'm using the wrong database files with the wrong core. What are the correct database files for Ascent 3650?

Quote:

---

Originally Posted by rasta-raus

Had the same exact problem.

Asked a guy, download the sql updates, and do every single one of them.. For the world and the characters and it works :)

---

I can't. This comes up:
http://i26.tinypic.com/ct447.png

The error file is filled with "cannot find column "whatever" or "cannot drop column "whatever". Check that exists."

It seems like I'm using the wrong database files with the wrong core. What are the correct database files for Ascent 3650?

Ok, well, download the .zip I've attached, it contains the updates you need.

Delete your whole character database.

Create a new one called character and execute the SQLs in the .zip one by one.

They're numbered, so number 1 first, 2 second etc.

EDIT: Ok, Ragezone decided to time out while attaching, so it screwed up. Dwnload the .zip here: http://rapidshare.com/files/89213760...dates.zip.html

I still get this error even with that:
http://i30.tinypic.com/kar0is.png

Then it's not your database, it's the repack's fault.

Get the real version of ascent, it's stickied in this forum.

dont worry about that. just keep going. Just keep execing all the sql tihngs. i had the same prob

I think it's the repack's database that's the problem. That's the only constant in this. What the Ascent 3650-compatible World Database?

Quote:

---

Originally Posted by Vereux0

I think it's the repack's database that's the problem. That's the only constant in this. What the Ascent 3650-compatible World Database?

---

The SQL zip I posted is the official Ascent SQL files.

OK, I used the World SQL Files in that zip. And Logonserver is staying up :D FINALLY!!!

However, whenever I make a Character, I get a "Disconnected From Server" Error and it doesn't save the character. Anyone know the solution to this?

On a side note, I noticed this in the logonserver.conf:

Quote:

---

# LogonDatabase Section
#
# These directives are the location of the `realms` and `accounts`
# tables.

---

I don't have a 'realms' table in my character or world database. Is there an SQL Update for this?

Quote:

---

Originally Posted by Vereux0

OK, I used the World SQL Files in that zip. And Logonserver is staying up :D FINALLY!!!

However, whenever I make a Character, I get a "Disconnected From Server" Error and it doesn't save the character. Anyone know the solution to this?

On a side note, I noticed this in the logonserver.conf:


I don't have a 'realms' table in my character or world database. Is there an SQL Update for this?

---

Nope, neither do I. It's a typo I think.

The logon is just where your 'accounts' table is.

So anyone know how to stop the DCing when I make a character?

Quote:

---

Originally Posted by Vereux0

I can't. This comes up:
http://i26.tinypic.com/ct447.png

The error file is filled with "cannot find column "whatever" or "cannot drop column "whatever". Check that exists."

It seems like I'm using the wrong database files with the wrong core. What are the correct database files for Ascent 3650?

---

delete your databse and reinstall,, i dont see others having same problem.

Quote:

---

Originally Posted by Cody900

Then it's not your database, it's the repack's fault.

Get the real version of ascent, it's stickied in this forum.

---

ther eis nothing wrong with a repack.... repack and ascent is 2 different things... Ascent is compiled by Ascent Emu ,,, so plz dont even try to say it has somethign to do with my databse.. why you think erveryone in my threads saying thatnk yuou, great job? ok ty,.

now in regards of the repack , its a simple one sql file, and it never gives errors as it was downloaded by 3500 ppl ... so dont you try to say antying about repack.


learn to justify



to the guy with maswsive pics.. my database repack comes with 3500 ascent... and compatible databse 1006.. obviously if you using 3.6 , my repack is build on 1006 core thats why both ascent and 3.5 comes with it together.

if you decide to change the ascent version then do it , but make sure to run updates

ascent rev3681 is now on the sticky forum :) sorry i took some time, but was working ;)

Quote:

---

Originally Posted by rr2739

ther eis nothing wrong with a repack.... repack and ascent is 2 different things... Ascent is compiled by Ascent Emu ,,, so plz dont even try to say it has somethign to do with my databse.. why you think erveryone in my threads saying thatnk yuou, great job? ok ty,.

now in regards of the repack , its a simple one sql file, and it never gives errors as it was downloaded by 3500 ppl ... so dont you try to say antying about repack.


learn to justify



to the guy with maswsive pics.. my database repack comes with 3500 ascent... and compatible databse 1006.. obviously if you using 3.6 , my repack is build on 1006 core thats why both ascent and 3.5 comes with it together.

if you decide to change the ascent version then do it , but make sure to run updates

---

I wasn't referring to your database, I'm sure that's all fine.

I was referring to the pre-compiled DLLs and EXEs.... seems like they don't work on his computer. He can at least try the official stickied ones to see if they work.

yeah. and i've created the char db 2.3.3 and if his errors continues he could also use those files in combination with the newest ascent. All the needed updates are included.

Quote:

---

Originally Posted by rr2739

ther eis nothing wrong with a repack.... repack and ascent is 2 different things... Ascent is compiled by Ascent Emu ,,, so plz dont even try to say it has somethign to do with my databse.. why you think erveryone in my threads saying thatnk yuou, great job? ok ty,.

now in regards of the repack , its a simple one sql file, and it never gives errors as it was downloaded by 3500 ppl ... so dont you try to say antying about repack.


learn to justify



to the guy with maswsive pics.. my database repack comes with 3500 ascent... and compatible databse 1006.. obviously if you using 3.6 , my repack is build on 1006 core thats why both ascent and 3.5 comes with it together.

if you decide to change the ascent version then do it , but make sure to run updates

---

Well obviously, it doesn't work or it would've stayed up.
Also...

LEARN TO TYPE

What are "maswsive pics"?

Massive pics.

To Paco:

http://www.ihasabucket.com/images/walrus_bucket.jpg

I'm guessing you meant to say more, Cody.

Bump.