fingerprn Posted February 25, 2006 Share Posted February 25, 2006 I've been running a dating site written in php/mysql. Most of it was built by someone else and I've done some minor modifications. It works fine 99% of the time, but occassionally it makes small errors when writing a record to the database. For example, it might post a record for a new member and all of the info is correct except it doesn't post the "M" or "F" for male or female. Or it might be a logical field and it posts a "N" instead of a "Y". Like I said, it posts most of the record correctly with a small exception like the ones above. Also, it might post 99 records correctly, but then one day I get a glitch. I've only got about 500 members right now, so it's not a big deal. But when I get up to 5,000+ members, these glitches will become a daily occurance! Do anyone know why this might happen? Is there any way of keeping this from happening? I've only been using PHP and MySQL for a year, so I'm not expert, but I'm assuming this isn't normal. Thanks in advance for your suggestions. Quote Link to comment https://forums.phpfreaks.com/topic/3601-problems-writing-to-mysql/ Share on other sites More sharing options...
wickning1 Posted February 26, 2006 Share Posted February 26, 2006 It's impossible to say for certain without looking over the code. Could they just be users making errors? Quote Link to comment https://forums.phpfreaks.com/topic/3601-problems-writing-to-mysql/#findComment-12500 Share on other sites More sharing options...
fingerprn Posted February 26, 2006 Author Share Posted February 26, 2006 [!--quoteo(post=349454:date=Feb 25 2006, 08:36 PM:name=wickning1)--][div class=\'quotetop\']QUOTE(wickning1 @ Feb 25 2006, 08:36 PM) [snapback]349454[/snapback][/div][div class=\'quotemain\'][!--quotec--]It's impossible to say for certain without looking over the code. Could they just be users making errors?[/quote]Not likely. I've got verifiers on all of the fields. However, I'm wondering if the verifiers could be causing the problem. For example, maybe if they get a verification error page and then go back to correct the mistake, some data gets lost in the process. I know that they have to re-enter password and state/city info after getting a verification error page. The person's sex doesn't get dropped under normal circumstances, but maybe it's happening under abnormal circumstances. For example, when I first tested the system, if made a mistake in filling out forms and got and error page and then did the same thing again, it would often not accept your record even if you finally got everything entered correctly. I got that problem fixed, but maybe there's another one hidden in there.Believe it or not, your question helped me. Thanks! :) Quote Link to comment https://forums.phpfreaks.com/topic/3601-problems-writing-to-mysql/#findComment-12514 Share on other sites More sharing options...
suma237 Posted June 11, 2007 Share Posted June 11, 2007 Hi,Please check the database type of the particular field. Quote Link to comment https://forums.phpfreaks.com/topic/3601-problems-writing-to-mysql/#findComment-272170 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.