-
[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
-
Re: [Ascent] Where are my characters?
Answer: you have an unknown column 'publicNote' missing in your characters table, right between timestamp and officerNote.
Maybe an idea do add it there?
-
Re: [Ascent] Where are my characters?
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.
-
Re: [Ascent] Where are my characters?
I had a similar problem, the fix is just to add the column using SQLyog.
-
Re: [Ascent] Where are my characters?
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?
-
Re: [Ascent] Where are my characters?
-
Re: [Ascent] Where are my characters?
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
-
Re: [Ascent] Where are my characters?
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.
-
Re: [Ascent] Where are my characters?
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
-
Re: [Ascent] Where are my characters?
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
-
Re: [Ascent] Where are my characters?
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
-
Re: [Ascent] Where are my characters?
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
-
Re: [Ascent] Where are my characters?
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
-
Re: [Ascent] Where are my characters?
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?
-
Re: [Ascent] Where are my characters?
-
Re: [Ascent] Where are my characters?
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.
-
Re: [Ascent] Where are my characters?
Yeah, but both ascent and logonserver crash when I start them.
-
Re: [Ascent] Where are my characters?
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.
-
Re: [Ascent] Where are my characters?
What version is the latest?
-
Re: [Ascent] Where are my characters?
As of 04 February 2008, 10:15pm GMT time, 3681 is the latest.
-
Re: [Ascent] Where are my characters?
Wow. Thanks for the fast reply.
-
Re: [Ascent] Where are my characters?
Can you give me a link? I can't find it in the forums.
-
Re: [Ascent] Where are my characters?
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 :)
-
Re: [Ascent] Where are my characters?
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. :)
-
Re: [Ascent] Where are my characters?
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?