PlaneShift

Development => Development Deliberation => Topic started by: zanz on November 09, 2006, 11:56:13 pm

Title: Having trouble getting the server running
Post by: zanz on November 09, 2006, 11:56:13 pm

I am finally getting back to trying to get my planeshift server running and have run into a snag.  I have gotten everything compiled without error and got the MySQL database created, but when i run psserver I am getting the following error:

Couldn't determine database version.  Error was Table 'planeshift.server_options' doesn't exist.

I logged into mysql and indeed there is no table called server_options.  Here is the list of tables in the planeshift database that ARE listed:

+----------------------------+
| Tables_in_planeshift       |
+----------------------------+
| accessrules                |
| action_locations           |
| alliances                  |
| bad_names                  |
| bans                       |
| char_create_affinity       |
| char_create_life           |
| char_create_life_relations |
| character_advantages       |
| character_creation         |
| character_quests           |
| character_relationships    |
| character_skills           |
| character_traits           |
| characters                 |
| command_group_assignment   |
| command_groups             |
| common_strings             |
| factions                   |
| familiar_types             |
| gm_command_log             |
| guildlevels                |
| guilds                     |
| hunt_locations             |
| item_animations            |
| loot_modifiers             |
| loot_rule_details          |
| loot_rules                 |
| merchant_item_categories   |
| migration                  |
| movement_modes             |
| movement_types             |
| natural_resources          |
| npc_disallowed_words       |
| npc_knowledge_areas        |
| npc_responses              |
| npc_spawn_ranges           |
| npc_spawn_rules            |
| npc_synonyms               |
| npc_trigger_groups         |
| npc_triggers               |
| petitions                  |
| player_spells              |
| progression_events         |
| quest_scripts              |
| quests                     |
| race_info                  |
| sc_npc_definitions         |
| sc_waypoint_links          |
| sc_waypoints               |
| sectors                    |
| security_levels            |
| skills                     |
| spell_glyphs               |
| spells                     |
| tips                       |
| trade_autocontainers       |
| trade_combinations         |
| trade_constraints          |
| trade_patterns             |
| trade_transformations      |
| trainer_skills             |
| traits                     |
| tribe_members              |
| tribes                     |
| ways                       |
+----------------------------+


Am I missing a step somewhere?  Any help would be greatly appreciated.
-=ZanZ=-

Title: Re: Having trouble getting the server running
Post by: ThomPhoenix on November 10, 2006, 12:07:54 am

It means that the database wasn't correctly created.
Just do a new source create_all.sql and see what happens.
Also make sure you have a correct checkout, the server_options.sql file should be located in \src\server\database\mysql\

If that doesn't work, visit the IRC channel #planeshift-build on Freenode and ask there.