Title: Database Table Error on submit
Last modified: May 2, 2023

---

# Database Table Error on submit

 *  Resolved [torgem](https://wordpress.org/support/users/torgem/)
 * (@torgem)
 * [3 years ago](https://wordpress.org/support/topic/database-table-error-on-submit/)
 * Hi there,
 * when I submit a simple test form, I get the following error message as debug 
   output an in the logs (WP 6.2):
 * Table ‘_(dbschema)_.wp01_rednaoeasycalculationforms_records_detail’ doesn’t exist–#
   0
    -  This topic was modified 3 years ago by [torgem](https://wordpress.org/support/users/torgem/).

Viewing 4 replies - 1 through 4 (of 4 total)

 *  Plugin Author [EDGARROJAS](https://wordpress.org/support/users/edgarrojas/)
 * (@edgarrojas)
 * [3 years ago](https://wordpress.org/support/topic/database-table-error-on-submit/#post-16704511)
 * Hello!
 * Looks like one of the tables wasn’t created for some reason. to fix it please
   open the file core/PluginBase.php and temporary change this:
 * if($dbversion<$this->dbVersion)
 * for this
 * if(true)
 * This will force the plugin to create the tables again, after that please try 
   again.
 * Once the plugin submit the form correctly you can revert this change if you want
   or it will automatically removed in the next plugin update.
 * Regards!
 *  Thread Starter [torgem](https://wordpress.org/support/users/torgem/)
 * (@torgem)
 * [3 years ago](https://wordpress.org/support/topic/database-table-error-on-submit/#post-16706081)
 * This did not help:
 * public function MaybeCreateTables(){
 * $optionName=’rednao_’.$this->Prefix.’_db_version’;
 * $dbversion=get_option($optionName,0);
 * //if($dbversion<$this->dbVersion)
 * if(true)
 * {
 * $this->OnCreateTable();
 * update_option($optionName,$this->dbVersion);
 * }
 * }
 *  Thread Starter [torgem](https://wordpress.org/support/users/torgem/)
 * (@torgem)
 * [3 years ago](https://wordpress.org/support/topic/database-table-error-on-submit/#post-16706088)
 * My Tables Prefix is “wp01_”, default is “WP_”. Maybe the plugin does not work
   with alternative table prefix?
 * But… I see, other tables have been generated:
   e. g. “wp01_rednaoeasycalculationforms_records”
 * mySQL Version is 5.5
    -  This reply was modified 3 years ago by [torgem](https://wordpress.org/support/users/torgem/).
 *  Plugin Author [EDGARROJAS](https://wordpress.org/support/users/edgarrojas/)
 * (@edgarrojas)
 * [3 years ago](https://wordpress.org/support/topic/database-table-error-on-submit/#post-16707249)
 * It works with those prefix, could you try to create the table manually and see
   if it lets you please?
 *     ```wp-block-code
       CREATE TABLE wp01_rednaoeasycalculationforms_records_detail (
       entry_detail_id int AUTO_INCREMENT,
       form_id int,
       entry_id int,
       uniq_id int,
       type VARCHAR(30),
       field_id int NOT NULL,
       subtype varchar(200) NOT NULL,
       value MEDIUMTEXT NOT NULL,
       exvalue1 MEDIUMTEXT NOT NULL,
       exvalue2 MEDIUMTEXT NOT NULL,
       exvalue3 MEDIUMTEXT NOT NULL,
       exvalue4 MEDIUMTEXT NOT NULL,
       exvalue5 MEDIUMTEXT NOT NULL,
       exvalue6 MEDIUMTEXT NOT NULL,
       numericvalue DOUBLE,
       numericvalue2 DOUBLE,
       datevalue DATETIME,
       datevalue2 DATETIME,
       unit_price decimal(19,4),
       total_field_price decimal(19,4),
       PRIMARY KEY (entry_detail_id),
       KEY subtype (subtype),
       KEY entry_id (entry_id),
       KEY field_id (field_id),
       KEY numericvalue (numericvalue),
       KEY numericvalue2 (numericvalue2),
       KEY datevalue (datevalue),
       KEY datevalue2 (datevalue2),
       FULLTEXT KEY value (value),
       FULLTEXT KEY exvalue1 (exvalue1),
       FULLTEXT KEY exvalue2 (exvalue2),
       FULLTEXT KEY exvalue3 (exvalue3),
       FULLTEXT KEY exvalue4 (exvalue4),
       FULLTEXT KEY exvalue5 (exvalue5),
       FULLTEXT KEY exvalue6 (exvalue6)
       ) COLLATE utf8_general_ci;
       ```
   

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Database Table Error on submit’ is closed to new replies.

 * ![](https://ps.w.org/all-in-one-forms/assets/icon-256x256.gif?rev=2935720)
 * [AIO Forms - Craft Complex Forms Easily](https://wordpress.org/plugins/all-in-one-forms/)
 * [Support Threads](https://wordpress.org/support/plugin/all-in-one-forms/)
 * [Active Topics](https://wordpress.org/support/plugin/all-in-one-forms/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/all-in-one-forms/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/all-in-one-forms/reviews/)

 * 4 replies
 * 2 participants
 * Last reply from: [EDGARROJAS](https://wordpress.org/support/users/edgarrojas/)
 * Last activity: [3 years ago](https://wordpress.org/support/topic/database-table-error-on-submit/#post-16707249)
 * Status: resolved