-
[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?
-
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?
-
Re: [Ascent] Where are my characters?
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
-
Re: [Ascent] Where are my characters?
I still get this error even with that:
http://i30.tinypic.com/kar0is.png
-
Re: [Ascent] Where are my characters?
Then it's not your database, it's the repack's fault.
Get the real version of ascent, it's stickied in this forum.
-
Re: [Ascent] Where are my characters?
dont worry about that. just keep going. Just keep execing all the sql tihngs. i had the same prob
-
Re: [Ascent] Where are my characters?
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?
-
Re: [Ascent] Where are my characters?
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.
-
Re: [Ascent] Where are my characters?
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?
-
Re: [Ascent] Where are my characters?
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.
-
Re: [Ascent] Where are my characters?
So anyone know how to stop the DCing when I make a character?
-
Re: [Ascent] Where are my characters?
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.
-
Re: [Ascent] Where are my characters?
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
-
Re: [Ascent] Where are my characters?
ascent rev3681 is now on the sticky forum :) sorry i took some time, but was working ;)
-
Re: [Ascent] Where are my characters?
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.
-
Re: [Ascent] Where are my characters?
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.
-
Re: [Ascent] Where are my characters?
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"?
-
Re: [Ascent] Where are my characters?
-
Re: [Ascent] Where are my characters?
-
Re: [Ascent] Where are my characters?
I'm guessing you meant to say more, Cody.
-
Re: [Ascent] Where are my characters?