Data submission problem

steveo2
steveo2 used Ask the Experts™
on
I have a web app that records flash form data. We use actionscript to call a php page that inserts the data into a mySql database. This process has worked seamlessly for about a month, storing approx. 140000 rows of data.  Today we received user complaints users from one location that their data is not being recorded.  

The data recorded is: Id, user_name, lesson, question, score, timestamp.  

Normally the data looks like: 1234, somename, 01, q1, 1, 2012-04-19 14:16:09.

Some of the user data from this one location is looking like this: 1234, jdoe, Pr, Pr, 1, 2012-04-19 14:16:09.

I have no idea where "Pr" is coming from.  We don't send this value.  The issue is limited to these users at this specific location.  I'm thinking it may have something to due with their network or browser settings.

Does "Pr" mean anything to anyone??

Thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Kim WalkerWeb Programmer/Technician

Commented:
Are the two fields that have Pr limited to two characters? You could increase the field width and have them submit again to see what's being truncated. That may lead you to a solution.
Both fields are varchar.  lesson is 2 two characters long and question is four.
Kim WalkerWeb Programmer/Technician

Commented:
Sorry, I have more questions than answers.

Are those two values ALWAYS "Pr" from that one location?

At what point are you determining the values to be "Pr"? Is that what's being recorded in the database? Do you have any validation or manipulation of the data before it goes into the database? Do you know whether the form is being submitted with those values or if it gets changed somehow before it's recorded in the database?

Is the form field where the raw data is entered on the client side limited to two and four characters, too?
11/26 Forrester Webinar: Savings for Enterprise

How can your organization benefit from savings just by replacing your legacy backup solutions with Acronis' #CyberProtection? Join Forrester's Joe Branca and Ryan Davis from Acronis live as they explain how you can too.

thanks for your response.

To your questions

At what point are you determining the values to be "Pr"? Is that what's being recorded in the database?  Yes these are the values recorded in the database.

Are those two values ALWAYS "Pr" from that one location?
The problem has only occurred for users accessing the site from this one locate.  But not every record submitted is affected. Looks one or the other field is effected but not both at the same time:  Here's examples of 3 records from one user:

The data recorded is: Id, user_name, lesson, question, score, timestamp.  

Normally the data looks like: The lesson and question fields are effected only.

1231, jdoe, 01, q1, 1, 2012-04-21 14:16:09
1232, jdoe, Pr, q1, 1, 2012-04-21 14:17:09
1233, jdoe, 01, Pr, 1, 2012-04-21 14:16:09

Do you have any validation or manipulation of the data before it goes into the database? Do you know whether the form is being submitted with those values or if it gets changed somehow before it's recorded in the database?

The forms are Flash and are just some radio buttons and a submit button. Actionscript is posting to the php file that inserts into the database. The thing is I haven't been able to replicate.  We had issues from some users regarding Flash and their browser configs.  I'm inclined to think that something is going wrong on the particular forms for these users.

It is curious why "Pr" is being recorded. I was thinking it might have some significance in MySQL..  but I guess not.  We have other forms that are working seamless for these same users.  I think I need to look at the actionscript for the forms in question.

Thanks
Web Programmer/Technician
Commented:
Unfortunately, "Pr" doesn't ring any bells that might lead to a solution. I would love to see a snap shot of the $_POST array that is being submitted by the client. I'm inclined to think that it's being truncated down to two characters somewhere and the full value might be enlightening. But if one of these fields is already four characters long in the database, it must be getting truncated elsewhere if that's what's going on.
Thanks,

I think you are correct... I'll take a look at what the is being posted by the client and see if there is anything that might produce "Pr" for certain users.

Thanks for the help!!!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial