Adding data to Mysql

User 2726466 Photo


Registered User
25 posts

I have been using form builder for sometime very successfully. Now i have an issue which clouds my head.
Very simply, a users can load data and upload 3 images. Previously 2 tables were created. gt_master (which is table I have named) and web builder creates a second table called gt_master_upload. ....gt_master_upload store the images and gt_master store the data....all work well.

Now i have errors.. data cannot be saved. So I went back to the very beginning. Web builder now creates a table called gt_master (correctly) and gt_master_uploadrefs, a different file name.

Also i noticed the original gt_master table had 3 fields with no data, i assume this relates to the 3 images upload options.
The new version of the gt_master has data of file names linked to the gt_master_uploadrefs fields.

See attached images
Attachments:
User 2726466 Photo


Registered User
25 posts

additional file i could upload on original post
Attachments:
User 2726466 Photo


Registered User
25 posts

I have found my problem...i need to select uploads to save in database. I have done this change but still have a problem.

Images are not uploaded. gt_master has the master details, but there are no images uploaded

appreciate your help
User 187934 Photo


Senior Advisor
19,190 posts

Hi Henry,
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 2726466 Photo


Registered User
25 posts

HI
I think it has something to do with my PHP v7.2 config in my dev server. No error messages

I have moved the app to my production server with my ISP and it works.
This is my prod link......http://www.safairmontgt.com.au/addtoregister.htm

R there any Web builder log files i can look at

regards
Henry
User 2726466 Photo


Registered User
25 posts

HI

Some more info

I have built a centos 6 dev server with php 5.6.40 and it all works perfectly
On my centros v7 dev server php 7.2 images do not get uploaded.

there is some difference with the php versions ....appreciate any help

regards
Henry
User 2726466 Photo


Registered User
25 posts

See attached php v7 php.ini
Attachments:
User 187934 Photo


Senior Advisor
19,190 posts

The server test looks good.
http://www.safairmontgt.com.au/test_reg … essiontest I bet it has something to do with a setting in your php version.
I would open a support topic and see if the CC gurus can point to the issue. It should work without any tweaking but maybe your host made some alterations that the Form Builder can't account for.

https://www.coffeecup.com/help/myroom/

Post back when you get an answer.
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

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.