TruthMedia » Blog Archive » FormBuilder 0.74: Experts in Online Ministry

FormBuilder 0.74

Well, we have been hard at work fixing some bugs and building new functionality into FormBuilder. We’re excited to announce the following new features:

Database Backup Viewing and Export
Having previously released an extension to FormBuilder which allowed you to store form results in the database, we have now expanded that extension to allow listing the results in the database along with the ability to read archived forms and export date ranges to a CSV file.
Multi-page Forms
We have added the ability to put page breaks into your forms to allow for splitting forms across multiple pages. This is especially useful if you have large forms you want the visitor to fill out, but don’t want to overwhelm them with one big long list of questions.
Minor CAPTCHA Bug Fixes
There were some minor bugs introduced in the CAPTCHA system which would have affected certain website configurations. The bugs have been squashed.

We hope you like the improvements. We’d love to hear your feedback below. As always, you can download this version of FormBuilder from WordPress.org.

This entry was posted on Wednesday, February 4th, 2009 at 1:01 am and is filed under FormBuilder, WordPress. You can follow any responses to this entry through the RSS 2.0 feed. Both comments and pings are currently closed.

25 Responses to “FormBuilder 0.74”

BTreece says:

February 4, 2009 at 5:10 pm

Thanks for getting some database storage management taken care of so quickly.

Looks like all it’s missing now is a dashboard widget to show recent entries, and a better menu within the 2.7 menu interface for accessing the options.

This might be the perfect form plugin at that point.

ErrorAfterUpdate says:

February 7, 2009 at 8:55 am

Hi,

After upgrading I get the following error when I try access the blog

Error: Unable to load field details from table. [SHOW FIELDS FROM `wp_formbuilder_pages`]

any ideas?

David Sloane says:

February 8, 2009 at 5:40 pm

Hello,

I have just installed FormBuilder 0.74 with WordPress 2.7 and when I attempt to create a new form I receive the message “Unable to create new form”.

Any ideas as to what I should be looking at?

James says:

February 9, 2009 at 8:26 am

@ErrorAfterUpdate: Did you install from scratch (ie new install?) or was it an upgrade? If it was an upgrade, what version did you upgrade from? I don’t think that particular error would be related to anything we have changed in the code recently. It sounds to me like your database user doesn’t have permission to “SHOW FIELDS” any more, but you would have seen this problem before an upgrade…

@David Sloane: Do you know what version of PHP you’re running? That’s a very strange error. Are you able to look in your MySQL database and confirm that the tables all exist? The table that affects this particular query is probably called “wp_formbuilder_forms”. At very least it should have three fields: name, subject and recipient.

James W.

Lori says:

February 9, 2009 at 9:20 am

I just updated from 0.73 to 0.74 and can no longer add items to a shopping cart built with shopp plugin. It worked fine before the update and works again when I disable the formbuilder plugin. Reverting files back to 0.73 does not fix it.

Any ideas what might be causing this and/or how to fix it?

Thanks very much.

David Sloane says:

February 9, 2009 at 9:59 am

PHP Version 5.1.4
MySQL 5.0.22

The tables all exist and appear to be complete,

wp_formbuilder_fields
Table comments: InnoDB free: 10240 kB

————————————-

wp_formbuilder_forms
Table comments: InnoDB free: 10240 kB

————————————-

wp_formbuilder_pages
Table comments: InnoDB free: 10240 kB

————————————-

wp_formbuilder_responses
Table comments: InnoDB free: 10240 kB

————————————-

wp_formbuilder_results
Table comments: InnoDB free: 10240 kB

James says:

February 9, 2009 at 10:49 am

@Lori: Can you please let me know which shopping cart plugin you were using? I will try and determine the cause of this. In the mean time, you could try installing and using ver 0.63 which can be downloaded from WordPress.org here:
http://downloads.wordpress.org/plugin/formbuilder.0.63.zip

@David Sloane: I’m sorry, I really don’t know what the problem might be. The plugin is just using very standard WordPress commands to create the new form. I don’t understand why it wouldn’t be working. Maybe try with an alternate version like 0.63? (see link above)

Lori says:

February 9, 2009 at 10:53 am

Thanks James! Installing 0.63 fixed it. Cart plugin is Shopp (http://shopplugin.net/).

Sam Powers says:

February 10, 2009 at 10:28 am

@James, I’m having the same problem as David, and I think I have an idea of what the problem is, or at least a clue.

When I attempt to create a new form, I get the following error in my apache error.log:

[Tue Feb 10 10:22:56 2009] [error] [client 10.33.5.11] WordPress database error Field ‘action’ doesn’t have a default value for query INSERT INTO wp_sms_formbuilder_forms(`name`,`subject`,`recipient`) VALUES (‘New Form’, ‘Generic Website Feedback Form’, ‘admin@district6.org’); made by require_once, do_action, call_user_func_array, formbuilder_options_page, formbuilder_options_newForm, referer: http://blogs.district6.org/sms/wp-admin/tools.php?page=formbuilder.php

The query used there does not include a value for the ‘action’ field, but the field is set as non-nullable in the database and does not have a default value, and I think that’s the problem.

Sam Powers says:

February 10, 2009 at 10:31 am

Making all of the fields in that table nullable allows me to create a form, but I don’t know what hidden side effects this might have. It would probably be best for that to be tweaked in formbuilder_options_newForm to include all required values, or for the activation hook where the tables are created to have non-required fields given a reasonable default.

Michal says:

February 14, 2009 at 10:58 am

I think Formbuilder is great. Never having tried to build a form before, I found it simple and easy to use. I have one question: I created a question where people need to be able to tick more than one tickbox (it’s a membership question and people filling in the form are likely to be members of more than one organization). Currently, the only way I have been able to do it is to create a new field for each tick box, which means that the first tick box lines up with the question, but then all the other tick boxes are below the question and do not look as though they are part of the question. Any suggestions to solve this would be much appreciated.

Mike Brown says:

February 15, 2009 at 4:53 am

I instaled this and was easy to post my forms very easily but want I really want to do is post my forms in the sidebar. Is there an easy way to do this?

I am not a programmer but I can follow simple instructions.

Thank you!

Buddy Ray says:

February 15, 2009 at 8:04 pm

I installed and activated Formbuilder. All went with no errors.
When I visit the Tools / Formbuilder page and click on any of the links to creat a new form, creat a new autoresponse or even the link to uninstall the database, I get a 404, page not found error.

Its trying to access: http://kids-closet.org/wordpress/wp-a&fbaction=newResponse

I’m running on a Windows Server at Godaddy with Formbuilder .074 and WP 2.7.1.

Any ideas?

Chris says:

February 16, 2009 at 4:31 pm

Hi,

Love the plug, just wondering if you can tell us the code to insert into a post as I need to control the position of the form, and by using the drop down it just appears at the bottom of the page.

admin says:

February 17, 2009 at 8:52 am

@Mike and Chris: You can find instructions on how to put forms other places in your content or template here:
http://truthmedia.com/2008/08/26/formbuilder-061/

@Michal: Yes, we have found this same issue. Unfortunately, checkboxes in HTML follow a very specific pattern basically requiring one field for each. We solved the problem by adding some more customized CSS to our templates to help line these up better. I hope to release updated form CSS at some point in the near future. In the mean time you should be able to follow the example see here:
http://truthmedia.com/wordpress/formbuilder/sample-form

Martin says:

February 20, 2009 at 3:12 pm

Hi,

I really do appreciate this plugin because it’s the only one that meets my requirements. But I found a bug that makes the generated form unuseable for me. (After form submission I get error messages that no required field was filled and that I have already sent the same date before. Whatever I fill in the form.)

I found out that when generating the form fields, the plugin does not generate attribute _name_ for any field, e.g I get in html. I found the problem between lines 606 and 767 (formbuilder.php). I had to replace every
> name=’$field[name]‘
for
> name=’” . $field[name] . “‘
to fix it.

Well, I don’t really know why the original code wasn’t working. But this little fix helped me and now everything is working perfect.

Best wishes,
Martin

P.S. my PHP configuration: http://s16.station.cz/php/

CC says:

February 26, 2009 at 1:00 pm

Installation and Activation went smoothly, all tables generated in MySQL. Then I got this error when I try to use Manage -> FormBuilder for the first time.

FormBuilder Management (v 0.74)
Navigation: FormBuilder show_adminpage(); break; case “uninstall”: formbuilder_cleaninstall($_GET[confirm]); break; default: formbuilder_options_default(); break; } ?>

I tried both WordPress 2.6.5 and 2.7.1, PHP 5.2.6, MySQL 5.0.45, Apache 2.2.11 on Windows XP. Please help, thanks!

James says:

March 3, 2009 at 10:51 am

@Martin: That seems like a very strange error. I’ll email you directly for more information.

@CC: I suspect that the problem you are encountering is due to some legacy “short tags” used in the codebase. I’ll try to clean those up for future releases, but in the mean time you should be able to fix the problem by switching on “short tags” in your PHP.ini file. (or have your website host do it).

andrew says:

March 8, 2009 at 9:23 am

love the plugin! one thing; when i export results to a csv it only exports the last 11 results whatever the date range i enter, any way i can change this?

Peter says:

March 12, 2009 at 10:58 am

I have problems in exporting the files to CSV.

It will try to call up a phyiscal path instead.

Any ideas on how to reconfig this?

Thanks,

James says:

March 16, 2009 at 8:38 am

Hi Andrew and Peter,

Sounds like we still have a few issues with the CSV exporting. I’ll have to look into those further when I have opportunity.

@Peter: Can you elaborate on what you mean by the fact that it is calling up a physical path?

James W.

Tom says:

March 24, 2009 at 4:19 am

How do I query data collected from one of my forms?

James says:

March 24, 2009 at 7:29 am

Hi Tom,

Right now, the query ability is very limited. From the main FormBuilder dashboard you would need to click the link to view stored form results, and can export them as CSV from that page.

We’re working on improving this functionality in the future.

Tom says:

March 24, 2009 at 10:22 am

Thanks, James.
I keep looking around through my wp-admin but don’t see a FormBuilder dashboard. If it’s there, I’m not seeing it.
Can you clarify? Thanks again.
Tom

Tom says:

March 24, 2009 at 11:11 am

Disregard, found it.