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:lol:

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 :cool:

DB->QStore("SELECT id,level,sp,'range',type,target,power,duration,mp,

size increased for ease of reading :wink:

OH yaaa i got it wooot thx so mutch hehehe:laugh::laugh::P:

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


---

Quote:

---

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 :cool:

DB->QStore("SELECT id,level,sp,'range',type,target,power,duration,mp,

size increased for ease of reading :wink:

---

purple i have the same problem as he is.
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

Code:

---

buff3,buffv31,buffv***clevel,aoe

---

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 here
It won't even let me write 3 2 , without the spaces :laugh:

other than that i don't see anything obviously wrong with your query. In the code box it looks fine.
this is perfect

Code:

---

DB->QStore("SELECT id,level,sp,type,'range',target

---

in the error though, it's different.

Code:

---

syntax to use near 'range,target,power

---

range has no smart quotes
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. :closedeyes:

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.

thx purple :thumbup:
i dont need to add. cuz i have the -lmysql -lpthreadGC -lws2_32

the last task.......... hope im not annoying u. :P: so sorry

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.

Quote:

---

the last task.......... hope im not annoying u. so sorry

---

No you aren't annoying me.
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 :lol:

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

---