[ZERO] Error BD

[minatohd]

2013-04-07 05:34:30 SQL: SELECT required_z2330_sxxxx_xxxxx_01_mangos_spell_proc_event FROM db_version LIMIT 1
2013-04-07 05:34:30 query ERROR: Unknown column 'required_z2330_sxxxx_xxxxx_01_mangos_spell_proc_event' in 'field list'
2013-04-07 05:34:30 The table `db_version` in your [WORLD] database indicates that this database is out of date!
2013-04-07 05:34:30
2013-04-07 05:34:30   [A] You have: --> `z2268_s1900_12370_02_mangos_npc_vendor_template.sql`
2013-04-07 05:34:30
2013-04-07 05:34:30   [b] You need: --> `z2330_sxxxx_xxxxx_01_mangos_spell_proc_event.sql`
2013-04-07 05:34:30
2013-04-07 05:34:30 You must apply all updates after [A] to [b] to use mangos with this database.
2013-04-07 05:34:30 These updates are included in the sql/updates folder.
2013-04-07 05:34:30 Please read the included [README] in sql/updates for instructions on updating.
~

In addition to this error, how is that mangoes are running? Does it come as a process?

[antz]

on windows both the world process (mangosd.exe) and realm process (realmd.exe) need to be running

- By default they run as applications, but have optional switches so they can be made to run as a service

[Christian Schamara]

https://github.com/mangoszero/server/tree/master/sql/updates

[minatohd]

on windows both the world process (mangosd.exe) and realm process (realmd.exe) need to be running

- By default they run as applications, but have optional switches so they can be made to run as a service

ubuntu server, sorry. :SS

And thanks for that update.

[Christian Schamara]

wehn you need help for update check 2013-04-07 05:34:30

Please read the included [README] in sql/updates for instructions on updating.

[minatohd]

Realmd runs well. but mangosd falls.

Server.log:

013-04-07 06:57:34 MaNGOS Zero/ (* * Revision 2346 - *) for Linux_x64 (little-endian) [world-daemon]
2013-04-07 06:57:34 <Ctrl-C> to stop.
2013-04-07 06:57:34

MM   MM         MM   MM  MMMMM   MMMM   MMMMM
MM   MM         MM   MM MMM MMM MM  MM MMM MMM
MMM MMM         MMM  MM MMM MMM MM  MM MMM
MM M MM         MMMM MM MMM     MM  MM  MMM
MM M MM  MMMMM  MM MMMM MMM     MM  MM   MMM
MM M MM M   MMM MM  MMM MMMMMMM MM  MM    MMM
MM   MM     MMM MM   MM MM  MMM MM  MM     MMM
MM   MM MMMMMMM MM   MM MMM MMM MM  MM MMM MMM
MM   MM MM  MMM MM   MM  MMMMMM  MMMM   MMMMM
       MM  MMM [url]http://getmangos.eu[/url]
       MMMMMM


2013-04-07 06:57:34 Using configuration file /opt/mangos-server/etc/mangosd.conf.
2013-04-07 06:57:34 World Database total connections: 2
2013-04-07 06:57:34 MySQL client library: 5.5.29
2013-04-07 06:57:34 MySQL server ver: 5.5.29-0ubuntu0.12.04.2
2013-04-07 06:57:34 MySQL client library: 5.5.29
2013-04-07 06:57:34 MySQL server ver: 5.5.29-0ubuntu0.12.04.2
2013-04-07 06:57:34 Character Database total connections: 2
2013-04-07 06:57:34 MySQL client library: 5.5.29
2013-04-07 06:57:34 MySQL server ver: 5.5.29-0ubuntu0.12.04.2
2013-04-07 06:57:34 MySQL client library: 5.5.29
2013-04-07 06:57:34 MySQL server ver: 5.5.29-0ubuntu0.12.04.2
2013-04-07 06:57:34 Login Database total connections: 2
2013-04-07 06:57:34 MySQL client library: 5.5.29
2013-04-07 06:57:34 MySQL server ver: 5.5.29-0ubuntu0.12.04.2
2013-04-07 06:57:34 MySQL client library: 5.5.29
2013-04-07 06:57:34 MySQL server ver: 5.5.29-0ubuntu0.12.04.2
2013-04-07 06:57:34 Realm running as realm ID 1
2013-04-07 06:57:34 Using World DB: ZeroDatabase 2.0.5 for MaNGOSZero z2293+ and ScriptDevZero z2639+

Char.log, DBErrors.log and EventAiErrors are empty.

I run with these commands:

mangos-world:

#!/bin/sh
cd /opt/mangos-server/bin
screen -A -m -d -S mangosworld ./mangosd
mangos-realm:

#!/bin/sh
cd /opt/mangos-server/bin
screen -A -m -d -S mangosrealm ./realmd

[Christian Schamara]

Char.log, DBErrors.log and EventAiErrors are empty.

thats is good than you have not errors=)

[minatohd]

maps, vmaps and dbc.

Serve the windows to ubuntu?

[antz]

yes, copy all these to the server in the location you have in your .conf files

[minatohd]

yes, copy all these to the server in the location you have in your .conf files

Check existing of map file './maps/0004331.map': not exist!
Correct *.map files not found in path './maps' or *.vmtree/*.vmtile files in './vmaps'. Please place *.map and vmap files in appropriate directories or correct the DataDir value in the mangosd.conf file.
root@vps23549:/opt/mangos-server/bin#

DataDir = "."

I have maps, vmaps and dbc in the directory where the configuration files are

[minatohd]

yes, copy all these to the server in the location you have in your .conf files

Check existing of map file './maps/0004331.map': not exist!
Correct *.map files not found in path './maps' or *.vmtree/*.vmtile files in './vmaps'. Please place *.map and vmap files in appropriate directories or correct the DataDir value in the mangosd.conf file.
root@vps23549:/opt/mangos-server/bin#

DataDir = "."

I have maps, vmaps and dbc in the directory where the configuration files are

Help me pls!!!

[Christian Schamara]

way nothing here read the config file ?

# DataDir

# Data directory setting.

# Important: DataDir needs to be quoted, as it is a string which may contain space characters.

# Example: "@CMAKE_INSTALL_PREFIX@/share/mangos"

under linux you must make the full path of the folder

DataDir = "/home/root/mangos-zero/data/" for example

[minatohd]

way nothing here read the config file ?

# DataDir

# Data directory setting.

# Important: DataDir needs to be quoted, as it is a string which may contain space characters.

# Example: "@CMAKE_INSTALL_PREFIX@/share/mangos"

under linux you must make the full path of the folder

DataDir = "/home/root/mangos-zero/data/" for example

Sorry to be so annoying, but not working

[minatohd]

T_T