I need a little assistance please

Results 1 to 1 of 1
  1. #1
    Newbie SithLord2K is offline
    MemberRank
    Jan 2008 Join Date
    1Posts

    I need a little assistance please

    I updated my server last night. I'm currently using Ascent 3472 with NCDB 1025. Everything went ok for the most part. But anytime I start the server up I get an SQL error that a table doesn't exist. First I was getting this with the logonserver but I was able to fix that by adding the column into the database manually

    Now i'm getting one from the ascent.exe.

    Code:
    Sql query failed due to [Table 'world.item_randomprop_groups' doesn't exist], Qu
    ery: [SELECT * FROM item_randomprop_groups]
    Sql query failed due to [Table 'world.item_randomsuffix_groups' doesn't exist],
    Query: [SELECT * FROM item_randomsuffix_groups]
    I think I may have fixed this by manually removing the invalid sql in the dump fil

    So what I have done is locate this in the sql updates files and I did find it but when I went to added it into the database I get an sql syntax error. It seems to no like the line for ENGINE=myisam

    Unfortunatly I don't know alot about SQL Syntax and would appreciate any help that can be provided.

    I got the SQL Syntax thing fixed but now I'm not able to login, when I try it gets to connecting on the game and hangs there, the server screens don't even show the login
    Last edited by SithLord2K; 27-01-08 at 07:31 PM. Reason: I think I got it fixed




Advertisement