yip328
Members-
Posts
33 -
Joined
-
Last visited
Never -
Donations
0.00 GBP
yip328's Achievements
Advanced Member (3/3)
0
Reputation
-
Question regarding this topic. What if I put all the necessary update SQL files in one folder, and do "cat *.sql" to concatenate them into one big SQL file? It worked fine until a few months ago. Yeah, it's a very primitive way of doing it though. Thanks
-
First, you gotta find out which version of Mangos DB you're at. Easiest way, if you're on Linux, install phpmyadmin (GUI for managing database). On Ubuntu, sudo aptitude install phpmyadmin will do the trick. Login, and navigate to Mangos DB and click on "db_version" table. On the right side, you'll see something along the line of "required_####_..._mangos_..." where #### is where you're at. Work up from there. EDIT: ERROR 1054 (42S22) at line 1: Unknown column 'required_8731_01_mangos_creature_template' in 'db_version' means exactly what it says. You need 8731_01_mangos_creature_template.sql before you can import 8749_01_mangos_mail_loot_template.sql.
-
Maybe it's not it, but I see your libACE.so is red. In mine, it's a symlink to libACE-5.6.6.so, and red typically denotes that the link is broken. It may be the cause, but also it may be nothing. Here's my lib folder: jellyb@momserv:~/momd313/r8526/lib$ ll total 5.6M -rwxr-xr-x 1 jellyb jellyb 2.3M 2009-09-22 00:30 libACE-5.6.6.so -rwxr-xr-x 1 jellyb jellyb 970 2009-09-22 00:30 libACE.la lrwxrwxrwx 1 jellyb jellyb 15 2009-09-22 00:30 libACE.so -> libACE-5.6.6.so -rwxr-xr-x 1 jellyb jellyb 1007 2009-09-22 00:30 libmangosscript.la lrwxrwxrwx 1 jellyb jellyb 24 2009-09-22 00:30 libmangosscript.so -> libmangosscript.so.0.0.0 lrwxrwxrwx 1 jellyb jellyb 24 2009-09-22 00:30 libmangosscript.so.0 -> libmangosscript.so.0.0.0 -rwxr-xr-x 1 jellyb jellyb 3.4M 2009-09-22 00:30 libmangosscript.so.0.0.0
-
I'm sorry if I didn't make it clear in my last post. What I meant to say was that if you use characters.sql and realmd.sql, they already include 380, 381, 382 and updates from mangos/sql/updates. So, you don't have to touch those 2 databases after importing them from mangos/sql. Let me know if i'm not making clear this time.
-
But to my understanding, if you take realmd.sql and characters.sql from mangos/sql, you no longer need to update them with anything else including 381 and 382. Correct me if I'm wrong though. The way I figured out was by checking their db_version tables in each of them. Let me know of what you find. I'm not proficient in SQL.
-
Current supported client version is 3.1.3, and that's where you should get maps from. And yes, the guide is a bit outdated: ACID is at 3.0.0. http://www.scriptdev2.com/acid-3-0-t4502.html Dang .. seems like mangos doesn't like you .. Joking aside, I did a little research on your git error, and some people are experiencing similar problems on Jaunty 9.04. But I just tested it, and it went fine on my standalone 9.04 server. jellyb@momserv:~/playground$ git clone git://github.com/mangos/mangos.git Initialized empty Git repository in /home/jellyb/playground/mangos/.git/ remote: Counting objects: 35990, done. remote: Compressing objects: 100% (7052/7052), done. remote: Total 35990 (delta 29093), reused 35778 (delta 28884) Receiving objects: 100% (35990/35990), 28.93 MiB | 301 KiB/s, done. Resolving deltas: 100% (29093/29093), done. Is it specific to your new install? Can you run git on your regular machine?
-
Yeah .. other than those.. I"m really out of ideas... try the 9.04 in a VM first. So that you know it's working before you deploy it to a real server. When I tried it this afternoon, it was in a VM too. In case you wanna reproduce the exact same steps I did, here's how I installed it... (notes of steps that I took.. ask me if any steps doesn't make sense to you): ========================== NOTES ### Updated for Mangos(r8429) and ScriptDev2(r1373) on 2009-08-27 # Lines after "$" are actual commands. # Lines after "#" or "#"s are comments and descriptions. # MANGOS=$HOME/momserv313 # momd313 is where everything Mangos related resides. # myup = mysql -uroot -pmangos ========================== DEPENDENCIES # "sudo aptitude install" the following: build-essential git-core subversion automake libtool zlibc libmysql++-dev \\ libssl-dev unrar p7zip-full pkg-config # If you're used to using apt-get, it's fine too. Just don't mix the two. ========================== II) COMPILING MANGOS AND SCRIPTDEV2 ### Downloading mangos and scriptdev2 sources @$MANGOS/ $ git clone git://github.com/mangos/mangos.git $ svn co [url]http://scriptdev2.svn.sourceforge.net/svnroot/scriptdev2[/url] \\ mangos/src/bindings/ScriptDev2 ### Apply the ScriptDev2 patch to Mangos @$MANGOS/ $ git apply src/bindings/ScriptDev2/patches/MaNGOS-8273-ScriptDev2.patch $ autoreconf --install --force --verbose $ mkdir build && cd build $ export MANGOS=$HOME/momserv313 ### The usual configure; make; make install @$MANGOS/build/ $ ../configure --prefix=$MANGOS/r8429 \\ --sysconfdir=$MANGOS/sysconfdir --datadir=$MANGOS/datadir --enable-cli \\ CXXFLAGS="-march=native -O2 -pipe" CFLAGS="${CXXFLAGS}" $ make -j3 #3:49.7 (i7-920), 9:49 (core2-e6600) $ make install ========================== EDIT: # Package "p7zip-full" is not necessary. # Package "unrar" is to later extract UDB.
Contact Us
To contact us
click here
You can also email us at [email protected]
Privacy Policy | Terms & Conditions
You can also email us at [email protected]
Privacy Policy | Terms & Conditions
Copyright © getMaNGOS. All rights Reserved.
This website is in no way associated with or endorsed by Blizzard Entertainment®
This website is in no way associated with or endorsed by Blizzard Entertainment®