brfp

just manually add the two tables, and issue solved.

For my understanding, MySQL provides various storage engines for its tables as follows:
MyISAM
InnoDB
MERGE
MEMORY (HEAP)
ARCHIVE
CSV
FEDERATED

I am not sure what is MySQLi?

In addition, since the two tables can not be created in the database, how can I can switch the storage engines?

In addition, removed both wp_wfls_settings.ibd and wp_wfls_2fa_secrets.ibd, the errors keep same after re-install.
It seems wp_wfls_settings.frm and wp_wfls_2fa_secrets.frm can not get back.

The two tables were corrupted and dropped.

After adding this line to /etc/my.cnf: innodb_log_file_size=5M, and reinstalling plugin, wp_wfls_settings.ibd the wp_wfls_2fa_secrets.ibd already exists, but the corresponding tables did not exist in the InnoDB data dictionary.

Below is the php.error.log information for reinstallation:

SELECT name, val, autoload FROM wp_wfConfig WHERE name = ‘allowLegacy2FA’

error: Table ‘database .wp_wfConfig’ doesn’t exist，

(activate_plugin, include_once(‘/plugins/wordfence/wordfence.php’),
require_once(‘/plugins/wordfence/lib/wordfenceClass.php’),
wfCredentialsController::useLegacy2FA, wfCredentialsController::allowLegacy2FA, wfConfig::get。)

CREATE TABLE IF NOT EXISTS wp_wfls_2fa_secrets (
id int(11) unsigned NOT NULL AUTO_INCREMENT,
user_id bigint(20) unsigned NOT NULL,
secret tinyblob NOT NULL,
recovery blob NOT NULL,
ctime int(10) unsigned NOT NULL,
vtime int(10) unsigned NOT NULL,
mode enum(‘authenticator’) NOT NULL DEFAULT ‘authenticator’,
PRIMARY KEY (id),
KEY user_id (user_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

error: Table ‘database.wp_wfls_2fa_secrets‘ already exists，

(activate_plugin, include_once(‘/plugins/wordfence/wordfence.php’),
require_once(‘/plugins/wordfence/lib/wordfenceClass.php’),
require(‘/plugins/wordfence/modules/login-security/wordfence-login-security.php’),
WordfenceLS\Controller_WordfenceLS->init, WordfenceLS\Controller_WordfenceLS->_init_actions,
WordfenceLS\Controller_WordfenceLS->_install, WordfenceLS\Controller_DB->install)
WordfenceLS\Controller_DB->_create_schema。

CREATE TABLE IF NOT EXISTS wp_wfls_settings (
name varchar(191) NOT NULL DEFAULT ”,
value longblob,
autoload enum(‘no’,’yes’) NOT NULL DEFAULT ‘yes’,
PRIMARY KEY (name)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

error: Table ‘database.wp_wfls_settings‘ already exists，

(activate_plugin, include_once(‘/plugins/wordfence/wordfence.php’),
require_once(‘/plugins/wordfence/lib/wordfenceClass.php’),
require(‘/plugins/wordfence/modules/login-security/wordfence-login-security.php’),
WordfenceLS\Controller_WordfenceLS->init, WordfenceLS\Controller_WordfenceLS->_init_actions,
WordfenceLS\Controller_WordfenceLS->_install, WordfenceLS\Controller_DB->install,
WordfenceLS\Controller_DB->_create_schema)

I tried to style the button by modifying the css you mentioned, but it does not work

original:
______________________

.es_textbox_button
{
width:100px;
}
______________________

.es_textbox_button
{
background-color:#ed8223;
color:#fff;
font-family:’Helvetica Neue’,sans-serif;
font-size:18px;
line-height:30px;
border-radius:20px;
-webkit-border-radius:20px;
-moz-border-radius:20px;
border:0;
text-shadow:#C17C3A 0 -1px 0;
width:120px;
height:32px
}

It can be done by directly entering Latitude and Longitude, but I prefer to enter zipcode and then latitude and longitude will be able to automatically generated from frontend, which currently can only be done from the back.

Anyway, thank you very much for the help!

Hi Tijmen,

Thanks a lot for your quick reply. Yes, I do use a third party plugin to enter the data. There are any way to directly geocode by enter an address from frontend?

same question. each services should have its time slot.

Restore password activation link does not work. I have to change back to WP-default restore link by editing login form! In addition, this plugin conflicts with some plugins.

View “detail” issue happened in WP multiple-site. Single site seems Ok.

I have found the reason that “zip code” can not be saved. Zip code input can only be “number”, not “text”. otherwise, zip code can not be saved.

You should change the zipCode input variable setting since the zipcode in some europe countries consists of nember and text!

Another bug is that “Longitude” and “Latitude” can not be automatically generated. Manually input the data, can not be saved. Thus, keep “undefined”.

The map can be shown at backend. But no map data in frontend.

I setup a test-site for your reference:
https://house.zs-store.com/?properties=2-bed-room-house

the site also has another real-estate plugin.

When I click “view detail”, the page opened is home page, not the single property page.

Hi Thanks. Yes, the map works right now. Another bug is the permalink for “detail” does not work, it redirects to home page. not to single property show detail.

Thanks for the suggestion. The issue I addressed happened in wordpress multi-site. Single site works fine.

latest version(2.4.6) has bugs for adding a new property type. Old version such as 1.9.0 can add a new property type.

Another bug is “for sale” page can not show when logged out from admin panel.

I guess I can not give you my admin access. I tested your plugin with different themes, and roled out other plugin conflicts by disable all other plugins. Thus, my guess is your free version might have some bugs.