Data submission problem
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
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
Kim Walker
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.
ASKER
Both fields are varchar. lesson is 2 two characters long and question is four.
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?
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?
ASKER
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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!!!
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!!!