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.
I think I may have fixed this by manually removing the invalid sql in the dump filCode: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]
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


Reply With Quote

