I can’t edit listings

Hello,

The latest version of uListing plugin is 2.1.2 (not 2.0) you can check it here:

Link

Please update the plugin to the latest version as well as the theme, here is the link to the update manual:

Link

After that, please re-check this case. We didn’t find this problem on our test websites. If the situation does not change after the update, please let us know.

Best regards.

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.

Hello @webimap,

Please go to the Dashboard > uListing > Pricing Plans > User Plans and check Expired date of the Plans. If Plan is already expired renew with actual dates.

If after changing expire dates of the plans let us know.

Regards

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

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

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

Hello dear,

Could you please kindly make sure that you have checked the issue in a proper environment with correct settings in the uListing plugin directly. We recommend you check on your own local host by creating a new user and including new listing from a scratch, as we didn’t detect any restrictions on our own testing environment

All the best!