webimap

**clarification**
What you have said about the expiration date I have changed to 2050 and everything was still the same

This is how it should look like (here it is with version 1.7.6)

Still not working.

And the console keeps giving the same error:

This is the version I am using of the plugin:

I am going to go back to version 1.7.6, since it is the last version that everything works correctly. But we would be interested in having the latest version for security reasons

Hello,

The same thing keeps happening, but looking at the logs we see the following error:

[11-Jan-2023 10:50:52 UTC] PHP Warning:  strtolower() expects parameter 1 to be string, array given in /home/inmobico/public_html/wp-includes/media.php on line 215
[11-Jan-2023 10:50:53 UTC] PHP Warning:  strtolower() expects parameter 1 to be string, array given in /home/inmobico/public_html/wp-includes/media.php on line 215
[11-Jan-2023 10:50:53 UTC] PHP Warning:  strtolower() expects parameter 1 to be string, array given in /home/inmobico/public_html/wp-includes/media.php on line 215
[11-Jan-2023 10:50:53 UTC] PHP Warning:  strtolower() expects parameter 1 to be string, array given in /home/inmobico/public_html/wp-includes/media.php on line 215
[11-Jan-2023 10:50:53 UTC] Error Incorrect DATETIME value: '' de la base de datos de WordPress para la consulta  SELECT * FROM IMP_posts 
  as listing 
   left join IMP_ulisting_listing_plan as listing_plan on (listing_plan.listing_id = listing.ID) 
  WHERE listing_plan.type = "limit_count" AND listing_plan.expired_date != "" AND listing_plan.expired_date <= "2023-01-11 10:50:53"   
  
  
  ORDER BY listing.ID ASC 
  
   realizada por do_action_ref_array('stm_listing_cron'), WP_Hook->do_action, WP_Hook->apply_filters, uListing\Classes\StmCron::run_cron, uListing\Classes\StmListing::expired_notifications, uListing\Classes\StmListing::expired_listings, uListing\Classes\Vendor\Query->find
[11-Jan-2023 10:50:53 UTC] Error Incorrect DATETIME value: '' de la base de datos de WordPress para la consulta  SELECT * FROM IMP_ulisting_listing_attribute_relationships 
  as listing_attribute 
   left join IMP_ulisting_listing_plan as listing_plan on (listing_plan.listing_id = listing_attribute.listing_id) 
  WHERE listing_attribute.attribute = "feature" AND listing_plan.type = "feature" AND listing_plan.expired_date != "" AND listing_plan.expired_date <= "2023-01-11 10:50:53"   
  
  
  ORDER BY listing_attribute.id ASC 
  
   realizada por do_action_ref_array('stm_listing_cron'), WP_Hook->do_action, WP_Hook->apply_filters, uListing\Classes\StmCron::run_cron, uListing\Classes\StmListing::expired_notifications, uListing\Classes\StmListing::expired_featured_listings, uListing\Classes\Vendor\Query->find
[11-Jan-2023 10:50:53 UTC] Error Incorrect DATETIME value: '' de la base de datos de WordPress para la consulta  DELETE  listing_attribute  FROM IMP_ulisting_listing_attribute_relationships 
  as listing_attribute 
   left join IMP_ulisting_listing_plan as listing_plan on (listing_plan.listing_id = listing_attribute.listing_id) 
  WHERE listing_attribute.attribute = "feature" AND listing_plan.type = "feature" AND listing_plan.expired_date != "" AND listing_plan.expired_date <= "2023-01-11 10:50:53"   realizada por do_action_ref_array('stm_listing_cron'), WP_Hook->do_action, WP_Hook->apply_filters, uListing\Classes\StmCron::run_cron, uListing\Lib\PricingPlan\Classes\StmListingPlan::delete_expired_listing_plan, uListing\Classes\Vendor\Query->delete
[11-Jan-2023 10:50:53 UTC] Error Incorrect DATETIME value: '' de la base de datos de WordPress para la consulta UPDATE IMP_posts  as listing   left join IMP_ulisting_listing_plan as listing_plan on (listing_plan.listing_id = listing.ID) SET post_status='draft'  WHERE listing_plan.type = "limit_count" AND listing_plan.expired_date != "" AND listing_plan.expired_date <= "2023-01-11 10:50:53"   realizada por do_action_ref_array('stm_listing_cron'), WP_Hook->do_action, WP_Hook->apply_filters, uListing\Classes\StmCron::run_cron, uListing\Lib\PricingPlan\Classes\StmListingPlan::delete_expired_listing_plan, uListing\Classes\Vendor\Query->update
[11-Jan-2023 10:50:53 UTC] Error Incorrect DATETIME value: '' de la base de datos de WordPress para la consulta  DELETE  FROM IMP_ulisting_listing_plan 
  
  
  WHERE expired_date != "" AND expired_date <= "2023-01-11 10:50:53"  realizada por do_action_ref_array('stm_listing_cron'), WP_Hook->do_action, WP_Hook->apply_filters, uListing\Classes\StmCron::run_cron, uListing\Lib\PricingPlan\Classes\StmListingPlan::delete_expired_listing_plan, uListing\Classes\Vendor\Query->delete
[11-Jan-2023 10:51:34 UTC] PHP Warning:  strtolower() expects parameter 1 to be string, array given in /home/inmobico/public_html/wp-includes/media.php on line 215
[11-Jan-2023 10:51:34 UTC] PHP Warning:  strtolower() expects parameter 1 to be string, array given in /home/inmobico/public_html/wp-includes/media.php on line 215
[11-Jan-2023 10:51:34 UTC] PHP Warning:  strtolower() expects parameter 1 to be string, array given in /home/inmobico/public_html/wp-includes/media.php on line 215

Inside the query that seems to output the property listing is doing the comparison listing_plan.expired_date != ” in which it compares the value of a datetime type field with a blank text string. Depending on the version of mySQL it throws an error, which is what causes the listing to not be retrieved and the editor to fail.

Thank you!!