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
(@torgem)
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
(@torgem)
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.
It works with those prefix, could you try to create the table manually and see if it lets you please?
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;
