codeman3518 Posted September 10, 2015 Report Share Posted September 10, 2015 Does anyone have the server or a link that matches the sql full 6.x when it came out because the updates are giving so many errors it would be easier to have the server matching the MySQL right at the same version so I don't have to do any updates but the base and run it but without it gives me errors. Thanks for any help. Link to comment Share on other sites More sharing options...
Nay Posted September 10, 2015 Report Share Posted September 10, 2015 Import TDB_full_world_6.02_2015_07_14.sql into an empty DB and then all the .sql files in /sql/updates/world. It's that simple. Link to comment Share on other sites More sharing options...
Shin Posted September 10, 2015 Report Share Posted September 10, 2015 or use the Naios automatic DB updater and you won't have to manually import all .sql files of /sql/updates/world folder. Link to comment Share on other sites More sharing options...
codeman3518 Posted September 10, 2015 Author Report Share Posted September 10, 2015 (edited) cool thanks guys sounds like a plan. Edited September 11, 2015 by codeman8214 Link to comment Share on other sites More sharing options...
codeman3518 Posted September 11, 2015 Author Report Share Posted September 11, 2015 Okay I did the full 6.x and did all the updates and still get In mysql_stmt_prepare() id: 22, sql: "INSERT INTO waypoint_data (id, point, position_x, position_y, position_z) VALUES (?, ?, ?, ?, ?)"Table 'world.waypoint_data' doesn't existIn mysql_stmt_prepare() id: 23, sql: "DELETE FROM waypoint_data WHERE id = ? AND point = ?"Table 'world.waypoint_data' doesn't existIn mysql_stmt_prepare() id: 24, sql: "UPDATE waypoint_data SET point = point - 1 WHERE id = ? AND point > ?"Table 'world.waypoint_data' doesn't existIn mysql_stmt_prepare() id: 25, sql: "UPDATE waypoint_data SET position_x = ?, position_y = ?, position_z = ? where id = ? AND point = ?"Table 'world.waypoint_data' doesn't existIn mysql_stmt_prepare() id: 26, sql: "UPDATE waypoint_data SET wpguid = ? WHERE id = ? and point = ?"Table 'world.waypoint_data' doesn't existIn mysql_stmt_prepare() id: 27, sql: "UPDATE waypoint_data SET wpguid = 0"Table 'world.waypoint_data' doesn't existIn mysql_stmt_prepare() id: 44, sql: "INSERT INTO waypoint_scripts (guid) VALUES (?)"Table 'world.waypoint_scripts' doesn't existIn mysql_stmt_prepare() id: 45, sql: "DELETE FROM waypoint_scripts WHERE guid = ?"Table 'world.waypoint_scripts' doesn't existIn mysql_stmt_prepare() id: 46, sql: "UPDATE waypoint_scripts SET id = ? WHERE guid = ?"Table 'world.waypoint_scripts' doesn't existIn mysql_stmt_prepare() id: 47, sql: "UPDATE waypoint_scripts SET x = ? WHERE guid = ?"Table 'world.waypoint_scripts' doesn't existIn mysql_stmt_prepare() id: 48, sql: "UPDATE waypoint_scripts SET y = ? WHERE guid = ?"Table 'world.waypoint_scripts' doesn't existIn mysql_stmt_prepare() id: 49, sql: "UPDATE waypoint_scripts SET z = ? WHERE guid = ?"Table 'world.waypoint_scripts' doesn't existIn mysql_stmt_prepare() id: 50, sql: "UPDATE waypoint_scripts SET o = ? WHERE guid = ?"Table 'world.waypoint_scripts' doesn't existMaybe 3.3.5 is more complete because got some errors with the updates. Link to comment Share on other sites More sharing options...
Recommended Posts