Skip to main content

Posts

Showing posts from July, 2011

2147483647 and my experience

I finished a project with a large database without any difficulty even when I tested I didn’t find any things hard to do or hard to understand. One day the client called me and asked me to check telephone field for a tables, apparently there was a problem with updating telephone field in the database. I checked and found that sometimes when I try to update the telephone number in return instead of saving the entered number it will saving another number (2147483647), I checked again and again and noticed that always it save the same number although I tried different numbers but same number in the database. I started for solve this problem by clearing all sessions and double checking my PHP and MySQL code but still same error. I remembered one of lecturer who was so cool but when someone asks a question almost definite he would reply “ask Dr. google”. I am sure he never read this post as once I sent him a link he didn’t click on that link, basically he never read such posts, I gues…