MySQL enters another value that the one given by PHP

Posted by Tristan on Stack Overflow See other posts from Stack Overflow or by Tristan
Published on 2010-04-24T23:12:02Z Indexed on 2010/04/24 23:43 UTC
Read the original article Hit count: 214

Filed under:
|
|
|
|

Hello,

The big problem : mysql does not stores the information i told him to via PHP

Example (this req is an echo just before the query) :

INSERT INTO serveur (GSP_nom , IPserv, port, tickrate, membre, nomPays, finContrat, type, jeux, slot, ipClient, email) 
VALUES ( 'ckras', '88.191.88.57', '37060', '100' , '', 'Allemagne','20110519', '2', '4','99' ,'82.220.201.183','[email protected]');

But on the MySQL i have :

403     ckras   88.191.88.57    32767   100         Allemagne   20110519    1   2010-04-25 00:51:47     2   4   99      82.220.201.183  [email protected]

port : 37060 (right value) //// 32767 (MySQL's drug?)

Any help would be appreciated, i'm worse than stuck and i'm ** off

PS: *There is no trigger on the mysql as far as i know / there is no controll on the port which means that nowhere i modify the "port" value

and this script works for 80% of the time ( it seems that as soon as the users enters a port >= 30000 it causes that bug), an user first reported to me this error today and the script was running since 3 months*

Thanks

© Stack Overflow or respective owner

Related posts about debug

Related posts about mysql-query