how to fix this server problem
Can any one explain me how to fix this i tried manny thing and still cant get it to work for connecting to my own server plz help me out here a picture of the problem and when i click connect i can log in but cant ether the server can any one help me out thx
It appears you have a error in your sql syntax
Takes me to state the oblivious.
Any ways not sure about these files source code but something in your sql call is formatted wrong, Or not compliant with your mysql version.
I spy the word range in that sql query.
I've answered this several times before. You should be able to find a detailed explanation in these forums if you use search.
In a nutshell though, the code was written for an earlier version of mysql. in later versions, range has become a keyword so we can't use it as a variable unless we wrap it in smart quotes.
try replacing range with 'range' in the query that you will find in startup.cpp / function loadskilldata()
ya ill try out a lastes sql and see what will it give me and see if i dont get it working ill be asking again if i dont find the search of what i need
ok i tried to change range and still wont load up and i changed mysql to latest and still got this problem of that range error and i done a search the site keep giving me error everytime i do search
this is what i got in the range section
bool CWorldServer::LoadSkillData( )
{
Log( MSG_LOAD, "Skills data " );
MYSQL_ROW row;
MYSQL_RES *result = DB->QStore("SELECT id,level,sp'range'type,target,power,duration,mp, success,weapon,class,rskills,lskills,buff1,buffv11,buffv12, buff2,buffv21,buffv22,buff3,buffv31,buffv***clevel,aoe,aoeradius,script,value1 FROM skills_data order by id");
if(result==NULL) return false;
while( row = mysql_fetch_row(result) )
{
CSkills* newskill = new (nothrow) CSkills;
if(newskill==NULL)
{
Log(MSG_ERROR, "Error allocing memory" );
DB->QFree( );
return false;
look at what you have written here
DB->QStore("SELECT id,level,sp'range'type,target,power,duration,mp,
I see your problem problem?
You have no commas before and after 'range'
try this instead
DB->QStore("SELECT id,level,sp,'range',type,target,power,duration,mp,
size increased for ease of reading
OH yaaa i got it wooot thx so mutch hehehe
here is my problem
Code:Wed Feb 04 23:21:28 2009 [INFO]: osRose Revision 80 Wed Feb 04 23:21:28 2009 [INFO]: Autosaving Every 2 minutes Wed Feb 04 23:21:28 2009 [INFO]: Connecting to MySQL Wed Feb 04 23:21:28 2009 [INFO]: SQL timeout set to 2678400 seconds Wed Feb 04 23:21:28 2009 [INFO]: Connected to MySQL server Wed Feb 04 23:21:28 2009 [INFO]: Map 11 is CF mode 1 ! Wed Feb 04 23:21:28 2009 [INFO]: Map 12 is CF mode 1 ! Wed Feb 04 23:21:28 2009 [INFO]: Map 13 is CF mode 1 ! Wed Feb 04 23:21:28 2009 [FATAL ERROR]: Could not execute query: You have an err or in your SQL syntax; check the manual that corresponds to your MySQL server ve rsion for the right syntax to use near 'range,target,power,duration,mp, success, weapon,class,rskills,lskills,buff1,buffv' at line 1
purple i have the same problem as he is.Originally Posted by Purpleyouko
look at what you have written here
DB->QStore("SELECT id,level,sp'range'type,target,power,duration,mp,
I see your problem problem?
You have no commas before and after 'range'
try this instead
DB->QStore("SELECT id,level,sp,'range',type,target,power,duration,mp,
size increased for ease of reading
i put as wat u say. but still the cant.
Code:Log( MSG_LOAD, "Skills data" ); MYSQL_ROW row; MYSQL_RES *result = DB->QStore("SELECT id,level,sp,type,'range',target,power,duration,mp, success,weapon,class,rskills,lskills,buff1,buffv11,buffv12, buff2,buffv21,buffv22,buff3,buffv31,buffv***clevel,aoe,aoeradius,script,value1 FROM skills_data order by id"); if(result==NULL) return false; while( row = mysql_fetch_row(result) )
I notice this in your code
i think that is a feature of the forums that it converts 32 comma into *** but just make sure you haven't copied it in from a code box hereCode:buff3,buffv31,buffv***clevel,aoe
It won't even let me write 3 2 , without the spaces
other than that i don't see anything obviously wrong with your query. In the code box it looks fine.
this is perfect
in the error though, it's different.Code:DB->QStore("SELECT id,level,sp,type,'range',target
range has no smart quotesCode:syntax to use near 'range,target,power
The quote that I highlighted in lime is not part of your query but is rather part of the error message
Did you recompile after editing it?
It doesn't look like you did.
im not quite sure how to recompile. so i leave it :p
sory bout that. huhuhu
ok il try to recompile by following the guide. thx :)
purpleyoko. sory to disturb u again.
fter the libmysql package is installed, we need to change a few lib paths. Open up your project (such as worldserver.dev, which can be found in the "worldserver" folder) Go to menu "Project>project option".
2. Go to "parameters" tab and change the "C:/Dev-Cpp/lib/libws2_32.a" and "C:/Dev-Cpp/lib/libmysql.a"
for you correct path.
i go to the paramaters tab. mine shows empty in the compiler and C++ compiler box. no "C:/Dev-Cpp/lib/libws2_32.a" and "C:/Dev-Cpp/lib/libmysql.a"
Open DEV C++ and in the menu go to "Project>Project Option". Then go to the tab "Parameters" and change the "C:/Dev-Cpp/lib/libws2_32.a" and "C:/Dev-Cpp/lib/libmysql.a" to their correct paths, (look for files in the "lib" folder, and just copy and path).
where is the folder named lib??
plz purple help me
the lib folder is located in the root folder of your dev-cpp installation which should be (as a default) C:/Dev-Cpp/lib
in the parameters tab of your dev-cpp program you should see 3 text areas.
just make sure that in the right hand one, you have this
-lmysql -lpthreadGC -lws2_32
That should be all you need. If it doesn't work by just pasting that in then you should click on the button underneath the box ( it is labelled "Add library or Object")
click this button then navigate to C:/Dev-Cpp/lib/libws2_32.a
select it and click OK
then do the same again for C:/Dev-Cpp/lib/libmysql.a
Then one more time for C:/Dev-Cpp/lib/libpthreadGC.a
You need all three of them.
Those should be the correct paths unless you installed dev-cpp in an unusual place such as on your D: drive or something.
Give it a try and tell me if it doesn't work.
Re: how to fix this server problem
thx purple
i dont need to add. cuz i have the -lmysql -lpthreadGC -lws2_32
the last task.......... hope im not annoying u.
Now, to compile the .exe, open the .dev (loginserver.dev, charserver.dev, worldserver.dev) and click on the menu "Execute>Rebuild All". And you have the .exe inside the sources folder!
he ask to open the 3 *.dev in devc++
but i cant open the three project at the same time.
just open worldserver.dev that's the only one we have changed
To do all 3 you would have to open then compile them all one by one. you can't do all 3 at once.
So just open Worldserver.dev (make sure you have the changes with 'range')
Execute->rebuild all and it will create you a new worldserver.exe in your binary folder
if you didn't make any changes to any .h (header) files then you can even do Execute->Compile for a much quicker build.
If it is teh first time that you have compiled your server it will do a full compile either way.
Like i said, you didn't change anything in loginserver.dev or charserver.dev so you won't need to recompile those unless you don't have them already.
No you aren't annoying me.the last task.......... hope im not annoying u. so sorry
Answering questions is what i do.
It's my job to give you guys tech support on the osrose servers . That's why I'm a Mod here
ok done but there is another problem.........
it says
Code:Thu Feb 05 03:59:17 2009 [FATAL ERROR]: Could not execute query: Table 'roseon.s kills_data' doesn't exist
It's a table in your databaseTable 'roseon.skills_data' doesn't exist
Please take a look in your DB and see if there is a table called "skills_data
It should be there.
If it isn't then I suggest re-installing your database.
thx purpleyouko
thank you :)
n yeah i know im starting to annoy u.
the last of all
there is an error on roseevo installation.
so i download avatar rose client.
and put the launcher n a note pad "ICONFIG.NHD"
n type in
n my ip for my server is all default. i dont change. which is 127.0.0.1.Code:[CFG] Server=127.0.0.1 HTTPReg=yourwebcms.com/register.php HTTPNot=yourwebcms.com
so the problem is.......i cant log in. when i type anything n log in
then i switch n check if there any entry in login.exe
user connected.
user disconnected.
so how do i want to play..... :(
That is totally normal.user connected.
user disconnected.
When a player logs in they first go to the login server and it registers user connected.
The login server then passes the player to the charserver and logs them out of the login server and registers user diconnected at the login.
Do you get any error message on the client when you try to log in?
no error message...... but forever it says connecting.......
i dont see no char select
something is configured wrong in your .conf files then
either that or you have a corrupted charserver.exe that is not accepting the request from loginserver.exe
I've seen that happen before
hmm but still cant :(
ive try reinstall. the server. still cant log in n see the char select :(
do you have all 3 servers running?
i have 3 server running, everything is green light.
im downloading rose evo client. i try to test it
Don't forget to patch it with the GG patch or else you won't be able to connect to your server using the latest NA Rose client. The packet architecture is completely different.
purpleyouku
ive done it. guess my insticts tell me it was the client
thank you so much for helping me to establish my server
infact i can help ppl to. who have the prblems same as mine
