Server ERROR.

[fictionworld]

http://imageshack.us/photo/my-images/18/charserv.jpg/

http://imageshack.us/photo/my-images/43/logservz.jpg/

http://imageshack.us/photo/my-images/33/mapserv.jpg/

Hi, I am creating my own server, but I encountered these errors. I am currently using

20100730aRagexeRE

SQL 3CeAM 655 SVN

Any Ideas on how to resolve this?

Thank you in advance. Happy Holidays.

[Emistry]

i guess for the SQL problem you forget to import a table named elemental_id

[Aerie]

Did you use an older db for your server ? You surely have to update it with files in your emulator sql-files/

http://3ceam.googlec...rite/sql-files/ In this revision they added the new field in the char table : http://3ceam.googlec...n_elemental.sql so you have to execute it under your phpmyadmin.

Also check for other sql upgrades.

[JayPee]

its your char table elemental_id column is missing

[fictionworld]

thank you for all the replies. I'll try every ideas you have given. Will update you soon.

[fictionworld]

and yes, it pertains to the elemental.sql file, applied it on my db and it works. Thanks!

Noob question, do I have to execute all of the updates found on the sql-files to encounter the least possible errors??

[Aerie]

3CEAM ones, yes ... If the upgrade have been already done you just will have an error ... Make a backup for avoid any problem. You have to read the file first some are here for purge some fields, other for add fields ...

[fictionworld]

Thank you for the quick responses everyone. Noted.

EDIT: Got another problem,

http://img593.imageshack.us/img593/4526/spriteerror.jpg

I got this error when I typed in @item pipe. I know I am missing some sprite images (please do correct me if I'm wrong), but I already got my kRO and RE updated to date. I've got some conclusions coming into mind though.

1.Myserver.grf conflicts with the fully patched data.grf or rdata.grf

2.I used an old data though I doubt it. Here's the link for the data that I used http://www.eathena.ws/board/index.php?showtopic=279640 along with http://www.eathena.ws/board/index.php?showtopic=230035.

If my hypothesis(nerd) is right, what files are concerned to all items/sprites inside the data? Thanks again.

Edited December 27, 2011 by fictionworld

[Aerie]

The gentlemen pipe seems to not be anymore provided in kRO client if I believe the request topic in graphic section. I can't make an archive with it yet (not on my main pc) : http://rathena.org/board/topic/56468-request-gentlemens-pipe/

I'll upload this item in few days if nobody make it before.

[fictionworld]

OK. tried something else and I encountered another sprite error. I believe its the Bapho_Horns_M, not sure what M stands for. :S

EDIT. Found another error. I tried to screenshot any of the bugs I encountered on my server but somehow the screenshot file itself is having an error.

Sample:

http://imageshack.us/photo/my-images/525/screenrorecreated001.jpg/

http://imageshack.us/photo/my-images/716/screenrorecreated000.jpg/

http://imageshack.us/photo/my-images/641/screenrorecreated002.jpg/

Another thing is, everytime I summon the MVP rangris I get this error.

http://imageshack.us/photo/my-images/266/aruafloat.jpg/

http://imageshack.us/photo/my-images/819/aruaring.jpg/

Sorry if there are lots of questions, but once I get a grip on these things I'll try to help others as well, still noob D:

Thanks in advance for the replies.

Edited December 28, 2011 by fictionworld

[Aerie]

If I remember for your screenshots you have to modificate your video parameters with the setup.exe.

For the second one, it's about auras, 2 files aurafloat.tga and auraring.bmp in effects/ repertory. You should look for those files in your client, if you find them it means that your launcher haven't be correctly diffed. If they're missing add them. (You can take a custom one)

[fictionworld]

ok noted. will update you again for the setup/

For the second problem, I changed from 3CeAM to rathena - Revision 15289 and the problem was solved for now. Thanks.