OregonCore, SQL ERROR when starting Oregon-Core.exe

[Henka44]

Hello!

Me being a complete EMU noob, i have now come to this forum to try and get some help with getting my server up and running, i have come to the point in the OregonCore Wiki were it tells me

• Double-click the oregon-realm program. This will start the authentication server. You should see Added realm "YourRealmName" in the console output.

• Double-click the oregon-core program. This will start the world server. You will see a lot of output in this console as the core loads the various required data. The server is ready to use when you see WORLD: World initialized in the console output.

and my Oregon-realm starts up fine and says that it added my realm, but when i come to start Oregon-core the program just flashes, so i went to see if i could find something usefull in `Server.log´ and this is what i found.
Now this doesnt make much sense to me since im the noob i am, so i was wondering if someone more experienced could help me out with this please, and its not a matter of being lazy at all, ive been trying with different Emu's and repacks and what not for a good 10 hours minimum and now i hit a wall and need help.

2011-11-0916:51:42MySQL client library:5.5.9
2011-11-0916:51:42MySQL server ver:5.1.59-community
2011-11-0916:51:42MySQL client library:5.5.9
2011-11-0916:51:42MySQL server ver:5.1.59-community
2011-11-0916:51:42MySQL client library:5.5.9
2011-11-0916:51:42MySQL server ver:5.1.59-community
2011-11-0916:51:42Realm running as realm ID 1
2011-11-0916:51:42 ERROR: SQL: SELECT db_version FROM version LIMIT 1
2011-11-0916:51:42 ERROR: query ERROR:Table'world.version' doesn't exist
2011-11-09 16:51:42 Using World DB: unknown world database
2011-11-09 16:51:42 ERROR: SQL: UPDATE version SET core_version = 'OregonCoreRev:0Hash:Archive(Win64,little-endian)', core_revision = '0'
2011-11-09 16:51:42 Will clear `logs` table of entries older than 1209600 seconds every 10 minutes.
2011-11-09 16:51:42 ERROR: SQL ERROR: Table 'world.version' doesn't exist
2011-11-0916:51:42UsingDataDir C:\OregonCore\Data/
2011-11-0916:51:42 WORLD:VMap support included.LineOfSight:1, getHeight:1, indoorCheck:0,PetLOS:1
2011-11-0916:51:42 WORLD:VMap data directory is: C:\OregonCore\Data/vmaps
2011-11-0916:51:42 ERROR: SQL: SELECT MAX(guid) FROM gameobject
2011-11-0916:51:42 ERROR: query ERROR:Table'world.gameobject' doesn't exist
2011-11-09 16:51:43
2011-11-09 16:51:43 Loading Oregon strings...
2011-11-09 16:51:43 ERROR: SQL: SELECT entry,content_default,content_loc1,content_loc2,content_loc3,content_loc4,content_loc5,content_loc6,content_loc7,content_loc8 FROM oregon_string
2011-11-09 16:51:43 ERROR: query ERROR: Table 'world.oregon_string' doesn't exist
2011-11-0916:51:43
2011-11-0916:51:43 ERROR:>>Loaded0Oregon strings. DB table oregon_string is empty.Cannotcontinue.

[kainevona]

It appears that either you didn't install a world database, or you didn't apply the sql updates from the Oregon Core sql folder.

[Henka44]

Yea something is wrong, i get ALOT of errors when i execute all the SQL's so i tryed SQLyog instead of Navicat but its the same there, it gives alot of errors and then stops executing were that error occured.

Here are two examples of errors i get.

"Query:
ALTER TABLE account DROP COLUMN online
Error occured at:2011-11-10 05:13:32
Line no.:1
Error Code: 1091 - Can't DROP 'online'; check that column/key exists"

Error occured at:2011-11-1005:15:45
Lineno.:2
ErrorCode:1060-Duplicate column name 'realmbuilds'

EDIT: Ok, so i came past those errors, but now when i start Oregone-realm.exe it says "ERROR: No valid realms specified."
and i have changed name to "test" and adress to "192.168.0.3" in the realmlist table in realmd database, did i do something wrong :S ?

[ferozagr]

Drop all of your databases and reinstall them the right way using their updates as well. Use their wiki guide in order to do it. From my point of view seems that you dont have a proper realm db, but guessing you did a wrong installation at realm, prolly you did wrong with characters and world which are way bigger in size.