form failing - mysql non-numberic value

User 506998 Photo


Registered User
164 posts

I'm attaching a screen grab of the error. Everything has been working fine for years but suddenly this. I compared the php file mentioned in the error with an older one and there have been changes, but when I try swapping with the older one, the form still fails. Before I go any deeper... has anyone encountered this, is this a know problem, or any ideas....? Thanks.
Attachments:
User 506998 Photo


Registered User
164 posts

NON-NUMERIC
User 506998 Photo


Registered User
164 posts


Your form could not be submitted for the following reason(s):

Warning: [ err 2/line 445/datasavemysql.cls.php] A non-numeric value encountered
Warning: [ err 2/line 445/datasavemysql.cls.php] A non-numeric value encountered
Warning: [ err 2/line 445/datasavemysql.cls.php] A non-numeric value encountered
Warning: [ err 2/line 445/datasavemysql.cls.php] A non-numeric value encountered
Warning: [ err 2/line 445/datasavemysql.cls.php] A non-numeric value encountered
Warning: [ err 2/line 445/datasavemysql.cls.php] A non-numeric value encountered
Warning: [ err 2/line 445/datasavemysql.cls.php] A non-numeric value encountered
User 187934 Photo


Senior Advisor
20,190 posts

Hi Gary,
Can you share a link to your form?
I can't hear what I'm looking at.
It's easy to overlook something you're not looking for.

This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com
User 506998 Photo


Registered User
164 posts

Sure Eric...
https://www.balletchildren.com/sched_reg/reg_form.php
It has custom script and custom editing after the fact... but It's been working fine for years. I believe I got the custom code from you, as a matter of fact.
I did disable the saving to the mysql database last night so that the form still records into a csv as well as proceeds to Paypal for payment. That allows it to still be functional. We do primarily use the csv for day to day record keeping. Because the error seemed to indicate a problem with a non-numeric value and because there are 7 error messages and 7 monetary fields, I thought it might be referring to them... so on the database I changed decimal to varchar in the data type field for all those. My understanding is that it is OK to do that but that it just uses a bit more data and makes searches or collation using that data problematic. Anyway... that didn't fix it, so I disabled saving to the mysql and it does still save to the csv and proceed to Paypal. But it would be nice if it there is something glaring that you catch right off.... :)
User 187934 Photo


Senior Advisor
20,190 posts

Check your download area of your CC account. It sounds like some of the issues were addressed in the latest update.
I can't hear what I'm looking at.
It's easy to overlook something you're not looking for.

This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com
User 506998 Photo


Registered User
164 posts

OK... that's new. So I need to go with the paid update to clear out the problem? Hope that is the fix. I reverted to an older php version on my server but that didn't fix it either. Hey you guys have funny math... 2.10 is the upgrade to 2.5 ? :)
Thanks Eric.
User 187934 Photo


Senior Advisor
20,190 posts

Typically software and scripts use the actual number after the decimal point as the update.
2.5 is update 5 of version 2 and 2.10 is update 10 of version 2.
I have to buy the upgrade also as it's been more than a year since I bought it. It's still a great app and I still use it enough to justify the purchase.
I can't hear what I'm looking at.
It's easy to overlook something you're not looking for.

This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com
User 506998 Photo


Registered User
164 posts

Yes. It has been very useful. Be nice if this update included a running total of the monetary fields - something I have to add with a script and a bunch of manual editing for each itteration of this one particular form. Cheers.
User 506998 Photo


Registered User
164 posts

The update blows my custom totals script. That was a waste of $70. And where are the improvements...? I see no difference. Plus like an idiot I snagged Form Designer thinking it was designed to work with Form Builder - yeah, if you cut and paste code. Next time I'll read. Besides that was an impulse buy - I was perfectly happy with plain looking forms and end users are too. Thankfully I have another solution... I just was trying not to have to rebuild this complex form.

Have something to add? We’d love to hear it!
You must have an account to participate. Please Sign In Here, then join the conversation.