[Plugin: Formbuilder] can’t create new form

Hey Troy,

What platform are you running on?
WordPress Version
Server Type (IIS or Apache)
MySQL version
….

James W

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

still have not come close to making this work.

probably gonna have to look at other form plugins

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