Posted 1 year ago #
Just installed FormBuilder v 0.852
When I try to create a new form, I get the following error message:
Unable to create new form. Attempted to run the following SQL:
INSERT INTO wp_an4nql_formbuilder_forms(name,subject,recipient,thankyoutext) VALUES ('New Form', 'Generic Website Feedback Form', 'info@bradfest.org', '');
Is there a fix for this?
Kind Thanks,
Troy
Posted 1 year ago #
Hey Troy,
What platform are you running on?
WordPress Version
Server Type (IIS or Apache)
MySQL version
....
James W
Posted 1 year ago #
i'm having the same problem
wp 3.0.1
apache
mysql v. 5.1
my message looks exactly the same as above...well, obviously with my email address.
thanks in advance for any help.
nate
Posted 1 year ago #
well, i think i found my problem, although i haven't yet found a solution. upon activation i get the following mysql errors.
Failed running query: CREATE TABLE IF NOT EXISTS wp_8yuo70_formbuilder_fields ( id bigint(20) NOT NULL auto_increment, form_id bigint(20) NOT NULL default '0', display_order int(11) NOT NULL default '0', field_type varchar(255) NOT NULL default '', field_name varchar(255) NOT NULL default '', field_value text NOT NULL, field_label text NOT NULL, required_data varchar(255) NOT NULL default '', error_message text NOT NULL, UNIQUE KEY id (id) ) DEFAULT CHARACTER SET DB_CHARSET COLLATE DB_COLLATE;
Failed running query: CREATE TABLE IF NOT EXISTS wp_8yuo70_formbuilder_forms ( id bigint(20) NOT NULL auto_increment, name varchar(255) NOT NULL default '', subject text NOT NULL, recipient text NOT NULL, method enum('POST','GET') NOT NULL default 'POST', action varchar(255) NOT NULL default '', thankyoutext text NOT NULL, autoresponse bigint(20) NOT NULL default '0', UNIQUE KEY id (id) ) DEFAULT CHARACTER SET DB_CHARSET COLLATE DB_COLLATE;
Failed running query: CREATE TABLE IF NOT EXISTS wp_8yuo70_formbuilder_pages ( id bigint(20) NOT NULL auto_increment, post_id bigint(20) NOT NULL default '0', form_id bigint(20) NOT NULL default '0', UNIQUE KEY id (id) ) DEFAULT CHARACTER SET DB_CHARSET COLLATE DB_COLLATE;
Failed running query: CREATE TABLE IF NOT EXISTS wp_8yuo70_formbuilder_responses ( id bigint(20) NOT NULL auto_increment, name varchar(255) NOT NULL default '', subject text NOT NULL, message text NOT NULL, from_name varchar(255) NOT NULL default '', from_email varchar(255) NOT NULL default '', PRIMARY KEY (id) ) DEFAULT CHARACTER SET DB_CHARSET COLLATE DB_COLLATE;
Failed running query: CREATE TABLE IF NOT EXISTS wp_8yuo70_formbuilder_results ( id bigint(20) unsigned zerofill NOT NULL auto_increment, form_id bigint(20) unsigned zerofill NOT NULL default '00000000000000000000', timestamp bigint(20) unsigned zerofill NOT NULL, xmldata longtext NOT NULL, PRIMARY KEY (id), KEY form_id (form_id,timestamp) ) DEFAULT CHARACTER SET DB_CHARSET COLLATE DB_COLLATE;
i got these with version 0.852...uninstalled that, and got the same with 0.84
Posted 1 year ago #
got past the query problem. it's installed.
however i'm still getting the "Formbuilder needs to be configured" and this same error...
"Unable to create new form. Attempted to run the following SQL:
INSERT INTO wp_8yuo70_formbuilder_forms(name,subject,recipient,thankyoutext) VALUES ('New Form', 'Generic Website Feedback Form', 'me@mycompany.com', '');"
Posted 1 year ago #
still have not come close to making this work.
probably gonna have to look at other form plugins
Posted 1 year ago #
Bump
WordPress version: 3.0.1
FormBuilder: v 0.852
Database errors when I first visit the admin page, as detailed above.
Posted 1 year ago #
Solved:
I logged in to phpMyAdmin and tried pasting the SQL CREATE TABLE statements in manually and got the following error:
MySQL said: Documentation
#1115 - Unknown character set: 'DB_CHARSET'I went to the Home page and made note of the following fields on the overview page:
MySQL charset: UTF-8 Unicode (utf8)
MySQL connection collation: utf8_unicode_ci
I then copied the database error messages pasted them into the SQL tab for the WordPress db, removed the texts 'Failed running query' from each, replaced the string
DEFAULT CHARACTER SET DB_CHARSET COLLATE DB_COLLATE
with
DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci
..and successfully executed the statements. I can now create forms.
Neither DB_CHARSET or DB_COLLATE are defined in my wp-config.php file. The following guide says to leave them undefined:
http://codex.wordpress.org/Editing_wp-config.php#Database_collation
Posted 1 year ago #
Hey brylie,
Looks like you found the problem. I guess some WordPress installs don't include the predefined DB_CHARSET and COLLATE constants. Strange... Anyway, I'll update the FB code to check for those in the next version. thanks for helping us figure this out.
James W.
This topic has been closed to new replies.
