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