Rumor

SYSERR: Feb 17 20:04:01 :: socket_bind: bind: Address already in use You have the server already running. Try turning off the server with kill. type "ps" Find the process IDs of the metin2 server then do this kill -s 9 31454 31456 31458 31449 where those numbers = the process IDs SYSERR: Feb 17 20:04:20 :: __GetAdminInfo: __GetAdminInfo() ==> DirectQuery failed(SELECT mID,mAccount,mName,mContactIP,mServerIP,mAuthority FROM gmlist WHERE mServerIP='ALL' or mServerIP='IP.IP.IP.IP') Use this SQL query to fix that error: /* Navicat MySQL Data Transfer Source Server : Metin2Nirvana@CloudCom Source Server Version : 50616 Source Host : Source Database : common Target Server Type : MYSQL Target Server Version : 50616 File Encoding : 65001 Date: 2014-02-17 13:13:50 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for `gmlist` -- ---------------------------- DROP TABLE IF EXISTS `gmlist`; CREATE TABLE `gmlist` ( `mID` int(10) unsigned NOT NULL AUTO_INCREMENT, `mAccount` varchar(32) CHARACTER SET big5 NOT NULL DEFAULT '', `mName` varchar(32) CHARACTER SET big5 NOT NULL DEFAULT '', `mContactIP` varchar(16) CHARACTER SET big5 NOT NULL DEFAULT '', `mServerIP` varchar(16) CHARACTER SET big5 NOT NULL DEFAULT 'ALL', `mAuthority` enum('IMPLEMENTOR','HIGH_WIZARD','GOD','LOW_WIZARD','PLAYER') CHARACTER SET big5 DEFAULT 'PLAYER', PRIMARY KEY (`mID`) ) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1; -- ---------------------------- -- Records of gmlist -- ---------------------------- though that could be an error caused by the database port being in use already..

[Hidden Content] and [Hidden Content]

You haven't really explained what the issue is or provided any kind of errors. Nobody can help you if they don't know what the problem is :/

Another idea of something to fix: the crash that happens when you "/reload q".

you could make a cronjob for this but it's better to fix your problem instead of leaving it broken and causing data loss.

Are you referring to a script that will automatically start the channel again after it has crashed?

check if mysql is running: service mysql-server status If it isn't running, start it: service mysql-server start Did you make sure the CONFIG files have the correct username/password to connect to the database? Also have you granted privileges to the user?

I looked but I'm not really experienced in this sorry

/* Navicat MySQL Data Transfer Source Server : Metin2Nirvana@CloudCom Source Server Version : 50616 Source Host : Source Database : common Target Server Type : MYSQL Target Server Version : 50616 File Encoding : 65001 Date: 2014-02-17 07:54:27 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for `locale` -- ---------------------------- DROP TABLE IF EXISTS `locale`; CREATE TABLE `locale` ( `mKey` varchar(255) NOT NULL DEFAULT '', `mValue` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`mKey`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- ---------------------------- -- Records of locale -- ---------------------------- INSERT INTO `locale` VALUES ('SKILL_POWER_BY_LEVEL_TYPE0', '0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125'); INSERT INTO `locale` VALUES ('SKILL_POWER_BY_LEVEL_TYPE1', '0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125'); INSERT INTO `locale` VALUES ('SKILL_POWER_BY_LEVEL_TYPE2', '0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125'); INSERT INTO `locale` VALUES ('SKILL_POWER_BY_LEVEL_TYPE3', '0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125'); INSERT INTO `locale` VALUES ('SKILL_POWER_BY_LEVEL_TYPE4', '0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125'); INSERT INTO `locale` VALUES ('SKILL_POWER_BY_LEVEL_TYPE5', '0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125'); INSERT INTO `locale` VALUES ('SKILL_POWER_BY_LEVEL_TYPE6', '0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125'); INSERT INTO `locale` VALUES ('SKILL_POWER_BY_LEVEL_TYPE7', '0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125'); INSERT INTO `locale` VALUES ('LOCALE', 'singapore'); INSERT INTO `locale` VALUES ('DB_NAME_COLUMN', 'locale_name'); INSERT INTO `locale` VALUES ('SKILL_DAMAGE_BY_LEVEL_UNDER_90', '0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0'); INSERT INTO `locale` VALUES ('SKILL_DAMAGE_BY_LEVEL_UNDER_45', '0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0'); INSERT INTO `locale` VALUES ('SKILL_POWER_BY_LEVEL', '0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125'); Run this query

Take a look in your files for the country name in the locale folder: Make sure this is the same name when you check the database:

Next time you should make a reply instead of editing your original post. Now anyone who comes will be confused why we are talking about something unrelated to the original post. Now for your new problem.. Here's the data folder: [Hidden Content] Don't forget to make sure you have a symlink to the data folder inside the channel folder. For the regen_load error: If you're using the 2013 files the database won't be modified if you add values into mob_proto using Navicat. You need to edit the mob_proto.txt and mob_names.txt files in your server files.

Yes, you're missing the libs. Try this: fetch [Hidden Content] tar Jxpvf lib.tar.gz -C / rm lib.tar.gzThen try starting the server

It looks like something is missing that allows the game to be launched at all. You could try this.. 1) go to where your metin channels are.. 2) cd channel1/first && ./game &3) After it's done sending text in PuTTy do CTRL+C. You should see some output when starting the server this way.

does that fix ALL negative XP issues? from players who are leveling up and get negative XP for example?

Loving that command log functionality, 6/7, and testmode protection.

When you start with this script, it doesn't show you all the start data like how most admins of pservers are used to. The cores are launched in vrunner. Type "ps" to see what's running. Here's an example of how to move the files in PuTTy, assuming that /home/metin2 is the directory where your files currently are. mv /home/metin2 /usr/home mv = move/home/metin2 = current directory you wish to move /usr/home = directory you want to move the entire "metin2" folder to The libs don't belong in that directory. For a 32-bit system they belong in /usr/lib32. [Hidden Content]

yeah looks normal by the way, cd means change directory, you don't need to do it every time you want to stay in the same folder before doing another command.

I figured it out.. . the other day the item_proto.txt had the incorrect data for demi-human on the yellow dragon slayer so I fixed it. Today I looked in the itemproto thinking that maybe there is something set wrong there like an out-of-place character or whatever.. I saw that there was 3170-3179 then another section in the txt file with 3179 again. The stupidest parts of all of this: 1) I never added an extra line of data to another random part of the file with the same vnum,. 2) When viewing the item_proto table, it showed the correct entry of the 3179 item rather than the bugged one, but in-game it was using the bugged one.

yea players get negative xp from this item in my server too

any ideas to fix this weird bug?

when 9011.chat."Wedding announce" with pc.is_married() and marriage.in_my_wedding() begin if pc.getqf("wedding_announce_time") < get_time() then local old_vid = pc.get_vid() local u_vid = marriage.find_married_vid() if u_vid != 0 then pc.select(u_vid) local partner = pc.getname() pc.select(old_vid) notice_all(pc.name.." and "..partner.." invite you to their wedding!") notice_all("Talk to the Old Lady to join the celebration.") pc.setqf("wedding_announce_time", get_time()+60*10) setskin(NOWINDOW) else say("Your partner is not online!") say("") end else local remaining = pc.getqf("wedding_announce_time") - get_time() say("You can announce again after "..remaining.." seconds.") say("") end I added it, like I said I customized this quest a little

yea I've seen it in some clients too