Avatar of steveo2
steveo2
Flag for United States of America asked on

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
PHPMySQL ServerScripting Languages

Avatar of undefined
Last Comment
steveo2

8/22/2022 - Mon
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.
steveo2

ASKER
Both fields are varchar.  lesson is 2 two characters long and question is four.
Kim Walker

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?
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
steveo2

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
ASKER CERTIFIED SOLUTION
Kim Walker

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
steveo2

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!!!