J-BusinessDirectory - Just updated to JBD to V5.7.2 But Warning Generated

Just updated to V5.7.2 but the following error was generated:

Warning: Undefined property: stdClass::$show_top_filter in /home/japantouring/stage.japantouring.com/components/com_jbusinessdirectory/models/search.php on line 959

The lines are:

//filter categories by general settings
$filteredCategories = $this->appSettings->search_categories;
if(!empty($filteredCategories) && $this->appSettings->show_top_filter){
$filteredTotal = array();
foreach ($categoriesTotal as $categoryTotal) {
if (in_array($categoryTotal->id, $filteredCategories)) {
$filteredTotal[] = $categoryTotal;
}
}

=============================

I subsequently uninstalled JBD and insured that the database tables related to JDB were also removed.

I reinstalled JBD and an DB error was shown on the Joomla backend Data Maintenance page, the following of which is displayed when the Red One Problem button is hovered over: 

	<ul><li>Table 'j401_jbusinessdirectory_companies' has the wrong type or attributes for column 'time_zone' with type `time_zone`. (From file 5.0.1.sql.)</li><li>Table 'j401_jbusinessdirectory_application_settings' should not have index 'idx_name'. 
(From file 5.0.1.sql.)</li><li>Table 'j401_jbusinessdirectory_package_fields' has the wrong type or attributes for column 'int' with type `id`. (From file 5.1.0.sql.)</li><li>Table 'j401_jbusinessdirectory_orders' has the wrong type or attributes for column 'vat' with type `vat`. 
(From file 5.3.0.sql.)</li><li>Table 'j401_jbusinessdirectory_search_logs(' does not exist. (From file 5.3.1.sql.)</li><li>Table 'j401_jbusinessdirectory_company_events' should not have index 'idx_search'. (From file 5.3.6.sql.)</li>
<li>Table 'j401_jbusinessdirectory_companies' has the wrong type or attributes for column 'keywords' with type `keywords`. (From file 5.3.6.sql.)</li><li>Table 'j401_jbusinessdirectory_billing_details' has the wrong type or attributes for column 'address' with type `address`. (From file 5.4.1.sql.)</li>
<li>Table 'j401_jbusinessdirectory_companies' has the wrong type or attributes for column 'employees' with type `employees`. (From file 5.4.2.sql.)</li><li>Table 'j401_jbusinessdirectory_companies' has the wrong type or attributes for column 'keywords' with type `keywords`. (From file 5.4.2.sql.)</li>
<li>Table 'j401_jbusinessdirectory_companies' has the wrong type or attributes for column 'website' with type `website`. (From file 5.4.2.sql.)</li><li>Table 'j401_jbusinessdirectory_packages' has the wrong type or attributes for column 'price' with type `price`. (From file 5.4.5.sql.)</li>
<li>Table 'j401_jbusinessdirectory_orders' has the wrong type or attributes for column 'initial_amount' with type `initial_amount`. (From file 5.4.5.sql.)</li><li>Table 'j401_jbusinessdirectory_orders' has the wrong type or attributes for column 'discount_amount' with type `discount_amount`. (From file 5.4.6.sql.)</li>
<li>Table 'IF' does not exist. (From file 5.4.9.sql.)</li><li>Table 'j401_jbusinessdirectory_taxes' has the wrong type or attributes for column 'tax_amount' with type `tax_amount`. (From file 5.5.5.sql.)</li><li>Table 'j401_jbusinessdirectory_order_taxes' has the wrong type or attributes for column 'tax_amount' with type `tax_amount`. (From file 5.5.5.sql.)</li>
<li>Table 'j401_jbusinessdirectory_packages' has the wrong type or attributes for column 'price' with type `price`. (From file 5.5.6.sql.)</li><li>Table 'j401_jbusinessdirectory_conference_sessions' has the wrong type or attributes for column 'short_description' with type `short_description`. (From file 5.5.9.sql.)</li>
<li>Table 'j401_jbusinessdirectory_conference_session_speakers' has the wrong type or attributes for column 'speaker_order' with type `speaker_order`. (From file 5.5.9.sql.)</li><li>Table 'j401_jbusinessdirectory_conference_sessions' has the wrong type or attributes for column 'name' with type `name`. (From file 5.5.9.sql.)</li>
<li>Table 'j401_jbusinessdirectory_conference_sessions' has the wrong type or attributes for column 'name' with type `name`. (From file 5.5.10.sql.)</li><li>Table 'j401_jbusinessdirectory_packages' has the wrong type or attributes for column 'description' with type `description`. (From file 5.6.0.sql.)</li>
<li>Table 'j401_jbusinessdirectory_company_reviews_question' has the wrong type or attributes for column 'ordering' with type `ordering`. (From file 5.6.1.sql.)</li><li>Table 'j401_jbusinessdirectory_company_event_tickets' has the wrong type or attributes for column 'ordering' with type `ordering`. (From file 5.6.1.sql.)</li>
<li>Table 'j401_jbusinessdirectory_company_event_types' has the wrong type or attributes for column 'ordering' with type `ordering`. (From file 5.6.1.sql.)</li><li>Table 'j401_jbusinessdirectory_company_offer_types' has the wrong type or attributes for column 'ordering' with type `ordering`. (From file 5.6.1.sql.)</li>
<li>Table 'j401_jbusinessdirectory_company_types' has the wrong type or attributes for column 'ordering' with type `ordering`. (From file 5.6.1.sql.)</li><li>Table 'j401_jbusinessdirectory_payment_processors' has the wrong type or attributes for column 'ordering' with type `ordering`. (From file 5.6.1.sql.)</li>
<li>Table 'j401_jbusinessdirectory_company_reviews_criteria' has the wrong type or attributes for column 'ordering' with type `ordering`. (From file 5.6.1.sql.)</li><li>Table 'j401_jbusinessdirectory_order_taxes' has the wrong type or attributes for column 'ordering' with type `ordering`. (From file 5.6.1.sql.)</li>
<li>Table 'j401_jbusinessdirectory_request_quote_questions' has the wrong type or attributes for column 'ordering' with type `ordering`. (From file 5.6.1.sql.)</li><li>Table 'j401_jbusinessdirectory_videos' has the wrong type or attributes for column 'ordering' with type `ordering`. (From file 5.6.1.sql.)</li>
<li>Table 'j401_jbusinessdirectory_taxes' has the wrong type or attributes for column 'ordering' with type `ordering`. (From file 5.6.1.sql.)</li><li>Table 'j401_jbusinessdirectory_attributes' has the wrong type or attributes for column 'show_on_search' with type `show_on_search`. (From file 5.6.2.sql.)</li>
<li>Table 'j401_jbusinessdirectory_company_events' has the wrong type or attributes for column 'approved' with type `approved`. (From file 5.6.3.sql.)</li><li>Table 'j401_jbusinessdirectory_campaigns' has the wrong type or attributes for column 'initial_budget' with type `initial_budget`. (From file 5.7.0.sql.)</li>
<li>Table 'j401_jbusinessdirectory_campaign_plans' has the wrong type or attributes for column 'click_price' with type `click_price`. (From file 5.7.0.sql.)</li><li>Table 'j401_jbusinessdirectory_company_event_bookings' has the wrong type or attributes for column 'amount' with type `amount`. (From file 5.7.0.sql.)</li>
<li>Table 'j401_jbusinessdirectory_company_event_tickets' has the wrong type or attributes for column 'price' with type `price`. (From file 5.7.0.sql.)</li><li>Table 'j401_jbusinessdirectory_company_offers' has the wrong type or attributes for column 'price' with type `price`. (From file 5.7.0.sql.)</li>
<li>Table 'j401_jbusinessdirectory_company_offer_orders' has the wrong type or attributes for column 'amount' with type `amount`. (From file 5.7.0.sql.)</li><li>Table 'j401_jbusinessdirectory_company_offer_order_products' has the wrong type or attributes for column 'price' with type `price`. (From file 5.7.0.sql.)</li>
<li>Table 'j401_jbusinessdirectory_company_services' has the wrong type or attributes for column 'price' with type `price`. (From file 5.7.0.sql.)</li><li>Table 'j401_jbusinessdirectory_company_services_list' has the wrong type or attributes for column 'service_price' with type `service_price`. (From file 5.7.0.sql.)</li>
<li>Table 'j401_jbusinessdirectory_company_service_bookings' has the wrong type or attributes for column 'amount' with type `amount`. (From file 5.7.0.sql.)</li><li>Table 'j401_jbusinessdirectory_offer_shipping_methods' has the wrong type or attributes for column 'price' with type `price`. (From file 5.7.0.sql.)</li><li>Table 'j401_jbusinessdirectory_offer_stock' has the wrong type or attributes for column 'price' with type `price`. (From file 5.7.0.sql.)</li><li>Table 'j401_jbusinessdirectory_order_packages' has the wrong type or attributes for column 'price' with type `price`. (From file 5.7.0.sql.)</li><li>Table 'j401_jbusinessdirectory_order_taxes' has the wrong type or attributes for column 'tax_amount' with type `tax_amount`. (From file 5.7.0.sql.)</li><li>Table 'j401_jbusinessdirectory_payments' has the wrong type or attributes for column 'amount' with type `amount`. (From file 5.7.0.sql.)</li><li>Table 'j401_jbusinessdirectory_shipping_methods' has the wrong type or attributes for column 'price' with type `price`. (From file 5.7.0.sql.)</li><li>Table 'j401_jbusinessdirectory_subscriptions' has the wrong type or attributes for column 'amount' with type `amount`. (From file 5.7.0.sql.)</li><li>Table 'j401_jbusinessdirectory_tax_countries' has the wrong type or attributes for column 'amount' with type `amount`. (From file 5.7.0.sql.)</li><li>Table 'j401_jbusinessdirectory_taxes' has the wrong type or attributes for column 'tax_amount' with type `tax_amount`. (From file 5.7.0.sql.)</li><li>Table 'j401_jbusinessdirectory_application_settings' has the wrong type or attributes for column 'value' with type `value`. (From file 5.7.2.sql.)</li><li>Table 'j401_jbusinessdirectory_attribute_types' has the wrong type or attributes for column 'id' with type `id`. (From file 5.7.2.sql.)</li><li>Table 'j401_jbusinessdirectory_campaign_plans' has the wrong type or attributes for column 'name' with type `name`. (From file 5.7.2.sql.)</li><li>Table 'j401_jbusinessdirectory_categories' has the wrong type or attributes for column 'name' with type `name`. (From file 5.7.2.sql.)</li><li>Table 'j401_jbusinessdirectory_companies' has the wrong type or attributes for column 'name' with type `name`. (From file 5.7.2.sql.)</li><li>Table 'j401_jbusinessdirectory_company_events' has the wrong type or attributes for column 'description' with type `description`. (From file 5.7.2.sql.)</li><li>Table 'j401_jbusinessdirectory_company_event_pictures' has the wrong type or attributes for column 'picture_info' with type `picture_info`. (From file 5.7.2.sql.)</li><li>Table 'j401_jbusinessdirectory_company_event_tickets' has the wrong type or attributes for column 'description' with type `description`. (From file 5.7.2.sql.)</li><li>Table 'j401_jbusinessdirectory_company_locations' has the wrong type or attributes for column 'address' with type `address`. (From file 5.7.2.sql.)</li><li>Table 'j401_jbusinessdirectory_company_members' has the wrong type or attributes for column 'name' with type `name`. (From file 5.7.2.sql.)</li><li>Table 'j401_jbusinessdirectory_company_offers' has the wrong type or attributes for column 'subject' with type `subject`. (From file 5.7.2.sql.)</li><li>Table 'j401_jbusinessdirectory_company_offer_pictures' has the wrong type or attributes for column 'picture_info' with type `picture_info`. (From file 5.7.2.sql.)</li><li>Table 'j401_jbusinessdirectory_company_pictures' has the wrong type or attributes for column 'picture_info' with type `picture_info`. (From file 5.7.2.sql.)</li><li>Table 'j401_jbusinessdirectory_company_projects' has the wrong type or attributes for column 'description' with type `description`. (From file 5.7.2.sql.)</li><li>Table 'j401_jbusinessdirectory_company_projects_pictures' has the wrong type or attributes for column 'picture_info' with type `picture_info`. (From file 5.7.2.sql.)</li><li>Table 'j401_jbusinessdirectory_company_providers' has the wrong type or attributes for column 'name' with type `name`. (From file 5.7.2.sql.)</li><li>Table 'j401_jbusinessdirectory_company_ratings' has the wrong type or attributes for column 'rating' with type `rating`. (From file 5.7.2.sql.)</li><li>Table 'j401_jbusinessdirectory_company_registered' has the wrong type or attributes for column 'approved' with type `approved`. (From file 5.7.2.sql.)</li><li>Table 'j401_jbusinessdirectory_company_reviews' has the wrong type or attributes for column 'description' with type `description`. (From file 5.7.2.sql.)</li><li>Table 'j401_jbusinessdirectory_company_review_abuses' has the wrong type or attributes for column 'email' with type `email`. (From file 5.7.2.sql.)</li><li>Table 'j401_jbusinessdirectory_company_review_responses' has the wrong type or attributes for column 'response' with type `response`. (From file 5.7.2.sql.)</li><li>Table 'j401_jbusinessdirectory_company_services' has the wrong type or attributes for column 'name' with type `name`. (From file 5.7.2.sql.)</li><li>Table 'j401_jbusinessdirectory_company_services_list' has the wrong type or attributes for column 'service_section' with type `service_section`. (From file 5.7.2.sql.)</li><li>Table 'j401_jbusinessdirectory_conferences' has the wrong type or attributes for column 'description' with type `description`. (From file 5.7.2.sql.)</li><li>Table 'j401_jbusinessdirectory_conference_sessions' has the wrong type or attributes for column 'description' with type `description`. (From file 5.7.2.sql.)</li><li>Table 'j401_jbusinessdirectory_conference_session_speakers' has the wrong type or attributes for column 'speaker_order' with type `speaker_order`. (From file 5.7.2.sql.)</li><li>Table 'j401_jbusinessdirectory_conference_speakers' has the wrong type or attributes for column 'biography' with type `biography`. (From file 5.7.2.sql.)</li><li>Table 'j401_jbusinessdirectory_countries' has the wrong type or attributes for column 'country_name' with type `country_name`. (From file 5.7.2.sql.)</li><li>Table 'j401_jbusinessdirectory_currencies' has the wrong type or attributes for column 'currency_name' with type `currency_name`. (From file 5.7.2.sql.)</li><li>Table 'j401_jbusinessdirectory_date_formats' has the wrong type or attributes for column 'name' with type `name`. (From file 5.7.2.sql.)</li><li>Table 'j401_jbusinessdirectory_directory_apps' has the wrong type or attributes for column 'name' with type `name`. (From file 5.7.2.sql.)</li><li>Table 'j401_jbusinessdirectory_discounts' has the wrong type or attributes for column 'name' with type `name`. (From file 5.7.2.sql.)</li><li>Table 'j401_jbusinessdirectory_emails' has the wrong type or attributes for column 'email_subject' with type `email_subject`. (From file 5.7.2.sql.)</li><li>Table 'j401_jbusinessdirectory_language_translations' has the wrong type or attributes for column 'type' with type `type`. (From file 5.7.2.sql.)</li><li>Table 'j401_jbusinessdirectory_messages' has the wrong type or attributes for column 'email' with type `email`. (From file 5.7.2.sql.)</li><li>Table 'j401_jbusinessdirectory_news' has the wrong type or attributes for column 'description' with type `description`. (From file 5.7.2.sql.)</li><li>Table 'j401_jbusinessdirectory_offer_stock' has the wrong type or attributes for column 'notify_stock_qty' with type `notify_stock_qty`. (From file 5.7.2.sql.)</li><li>Table 'j401_jbusinessdirectory_order_packages' has the wrong type or attributes for column 'ordering' with type `ordering`. (From file 5.7.2.sql.)</li><li>Table 'j401_jbusinessdirectory_packages' has the wrong type or attributes for column 'ordering' with type `ordering`. (From file 5.7.2.sql.)</li><li>Table 'j401_jbusinessdirectory_payments' has the wrong type or attributes for column 'processor_type' with type `processor_type`. (From file 5.7.2.sql.)</li><li>Table 'j401_jbusinessdirectory_payment_processors' has the wrong type or attributes for column 'name' with type `name`. (From file 5.7.2.sql.)</li><li>Table 'j401_jbusinessdirectory_reports' has the wrong type or attributes for column 'description' with type `description`. (From file 5.7.2.sql.)</li><li>Table 'j401_jbusinessdirectory_request_quote' has the wrong type or attributes for column 'summary' with type `summary`. (From file 5.7.2.sql.)</li><li>Table 'j401_jbusinessdirectory_request_quote_messages' has the wrong type or attributes for column 'text' with type `text`. (From file 5.7.2.sql.)</li><li>Table 'j401_jbusinessdirectory_review_pictures' has the wrong type or attributes for column 'picture_info' with type `picture_info`. (From file 5.7.2.sql.)</li><li>Table 'j401_jbusinessdirectory_shipping_methods' has the wrong type or attributes for column 'description' with type `description`. (From file 5.7.2.sql.)</li><li>Table 'j401_jbusinessdirectory_company_pictures_extra' has the wrong type or attributes for column 'image_info' with type `image_info`. (From file 5.7.2.sql.)</li><li>168 database changes were checked.</li>

<li>295 database changes did not alter table structure and were skipped.</li></ul>

I am sending the Joomla System Info via "Contact US"
											

I would try turning off all your modules to see if the error goes away.

If the issue disappears, then turn them on one by one to find the culprit.

I recall something similar, here, a way back.

For the $show_top_filter warning, you need to access directory general settings set the show top filter setting.
The warnings for the database are caused by a Joomla bug. There is nothing wrong with the database. This feature is new and does not parse the update SQL files correctly.

Thanks for the timely reply!

I will close my eyes everytime I see that nasty little warning then

Regards,

Jim

We will apply also some changes on the 5.7.3 version to avoid this warnings.

I got the same warnings when trying to install the new update. Moreover, when I went further with the update, all my products disappeared.Could it be that the new Joomla update and JB update are in conflict?

There is no conflict between Joomla and JBD. What products have disappeared? From where?

I am using Joomla! 4.1.2 and JBD v5.7.2 and was able to update from JBD v5.7.1 to v5.7.2 without any problems.

Can you provide specifics to your post:

   - What is your Joomla version

   - What is your JBD version

   - Need to quote the warning

   - Any screenshots or videos would be helpful.

Also, JBD is compatible for Joomla 3 and 4.

Just installed JBD 5.8.1 and the same warning appears in error_log, now for another component:

PHP Warning: Undefined property: stdClass::$latitude in .../components/com_jbusinessdirectory/helpers/utils.php on line 996
(and same warning for line 997).

Could you please advise?