+- Form Tools (https://forums.formtools.org)
+-- Forum: Form Tools (https://forums.formtools.org/forumdisplay.php?fid=1)
+--- Forum: General Discussion (https://forums.formtools.org/forumdisplay.php?fid=5)
+--- Thread: data is entering DB as null...help! (/showthread.php?tid=1557)
data is entering DB as null...help! - bbeehler - Aug 24th, 2011
When using my form the fields are moving a value of NULL into the DB. How do I fix this?
RE: data is entering DB as null...help! - Ben - Aug 24th, 2011
Hi bbeehler,
All of them, or just some? Do any form field values get into the database? If not, you just get new blank entries for each submission? When did this happen - just recently, or right after you added the form to be processed by Form Tools?
- Ben
RE: data is entering DB as null...help! - bbeehler - Aug 24th, 2011
Thanks Ben for your response,
I created in the form in the tool and then proceeded to add a new submission. I filled out the form and hit ADD. I returned to the search results page and it showed the record however all the fields where NULL. This happens every time I enter a new submission. This form is Internal only and it happens to all the fields I created.
RE: data is entering DB as null...help! - bbeehler - Aug 24th, 2011
(Aug 24th, 2011, 7:34 AM)Ben Wrote: Hi bbeehler,
All of them, or just some? Do any form field values get into the database? If not, you just get new blank entries for each submission? When did this happen - just recently, or right after you added the form to be processed by Form Tools?
- Ben
Thanks Ben for your response,
I created in the form in the tool and then proceeded to add a new submission. I filled out the form and hit ADD. I returned to the search results page and it showed the record however all the fields where NULL. This happens every time I enter a new submission. This form is Internal only and it happens to all the fields I created.
RE: data is entering DB as null...help! - Ben - Aug 24th, 2011
Hi Bbeehler,
Whoah... that's not good! I've never heard of that problem before, but it's pretty serious: it means the script isn't working as it should; there's no reason it should behave like that.
Are you by any chance using the Classic Grey theme? If so, could you check that you're using a compatible version for the Core? For Form Tools 2.1.0 you should be using Classic Grey v1.1.2
Yesterday someone spotted a related problem & I realized the main download file contained the incorrect version. It was fixed yesterday, but if you downloaded it before then, it could be that...
Any help...?
- Ben
RE: data is entering DB as null...help! - bbeehler - Aug 25th, 2011
(Aug 24th, 2011, 11:31 AM)Ben Wrote: Hi Bbeehler,
Whoah... that's not good! I've never heard of that problem before, but it's pretty serious: it means the script isn't working as it should; there's no reason it should behave like that.
Are you by any chance using the Classic Grey theme? If so, could you check that you're using a compatible version for the Core? For Form Tools 2.1.0 you should be using Classic Grey v1.1.2
Yesterday someone spotted a related problem & I realized the main download file contained the incorrect version. It was fixed yesterday, but if you downloaded it before then, it could be that...
Any help...?
- Ben
Hi Ben,
I switched to the Grey theme recreated the DB and still experienced the same result. NULL values being entered into the DB instead of the data inputted.
RE: data is entering DB as null...help! - bbeehler - Aug 26th, 2011
thanks for the quick replies Ben!!
RE: data is entering DB as null...help! - Ben - Aug 26th, 2011
Hi bbeehler,
I'm out of ideas. Any chance I could get temporary access to your Form Tools installation so I could log on and see the problem directly? If so, email me at ben.keen@gmail.com
- Ben