PhpDig.net

PhpDig.net (http://www.phpdig.net/forum/index.php)
-   Mod Submissions (http://www.phpdig.net/forum/forumdisplay.php?f=24)
-   -   MySQL smallint(6)... (http://www.phpdig.net/forum/showthread.php?t=2861)

Maskime 03-28-2008 06:52 AM

MySQL smallint(6)...
 
Watch out!

In the table phpdig_sites the column 'port' is a smallint(6) which bounds are [-37676; 37676]. So if you put a port above those limits (which was my case... (42232)) MySQL convert the port so that it can go into the column.
I've replace the smallint by a bigint and it's working fine now.


All times are GMT -8. The time now is 03:30 PM.

Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright © 2001 - 2005, ThinkDing LLC. All Rights Reserved.