[Ascent] Where are my characters?

Page 1 of 2 12 LastLast
Results 1 to 25 of 45
  1. #1
    Member Vereux0 is offline
    MemberRank
    Feb 2008 Join Date
    32Posts

    [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:


  2. #2
    Sorcerer Supreme aceindy is offline
    Member +Rank
    Jun 2006 Join Date
    322Posts

    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?

  3. #3
    Member Raptress is offline
    MemberRank
    Jan 2008 Join Date
    49Posts

    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.

  4. #4
    Newbie auswa100 is offline
    MemberRank
    Feb 2008 Join Date
    1Posts

    Re: [Ascent] Where are my characters?

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

  5. #5
    Member Vereux0 is offline
    MemberRank
    Feb 2008 Join Date
    32Posts

    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?
    Last edited by Vereux0; 02-02-08 at 06:34 PM.

  6. #6
    Member Vereux0 is offline
    MemberRank
    Feb 2008 Join Date
    32Posts

    Re: [Ascent] Where are my characters?

    Bump.

  7. #7
    Elite Member myil is offline
    Member +Rank
    Jan 2008 Join Date
    173Posts

    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

  8. #8
    Grand Master rr2739 is offline
    Grand MasterRank
    Nov 2007 Join Date
    Your BIOSLocation
    562Posts

    Re: [Ascent] Where are my characters?

    Quote Originally Posted by Vereux0 View Post
    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:
    U USING 2456 REVISION, ANSD EXECUTING FILES FROM OLDER updates

    SIMPLY EXECUTE UPDATES THAT CORRESPOND TO YOUR REVISIONS.

  9. #9
    Grand Master rr2739 is offline
    Grand MasterRank
    Nov 2007 Join Date
    Your BIOSLocation
    562Posts

    Re: [Ascent] Where are my characters?

    Quote Originally Posted by myil View Post
    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

  10. #10
    Grand Master rr2739 is offline
    Grand MasterRank
    Nov 2007 Join Date
    Your BIOSLocation
    562Posts

    Re: [Ascent] Where are my characters?

    Quote Originally Posted by Vereux0 View Post
    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

  11. #11
    Grand Master rr2739 is offline
    Grand MasterRank
    Nov 2007 Join Date
    Your BIOSLocation
    562Posts

    Re: [Ascent] Where are my characters?

    Quote Originally Posted by aceindy View Post
    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

  12. #12
    Member Vereux0 is offline
    MemberRank
    Feb 2008 Join Date
    32Posts

    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:

  13. #13
    Grand Master rr2739 is offline
    Grand MasterRank
    Nov 2007 Join Date
    Your BIOSLocation
    562Posts

    Re: [Ascent] Where are my characters?

    Quote Originally Posted by Vereux0 View Post
    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:
    check my sig and your problem solved forever

  14. #14
    Member Vereux0 is offline
    MemberRank
    Feb 2008 Join Date
    32Posts

    Re: [Ascent] Where are my characters?

    Quote Originally Posted by rr2739 View Post
    check my sig and your problem solved forever
    OK. I downloaded it, but now this happens in logonserver:


    and realmserver:

    "moocow"? How do I change it to admin?

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

  15. #15
    Member Vereux0 is offline
    MemberRank
    Feb 2008 Join Date
    32Posts

    Re: [Ascent] Where are my characters?

    Bump.

  16. #16
    Member Cody900 is offline
    MemberRank
    Feb 2008 Join Date
    76Posts

    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.

  17. #17
    Member Vereux0 is offline
    MemberRank
    Feb 2008 Join Date
    32Posts

    Re: [Ascent] Where are my characters?

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

  18. #18
    Member Cody900 is offline
    MemberRank
    Feb 2008 Join Date
    76Posts

    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.

  19. #19
    Member Vereux0 is offline
    MemberRank
    Feb 2008 Join Date
    32Posts

    Re: [Ascent] Where are my characters?

    What version is the latest?

  20. #20
    Member Cody900 is offline
    MemberRank
    Feb 2008 Join Date
    76Posts

    Re: [Ascent] Where are my characters?

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

  21. #21
    Member Vereux0 is offline
    MemberRank
    Feb 2008 Join Date
    32Posts

    Re: [Ascent] Where are my characters?

    Wow. Thanks for the fast reply.

  22. #22
    Member Vereux0 is offline
    MemberRank
    Feb 2008 Join Date
    32Posts

    Re: [Ascent] Where are my characters?

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

  23. #23
    Sorcerer Supreme rasta-raus is offline
    Member +Rank
    May 2007 Join Date
    297Posts

    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 :)

  24. #24
    Member Cody900 is offline
    MemberRank
    Feb 2008 Join Date
    76Posts

    Re: [Ascent] Where are my characters?

    Quote Originally Posted by Vereux0 View Post
    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. :)

  25. #25
    Member Vereux0 is offline
    MemberRank
    Feb 2008 Join Date
    32Posts

    Re: [Ascent] Where are my characters?

    Quote Originally Posted by rasta-raus View Post
    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:


    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?



Page 1 of 2 12 LastLast

Advertisement