Saving to a MySQL database - Post ID...

User 2352111 Photo


Registered User
2 posts

Man, That is so cool!!
Just created the db, submitted the form ... Bingo! fields are there, info is there, no brain damage!
Nice Work Guys

Tom
User 1743776 Photo


Registered User
74 posts

Thanks, Eric!
That "redirect" code sample was super! Solved all my problems and may have stopped global warming, as a bonus!.
I even switched to the much-better PDO.
Soon my all-CC full site will be in production; I'll post it then.

Dick
Live in a steady joy!
User 374891 Photo


Registered User
6 posts

Hi,
I've been using WFB 2.5 5437 on my club's website a couple of times a year (sorry I missed the discounted upgrade -- oh, well).

Form builder has bee useful for online registration of our semiannual camping trips. Anyway I had problems getting WFB to run even after a reinstall but it is finally working. Not that I did anything, but Windows10 and Symantec move in mysterious ways.

Anyway #2, after tweaking my sign-up form, I uploaded it and the associated folder to my server's HTML directory, but the form won't display. Instead I get this message, "Fatal error: Call to undefined function json_decode() in /home/peter45/public_html/Signup_early/fbapp/php/config.cls.php on line 351"

Here's the associated code:

// always record times in UTC, apply time zones only when displaying
date_default_timezone_set( 'UTC' );

$txt = file_get_contents( ($this->sdrive ? CONFIG_FILE_SDRIVE : CONFIG_FILE) , FILE_USE_INCLUDE_PATH );

if( $txt === false ) {
writeErrorLog( 'Couldn\'t open or read:', CONFIG_FILE );
echo '<html><body>Configuration missing.</body></html>';
exit();
}

$this->config = json_decode( substr( $txt, strpos( $txt, "{" ) ) );

if( $this->config == NULL )
{
FormPage::GetInstance()->SetErrors( array( array( 'err' => 'Failed to read or decode form configuration.' ) ) );
writeErrorLog( 'Couldn\'t decode:', ($this->sdrive ? CONFIG_FILE_SDRIVE : CONFIG_FILE) );
return false;
}

The server appears to be running PHP version "ea-php56" on my homepage directory. Any thoughts?
User 187934 Photo


Senior Advisor
20,181 posts
Online Now

Hi Mike,
Can you share a link to your form?
Otherwise I would try manually deleting the form off the server and republishing.
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 374891 Photo


Registered User
6 posts

Thanks Eric,
I will try republishing. Here's the link to the test page. You'll have to scroll down a bit. The form fits into the second colored frame, below the first block of text.

http://www.peterlebeckecv.com/detailsS18_test.html

Mike
User 187934 Photo


Senior Advisor
20,181 posts
Online Now

I would reexport the files also just to make sure. If reexporting and uploading doesn't solve the issue I bet there's a server configuration issue.
You can open a support topic.
https://www.coffeecup.com/help/myroom/opentopic/
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 374891 Photo


Registered User
6 posts

Thanks Eric.

I did reexport with no luck. I just uninstalled and tried to reinstall WFB2.5, but Windows10 won't let me do it. After I get the the WFB Installer logo the process stops and a small "Windows installer" window pops up with a list of installation switches. I'd screen shot it and post it here but the snipping tool only snips what's under the installer window. Same goes for WFB2.9 lite.

At this point I'm going to try to install to my wife's computer to see if I can salvage my project. Not fun.
User 374891 Photo


Registered User
6 posts

Eric,

I successfully reinstalled WFB2.5 to my wife's computer and uploaded the compiled files to my server with no luck. I will open a support ticket as you suggested. Thanks for your help!
User 187934 Photo


Senior Advisor
20,181 posts
Online Now

I would dbl check what version of php your running.
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 2947074 Photo


Registered User
27 posts

I have this error Failed to execute query on table.

My host with Mysql is up to date, try contacting my hosting and they told me it developer issue. I did not fill in the table But it tell me I have to before exporting it. Iv done all of it.
When the form is summit it goes to my database email I have no problems there even when its summit then the error message comes on.

I check my error log in mysql and it tells me I have an error
[0] 42000 [1] 1118 [2] Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs

I have an application form and its pretty long.
Im not a Coder, so I can not write my own script, but if anyone can help and show and tell me how to get rid of this error.

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.