A problem with messaging using XAMP

[Wakish]

Hi guys..
I'm having a problem.. the "messaging" system of any php games is not working under XAMP.. But with others like WAMP and EasyPhp, it is working.
I need to work with XAMP for the moment, can anyone try to help me with this issue?

Thanks!
- Wakish -

[Aliss]

Say better for what game you need that messaging or if that is your made game show us a source only that we can help you width your problem.

[Wakish]

Say better for what game you need that messaging or if that is your made game show us a source only that we can help you width your problem.

It has nothing to do with the codes! It's with the settings of XAMP.. I thought that perhaps someone here is using XAMP?

I have asked for help on XAMP's forum, but there support is very poor! No answer since almost 3 days now..

[Zeggy]

I use XAMPP, but for me everything works fine...

[Wakish]

I use XAMPP, but for me everything works fine...

I'm using the new version of XAMP.. do you think this might be a bug?
I have tried XAMP both on linux and WinXP.. still I get same problem on both..
But as I said, with WAMP on WinXP, I don't have any problem..

That's a strange problem

[codestryke]

I may have an explanation but it's been a bit since you last posted so you may have already found out the problem? If not lemme know and I'll post further...

[Zeggy]

Hmm, now I got a problem that's happening on my XAMPP installation...

I have this query:
select `msg` from `log_gm`

If I change it to this:
select `msg` from `log_gm` order by `id` desc limit 1

Apache just hangs, and I have to restart it. If there something wrong with the query/code, or is my XAMPP just messed up?

The same query works fine on other pages, just not on index.php.

[Wakish]

I may have an explanation but it's been a bit since you last posted so you may have already found out the problem? If not lemme know and I'll post further...

No I have not been able to work around this error on XAMP
But on easyPhp it's fine.
But I want to use linux and Xampp

Can you help me please?

The error reported is:

Invalid query: 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 'reads='0'' at line 7

Code: [Select]

/* ***PHP CODES*** */
mysql_query("INSERT INTO messages
(recipient,user,name,content,mytime,reads) VALUES('$target','$user->username','$thrd_title',content='$thrd_content',mytime='$time',reads='0') ")
or die(mysql_error());

/* *** SQL details*** */
ID int(10)
recipient varchar(225)
user varchar(225)
name varchar(225)
content text
mytime int(11)
reads int(1)

I cannot figure out why this reports an error ONLY with XAMPP

[codestryke]

You've got your INSERT with SET statments goofed up

Code: [Select]

mysql_query("INSERT INTO messages
(recipient,user,name,content,mytime,reads) VALUES('$target','$user->username','$thrd_title','$thrd_content','$time','0') ")
or die(mysql_error());

With inserts you don't use field name = value

You just use values

[Wakish]

Codestryke actually I wrote the code properly, but here I can't believe how I messed it up while wrting, I guessed I was very tired.. I barely slept..lol  -_-

I get the error still

Invalid query: 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 'reads='0'' at line 7

Everytime it's the near "reads"... I can;t figure out where is the error..

[Wakish]

============= UPDATED - SUCCESS =============

Ok after 2 days messing around with all types of possible solutions, here is my report and obervations:

1) I changed the "type" of reads to char, int, varchar - FAILURE
2) I changed the values to default,null..etc..etc - FAILURE
3) tried all possible syntax - FAILURE

PS: But most of time was wasted just starring in vain at the code  :mib: hah 

4) I just RENAMED 'reads' as 'readss' - SUCCESS

Conclusion:
=> Perhaps "reads" is an internal reserved like word in Lampp ?

Any, I was going to "throw" lampp away, but I'm happy I finally reslved this problem.

[codestryke]

Nice job!!!

With SQL if the word you are using is a reserved work then you can add the tick around the field name to let SQL know you are referencing a field name rather then the reserved work...

ie..

Code: [Select]

mysql_query("INSERT INTO messages
(recipient,user,name,content,mytime,`reads`) VALUES('$target','$user->username','$thrd_title','$thrd_content','$time','0') ")
or die(mysql_error());

[Wakish]

Nice job!!!

With SQL if the word you are using is a reserved work then you can add the tick around the field name to let SQL know you are referencing a field name rather then the reserved work...

ie..

Code: [Select]

mysql_query("INSERT INTO messages
(recipient,user,name,content,mytime,`reads`) VALUES('$target','$user->username','$thrd_title','$thrd_content','$time','0') ")
or die(mysql_error());

Thanks CodeStryke.. I did not know about the "tick around"...thanks mate!