Printable View
SQL: DELETE FROM `ip_banned` WHERE `unbandate`<=UNIX_TIMESTAMP() AND `unbandate`
<>`bandate`
SQL ERROR: Unknown column 'unbandate' in 'where clause'
SQL: SELECT `bandate`,`unbandate` FROM `account_banned` WHERE `id` = 1 AND `acti
ve` = 1 AND (`bandate`=`unbandate` OR `unbandate`>UNIX_TIMESTAMP())
query ERROR: Table 'realmd.account_banned' doesn't exist
how i fix this?
Found out that error is cause by haveing a charactor over level 70 for some reason it just dont calculate the stats correctly. Just dont open your charactor page while you have your level 255 and youll be fine.Quote:
Originally Posted by atezeroate
alright got everything sorted, got mangos up, ran about had some fun but only i can connect?
how do i make it public so other people can join? My friend reported his game stuck at 'logging into game server' after selecting the realm.
my realmlist in realmd db has the address set to 192.168.0.4 and my realm list is set to my WAN ip address.
any idea?
Any help is really appreciated.
I checked the DBErrors.log and i found the following errors. If someone can help I'll apreciate it.
2007-06-07 08:09:34 Some items can't be succesfully looted: not exist or have in chance field value < 0.000001 with quest chance ==0 in `creature_loot_template` DB table . List:
loot entry = 18805 item = 29981 mincount = 1 maxcount = 1 (not exist)
loot entry = 18805 item = 29977 mincount = 1 maxcount = 1 (not exist)
loot entry = 18805 item = 29951 mincount = 1 maxcount = 1 (not exist)
loot entry = 18728 item = 0 mincount = 1 maxcount = 1 (not exist)
loot entry = 18805 item = 30446 mincount = 1 maxcount = 1 (not exist)
loot entry = 18805 item = 29950 mincount = 1 maxcount = 1 (not exist)
loot entry = 18805 item = 30449 mincount = 1 maxcount = 1 (not exist)
loot entry = 18805 item = 29976 mincount = 1 maxcount = 1 (not exist)
Thank u
mapeto: you can just ignore that error... on other hand you can remove it if you REALLY want, but this is nothing to be worried about, I think it's the items that are missing in the item_template table
Eroa: Go HERE
Deathtonoobs: you need a working database for your version, easiest if you figure out how to import mine, but if you don't want to do that,
you can EASILY fix it by getting the source and finding the mangos sql to import, and import table by table that you need...
you can fix it with more difficulty by observing the errors and directly editing your database (if you don't get it from what you posted, you can't really do this)
There's no other way to fix it.
Quote:
Originally Posted by Eroa
your outside friends should connect to your outside address and the realmlist ip in the realm bd is the one to change to your outside address.
path of communication:
you start game, it asks to realm server what realms {game server} are avail, most servers would have only one, then the realm server points you to the game server, could be different computer could be same...thats where the outside address comes in to play.
if its pointing to an inside address {192.168.x.x or 127.0.0.1} then when it tells the players to connect to game at that address there looking to their computer and no connect, again this is where your outside ip address come into play.
if pointing to outside address then the game client connects to the game server at your outside address being passed through your router to the correct ip of the computer running server...and everyone should be happy...
hope this answers a few questions...i know i had this same issue for a few days till i got the 3 ip's figured out
oh and dont forget the router or firewall...iv got 3306, 3724, 8080-8085 80,85 forwarded to my servers ip address, some are for web server and other things but you get the idea
got it sorted, had some dodgy router port forwarding, thanks both you guys.Quote:
Originally Posted by lbvagrant
link is working fine for me?. Anyways.. In case you still don't have it, I uploaded it to rapidshare..Quote:
Originally Posted by Virii
:juggle:
RapidShare: 1-Click Webhosting
Here you can Find the
[Mangos] 2.0.12 Silvermoon rev 6 Newest
http://forum.ragezone.com/2315324-post1.html
PS:8 more days and my main account will be unbanned yeah its me Inkredibil
Quote:
Originally Posted by OSP
are you telling me i need to install firefox to download this file?
is there another link to the server files?
Im having trouble getting this eady to make a server, can someone link a more descriptive guide plz....?
There is no other link .Quote:
Originally Posted by lbvagrant
I'm having a spot of trouble with making a character, my server loads up fine and such but when i sign in on any account and go to create a char, once i've made him and all and click create it just sends me back to a blank character selection screen. Anyone know how to fix this?
I found a guide but nw im stuck again >_< Anyone know what to do if it says can not validate server, ive tried everything i can think of
Quote:
Originally Posted by Eroa
Double check and make sure you don't have any errors in the config file.. I had one where I used a ' in a name for my server, that left an unquoted string and tossed the parsing of the file, then reported the file wasn't there (instead of reporting bad file).. I had to escape the single tic (with \' ) so it would parse right.. Now my MOTD is "Welcome to Savant\'s cRaZY WuRLdZ".. loads fine ;)
Quote:
Originally Posted by MrPink
is this an upgrade? are you transfering chars?
reason i ask is i had same issue and found that version i was useing didnt have a "rename" setion in the charctors table in the mangos db
added that line and all my old and new chars showed up...
info added was rename / tinyinit / 1 not sure on grammer of telling what to go where but there it is...
my seperate question is i got everything to transfer over minus a few gm island gear and mounts...
but the bigest issue was pets no longer worked...couldnt stable them or dismiss without loseing them...is this normal or known?
wasent this way in current server...{went back to old for this reason}- Mangos: rev.3552 Using DB: Project Silvermoon + Fixpack1.02 +SDB rev.172
looking for best way to upgrade to 2.1.XX with least amout of loss and trouble...
new items i'm able to handle but skills and pets are a must...
if this build is spost to be pet friendly please let me know where to look to fix this issue...thnx
keep up the most exelent work guy's
i have problem where can help me pls
2007-06-13 08:26:52 Realm running as realm ID 1
2007-06-13 08:26:52 Using DataDir ./
2007-06-13 08:26:52 Initialize data stores...
2007-06-13 08:26:52
2007-06-13 08:26:52 >> Loaded 28 data stores
2007-06-13 08:26:52
2007-06-13 08:26:52 Loading Game Object Templates...
2007-06-13 08:26:53 ERROR:Error in `gameobject_template` table, probably sql file format was updated (there should be 18 fields in sql).
I cannot login with WoW Client 2.1.0...
Unvable Client
Can anyone help me? Appreciated.
I did everything, even updated the DB to rev6... now it works... but the BC chars (blood elfs draenei) doesnt work... can someone help?
with 10 mins of google I got rev 6 on its own
Filebeam - Free Fast File Hosting
All characters I create on my server have no skills and 0 of 0 experience. I also can't use GM commands with them, or at all. Any idea what my problem is?
Hi I have istalled it all right and bla bla bla.... my mangos restarter is working and so on. But when i try to login WoW is saying it cant varify the gameversion :/
Do u think i need to downgrade from 2.1.1 to 2.1.0 ? (or maby i should just repare wow.. hmmm)
sand a messege to me if u got the answer thx :D
Btw sry for my bad English ;)
---------------------------------
I have fixed this on my own now and it were wrong with thw realmd.exe and .conf
OBS! if u are going to use this emu with patches over 2.1.0 (exampel 2.1.1) u cant send any messanges... (and probebly dont invite) This mangos emu is ony good at one thing : it have BG!! othervise it realy SUCKS!
Silvermoon database rev 7 was released now few days .
What MangOS release should i use with Silvermoon database rev. 7?