Xephyras

So the 3.0.5 version doesnt get along with custom skins am I correct? Which version is fully compatible with custom skins?

Use the right lua version for the right client version. You can find the lua version here: http://svn6.assembla.com/svn/ClientSide/Lua_Project/ Just download the lua version that corresponds to your client version and update your /data folder or grf file with the new downloaded lua version.

Well, I haven't used eAthena for years right now, so I forgot... But all I remember is that in eAthena you only had to change a value to remove it, but that might have been changed too perhaps. Solved it by replacing (%d)# with # in "msgstringtable"

Hahaha, true that. No I was just wondering, because it seemed pretty easy to remove in eAthena. But anyway, thanks a lot for the effort guys! Appreciated it very much!

So there is no easier way in rAthena to remove that?

Delete the GRF paths in /conf and try again. It is not necessary to put those in /conf. What I think happened is that the client reads the GRF list from your server side first and it read it by order, so that images from data.grf comes first and then all the rest that are missing are being read in adata.grf. Meaning that the korean images are being read first, thus ignoring the english version. Leave the DATA.ini as it is, because the order the GRF files are being read in there is correct.

At the Server Selection screen (client side), there is a (0) showing next to the server name (which shows the number of players online). For example: SampleRO(76) How do I delete that so that only the server name shows? Thanks in advance!

I am totally clueless about what exactly happened, but I am very glad it is solved now. What I did: - Bought a second host - Put the CP on the second host - Made the configuration to connect to first host - Renamed the databases without spaces and/or periods. What I think the problem was, was probably the database naming, like Brynner mentioned a while ago. For some reason, it just messes up the system if you use spaces or periods or whatever that is not alphabetical or number. I am not sure and cannot confirm this theory, but just a thought to share with anyone that might encounter the same problem.

Installing with or without password?

@Brynner What does TeamViewer exactly do other than remote assistant?

@Xantara I didn't understand the 'Main' and 'Server Main' part of the error either. I never used those two names (or is it something that I SHOULD use instead?). Also, I installed FluxCP with username and password. It doesn't allow me to install without it. @Brynner I am gonna reinstall the whole system again, with a better database naming and see if it works. Cuz now I did lots of things and changed lots of things and probably messed up the whole system again. If it doesn't work I will come back here and install TeamViewer.

Well, I have literally tried everything including what you just suggesting Brynner. I'm going to have a rest now, cuz I have been doing this the whole day already and am tired.... I hope I can solve it tomorrow with your guys' help.

@Brynner I did that too, but no success. I'm gonna list all the things I did, so maybe that could make you able to conclude what I missed. I did the following in actual order: - Setting up SQL server connection (localhost) - Made account FluxCP (as described in my server.php) - Gave user FluxCP all permissions to alter the SQL databases - Made ragnarokmain database - Made ragnaroklog database - Executed all *.sql files from rAthena - Rev16622 on ragnarokmain database - Executed log.sql from rAthena- Rev16622 on ragnaroklog database - Altered login table from ragnarokmain database's username and password according to the username and password used in rAthena's login,char and map_conf. - Downloaded Xantara's FluxCP - Altered records in Xantara's FluxCP's application.php and server.php accordingly (see above post for results on application.php and server.php) - Put the altered Xantara's FluxCP in Apache's HTML folder (everything related to Apache, including all php files, mysql, etc. are installed) - Changed the owner of Apache's HTML folder to Apache (including FluxCP folder and files), instead of root. - Changed the permission for Apache to read and write on FluxCP's folder and files. - Went to the FluxCP address on I.E.8 - Installed and updated FluxCP - Checked if everything worked (server status, who is online etc.) - Tried to register a new account and failed (the error appeared)

@Xantara I just checked my servers.php and I didn't find anything near 'birthday'. I'll just post my servers.php and application.php here: servers.php: application.php: The following errors are given at cp/data/logs/mysql/errors/ folder: [2012-08-14 13:06:24] [sqlSTATE=42000] Err 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Main.char WHERE online > 0' at line 1 [2012-08-14 13:06:52] [sqlSTATE=42000] Err 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Main.login WHERE LOWER(userid) = LOWER('Test') LIMIT 1' at line 1 [2012-08-14 13:06:52] [sqlSTATE=42000] Err 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Main.login WHERE email = '[email protected]' LIMIT 1' at line 1 [2012-08-14 13:06:52] [sqlSTATE=42000] Err 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Server Main.login (userid, user_pass, email, sex, group_id, birthdate) VALUES ('' at line 1 There were no errors given at cp/data/logs/errors/exceptions/, the folder was empty. I hope this gives more detail in where it goes wrong.

I am using rAthena Rev16622 main.sql, yes. Maybe if I could check someone who had it working configuration files, I could get it to work. I thought that my files were messed up, so I downloaded the FluxCP files many times over and over (which did the trick with rAthena), but still no progress.

Would it be possible if you could post your application.php and server.php configurations or any related configuration? (of course, exclude the password and username)

Yes, I deleted the whole system and all the related folders, I even did a format on the system that the FluxCP is running at and re-installed everything again accordingly with the new Xantara's FluxCP-rA only.

Well, I already did that, and a lot of times too at any configuration possible. Unless you could tell me specifically which config I should look into again.

Due to Brynner's help, I got my FluxCP running. However, now I'm getting the famous 'Uh oh, what happened?' error when trying to register an account. What is installed: - I am using Xantara's FluxCP-rA (because Calciumkid's FluxCP gave unexisting errors). - The FluxCP is running on the same system as the SQL server - The FluxCP is the latest downloadable SVN from https://github.com/m...ntara/FluxCP-rA - The rAthena SVN is Rev. 16622 What I can do on FluxCP: - Basically everything (the server status is showing correctly, who is online is showing correctly etc.) What I cannot do on FluxCP: - Just registering a new account I have read a lot of topics about this error, for example, about if the group_id and birthday columns are present at login table, if the username/password is correct, if the hostname/port is correct etc. and I have re-checked them all and confirmed that they are correct (else I wouldn't be able to install FluxCP and get it running, I presume). There is only one thing that bothers me, might it be that Xantara's FluxCP-rA doesn't have the 'group_id' and is using 'level' instead? Or does the problem come from somewhere else? Also, does the RO server needs to be up in order to be able to register? (because it's currently down) Please help, and thanks in advance!

Thanks a bunch!

Where do I add those if I may ask? Same as where I added main.sql?

Now I'm getting a Flux MySQL error (see attachement). Could someone help me with this error? Thanks in advance! *Solved*

It's been fixed, thanks!

Hello, I am using Rev16617 and got this while compiling. /root/Desktop/trunk/src/char/char.c: In function \u2018inventory_to_sql\u2019: /root/Desktop/trunk/src/char/char.c:892: error: \u2018struct item\u2019 has no member named \u2018favorite\u2019 /root/Desktop/trunk/src/char/char.c:920: error: \u2018const struct item\u2019 has no member named \u2018favorite\u2019 /root/Desktop/trunk/src/char/char.c:920: error: \u2018struct item\u2019 has no member named \u2018favorite\u2019 /root/Desktop/trunk/src/char/char.c:926: error: \u2018const struct item\u2019 has no member named \u2018favorite\u2019 /root/Desktop/trunk/src/char/char.c:969: error: \u2018const struct item\u2019 has no member named \u2018favorite\u2019 /root/Desktop/trunk/src/char/char.c: In function \u2018mmo_char_fromsql\u2019: /root/Desktop/trunk/src/char/char.c:1224: error: \u2018struct item\u2019 has no member named \u2018favorite\u2019 make[2]: *** [src/char/CMakeFiles/char-server_sql.dir/char.c.o] Error 1 make[1]: *** [src/char/CMakeFiles/char-server_sql.dir/all] Error 2 make: *** [all] Error 2 Could someone give any hints?

Sorry for my late reply, and thank you for your answer. This is the full report of ./configure. checking for gcc... gcc checking whether the C compiler works... yes checking for C compiler default output file name... a.out checking for suffix of executables... checking whether we are cross compiling... no checking for suffix of object files... o checking whether we are using the GNU C compiler... yes checking whether gcc accepts -g... yes checking for gcc option to accept ISO C89... none needed checking how to run the C preprocessor... gcc -E checking for grep that handles long lines and -e... /bin/grep checking for egrep... /bin/grep -E checking for ANSI C header files... yes checking for sys/types.h... yes checking for sys/stat.h... yes checking for stdlib.h... yes checking for string.h... yes checking for memory.h... yes checking for strings.h... yes checking for inttypes.h... yes checking for stdint.h... yes checking for unistd.h... yes checking minix/config.h usability... no checking minix/config.h presence... no checking for minix/config.h... no checking whether it is safe to define __EXTENSIONS__... yes checking whether make sets $(MAKE)... yes checking for gcc... (cached) gcc checking whether we are using the GNU C compiler... (cached) yes checking whether gcc accepts -g... (cached) yes checking for gcc option to accept ISO C89... (cached) none needed checking how to run the C preprocessor... gcc -E checking for ar... /usr/bin/ar checking whether byte ordering is bigendian... no checking whether gcc produces 32bit code... yes checking whether gcc supports __thread specifier (TLS)... yes checking whether gcc supports -Wno-unused-parameter... yes checking whether gcc supports -flto... no checking whether gcc supports -Wno-pointer-sign... yes checking whether gcc can actually use -Wno-pointer-sign... yes checking whether gcc supports -Wno-switch... yes checking whether gcc supports -fPIC... yes checking whether gcc supports -fno-strict-aliasing... yes checking for setrlimit... yes checking for strnlen... yes checking for uselocale... yes checking for newlocale... yes checking for freelocale... yes checking xlocale.h usability... yes checking xlocale.h presence... yes checking for xlocale.h... yes checking for inflateEnd in -lz... yes checking zlib.h usability... yes checking zlib.h presence... yes checking for zlib.h... yes checking for library containing sqrt... -lm checking for library containing clock_gettime... -lrt checking whether CLOCK_MONOTONIC is supported and works... yes checking for pthread_create in -lpthread... yes checking for pthread_sigmask in -lpthread... yes checking for pthread_attr_init in -lpthread... yes checking for pthread_attr_setstacksize in -lpthread... yes checking for pthread_attr_destroy in -lpthread... yes checking for pthread_cancel in -lpthread... yes checking for pthread_join in -lpthread... yes checking for mysql_config... /usr/bin/mysql_config checking for mysql_init in -lmysqlclient... yes checking mysql.h usability... yes checking mysql.h presence... yes checking for mysql.h... yes checking MySQL library (required)... yes (5.1.61) checking for pcre_study in -lpcre... no checking PCRE library (optional)... no configure: disabling PCRE (optional) checking host OS... Linux checking for MinGW... no configure: creating ./config.status config.status: creating Makefile config.status: creating src/common/Makefile config.status: creating 3rdparty/mt19937ar/Makefile config.status: creating 3rdparty/libconfig/Makefile config.status: creating src/char/Makefile config.status: creating src/login/Makefile config.status: creating src/map/Makefile config.status: creating src/tool/Makefile config.status: creating src/test/Makefile I am not sure what I am missing here, so if one of the expert could tell me what it is and tell me what I have to install/configure, I would appreciate it very much! Thanks in advance. Sidenote: I am using Rev.16328 now.