Skip to:
Content
Pages
Categories
Search
Top
Bottom

Search Results for 'country state city'

Viewing 25 results - 1 through 25 (of 46 total)
  • Author
    Search Results
  • #318859
    leaftechakshay
    Participant

    i have posted an error log for refrance

    [12-May-2021 10:18:40 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT
    *
    FROM wp_aioseo_notifications
    WHERE 1 = 1 AND
    notification_name = ‘deprecated-filters’
    /* 1 = 1 */ made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, AIOSEO\Plugin\Common\Utils\Filter->flagDeprecated, AIOSEO\Plugin\Common\Models\Notification::getNotificationByName, AIOSEO\Plugin\Common\Utils\Database->run
    [12-May-2021 10:18:40 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT
    *
    FROM wp_aioseo_notifications
    WHERE 1 = 1 AND
    notification_name = ‘deprecated-filters-v2’
    /* 1 = 1 */ made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, AIOSEO\Plugin\Common\Utils\Filter->flagDeprecated, AIOSEO\Plugin\Common\Models\Notification::getNotificationByName, AIOSEO\Plugin\Common\Utils\Database->run
    [13-May-2021 05:24:12 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT
    *
    FROM wp_aioseo_notifications
    WHERE 1 = 1 AND
    notification_name = ‘deprecated-filters’
    /* 1 = 1 */ made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, AIOSEO\Plugin\Common\Utils\Filter->flagDeprecated, AIOSEO\Plugin\Common\Models\Notification::getNotificationByName, AIOSEO\Plugin\Common\Utils\Database->run
    [13-May-2021 05:24:12 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT
    *
    FROM wp_aioseo_notifications
    WHERE 1 = 1 AND
    notification_name = ‘deprecated-filters-v2’
    /* 1 = 1 */ made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, AIOSEO\Plugin\Common\Utils\Filter->flagDeprecated, AIOSEO\Plugin\Common\Models\Notification::getNotificationByName, AIOSEO\Plugin\Common\Utils\Database->run
    [13-May-2021 10:38:33 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT
    *
    FROM wp_aioseo_notifications
    WHERE 1 = 1 AND
    notification_name = ‘deprecated-filters’
    /* 1 = 1 */ made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, AIOSEO\Plugin\Common\Utils\Filter->flagDeprecated, AIOSEO\Plugin\Common\Models\Notification::getNotificationByName, AIOSEO\Plugin\Common\Utils\Database->run
    [13-May-2021 10:38:33 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT
    *
    FROM wp_aioseo_notifications
    WHERE 1 = 1 AND
    notification_name = ‘deprecated-filters-v2’
    /* 1 = 1 */ made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, AIOSEO\Plugin\Common\Utils\Filter->flagDeprecated, AIOSEO\Plugin\Common\Models\Notification::getNotificationByName, AIOSEO\Plugin\Common\Utils\Database->run
    [13-May-2021 10:38:34 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT
    *
    FROM wp_aioseo_notifications
    WHERE 1 = 1 AND
    notification_name = ‘deprecated-filters’
    /* 1 = 1 */ made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, AIOSEO\Plugin\Common\Utils\Filter->flagDeprecated, AIOSEO\Plugin\Common\Models\Notification::getNotificationByName, AIOSEO\Plugin\Common\Utils\Database->run
    [13-May-2021 10:38:34 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SHOW COLUMNS FROM wp_aioseo_notifications made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, AIOSEO\Plugin\Common\Utils\Filter->flagDeprecated, AIOSEO\Plugin\Common\Models\Notification::getNotificationByName, AIOSEO\Plugin\Common\Utils\Database->model, AIOSEO\Plugin\Common\Models\Model->__construct, AIOSEO\Plugin\Common\Models\Model->getColumns, AIOSEO\Plugin\Common\Utils\Database->execute
    [13-May-2021 10:38:34 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT
    *
    FROM wp_aioseo_notifications
    WHERE 1 = 1 AND
    notification_name = ‘deprecated-filters-v2’
    /* 1 = 1 */ made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, AIOSEO\Plugin\Common\Utils\Filter->flagDeprecated, AIOSEO\Plugin\Common\Models\Notification::getNotificationByName, AIOSEO\Plugin\Common\Utils\Database->run
    [13-May-2021 10:38:34 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SHOW COLUMNS FROM wp_aioseo_notifications made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, AIOSEO\Plugin\Common\Utils\Filter->flagDeprecated, AIOSEO\Plugin\Common\Models\Notification::getNotificationByName, AIOSEO\Plugin\Common\Utils\Database->model, AIOSEO\Plugin\Common\Models\Model->__construct, AIOSEO\Plugin\Common\Models\Model->getColumns, AIOSEO\Plugin\Common\Utils\Database->execute
    [15-May-2021 06:10:27 UTC] product_type was called incorrectly. Product properties should not be accessed directly. Backtrace: require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), do_action(‘template_redirect’), WP_Hook->do_action, WP_Hook->apply_filters, WC_AJAX::do_wc_ajax, do_action(‘wc_ajax_add_to_cart’), WP_Hook->do_action, WP_Hook->apply_filters, WC_AJAX::add_to_cart, WC_Cart->add_to_cart, do_action(‘woocommerce_add_to_cart’), WP_Hook->do_action, WP_Hook->apply_filters, JNews_Frontend_Package->product_added, WC_Abstract_Legacy_Product->__get, wc_doing_it_wrong. This message was added in version 3.0.
    [17-May-2021 15:05:41 UTC] product_type was called incorrectly. Product properties should not be accessed directly. Backtrace: require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), do_action(‘template_redirect’), WP_Hook->do_action, WP_Hook->apply_filters, WC_AJAX::do_wc_ajax, do_action(‘wc_ajax_add_to_cart’), WP_Hook->do_action, WP_Hook->apply_filters, WC_AJAX::add_to_cart, WC_Cart->add_to_cart, do_action(‘woocommerce_add_to_cart’), WP_Hook->do_action, WP_Hook->apply_filters, JNews_Frontend_Package->product_added, WC_Abstract_Legacy_Product->__get, wc_doing_it_wrong. This message was added in version 3.0.
    [17-May-2021 15:05:46 UTC] product_type was called incorrectly. Product properties should not be accessed directly. Backtrace: require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), do_action(‘template_redirect’), WP_Hook->do_action, WP_Hook->apply_filters, WC_AJAX::do_wc_ajax, do_action(‘wc_ajax_add_to_cart’), WP_Hook->do_action, WP_Hook->apply_filters, WC_AJAX::add_to_cart, WC_Cart->add_to_cart, do_action(‘woocommerce_add_to_cart’), WP_Hook->do_action, WP_Hook->apply_filters, JNews_Frontend_Package->product_added, WC_Abstract_Legacy_Product->__get, wc_doing_it_wrong. This message was added in version 3.0.
    [17-May-2021 15:05:46 UTC] product_type was called incorrectly. Product properties should not be accessed directly. Backtrace: require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), do_action(‘template_redirect’), WP_Hook->do_action, WP_Hook->apply_filters, WC_AJAX::do_wc_ajax, do_action(‘wc_ajax_add_to_cart’), WP_Hook->do_action, WP_Hook->apply_filters, WC_AJAX::add_to_cart, WC_Cart->add_to_cart, do_action(‘woocommerce_add_to_cart’), WP_Hook->do_action, WP_Hook->apply_filters, JNews_Frontend_Package->product_added, WC_Abstract_Legacy_Product->__get, wc_doing_it_wrong. This message was added in version 3.0.
    [20-May-2021 07:41:57 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT wp_posts.* FROM wp_posts WHERE ID IN (391,396) made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, WC_Cart_Session->maybe_set_cart_cookies, WC_Cart->is_empty, WC_Cart->get_cart, WC_Cart_Session->get_cart_from_session, _prime_post_caches
    [20-May-2021 07:41:57 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT * FROM wp_posts WHERE ID = 391 LIMIT 1 made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, WC_Cart_Session->maybe_set_cart_cookies, WC_Cart->is_empty, WC_Cart->get_cart, WC_Cart_Session->get_cart_from_session, wc_get_product, WC_Product_Factory->get_product, WC_Product_Factory::get_product_type, WC_Data_Store->__call, WC_Product_Data_Store_CPT->get_product_type, get_post_type, get_post, WP_Post::get_instance
    [20-May-2021 07:41:57 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT * FROM wp_posts WHERE ID = 391 LIMIT 1 made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, WC_Cart_Session->maybe_set_cart_cookies, WC_Cart->is_empty, WC_Cart->get_cart, WC_Cart_Session->get_cart_from_session, wc_get_product, WC_Product_Factory->get_product, WC_Product_Simple->__construct, WC_Product->__construct, WC_Data_Store->read, WC_Product_Data_Store_CPT->read, get_post, WP_Post::get_instance
    [20-May-2021 07:41:57 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT * FROM wp_posts WHERE ID = 396 LIMIT 1 made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, WC_Cart_Session->maybe_set_cart_cookies, WC_Cart->is_empty, WC_Cart->get_cart, WC_Cart_Session->get_cart_from_session, wc_get_product, WC_Product_Factory->get_product, WC_Product_Factory::get_product_type, WC_Data_Store->__call, WC_Product_Data_Store_CPT->get_product_type, get_post_type, get_post, WP_Post::get_instance
    [20-May-2021 07:41:57 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT * FROM wp_posts WHERE ID = 396 LIMIT 1 made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, WC_Cart_Session->maybe_set_cart_cookies, WC_Cart->is_empty, WC_Cart->get_cart, WC_Cart_Session->get_cart_from_session, wc_get_product, WC_Product_Factory->get_product, WC_Product_Simple->__construct, WC_Product->__construct, WC_Data_Store->read, WC_Product_Data_Store_CPT->read, get_post, WP_Post::get_instance
    [20-May-2021 07:41:57 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT
    *
    FROM wp_aioseo_notifications
    WHERE 1 = 1 AND
    notification_name = ‘deprecated-filters’
    /* 1 = 1 */ made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, AIOSEO\Plugin\Common\Utils\Filter->flagDeprecated, AIOSEO\Plugin\Common\Models\Notification::getNotificationByName, AIOSEO\Plugin\Common\Utils\Database->run
    [20-May-2021 07:41:57 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT
    *
    FROM wp_aioseo_notifications
    WHERE 1 = 1 AND
    notification_name = ‘deprecated-filters-v2’
    /* 1 = 1 */ made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, AIOSEO\Plugin\Common\Utils\Filter->flagDeprecated, AIOSEO\Plugin\Common\Models\Notification::getNotificationByName, AIOSEO\Plugin\Common\Utils\Database->run
    [20-May-2021 07:41:57 UTC] WordPress database error Commands out of sync; you can’t run this command now for query INSERT INTO wp_woocommerce_sessions (session_key, session_value, session_expiry) VALUES (‘1’, ‘a:7:{s:4:\”cart\”;s:6:\”a:0:{}\”;s:11:\”cart_totals\”;s:396:\”a:15:{s:8:\”subtotal\”;s:4:\”2200\”;s:12:\”subtotal_tax\”;d:0;s:14:\”shipping_total\”;s:1:\”0\”;s:12:\”shipping_tax\”;i:0;s:14:\”shipping_taxes\”;a:0:{}s:14:\”discount_total\”;i:0;s:12:\”discount_tax\”;i:0;s:19:\”cart_contents_total\”;s:4:\”2200\”;s:17:\”cart_contents_tax\”;i:0;s:19:\”cart_contents_taxes\”;a:0:{}s:9:\”fee_total\”;s:1:\”0\”;s:7:\”fee_tax\”;i:0;s:9:\”fee_taxes\”;a:0:{}s:5:\”total\”;s:4:\”2200\”;s:9:\”total_tax\”;d:0;}\”;s:15:\”applied_coupons\”;s:6:\”a:0:{}\”;s:22:\”coupon_discount_totals\”;s:6:\”a:0:{}\”;s:26:\”coupon_discount_tax_totals\”;s:6:\”a:0:{}\”;s:21:\”removed_cart_contents\”;s:6:\”a:0:{}\”;s:8:\”customer\”;s:740:\”a:26:{s:2:\”id\”;s:1:\”1\”;s:13:\”date_modified\”;s:25:\”2021-05-11T16:56:32+00:00\”;s:8:\”postcode\”;s:0:\”\”;s:4:\”city\”;s:0:\”\”;s:9:\”address_1\”;s:0:\”\”;s:7:\”address\”;s:0:\”\”;s:9:\”address_2\”;s:0:\”\”;s:5:\”state\”;s:2:\”MH\”;s:7:\”country\”;s:2:\”IN\”;s:17:\”shipping_postcode\”;s:0:\”\”;s:13:\”shipping_city\”;s:0:\”\”;s:18:\”shipping_address_1\”;s:0:\”\”;s:16:\”shipping_address\”;s:0:\”\”;s:18:\”shipping_address_2\”;s:0:\”\”;s:14:\”shipping_state\”;s:2:\”MH\”;s:16:\”shipping_country\”;s:2:\”IN\”;s:13:\”is_vat_exempt\”;s:0:\”\”;s:19:\”calculated_shipping\”;s:0:\”\”;s:10:\”first_name\”;s:0:\”\”;s:9:\”last_name\”;s:0:\”\”;s:7:\”company\”;s:0:\”\”;s:5:\”phone\”;s:0:\”\”;s:5:\”email\”;s:22:\”leaftech1989@gmail.com\”;s:19:\”shipping_first_name\”;s:0:\”\”;s:18:\”shipping_last_name\”;s:0:\”\”;s:16:\”shipping_company\”;s:0:\”\”;}\”;}’, 1621665868)
    ON DUPLICATE KEY UPDATE session_value = VALUES(session_value), session_expiry = VALUES(session_expiry) made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, WC_Session_Handler->save_data
    [20-May-2021 07:41:57 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SHOW FULL COLUMNS FROM wp_woocommerce_sessions made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, WC_Session_Handler->save_data, WC_Session_Handler->delete_session
    [20-May-2021 08:08:14 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT wp_posts.* FROM wp_posts WHERE ID IN (391,396) made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, WC_Cart_Session->maybe_set_cart_cookies, WC_Cart->is_empty, WC_Cart->get_cart, WC_Cart_Session->get_cart_from_session, _prime_post_caches
    [20-May-2021 08:08:14 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT * FROM wp_posts WHERE ID = 391 LIMIT 1 made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, WC_Cart_Session->maybe_set_cart_cookies, WC_Cart->is_empty, WC_Cart->get_cart, WC_Cart_Session->get_cart_from_session, wc_get_product, WC_Product_Factory->get_product, WC_Product_Factory::get_product_type, WC_Data_Store->__call, WC_Product_Data_Store_CPT->get_product_type, get_post_type, get_post, WP_Post::get_instance
    [20-May-2021 08:08:14 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT * FROM wp_posts WHERE ID = 391 LIMIT 1 made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, WC_Cart_Session->maybe_set_cart_cookies, WC_Cart->is_empty, WC_Cart->get_cart, WC_Cart_Session->get_cart_from_session, wc_get_product, WC_Product_Factory->get_product, WC_Product_Simple->__construct, WC_Product->__construct, WC_Data_Store->read, WC_Product_Data_Store_CPT->read, get_post, WP_Post::get_instance
    [20-May-2021 08:08:14 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT * FROM wp_posts WHERE ID = 396 LIMIT 1 made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, WC_Cart_Session->maybe_set_cart_cookies, WC_Cart->is_empty, WC_Cart->get_cart, WC_Cart_Session->get_cart_from_session, wc_get_product, WC_Product_Factory->get_product, WC_Product_Factory::get_product_type, WC_Data_Store->__call, WC_Product_Data_Store_CPT->get_product_type, get_post_type, get_post, WP_Post::get_instance
    [20-May-2021 08:08:14 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT * FROM wp_posts WHERE ID = 396 LIMIT 1 made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, WC_Cart_Session->maybe_set_cart_cookies, WC_Cart->is_empty, WC_Cart->get_cart, WC_Cart_Session->get_cart_from_session, wc_get_product, WC_Product_Factory->get_product, WC_Product_Simple->__construct, WC_Product->__construct, WC_Data_Store->read, WC_Product_Data_Store_CPT->read, get_post, WP_Post::get_instance
    [20-May-2021 08:08:14 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT
    *
    FROM wp_aioseo_notifications
    WHERE 1 = 1 AND
    notification_name = ‘deprecated-filters’
    /* 1 = 1 */ made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, AIOSEO\Plugin\Common\Utils\Filter->flagDeprecated, AIOSEO\Plugin\Common\Models\Notification::getNotificationByName, AIOSEO\Plugin\Common\Utils\Database->run
    [20-May-2021 08:08:14 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT
    *
    FROM wp_aioseo_notifications
    WHERE 1 = 1 AND
    notification_name = ‘deprecated-filters-v2’
    /* 1 = 1 */ made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, AIOSEO\Plugin\Common\Utils\Filter->flagDeprecated, AIOSEO\Plugin\Common\Models\Notification::getNotificationByName, AIOSEO\Plugin\Common\Utils\Database->run
    [20-May-2021 08:08:14 UTC] WordPress database error Commands out of sync; you can’t run this command now for query INSERT INTO wp_woocommerce_sessions (session_key, session_value, session_expiry) VALUES (‘1’, ‘a:7:{s:4:\”cart\”;s:6:\”a:0:{}\”;s:11:\”cart_totals\”;s:396:\”a:15:{s:8:\”subtotal\”;s:4:\”2200\”;s:12:\”subtotal_tax\”;d:0;s:14:\”shipping_total\”;s:1:\”0\”;s:12:\”shipping_tax\”;i:0;s:14:\”shipping_taxes\”;a:0:{}s:14:\”discount_total\”;i:0;s:12:\”discount_tax\”;i:0;s:19:\”cart_contents_total\”;s:4:\”2200\”;s:17:\”cart_contents_tax\”;i:0;s:19:\”cart_contents_taxes\”;a:0:{}s:9:\”fee_total\”;s:1:\”0\”;s:7:\”fee_tax\”;i:0;s:9:\”fee_taxes\”;a:0:{}s:5:\”total\”;s:4:\”2200\”;s:9:\”total_tax\”;d:0;}\”;s:15:\”applied_coupons\”;s:6:\”a:0:{}\”;s:22:\”coupon_discount_totals\”;s:6:\”a:0:{}\”;s:26:\”coupon_discount_tax_totals\”;s:6:\”a:0:{}\”;s:21:\”removed_cart_contents\”;s:6:\”a:0:{}\”;s:8:\”customer\”;s:740:\”a:26:{s:2:\”id\”;s:1:\”1\”;s:13:\”date_modified\”;s:25:\”2021-05-11T16:56:32+00:00\”;s:8:\”postcode\”;s:0:\”\”;s:4:\”city\”;s:0:\”\”;s:9:\”address_1\”;s:0:\”\”;s:7:\”address\”;s:0:\”\”;s:9:\”address_2\”;s:0:\”\”;s:5:\”state\”;s:2:\”MH\”;s:7:\”country\”;s:2:\”IN\”;s:17:\”shipping_postcode\”;s:0:\”\”;s:13:\”shipping_city\”;s:0:\”\”;s:18:\”shipping_address_1\”;s:0:\”\”;s:16:\”shipping_address\”;s:0:\”\”;s:18:\”shipping_address_2\”;s:0:\”\”;s:14:\”shipping_state\”;s:2:\”MH\”;s:16:\”shipping_country\”;s:2:\”IN\”;s:13:\”is_vat_exempt\”;s:0:\”\”;s:19:\”calculated_shipping\”;s:0:\”\”;s:10:\”first_name\”;s:0:\”\”;s:9:\”last_name\”;s:0:\”\”;s:7:\”company\”;s:0:\”\”;s:5:\”phone\”;s:0:\”\”;s:5:\”email\”;s:22:\”leaftech1989@gmail.com\”;s:19:\”shipping_first_name\”;s:0:\”\”;s:18:\”shipping_last_name\”;s:0:\”\”;s:16:\”shipping_company\”;s:0:\”\”;}\”;}’, 1621665868)
    ON DUPLICATE KEY UPDATE session_value = VALUES(session_value), session_expiry = VALUES(session_expiry) made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, WC_Session_Handler->save_data
    [20-May-2021 08:08:14 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SHOW FULL COLUMNS FROM wp_woocommerce_sessions made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, WC_Session_Handler->save_data, WC_Session_Handler->delete_session
    [20-May-2021 08:08:15 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT
    *
    FROM wp_aioseo_notifications
    WHERE 1 = 1 AND
    notification_name = ‘deprecated-filters’
    /* 1 = 1 */ made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, AIOSEO\Plugin\Common\Utils\Filter->flagDeprecated, AIOSEO\Plugin\Common\Models\Notification::getNotificationByName, AIOSEO\Plugin\Common\Utils\Database->run
    [20-May-2021 08:08:15 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SHOW COLUMNS FROM wp_aioseo_notifications made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, AIOSEO\Plugin\Common\Utils\Filter->flagDeprecated, AIOSEO\Plugin\Common\Models\Notification::getNotificationByName, AIOSEO\Plugin\Common\Utils\Database->model, AIOSEO\Plugin\Common\Models\Model->__construct, AIOSEO\Plugin\Common\Models\Model->getColumns, AIOSEO\Plugin\Common\Utils\Database->execute
    [20-May-2021 08:08:15 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT
    *
    FROM wp_aioseo_notifications
    WHERE 1 = 1 AND
    notification_name = ‘deprecated-filters-v2’
    /* 1 = 1 */ made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, AIOSEO\Plugin\Common\Utils\Filter->flagDeprecated, AIOSEO\Plugin\Common\Models\Notification::getNotificationByName, AIOSEO\Plugin\Common\Utils\Database->run
    [20-May-2021 08:08:15 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SHOW COLUMNS FROM wp_aioseo_notifications made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, AIOSEO\Plugin\Common\Utils\Filter->flagDeprecated, AIOSEO\Plugin\Common\Models\Notification::getNotificationByName, AIOSEO\Plugin\Common\Utils\Database->model, AIOSEO\Plugin\Common\Models\Model->__construct, AIOSEO\Plugin\Common\Models\Model->getColumns, AIOSEO\Plugin\Common\Utils\Database->execute
    [20-May-2021 08:08:29 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT
    *
    FROM wp_aioseo_notifications
    WHERE 1 = 1 AND
    notification_name = ‘deprecated-filters’
    /* 1 = 1 */ made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, AIOSEO\Plugin\Common\Utils\Filter->flagDeprecated, AIOSEO\Plugin\Common\Models\Notification::getNotificationByName, AIOSEO\Plugin\Common\Utils\Database->run
    [20-May-2021 08:08:29 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SHOW COLUMNS FROM wp_aioseo_notifications made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, AIOSEO\Plugin\Common\Utils\Filter->flagDeprecated, AIOSEO\Plugin\Common\Models\Notification::getNotificationByName, AIOSEO\Plugin\Common\Utils\Database->model, AIOSEO\Plugin\Common\Models\Model->__construct, AIOSEO\Plugin\Common\Models\Model->getColumns, AIOSEO\Plugin\Common\Utils\Database->execute
    [20-May-2021 08:08:29 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT
    *
    FROM wp_aioseo_notifications
    WHERE 1 = 1 AND
    notification_name = ‘deprecated-filters-v2’
    /* 1 = 1 */ made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, AIOSEO\Plugin\Common\Utils\Filter->flagDeprecated, AIOSEO\Plugin\Common\Models\Notification::getNotificationByName, AIOSEO\Plugin\Common\Utils\Database->run
    [20-May-2021 08:08:29 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SHOW COLUMNS FROM wp_aioseo_notifications made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, AIOSEO\Plugin\Common\Utils\Filter->flagDeprecated, AIOSEO\Plugin\Common\Models\Notification::getNotificationByName, AIOSEO\Plugin\Common\Utils\Database->model, AIOSEO\Plugin\Common\Models\Model->__construct, AIOSEO\Plugin\Common\Models\Model->getColumns, AIOSEO\Plugin\Common\Utils\Database->execute
    [20-May-2021 08:08:30 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT wp_posts.* FROM wp_posts WHERE ID IN (391,396) made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, WC_Cart_Session->maybe_set_cart_cookies, WC_Cart->is_empty, WC_Cart->get_cart, WC_Cart_Session->get_cart_from_session, _prime_post_caches
    [20-May-2021 08:08:30 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT * FROM wp_posts WHERE ID = 391 LIMIT 1 made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, WC_Cart_Session->maybe_set_cart_cookies, WC_Cart->is_empty, WC_Cart->get_cart, WC_Cart_Session->get_cart_from_session, wc_get_product, WC_Product_Factory->get_product, WC_Product_Factory::get_product_type, WC_Data_Store->__call, WC_Product_Data_Store_CPT->get_product_type, get_post_type, get_post, WP_Post::get_instance
    [20-May-2021 08:08:30 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT * FROM wp_posts WHERE ID = 391 LIMIT 1 made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, WC_Cart_Session->maybe_set_cart_cookies, WC_Cart->is_empty, WC_Cart->get_cart, WC_Cart_Session->get_cart_from_session, wc_get_product, WC_Product_Factory->get_product, WC_Product_Simple->__construct, WC_Product->__construct, WC_Data_Store->read, WC_Product_Data_Store_CPT->read, get_post, WP_Post::get_instance
    [20-May-2021 08:08:30 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT * FROM wp_posts WHERE ID = 396 LIMIT 1 made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, WC_Cart_Session->maybe_set_cart_cookies, WC_Cart->is_empty, WC_Cart->get_cart, WC_Cart_Session->get_cart_from_session, wc_get_product, WC_Product_Factory->get_product, WC_Product_Factory::get_product_type, WC_Data_Store->__call, WC_Product_Data_Store_CPT->get_product_type, get_post_type, get_post, WP_Post::get_instance
    [20-May-2021 08:08:30 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT * FROM wp_posts WHERE ID = 396 LIMIT 1 made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, WC_Cart_Session->maybe_set_cart_cookies, WC_Cart->is_empty, WC_Cart->get_cart, WC_Cart_Session->get_cart_from_session, wc_get_product, WC_Product_Factory->get_product, WC_Product_Simple->__construct, WC_Product->__construct, WC_Data_Store->read, WC_Product_Data_Store_CPT->read, get_post, WP_Post::get_instance
    [20-May-2021 08:08:30 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT
    *
    FROM wp_aioseo_notifications
    WHERE 1 = 1 AND
    notification_name = ‘deprecated-filters’
    /* 1 = 1 */ made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, AIOSEO\Plugin\Common\Utils\Filter->flagDeprecated, AIOSEO\Plugin\Common\Models\Notification::getNotificationByName, AIOSEO\Plugin\Common\Utils\Database->run
    [20-May-2021 08:08:30 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT
    *
    FROM wp_aioseo_notifications
    WHERE 1 = 1 AND
    notification_name = ‘deprecated-filters-v2’
    /* 1 = 1 */ made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, AIOSEO\Plugin\Common\Utils\Filter->flagDeprecated, AIOSEO\Plugin\Common\Models\Notification::getNotificationByName, AIOSEO\Plugin\Common\Utils\Database->run
    [20-May-2021 08:08:30 UTC] WordPress database error Commands out of sync; you can’t run this command now for query INSERT INTO wp_woocommerce_sessions (session_key, session_value, session_expiry) VALUES (‘1’, ‘a:7:{s:4:\”cart\”;s:6:\”a:0:{}\”;s:11:\”cart_totals\”;s:396:\”a:15:{s:8:\”subtotal\”;s:4:\”2200\”;s:12:\”subtotal_tax\”;d:0;s:14:\”shipping_total\”;s:1:\”0\”;s:12:\”shipping_tax\”;i:0;s:14:\”shipping_taxes\”;a:0:{}s:14:\”discount_total\”;i:0;s:12:\”discount_tax\”;i:0;s:19:\”cart_contents_total\”;s:4:\”2200\”;s:17:\”cart_contents_tax\”;i:0;s:19:\”cart_contents_taxes\”;a:0:{}s:9:\”fee_total\”;s:1:\”0\”;s:7:\”fee_tax\”;i:0;s:9:\”fee_taxes\”;a:0:{}s:5:\”total\”;s:4:\”2200\”;s:9:\”total_tax\”;d:0;}\”;s:15:\”applied_coupons\”;s:6:\”a:0:{}\”;s:22:\”coupon_discount_totals\”;s:6:\”a:0:{}\”;s:26:\”coupon_discount_tax_totals\”;s:6:\”a:0:{}\”;s:21:\”removed_cart_contents\”;s:6:\”a:0:{}\”;s:8:\”customer\”;s:740:\”a:26:{s:2:\”id\”;s:1:\”1\”;s:13:\”date_modified\”;s:25:\”2021-05-11T16:56:32+00:00\”;s:8:\”postcode\”;s:0:\”\”;s:4:\”city\”;s:0:\”\”;s:9:\”address_1\”;s:0:\”\”;s:7:\”address\”;s:0:\”\”;s:9:\”address_2\”;s:0:\”\”;s:5:\”state\”;s:2:\”MH\”;s:7:\”country\”;s:2:\”IN\”;s:17:\”shipping_postcode\”;s:0:\”\”;s:13:\”shipping_city\”;s:0:\”\”;s:18:\”shipping_address_1\”;s:0:\”\”;s:16:\”shipping_address\”;s:0:\”\”;s:18:\”shipping_address_2\”;s:0:\”\”;s:14:\”shipping_state\”;s:2:\”MH\”;s:16:\”shipping_country\”;s:2:\”IN\”;s:13:\”is_vat_exempt\”;s:0:\”\”;s:19:\”calculated_shipping\”;s:0:\”\”;s:10:\”first_name\”;s:0:\”\”;s:9:\”last_name\”;s:0:\”\”;s:7:\”company\”;s:0:\”\”;s:5:\”phone\”;s:0:\”\”;s:5:\”email\”;s:22:\”leaftech1989@gmail.com\”;s:19:\”shipping_first_name\”;s:0:\”\”;s:18:\”shipping_last_name\”;s:0:\”\”;s:16:\”shipping_company\”;s:0:\”\”;}\”;}’, 1621665868)
    ON DUPLICATE KEY UPDATE session_value = VALUES(session_value), session_expiry = VALUES(session_expiry) made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, WC_Session_Handler->save_data
    [20-May-2021 08:08:30 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SHOW FULL COLUMNS FROM wp_woocommerce_sessions made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, WC_Session_Handler->save_data, WC_Session_Handler->delete_session
    [20-May-2021 08:08:32 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT
    *
    FROM wp_aioseo_notifications
    WHERE 1 = 1 AND
    notification_name = ‘deprecated-filters’
    /* 1 = 1 */ made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, AIOSEO\Plugin\Common\Utils\Filter->flagDeprecated, AIOSEO\Plugin\Common\Models\Notification::getNotificationByName, AIOSEO\Plugin\Common\Utils\Database->run
    [20-May-2021 08:08:32 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT
    *
    FROM wp_aioseo_notifications
    WHERE 1 = 1 AND
    notification_name = ‘deprecated-filters-v2’
    /* 1 = 1 */ made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, AIOSEO\Plugin\Common\Utils\Filter->flagDeprecated, AIOSEO\Plugin\Common\Models\Notification::getNotificationByName, AIOSEO\Plugin\Common\Utils\Database->run
    [20-May-2021 08:08:39 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT
    *
    FROM wp_aioseo_notifications
    WHERE 1 = 1 AND
    notification_name = ‘conflicting-plugins’
    AND notification_name = ‘deprecated-filters’
    /* 1 = 1 */ made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, AIOSEO\Plugin\Common\Utils\Filter->flagDeprecated, AIOSEO\Plugin\Common\Models\Notification::getNotificationByName, AIOSEO\Plugin\Common\Utils\Database->run
    [20-May-2021 08:08:39 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT
    *
    FROM wp_aioseo_notifications
    WHERE 1 = 1 AND
    notification_name = ‘deprecated-filters-v2’
    /* 1 = 1 */ made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, AIOSEO\Plugin\Common\Utils\Filter->flagDeprecated, AIOSEO\Plugin\Common\Models\Notification::getNotificationByName, AIOSEO\Plugin\Common\Utils\Database->run
    [20-May-2021 08:09:02 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT wp_posts.* FROM wp_posts WHERE ID IN (391,396) made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, WC_Cart_Session->maybe_set_cart_cookies, WC_Cart->is_empty, WC_Cart->get_cart, WC_Cart_Session->get_cart_from_session, _prime_post_caches
    [20-May-2021 08:09:02 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT * FROM wp_posts WHERE ID = 391 LIMIT 1 made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, WC_Cart_Session->maybe_set_cart_cookies, WC_Cart->is_empty, WC_Cart->get_cart, WC_Cart_Session->get_cart_from_session, wc_get_product, WC_Product_Factory->get_product, WC_Product_Factory::get_product_type, WC_Data_Store->__call, WC_Product_Data_Store_CPT->get_product_type, get_post_type, get_post, WP_Post::get_instance
    [20-May-2021 08:09:02 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT * FROM wp_posts WHERE ID = 391 LIMIT 1 made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, WC_Cart_Session->maybe_set_cart_cookies, WC_Cart->is_empty, WC_Cart->get_cart, WC_Cart_Session->get_cart_from_session, wc_get_product, WC_Product_Factory->get_product, WC_Product_Simple->__construct, WC_Product->__construct, WC_Data_Store->read, WC_Product_Data_Store_CPT->read, get_post, WP_Post::get_instance
    [20-May-2021 08:09:02 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT * FROM wp_posts WHERE ID = 396 LIMIT 1 made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, WC_Cart_Session->maybe_set_cart_cookies, WC_Cart->is_empty, WC_Cart->get_cart, WC_Cart_Session->get_cart_from_session, wc_get_product, WC_Product_Factory->get_product, WC_Product_Factory::get_product_type, WC_Data_Store->__call, WC_Product_Data_Store_CPT->get_product_type, get_post_type, get_post, WP_Post::get_instance
    [20-May-2021 08:09:02 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT * FROM wp_posts WHERE ID = 396 LIMIT 1 made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, WC_Cart_Session->maybe_set_cart_cookies, WC_Cart->is_empty, WC_Cart->get_cart, WC_Cart_Session->get_cart_from_session, wc_get_product, WC_Product_Factory->get_product, WC_Product_Simple->__construct, WC_Product->__construct, WC_Data_Store->read, WC_Product_Data_Store_CPT->read, get_post, WP_Post::get_instance
    [20-May-2021 08:09:02 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT
    *
    FROM wp_aioseo_notifications
    WHERE 1 = 1 AND
    notification_name = ‘deprecated-filters’
    /* 1 = 1 */ made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, AIOSEO\Plugin\Common\Utils\Filter->flagDeprecated, AIOSEO\Plugin\Common\Models\Notification::getNotificationByName, AIOSEO\Plugin\Common\Utils\Database->run
    [20-May-2021 08:09:02 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT
    *
    FROM wp_aioseo_notifications
    WHERE 1 = 1 AND
    notification_name = ‘deprecated-filters-v2’
    /* 1 = 1 */ made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, AIOSEO\Plugin\Common\Utils\Filter->flagDeprecated, AIOSEO\Plugin\Common\Models\Notification::getNotificationByName, AIOSEO\Plugin\Common\Utils\Database->run
    [20-May-2021 08:09:02 UTC] WordPress database error Commands out of sync; you can’t run this command now for query INSERT INTO wp_woocommerce_sessions (session_key, session_value, session_expiry) VALUES (‘1’, ‘a:7:{s:4:\”cart\”;s:6:\”a:0:{}\”;s:11:\”cart_totals\”;s:396:\”a:15:{s:8:\”subtotal\”;s:4:\”2200\”;s:12:\”subtotal_tax\”;d:0;s:14:\”shipping_total\”;s:1:\”0\”;s:12:\”shipping_tax\”;i:0;s:14:\”shipping_taxes\”;a:0:{}s:14:\”discount_total\”;i:0;s:12:\”discount_tax\”;i:0;s:19:\”cart_contents_total\”;s:4:\”2200\”;s:17:\”cart_contents_tax\”;i:0;s:19:\”cart_contents_taxes\”;a:0:{}s:9:\”fee_total\”;s:1:\”0\”;s:7:\”fee_tax\”;i:0;s:9:\”fee_taxes\”;a:0:{}s:5:\”total\”;s:4:\”2200\”;s:9:\”total_tax\”;d:0;}\”;s:15:\”applied_coupons\”;s:6:\”a:0:{}\”;s:22:\”coupon_discount_totals\”;s:6:\”a:0:{}\”;s:26:\”coupon_discount_tax_totals\”;s:6:\”a:0:{}\”;s:21:\”removed_cart_contents\”;s:6:\”a:0:{}\”;s:8:\”customer\”;s:740:\”a:26:{s:2:\”id\”;s:1:\”1\”;s:13:\”date_modified\”;s:25:\”2021-05-11T16:56:32+00:00\”;s:8:\”postcode\”;s:0:\”\”;s:4:\”city\”;s:0:\”\”;s:9:\”address_1\”;s:0:\”\”;s:7:\”address\”;s:0:\”\”;s:9:\”address_2\”;s:0:\”\”;s:5:\”state\”;s:2:\”MH\”;s:7:\”country\”;s:2:\”IN\”;s:17:\”shipping_postcode\”;s:0:\”\”;s:13:\”shipping_city\”;s:0:\”\”;s:18:\”shipping_address_1\”;s:0:\”\”;s:16:\”shipping_address\”;s:0:\”\”;s:18:\”shipping_address_2\”;s:0:\”\”;s:14:\”shipping_state\”;s:2:\”MH\”;s:16:\”shipping_country\”;s:2:\”IN\”;s:13:\”is_vat_exempt\”;s:0:\”\”;s:19:\”calculated_shipping\”;s:0:\”\”;s:10:\”first_name\”;s:0:\”\”;s:9:\”last_name\”;s:0:\”\”;s:7:\”company\”;s:0:\”\”;s:5:\”phone\”;s:0:\”\”;s:5:\”email\”;s:22:\”leaftech1989@gmail.com\”;s:19:\”shipping_first_name\”;s:0:\”\”;s:18:\”shipping_last_name\”;s:0:\”\”;s:16:\”shipping_company\”;s:0:\”\”;}\”;}’, 1621665868)
    ON DUPLICATE KEY UPDATE session_value = VALUES(session_value), session_expiry = VALUES(session_expiry) made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, WC_Session_Handler->save_data
    [20-May-2021 08:09:02 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SHOW FULL COLUMNS FROM wp_woocommerce_sessions made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, WC_Session_Handler->save_data, WC_Session_Handler->delete_session
    [20-May-2021 08:09:05 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT
    *
    FROM wp_aioseo_notifications
    WHERE 1 = 1 AND
    notification_name = ‘conflicting-plugins’
    AND notification_name = ‘deprecated-filters’
    /* 1 = 1 */ made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, AIOSEO\Plugin\Common\Utils\Filter->flagDeprecated, AIOSEO\Plugin\Common\Models\Notification::getNotificationByName, AIOSEO\Plugin\Common\Utils\Database->run
    [20-May-2021 08:09:05 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT
    *
    FROM wp_aioseo_notifications
    WHERE 1 = 1 AND
    notification_name = ‘deprecated-filters-v2’
    /* 1 = 1 */ made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, AIOSEO\Plugin\Common\Utils\Filter->flagDeprecated, AIOSEO\Plugin\Common\Models\Notification::getNotificationByName, AIOSEO\Plugin\Common\Utils\Database->run
    [20-May-2021 08:09:14 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT wp_posts.* FROM wp_posts WHERE ID IN (391,396) made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, WC_Cart_Session->maybe_set_cart_cookies, WC_Cart->is_empty, WC_Cart->get_cart, WC_Cart_Session->get_cart_from_session, _prime_post_caches
    [20-May-2021 08:09:14 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT * FROM wp_posts WHERE ID = 391 LIMIT 1 made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, WC_Cart_Session->maybe_set_cart_cookies, WC_Cart->is_empty, WC_Cart->get_cart, WC_Cart_Session->get_cart_from_session, wc_get_product, WC_Product_Factory->get_product, WC_Product_Factory::get_product_type, WC_Data_Store->__call, WC_Product_Data_Store_CPT->get_product_type, get_post_type, get_post, WP_Post::get_instance
    [20-May-2021 08:09:14 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT * FROM wp_posts WHERE ID = 391 LIMIT 1 made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, WC_Cart_Session->maybe_set_cart_cookies, WC_Cart->is_empty, WC_Cart->get_cart, WC_Cart_Session->get_cart_from_session, wc_get_product, WC_Product_Factory->get_product, WC_Product_Simple->__construct, WC_Product->__construct, WC_Data_Store->read, WC_Product_Data_Store_CPT->read, get_post, WP_Post::get_instance
    [20-May-2021 08:09:14 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT * FROM wp_posts WHERE ID = 396 LIMIT 1 made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, WC_Cart_Session->maybe_set_cart_cookies, WC_Cart->is_empty, WC_Cart->get_cart, WC_Cart_Session->get_cart_from_session, wc_get_product, WC_Product_Factory->get_product, WC_Product_Factory::get_product_type, WC_Data_Store->__call, WC_Product_Data_Store_CPT->get_product_type, get_post_type, get_post, WP_Post::get_instance
    [20-May-2021 08:09:14 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT * FROM wp_posts WHERE ID = 396 LIMIT 1 made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, WC_Cart_Session->maybe_set_cart_cookies, WC_Cart->is_empty, WC_Cart->get_cart, WC_Cart_Session->get_cart_from_session, wc_get_product, WC_Product_Factory->get_product, WC_Product_Simple->__construct, WC_Product->__construct, WC_Data_Store->read, WC_Product_Data_Store_CPT->read, get_post, WP_Post::get_instance
    [20-May-2021 08:09:14 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT
    *
    FROM wp_aioseo_notifications
    WHERE 1 = 1 AND
    notification_name = ‘deprecated-filters’
    /* 1 = 1 */ made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, AIOSEO\Plugin\Common\Utils\Filter->flagDeprecated, AIOSEO\Plugin\Common\Models\Notification::getNotificationByName, AIOSEO\Plugin\Common\Utils\Database->run
    [20-May-2021 08:09:14 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT
    *
    FROM wp_aioseo_notifications
    WHERE 1 = 1 AND
    notification_name = ‘deprecated-filters-v2’
    /* 1 = 1 */ made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, AIOSEO\Plugin\Common\Utils\Filter->flagDeprecated, AIOSEO\Plugin\Common\Models\Notification::getNotificationByName, AIOSEO\Plugin\Common\Utils\Database->run
    [20-May-2021 08:09:14 UTC] WordPress database error Commands out of sync; you can’t run this command now for query INSERT INTO wp_woocommerce_sessions (session_key, session_value, session_expiry) VALUES (‘1’, ‘a:7:{s:4:\”cart\”;s:6:\”a:0:{}\”;s:11:\”cart_totals\”;s:396:\”a:15:{s:8:\”subtotal\”;s:4:\”2200\”;s:12:\”subtotal_tax\”;d:0;s:14:\”shipping_total\”;s:1:\”0\”;s:12:\”shipping_tax\”;i:0;s:14:\”shipping_taxes\”;a:0:{}s:14:\”discount_total\”;i:0;s:12:\”discount_tax\”;i:0;s:19:\”cart_contents_total\”;s:4:\”2200\”;s:17:\”cart_contents_tax\”;i:0;s:19:\”cart_contents_taxes\”;a:0:{}s:9:\”fee_total\”;s:1:\”0\”;s:7:\”fee_tax\”;i:0;s:9:\”fee_taxes\”;a:0:{}s:5:\”total\”;s:4:\”2200\”;s:9:\”total_tax\”;d:0;}\”;s:15:\”applied_coupons\”;s:6:\”a:0:{}\”;s:22:\”coupon_discount_totals\”;s:6:\”a:0:{}\”;s:26:\”coupon_discount_tax_totals\”;s:6:\”a:0:{}\”;s:21:\”removed_cart_contents\”;s:6:\”a:0:{}\”;s:8:\”customer\”;s:740:\”a:26:{s:2:\”id\”;s:1:\”1\”;s:13:\”date_modified\”;s:25:\”2021-05-11T16:56:32+00:00\”;s:8:\”postcode\”;s:0:\”\”;s:4:\”city\”;s:0:\”\”;s:9:\”address_1\”;s:0:\”\”;s:7:\”address\”;s:0:\”\”;s:9:\”address_2\”;s:0:\”\”;s:5:\”state\”;s:2:\”MH\”;s:7:\”country\”;s:2:\”IN\”;s:17:\”shipping_postcode\”;s:0:\”\”;s:13:\”shipping_city\”;s:0:\”\”;s:18:\”shipping_address_1\”;s:0:\”\”;s:16:\”shipping_address\”;s:0:\”\”;s:18:\”shipping_address_2\”;s:0:\”\”;s:14:\”shipping_state\”;s:2:\”MH\”;s:16:\”shipping_country\”;s:2:\”IN\”;s:13:\”is_vat_exempt\”;s:0:\”\”;s:19:\”calculated_shipping\”;s:0:\”\”;s:10:\”first_name\”;s:0:\”\”;s:9:\”last_name\”;s:0:\”\”;s:7:\”company\”;s:0:\”\”;s:5:\”phone\”;s:0:\”\”;s:5:\”email\”;s:22:\”leaftech1989@gmail.com\”;s:19:\”shipping_first_name\”;s:0:\”\”;s:18:\”shipping_last_name\”;s:0:\”\”;s:16:\”shipping_company\”;s:0:\”\”;}\”;}’, 1621665868)
    ON DUPLICATE KEY UPDATE session_value = VALUES(session_value), session_expiry = VALUES(session_expiry) made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, WC_Session_Handler->save_data
    [20-May-2021 08:09:14 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SHOW FULL COLUMNS FROM wp_woocommerce_sessions made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, WC_Session_Handler->save_data, WC_Session_Handler->delete_session
    [20-May-2021 08:09:15 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT
    *
    FROM wp_aioseo_notifications
    WHERE 1 = 1 AND
    notification_name = ‘deprecated-filters’
    /* 1 = 1 */ made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, AIOSEO\Plugin\Common\Utils\Filter->flagDeprecated, AIOSEO\Plugin\Common\Models\Notification::getNotificationByName, AIOSEO\Plugin\Common\Utils\Database->run
    [20-May-2021 08:09:15 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SHOW COLUMNS FROM wp_aioseo_notifications made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, AIOSEO\Plugin\Common\Utils\Filter->flagDeprecated, AIOSEO\Plugin\Common\Models\Notification::getNotificationByName, AIOSEO\Plugin\Common\Utils\Database->model, AIOSEO\Plugin\Common\Models\Model->__construct, AIOSEO\Plugin\Common\Models\Model->getColumns, AIOSEO\Plugin\Common\Utils\Database->execute
    [20-May-2021 08:09:15 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT
    *
    FROM wp_aioseo_notifications
    WHERE 1 = 1 AND
    notification_name = ‘deprecated-filters-v2’
    /* 1 = 1 */ made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, AIOSEO\Plugin\Common\Utils\Filter->flagDeprecated, AIOSEO\Plugin\Common\Models\Notification::getNotificationByName, AIOSEO\Plugin\Common\Utils\Database->run
    [20-May-2021 08:09:15 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SHOW COLUMNS FROM wp_aioseo_notifications made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, AIOSEO\Plugin\Common\Utils\Filter->flagDeprecated, AIOSEO\Plugin\Common\Models\Notification::getNotificationByName, AIOSEO\Plugin\Common\Utils\Database->model, AIOSEO\Plugin\Common\Models\Model->__construct, AIOSEO\Plugin\Common\Models\Model->getColumns, AIOSEO\Plugin\Common\Utils\Database->execute
    [20-May-2021 08:09:17 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT
    *
    FROM wp_aioseo_notifications
    WHERE 1 = 1 AND
    notification_name = ‘deprecated-filters’
    /* 1 = 1 */ made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, AIOSEO\Plugin\Common\Utils\Filter->flagDeprecated, AIOSEO\Plugin\Common\Models\Notification::getNotificationByName, AIOSEO\Plugin\Common\Utils\Database->run
    [20-May-2021 08:09:17 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT
    *
    FROM wp_aioseo_notifications
    WHERE 1 = 1 AND
    notification_name = ‘deprecated-filters-v2’
    /* 1 = 1 */ made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, AIOSEO\Plugin\Common\Utils\Filter->flagDeprecated, AIOSEO\Plugin\Common\Models\Notification::getNotificationByName, AIOSEO\Plugin\Common\Utils\Database->run

    #305715
    allnamestaken
    Participant

    I just downloaded it myself, any idea how I could used this for addresses? My addresses are shown as city,state,country but my groups are city,state. Current setting of group name|equils is not working for me. I would rather not have to rename my group names.

    amandafrench
    Participant

    I guess I’m never satisfied, but I do have an additional request / problem, if someone can help (cough @boonebgorges?). Our xprofile fields are geographical: City, State, Country. I’d like to do a sequential sort on them on the Members directory: first ASC by Country (which I’ve now got working, finally, thanks to this post), then second ASC by State, third ASC by City. I’ve mucked around with SQL statements and ORDER BY FIELD and CASE IF THEN, but I can’t get those subsequent sorts to work.

    xprofile field_id values: 1 = Name, 8 = Org, 9 = City, 10 = State, 11 = Country

    Members loop code:

    <?php if ( bp_has_members( bp_ajax_querystring( 'members' ) . '&per_page=500' . '&populate_extras&type=alphabetical' . '&exclude=1,2,3,4,6') ) : ?>

    Below code in functions.php works – it sorts members by Country ASC
    custom_ids = $wpdb->get_col("SELECT user_id FROM {$wpdb->prefix}bp_xprofile_data WHERE field_id = 11 ORDER BY value ASC");

    Below code in functions.php doesn’t work to sort by Country, State, City ASC – returns an unsorted members list. I think it’s sorting randomly. It isn’t by user id, username, last active, or newest registered. When I apply the default member type sorts, though, with the members-order-select dropdown, that works.

    $custom_ids = $wpdb->get_col("SELECT user_id FROM {$wpdb->prefix}bp_xprofile_data WHERE field_id IN ('1', '8', '9', '10', '11') ORDER BY FIELD (field_id, '11', '10', '9', '8', '1')");

    Any advice for constructing that SQL query? Do I need to look more into bp_parse_args?

    #268595
    azhrahan
    Participant

    Greetings,
    I have buddypress groups set up in a hierarchy. World, Country, State, County, City. I would like to have a dependency dropdown list on my front page that would allow users to navigate those options and “go” to the chosen page. Are there any plugins or ideas as to how I would achieve this?

    Using Advanced Classifieds and Directory Pro plugin I can create a directory but it gives the results of classifieds with the location tags. Not a particular page. Here is a video of the drop down list I would like. Lower right corner. https://www.youtube.com/watch?v=NyER5sm4iIs

    My current system works but is not user friendly. It can be seen here http://www.suroby.com/places/ clicking subdivision opens the directory further. Thanks in advance.

    wci
    Participant

    Hi Buddypress support,
    I am still waiting to get my problem to solve.
    While using bbpress search forum then the search result is not displayed, but instead get forward to homepage.
    Please find this screen video helpful to solve my issue
    > https://www.screencast.com/t/eMZEAnn9X2

    Please also find this info helpful as you stated you need those info too:

    Please try to supply answers to the following questions.
    1. Which version of WordPress are you running?
    WP ver. 4.8

    2. Did you install WordPress as a directory or subdomain install?
    directory but as multisite

    3. If a directory install, is it in root or in a subdirectory?
    subdirectory /public_html/wci

    4. Did you upgrade from a previous version of WordPress? If so, from which version?
    no – Version 2.8.2 is in use

    5. Was WordPress functioning properly before installing/upgrading BuddyPress (BP)? e.g. permalinks, creating a new post, commenting.
    not sure but I guess it was working

    6. Which version of BP are you running?
    Version 2.8.2 is in use

    7. Did you upgraded from a previous version of BP? If so, from which version?
    no

    8. Do you have any plugins other than BuddyPress installed and activated? If so, which ones?
    (but the problem occur even, if I deactiavete all plugins just using buddypress and bbpress together)
    Name Version Plugin URL
    WP Easy Updates 1.1.1 http://ayecode.io/
    AffiliateWP – Lifetime Commissions 1.2.4 http://affiliatewp.com/addons/lifetime-commissions/
    AffiliateWP – PayPal Payouts 1.1.7 http://affiliatewp.com/addons/paypal-payouts/
    AffiliateWP – Recurring Referrals 1.6.2 http://affiliatewp.com/addons/recurring-referrals/
    AffiliateWP 2.0.10 https://affiliatewp.com
    AffiliateWP – Affiliate Area Tabs 1.1.5 https://affiliatewp.com/
    AffiliateWP – Affiliate Dashboard Sharing 1.1.3 http://affiliatewp.com/addons/affiliate-dashboard-sharing/
    AffiliateWP BuddyPress Pro 1.0.1 http://propluginmarketplace.com/plugins/affiliatewp-buddypress-pro
    AffiliateWP – Direct Link Tracking 1.1.1 https://affiliatewp.com/add-ons/pro/direct-link-tracking/
    AffiliateWP MLM 1.1.2 http://theperfectplugin.com/downloads/affiliatewp-mlm
    AffiliateWP – Order Details For Affiliates 1.1.3 https://affiliatewp.com/addons/order-details-affiliates/
    AffiliateWP Performance Bonuses 1.0.3.1 http://propluginmarketplace.com/plugins/affiliatewp-performance-bonuses
    AffiliateWP Ranks 1.0.2 http://propluginmarketplace.com/plugins/affiliatewp-ranks
    AffiliateWP Variable Rates 1.3 http://propluginmarketplace.com/plugins/affiliatewp-variable-rates
    Akismet Anti-Spam 3.3.2 https://akismet.com/
    All In One WP Security 4.2.8 https://www.tipsandtricks-hq.com/wordpress-security-and-firewall-plugin
    Autoptimize 2.2.0 http://autoptimize.com/
    bbPress 2.5.12 https://bbpress.org
    BuddyPress Instant Chat 1.6 http://iamrichardphelps.com/
    BuddyPress 2.8.2 https://buddypress.org/
    Contact Form 7 Datepicker 2.6.0 https://github.com/relu/contact-form-7-datepicker/
    Contact Form 7 Honeypot 1.10 http://www.nocean.ca/plugins/honeypot-module-for-contact-form-7-wordpress-plugin/
    Contact Form 7 4.8 https://contactform7.com/
    Cookie Notice 1.2.38 http://www.dfactory.eu/plugins/cookie-notice/
    Delightful Downloads 1.6.6 https://delightfuldownloads.com
    Google Tag Manager for WordPress 1.6.1 https://duracelltomi.com/google-tag-manager-for-wordpress/
    Email Log 1.9.1 http://sudarmuthu.com/wordpress/email-log
    EWWW Image Optimizer 3.4.1 https://wordpress.org/plugins/ewww-image-optimizer/
    Featured Image Generator 1.1.5 https://designilcode.com
    FooTable 0.3.1 http://fooplugins.com/plugins/footable-lite/
    GD Business Hours 1.3.8.2 http://www.solarflarecomputing.com
    GeoDirectory Advance Search Filters 1.4.9 http://wpgeodirectory.com/
    GeoDirectory AffiliateWP Integration 1.0.8 http://wpgeodirectory.com
    GeoDirectory Ajax Duplicate Alert 1.1.8 http://wpgeodirectory.com
    GeoDirectory BuddyPress Integration 1.1.9 http://wpgeodirectory.com/
    GeoDirectory Claim Manager 1.3.21 http://wpgeodirectory.com
    GeoDirectory Custom Post Types 1.3.5 http://wpgeodirectory.com
    GeoDirectory Dashboard 0.0.1 https://wpgeodirectory.com
    GeoDirectory Events 1.4.6 https://wpgeodirectory.com
    GeoDirectory Franchise Manager 1.0.6 http://wpgeodirectory.com/
    GeoDirectory Invoice 1.0 http://www.worldcheckin.com
    GeoDirectory Location Manager 1.5.50 http://wpgeodirectory.com
    GeoDirectory Marker Cluster 1.3.0 http://wpgeodirectory.com
    GeoDirectory Payment Manager 1.4.4 http://wpgeodirectory.com
    GeoDirectory Re-Captcha 1.1.5 http://wpgeodirectory.com/
    GeoDirectory Review Rating Manager 1.3.8 http://wpgeodirectory.com
    GeoDirectory Social Importer 1.3.1 http://wpgeodirectory.com
    GeoDirectory 1.6.21 http://wpgeodirectory.com/
    GT-Vouchers – GeoDirectory Version 1.5.7.8 http://www.gt-vouchers.com/
    Icegram – Popups, Optins, CTAs & lot more… 1.10.5 http://www.icegram.com/
    Idea Factory 1.2 http://wpideafactory.com
    If Modified Since Header 1.2.5 https://www.isaumya.com/portfolio-item/if-modified-since-header-for-wordpress/
    Inbound Extension – MailPoet Integration 1.0.9 http://www.inboundnow.com/
    Insert HTML Snippet 1.2.2 http://xyzscripts.com/wordpress-plugins/insert-html-snippet/
    Collapse-O-Matic 1.7.5 https://plugins.twinpictures.de/plugins/collapse-o-matic/
    Leads 3.1.1 http://www.inboundnow.com/leads/
    MailPoet – Contact Form 7 Integration 1.0.7.5 https://github.com/jessepearson/mailpoet-contact-form-7
    Master Slider Pro 3.1.3 http://codecanyon.net/item/masterslider-pro/7467925?ref=averta
    Multilingual Tools 1.2 https://wpml.org/download/multilingual-tools/
    ProfitBuilder 2.2.7 http://www.imsuccesscenter.com/
    AffiliateWP – Pushover Notifications 1.0.2 http://affiliatewp.com/addons/pushover-notifications
    SendGrid 1.11.3 https://wordpress.org/plugins/sendgrid-email-delivery-simplified/
    WPML Multilingual CMS 3.7.1 https://wpml.org/
    Social Content Locker 1.1 http://web-settler.com/wordpress-social-locker/
    Standout CSS3 Buttons 0.3.0 http://www.jimmyscode.com/wordpress/standout-css3-buttons/
    TablePress Extension: Responsive Tables 1.4 https://tablepress.org/extensions/responsive-tables/
    TablePress 1.8 https://tablepress.org/
    TinyMCE Advanced 4.6.3 http://www.laptoptips.ca/projects/tinymce-advanced/
    UberMenu 3 – The Ultimate WordPress Mega Menu 3.2.5 http://wpmegamenu.com
    UpdraftPlus – Backup/Restore 2.13.4.21 https://updraftplus.com
    Use Google Libraries 1.6.2.3 http://jasonpenney.net/wordpress-plugins/use-google-libraries/
    Widget Logic 5.8.2 https://wordpress.org/extend/plugins/widget-logic/
    Yoast SEO 4.9 https://yoast.com/wordpress/plugins/seo/#utm_source=wpadmin&utm_medium=plugin&utm_campaign=wpseoplugin
    Clean Up Optimizer 4.0.10 http://beta.tech-banker.com
    Wordpress Social Invitations – Lite 2.1.1 http://wp.timersys.com/wordpress-social-invitations/
    WP Super Cache – Clear all cache 1.4 http://ocaoimh.ie/wp-super-cache/
    WP Super Cache 1.4.9 https://wordpress.org/plugins/wp-super-cache/
    WP Support Plus 8.0.7 https://wordpress.org/plugins/wp-support-plus-responsive-ticket-system-ticket-system/
    WPML CMS Nav 1.4.20 https://wpml.org/
    WPML Media 2.2.0 https://wpml.org/
    WPML Page Builders 1.1.3 https://wpml.org/
    WPML Sticky Links 1.4.1 https://wpml.org/
    WPML String Translation 2.5.4 https://wpml.org/
    WPML Translation Management 2.3.1 https://wpml.org/
    WPML Widgets 1.0.6 http://jeroensormani.com
    MailPoet Newsletters 2.7.10 http://www.mailpoet.com/

    9. Are you using the standard WordPress theme or customized theme?
    customized theme

    10. Which theme do you use ?
    GDF_child is from geodirectory (but the problem occur even, if I switch the theme to twenty fourteen)

    11. Have you modified the core files in any way?
    No

    12. Do you have any custom functions in bp-custom.php?
    Not as I know, but maybe the geodirectory addon “GeoDirectory BuddyPress Integration 1.1.9″

    13. If running bbPress, which version? Or did your BuddyPress install come with a copy of bbPress built-in?
    no build in. version in use is bbPress 2.5.12

    14. Please provide a list of any errors in your server’s log files.
    [23-Jun-2017 03:41:33 UTC] WordPress database error Table ‘worldche_wcimsgd.wp_term_relationships’ doesn’t exist for query SELECT tt.term_id, MAX(p.post_modified_gmt) AS date_gmt, l.country_slug AS country, l.region_slug AS region, l.city_slug AS city FROM ms_1_geodir_post_locations l LEFT JOIN ms_1_geodir_gd_video_detail pd ON pd.post_location_id = l.location_id LEFT JOIN ms_1_posts p ON p.ID = pd.post_id LEFT JOIN wp_term_relationships AS tr ON tr.object_id = p.ID LEFT JOIN wp_term_taxonomy AS tt ON ( tt.term_taxonomy_id = tr.term_taxonomy_id AND tt.taxonomy = ‘gd_videocategory’ ) WHERE pd.post_locations LIKE CONCAT( ‘[‘, l.city_slug, ‘],[‘, l.region_slug , ‘],[‘, l.country_slug , ‘]’ ) AND p.post_type = ‘gd_video’ AND p.post_status = ‘publish’ AND l.location_id IS NOT NULL AND tt.term_id IS NOT NULL GROUP BY CONCAT(tt.term_id, ‘-‘, l.country_slug, ‘-‘, l.region_slug, ‘-‘, l.city_slug) ORDER BY date_gmt DESC made by require(‘wp-blog-header.php’), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts, do_action_ref_array, WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, WPSEO_Sitemaps->redirect, WPSEO_Sitemaps->build_sitemap, WPSEO_Sitemaps->build_root_map, WPSEO_Sitemaps_Renderer->get_index, apply_filters(‘wpseo_sitemap_index’), WP_Hook->apply_filters, call_user_func_array, geodir_sitemap_index, geodir_sitemap_taxonomies_sitemap_index, geodir_sitemap_get_locations_taxonomies
    [23-Jun-2017 03:41:33 UTC] WordPress database error Table ‘worldche_wcimsgd.wp_term_relationships’ doesn’t exist for query SELECT tt.term_id, MAX(p.post_modified_gmt) AS date_gmt, l.country_slug AS country, l.region_slug AS region, l.city_slug AS city FROM ms_1_geodir_post_locations l LEFT JOIN ms_1_geodir_gd_video_detail pd ON pd.post_location_id = l.location_id LEFT JOIN ms_1_posts p ON p.ID = pd.post_id LEFT JOIN wp_term_relationships AS tr ON tr.object_id = p.ID LEFT JOIN wp_term_taxonomy AS tt ON ( tt.term_taxonomy_id = tr.term_taxonomy_id AND tt.taxonomy = ‘gd_video_tags’ ) WHERE pd.post_locations LIKE CONCAT( ‘[‘, l.city_slug, ‘],[‘, l.region_slug , ‘],[‘, l.country_slug , ‘]’ ) AND p.post_type = ‘gd_video’ AND p.post_status = ‘publish’ AND l.location_id IS NOT NULL AND tt.term_id IS NOT NULL GROUP BY CONCAT(tt.term_id, ‘-‘, l.country_slug, ‘-‘, l.region_slug, ‘-‘, l.city_slug) ORDER BY date_gmt DESC made by require(‘wp-blog-header.php’), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts, do_action_ref_array, WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, WPSEO_Sitemaps->redirect, WPSEO_Sitemaps->build_sitemap, WPSEO_Sitemaps->build_root_map, WPSEO_Sitemaps_Renderer->get_index, apply_filters(‘wpseo_sitemap_index’), WP_Hook->apply_filters, call_user_func_array, geodir_sitemap_index, geodir_sitemap_taxonomies_sitemap_index, geodir_sitemap_get_locations_taxonomies
    [23-Jun-2017 04:40:47 UTC] WordPress-Datenbank-Fehler You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ” at line 1 für Abfrage SELECT * FROM ms_1_geodir_invoice WHERE post_id = von require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/themes/GDF_child/geodirectory/listing-success.php’), my_project_updated_email
    [23-Jun-2017 04:40:47 UTC] WordPress-Datenbank-Fehler You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘WHERE post_author = 0’ at line 1 für Abfrage UPDATE ms_1_posts SET vat_id = WHERE post_author = 0 von require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/themes/GDF_child/geodirectory/listing-success.php’), my_project_updated_email
    [23-Jun-2017 06:43:08 UTC] PHP Fatal error: Call to undefined function is_bbpress() in /home/worldcheckin/public_html/wci/wp-content/plugins/widget-logic/widget_logic.php(463) : eval()’d code on line 2

    15. Which company provides your hosting?
    hetzner – I am using a own dedicated server

    16. Is your server running Windows, or if Linux; Apache, nginx or something else?
    Linux

    wci
    Participant

    Hi Buddypress support,
    I am still waiting to get my problem to solve.
    While using bbpress search forum then the search result is not displayed, but instead get forward to homepage.
    Please find this screen video helpful to solve my issue
    > https://www.screencast.com/t/eMZEAnn9X2

    Please also find this info helpful as you stated you need those info too:

    Please try to supply answers to the following questions.
    1. Which version of WordPress are you running?
    WP ver. 4.8

    2. Did you install WordPress as a directory or subdomain install?
    directory but as multisite

    3. If a directory install, is it in root or in a subdirectory?
    subdirectory /public_html/wci

    4. Did you upgrade from a previous version of WordPress? If so, from which version?
    no – Version 2.8.2 is in use

    5. Was WordPress functioning properly before installing/upgrading BuddyPress (BP)? e.g. permalinks, creating a new post, commenting.
    not sure but I guess it was working

    6. Which version of BP are you running?
    Version 2.8.2 is in use

    7. Did you upgraded from a previous version of BP? If so, from which version?
    no

    8. Do you have any plugins other than BuddyPress installed and activated? If so, which ones?
    (but the problem occur even, if I deactiavete all plugins just using buddypress and bbpress together)
    Name Version Plugin URL
    WP Easy Updates 1.1.1 http://ayecode.io/
    AffiliateWP – Lifetime Commissions 1.2.4 http://affiliatewp.com/addons/lifetime-commissions/
    AffiliateWP – PayPal Payouts 1.1.7 http://affiliatewp.com/addons/paypal-payouts/
    AffiliateWP – Recurring Referrals 1.6.2 http://affiliatewp.com/addons/recurring-referrals/
    AffiliateWP 2.0.10 https://affiliatewp.com
    AffiliateWP – Affiliate Area Tabs 1.1.5 https://affiliatewp.com/
    AffiliateWP – Affiliate Dashboard Sharing 1.1.3 http://affiliatewp.com/addons/affiliate-dashboard-sharing/
    AffiliateWP BuddyPress Pro 1.0.1 http://propluginmarketplace.com/plugins/affiliatewp-buddypress-pro
    AffiliateWP – Direct Link Tracking 1.1.1 https://affiliatewp.com/add-ons/pro/direct-link-tracking/
    AffiliateWP MLM 1.1.2 http://theperfectplugin.com/downloads/affiliatewp-mlm
    AffiliateWP – Order Details For Affiliates 1.1.3 https://affiliatewp.com/addons/order-details-affiliates/
    AffiliateWP Performance Bonuses 1.0.3.1 http://propluginmarketplace.com/plugins/affiliatewp-performance-bonuses
    AffiliateWP Ranks 1.0.2 http://propluginmarketplace.com/plugins/affiliatewp-ranks
    AffiliateWP Variable Rates 1.3 http://propluginmarketplace.com/plugins/affiliatewp-variable-rates
    Akismet Anti-Spam 3.3.2 https://akismet.com/
    All In One WP Security 4.2.8 https://www.tipsandtricks-hq.com/wordpress-security-and-firewall-plugin
    Autoptimize 2.2.0 http://autoptimize.com/
    bbPress 2.5.12 https://bbpress.org
    BuddyPress Instant Chat 1.6 http://iamrichardphelps.com/
    BuddyPress 2.8.2 https://buddypress.org/
    Contact Form 7 Datepicker 2.6.0 https://github.com/relu/contact-form-7-datepicker/
    Contact Form 7 Honeypot 1.10 http://www.nocean.ca/plugins/honeypot-module-for-contact-form-7-wordpress-plugin/
    Contact Form 7 4.8 https://contactform7.com/
    Cookie Notice 1.2.38 http://www.dfactory.eu/plugins/cookie-notice/
    Delightful Downloads 1.6.6 https://delightfuldownloads.com
    Google Tag Manager for WordPress 1.6.1 https://duracelltomi.com/google-tag-manager-for-wordpress/
    Email Log 1.9.1 http://sudarmuthu.com/wordpress/email-log
    EWWW Image Optimizer 3.4.1 https://wordpress.org/plugins/ewww-image-optimizer/
    Featured Image Generator 1.1.5 https://designilcode.com
    FooTable 0.3.1 http://fooplugins.com/plugins/footable-lite/
    GD Business Hours 1.3.8.2 http://www.solarflarecomputing.com
    GeoDirectory Advance Search Filters 1.4.9 http://wpgeodirectory.com/
    GeoDirectory AffiliateWP Integration 1.0.8 http://wpgeodirectory.com
    GeoDirectory Ajax Duplicate Alert 1.1.8 http://wpgeodirectory.com
    GeoDirectory BuddyPress Integration 1.1.9 http://wpgeodirectory.com/
    GeoDirectory Claim Manager 1.3.21 http://wpgeodirectory.com
    GeoDirectory Custom Post Types 1.3.5 http://wpgeodirectory.com
    GeoDirectory Dashboard 0.0.1 https://wpgeodirectory.com
    GeoDirectory Events 1.4.6 https://wpgeodirectory.com
    GeoDirectory Franchise Manager 1.0.6 http://wpgeodirectory.com/
    GeoDirectory Invoice 1.0 http://www.worldcheckin.com
    GeoDirectory Location Manager 1.5.50 http://wpgeodirectory.com
    GeoDirectory Marker Cluster 1.3.0 http://wpgeodirectory.com
    GeoDirectory Payment Manager 1.4.4 http://wpgeodirectory.com
    GeoDirectory Re-Captcha 1.1.5 http://wpgeodirectory.com/
    GeoDirectory Review Rating Manager 1.3.8 http://wpgeodirectory.com
    GeoDirectory Social Importer 1.3.1 http://wpgeodirectory.com
    GeoDirectory 1.6.21 http://wpgeodirectory.com/
    GT-Vouchers – GeoDirectory Version 1.5.7.8 http://www.gt-vouchers.com/
    Icegram – Popups, Optins, CTAs & lot more… 1.10.5 http://www.icegram.com/
    Idea Factory 1.2 http://wpideafactory.com
    If Modified Since Header 1.2.5 https://www.isaumya.com/portfolio-item/if-modified-since-header-for-wordpress/
    Inbound Extension – MailPoet Integration 1.0.9 http://www.inboundnow.com/
    Insert HTML Snippet 1.2.2 http://xyzscripts.com/wordpress-plugins/insert-html-snippet/
    Collapse-O-Matic 1.7.5 https://plugins.twinpictures.de/plugins/collapse-o-matic/
    Leads 3.1.1 http://www.inboundnow.com/leads/
    MailPoet – Contact Form 7 Integration 1.0.7.5 https://github.com/jessepearson/mailpoet-contact-form-7
    Master Slider Pro 3.1.3 http://codecanyon.net/item/masterslider-pro/7467925?ref=averta
    Multilingual Tools 1.2 https://wpml.org/download/multilingual-tools/
    ProfitBuilder 2.2.7 http://www.imsuccesscenter.com/
    AffiliateWP – Pushover Notifications 1.0.2 http://affiliatewp.com/addons/pushover-notifications
    SendGrid 1.11.3 https://wordpress.org/plugins/sendgrid-email-delivery-simplified/
    WPML Multilingual CMS 3.7.1 https://wpml.org/
    Social Content Locker 1.1 http://web-settler.com/wordpress-social-locker/
    Standout CSS3 Buttons 0.3.0 http://www.jimmyscode.com/wordpress/standout-css3-buttons/
    TablePress Extension: Responsive Tables 1.4 https://tablepress.org/extensions/responsive-tables/
    TablePress 1.8 https://tablepress.org/
    TinyMCE Advanced 4.6.3 http://www.laptoptips.ca/projects/tinymce-advanced/
    UberMenu 3 – The Ultimate WordPress Mega Menu 3.2.5 http://wpmegamenu.com
    UpdraftPlus – Backup/Restore 2.13.4.21 https://updraftplus.com
    Use Google Libraries 1.6.2.3 http://jasonpenney.net/wordpress-plugins/use-google-libraries/
    Widget Logic 5.8.2 https://wordpress.org/extend/plugins/widget-logic/
    Yoast SEO 4.9 https://yoast.com/wordpress/plugins/seo/#utm_source=wpadmin&utm_medium=plugin&utm_campaign=wpseoplugin
    Clean Up Optimizer 4.0.10 http://beta.tech-banker.com
    Wordpress Social Invitations – Lite 2.1.1 http://wp.timersys.com/wordpress-social-invitations/
    WP Super Cache – Clear all cache 1.4 http://ocaoimh.ie/wp-super-cache/
    WP Super Cache 1.4.9 https://wordpress.org/plugins/wp-super-cache/
    WP Support Plus 8.0.7 https://wordpress.org/plugins/wp-support-plus-responsive-ticket-system-ticket-system/
    WPML CMS Nav 1.4.20 https://wpml.org/
    WPML Media 2.2.0 https://wpml.org/
    WPML Page Builders 1.1.3 https://wpml.org/
    WPML Sticky Links 1.4.1 https://wpml.org/
    WPML String Translation 2.5.4 https://wpml.org/
    WPML Translation Management 2.3.1 https://wpml.org/
    WPML Widgets 1.0.6 http://jeroensormani.com
    MailPoet Newsletters 2.7.10 http://www.mailpoet.com/

    9. Are you using the standard WordPress theme or customized theme?
    customized theme

    10. Which theme do you use ?
    GDF_child is from geodirectory (but the problem occur even, if I switch the theme to twenty fourteen)

    11. Have you modified the core files in any way?
    No

    12. Do you have any custom functions in bp-custom.php?
    Not as I know, but maybe the geodirectory addon “GeoDirectory BuddyPress Integration 1.1.9″

    13. If running bbPress, which version? Or did your BuddyPress install come with a copy of bbPress built-in?
    no build in. version in use is bbPress 2.5.12

    14. Please provide a list of any errors in your server’s log files.
    [23-Jun-2017 03:41:33 UTC] WordPress database error Table ‘worldche_wcimsgd.wp_term_relationships’ doesn’t exist for query SELECT tt.term_id, MAX(p.post_modified_gmt) AS date_gmt, l.country_slug AS country, l.region_slug AS region, l.city_slug AS city FROM ms_1_geodir_post_locations l LEFT JOIN ms_1_geodir_gd_video_detail pd ON pd.post_location_id = l.location_id LEFT JOIN ms_1_posts p ON p.ID = pd.post_id LEFT JOIN wp_term_relationships AS tr ON tr.object_id = p.ID LEFT JOIN wp_term_taxonomy AS tt ON ( tt.term_taxonomy_id = tr.term_taxonomy_id AND tt.taxonomy = ‘gd_videocategory’ ) WHERE pd.post_locations LIKE CONCAT( ‘[‘, l.city_slug, ‘],[‘, l.region_slug , ‘],[‘, l.country_slug , ‘]’ ) AND p.post_type = ‘gd_video’ AND p.post_status = ‘publish’ AND l.location_id IS NOT NULL AND tt.term_id IS NOT NULL GROUP BY CONCAT(tt.term_id, ‘-‘, l.country_slug, ‘-‘, l.region_slug, ‘-‘, l.city_slug) ORDER BY date_gmt DESC made by require(‘wp-blog-header.php’), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts, do_action_ref_array, WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, WPSEO_Sitemaps->redirect, WPSEO_Sitemaps->build_sitemap, WPSEO_Sitemaps->build_root_map, WPSEO_Sitemaps_Renderer->get_index, apply_filters(‘wpseo_sitemap_index’), WP_Hook->apply_filters, call_user_func_array, geodir_sitemap_index, geodir_sitemap_taxonomies_sitemap_index, geodir_sitemap_get_locations_taxonomies
    [23-Jun-2017 03:41:33 UTC] WordPress database error Table ‘worldche_wcimsgd.wp_term_relationships’ doesn’t exist for query SELECT tt.term_id, MAX(p.post_modified_gmt) AS date_gmt, l.country_slug AS country, l.region_slug AS region, l.city_slug AS city FROM ms_1_geodir_post_locations l LEFT JOIN ms_1_geodir_gd_video_detail pd ON pd.post_location_id = l.location_id LEFT JOIN ms_1_posts p ON p.ID = pd.post_id LEFT JOIN wp_term_relationships AS tr ON tr.object_id = p.ID LEFT JOIN wp_term_taxonomy AS tt ON ( tt.term_taxonomy_id = tr.term_taxonomy_id AND tt.taxonomy = ‘gd_video_tags’ ) WHERE pd.post_locations LIKE CONCAT( ‘[‘, l.city_slug, ‘],[‘, l.region_slug , ‘],[‘, l.country_slug , ‘]’ ) AND p.post_type = ‘gd_video’ AND p.post_status = ‘publish’ AND l.location_id IS NOT NULL AND tt.term_id IS NOT NULL GROUP BY CONCAT(tt.term_id, ‘-‘, l.country_slug, ‘-‘, l.region_slug, ‘-‘, l.city_slug) ORDER BY date_gmt DESC made by require(‘wp-blog-header.php’), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts, do_action_ref_array, WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, WPSEO_Sitemaps->redirect, WPSEO_Sitemaps->build_sitemap, WPSEO_Sitemaps->build_root_map, WPSEO_Sitemaps_Renderer->get_index, apply_filters(‘wpseo_sitemap_index’), WP_Hook->apply_filters, call_user_func_array, geodir_sitemap_index, geodir_sitemap_taxonomies_sitemap_index, geodir_sitemap_get_locations_taxonomies
    [23-Jun-2017 04:40:47 UTC] WordPress-Datenbank-Fehler You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ” at line 1 für Abfrage SELECT * FROM ms_1_geodir_invoice WHERE post_id = von require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/themes/GDF_child/geodirectory/listing-success.php’), my_project_updated_email
    [23-Jun-2017 04:40:47 UTC] WordPress-Datenbank-Fehler You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘WHERE post_author = 0’ at line 1 für Abfrage UPDATE ms_1_posts SET vat_id = WHERE post_author = 0 von require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/themes/GDF_child/geodirectory/listing-success.php’), my_project_updated_email
    [23-Jun-2017 06:43:08 UTC] PHP Fatal error: Call to undefined function is_bbpress() in /home/worldcheckin/public_html/wci/wp-content/plugins/widget-logic/widget_logic.php(463) : eval()’d code on line 2

    15. Which company provides your hosting?
    hetzner – I am using a own dedicated server

    16. Is your server running Windows, or if Linux; Apache, nginx or something else?
    Linux

    #264433
    psnation
    Participant

    I’ve searched for nearly a year before I finally found a solution to automatically adding location to sign up and profiles. I am now using Location Autocomplete for BuddyPress by BuddyBoss. It is a paid plugin but it is amazing. It uses Google’s API so all you do is type a letter and it will auto suggest. There were many requests over the years for a plugin like this. The only thing missing so far is a way to search by distance. If you’ve been searching give this plugin a try.

    Location Autocomplete for BuddyPress

    #261327
    Colourscope
    Participant

    Hi,

    Is there any way to search for a member to select country first then a conditional drop-down lets you next select the state (if US) or county (if UK)?

    My website involves an international community and I need it to be searchable by country and region for multiple countries.

    Can anyone help, please?
    Andy

    #260682
    elgroyconboy
    Participant

    Hello,

    I’m developing a website for my company and we’re trying to sync the assigned group data in buddy press with the user so when we go into mailchimp we can sort/partition our lists in mailchimp by the corresponding group.

    The code we’re using to sync all the other data in extended profile is here, but my concern is that we can’t pull the group the same way because it’s not something that gets added in the extended profile. I’m almost certain that I can’t pull the group with these parameters because when i look in the database, there’s no user-ID tied to any group. However, when i go into buddypress groups there’s users assigned to them.

    This is the function we’re using to sync:

    add_filter( ‘mailchimp_sync_user_data’, ‘mailchimp_buddypress’, 10, 2 );
    //Write the function
    function mailchimp_buddypress( $data, $user ) {

    //Get user ID
    $user_id = $user->ID;

    // Store Xprofile fields in the $data variable
    $data[‘JOBTITLE’] = xprofile_get_field_data( 11 , $user_id );
    $data[‘ORG’] = xprofile_get_field_data( 12 , $user_id );
    $data[‘CITY’] = xprofile_get_field_data( 36 , $user_id );
    $data[‘STATE’] = xprofile_get_field_data( 16 , $user_id );
    $data[‘COUNTRY’] = xprofile_get_field_data( 18 , $user_id );
    $data[‘PHONE’] = xprofile_get_field_data( 19 , $user_id );
    $data[‘SALUTATION’] = xprofile_get_field_data( 3 , $user_id );
    $data[‘GROUP’] = bp_get_current_group_id( 1 , $user_id );
    //Return the data
    return $data;

    }

    Right now the last line “$data[‘GROUP’] = bp_get_current_group_id( 1 , $user_id );” outputs a “0”.

    Thank you for reading! Hoping someone on here can help me.

    #257245
    wescravn
    Participant

    I’m using WP ALL IMPORT PRO with BuddyPress. I’m able to see certain fields to import such as Name, and other standard fields. When I try to view custom fields, I get some custom fields, but none of the fields that I created, or that my theme SWEETDATE created. I can’t even see CITY, or COUNTRY. I see they are custom fields. Is there any way around this? I want to import the users city, and state.

    #255394
    rajsandy11
    Participant

    @danbp
    Thanks for the replay, Script to load xprofile list is working well, I also had state and city fields in my registraion form… Is there any script to achieve conditional selects ??? i mean if i select a country it should populate states belong to that country and if i select state from that list it should populate cities belong to that city only.

    Thanks

    #254017
    emeraldcity
    Participant

    Hi Everyone,

    I’m very new to the BP world and am excited to be using this amazing tool to build a new community online.

    GROUPS:
    I want to use groups as a notification center, allowing members to comment/interact with the notifications. So what I need is for only group admins/moderators to be able to post to the group activity stream. Other group members can only comment and favorite these posts, but cannot make a new post to the activity stream. Is this possible?

    MEMBERS
    Is there a way to show a google map with pins representing the city/state/country fields that users fill in their profile? Would further like these pins to be clickable, displaying certain fields from a user’s public profile.

    Any help with plugins and coding for the above would be very much appreciated. Thanks!

    #243799

    In reply to: custom profile fields

    danbp
    Participant

    @naisai,

    are you sure you want to show a list of over 80 cities ? Have you ever scrolled such a long list on a mobile (usage 2014) ?

    Please, read here:
    https://buddypress.org/support/topic/list-of-countrystatecity/

    #238457
    danbp
    Participant

    @fridafric,

    plugin is outdated and a support question about how to use it with buddypress is… unanswered.
    In the early stage of BuddyPress, countries where included to Core and finally removed around 1.1

    Honestly, you have 3 options:
    1) wasting time&money to code a plugin or tweaking BuddyPress and a third party plugin (long option).
    2) let the user enter his country when asked for (short option).
    3) do nothing (optionnal option)

    or you can read from here:
    https://buddypress.org/support/topic/list-of-countrystatecity/

    #235946
    howsepa
    Participant

    Sorry should have included full function…

    
    //Catch messages on successful login
        function login_action($user_login)
        {
    
            $userdata = get_user_by('login', $user_login);
    
            $uid = ($userdata && $userdata->ID) ? $userdata->ID : 0;
    
            $data[$this->data_labels['login']] = ( 1 == $this->login_success ) ? $this->data_labels['Successful'] : $this->data_labels['Failed'];
            if ( isset( $_REQUEST['redirect_to'] ) ) { $data[$this->data_labels['login Redirect']] = esc_attr( $_REQUEST['redirect_to'] ); }
            $data[$this->data_labels['User Agent']] = esc_attr( $_SERVER['HTTP_USER_AGENT'] );
    
            $serialized_data = serialize($data);
    
            //get user role
            $user_role = '';
            if( $uid ){
                $user = new WP_User( $uid );
                if ( !empty( $user->roles ) && is_array( $user->roles ) ) {
                    $user_role = implode(', ', $user->roles);
                }
            }
    		$current_user = wp_get_current_user();
    		$user_email = $user->user_email;
    	
    
    		$real_client_ip_address = isset($_SERVER['HTTP_X_FORWARDED_FOR']) ? esc_attr($_SERVER['HTTP_X_FORWARDED_FOR']) : esc_attr($_SERVER['REMOTE_ADDR']);
    		
    
    		$guest_ip   = $visitor_location['IP'];
    		$guest_country = "";
    		$guest_city  = "";
    		$guest_state = "";
    		$user_info = get_userdata($uid);
            $USErname =  $user_info->first_name .  " " . $user_info->last_name;
            
    		
    
    			
    		global $bp;
    		
    		$group =  get_group_ids( bp_loggedin_user_id() );
            
    		$values = array(
                'uid'           => $uid,
                'user_login'    => $user_login,
                'user_role'     => $user_role,
    			'user_email'		=> $user_email,
                'time'          => current_time('mysql'),
                'ip'            => isset($_SERVER['HTTP_X_FORWARDED_FOR']) ? esc_attr($_SERVER['HTTP_X_FORWARDED_FOR']) : esc_attr($_SERVER['REMOTE_ADDR']),
    			'country'       => $guest_country,
    			'city'			=> $guest_city,
                'login_result'  => $this->login_success,
                'data'          => $serialized_data,
    			'name'			=> $USErname,
    			'group'			=> $group
                );
    
            $format = array('%d', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s','%s','%s');
    
            $this->save_data($values, $format);
        }
    
    Buddypressnewb
    Participant

    Greetings,

    I am kinda new to WordPress and Buddypres. But i have some questions and i don’t know if it possible. For example my site is about cars. Is it possible to add something like this, example:

    Make (parent catergory)
    Honda
    Opel
    … more

    Type (sub category)
    Honda
    – Civic
    – CRX
    Opel
    – Astra
    – Mokka

    How can i use it in my profile? I choose the make: Honda it shows only Civic and CRX (no other type in the type field). And it should also allow me to create a filter for make and type, so that users can search for a certain car.

    —-

    Is there a way to use googlemap to determine the location of an user. And use the generated info for the advance search for example: I live in Zoetermeer NL, the generated info would be
    Country: NL State/Province: Zuid-Holland City: Zoetermeer. Allows a user to filter for nearby users.

    I am sorry but English is not that good, but i hope my message is clear enough, thanks in advance.

    Regards,
    Nunivo

    #197330
    danbp
    Participant
    #197314
    jessicana
    Participant

    I wish we consider having a dropdown select box of country> state> city out of the box with BuddyPress where if user selects United States, all of the states and cities related to the state appear automatically.

    Any current solution for this?

    Thanks!

    #177712
    webauthor
    Participant

    I’ve been reading a lot about this issue and it looks like BP is missing some very basic functionality. This is the first time using it and right out of the gate I see that there are some things that have me baffled.

    1) No way to create conditional fields. I’ve tried using the Gravity Forms User Registration Add-On plugin but there is no way to map fields properly. For example, in Gravity Forms I have Country, State and City fields. If someone selects United States as a Country for example, the next field that the user sees is the State field, but then I run into a problem when someone selects a City. In order to use conditional fields with Gravity Forms, I need to create many City fields (alabama-cities, alaska-cities etc). One City field for each State. These City fields are conditional fields that displayed to the user Cities based on what the user selects in the State field.

    The problem is that Gravity Forms wants me to first create User Profile Fields in BuddyPress. Then map each Gravity Forms field to the appropriate User Profile Field. Since I have many Gravity Forms cities field, there is no way I can tell Gravity Forms to use the City that the user selects and map it to a City User Profile field in BuddyPress.

    I’ve read a lot of posts on this forum dating back 5 years and no one has offered a working solution.

    2) Also, Why is there no option for an admin to be able to deny users from changing their Screenname? How about an option that prevents user from modifying a specific field such as Gender? All I see is havoc and chaos if you allow users to change certain fields.

    3) Why doesn’t BuddyPress offer a way to have different registration fields based on the user? Teacher / Student Registration, Doctor / Patient etc? It doesn’t make sense. Look at the core of BuddyPress. It’s a social network plugin. In almost every circumstance you have a need for one user have certain fields and another to have other fields. Trying to figure out how to show certain profile fields for one user and not another should be at the core of this plugin. Not to mention making it easy for the site owner to layout those fields so that they look nice. For example something as easy as defining the length of the fields. You can’t make those modifications without Firebug and CSS and PHP experience, or worse yet another plugin. If you use a plugin, then you have to pray to God the author of that plugin not to fall off a cliff or pray that he / she keeps that plugin conducive with the latest version of BP.

    I don’t mean to gripe but BuddyPress it seems to me that at it’s core, very little thought was given to how people would actually use it. Almost like it’s piecemealed together.

    Another big complaint is that it’s not compatible with the best WordPress themes on the planet – StudioPress. Shouldn’t the contributors of BP make sure that BP and StudioPress be compatible?

    I’m sorry if this sounds like a rant, it’s not. It’s just frustration. BP looks awesome but underneath the hood, there are a lot of obvious problems. My suggestion is to do what WooCommerce, StudioPress and others do. Sit down and figure out how to handle the big issues first. If need be, charge for BuddyPress. If the problem is that you have a bunch of contributors who work on things “they” deem important and at their own leisure, then the plugin suffers. Charge for it. Sit down and listen to the complaints and address them based on customer priority. Pay someone to reply to this forum so we’re not waiting days for a response. You’ll have much happier users and a much better plugin. Just my 2 cents worth. Honestly, since BP is virtually the only Plugin of it’s kind, not taking my advice will lead to someone creating a better wheel and that point, it’s only a matter of time before BP becomes obsolete.

    It’s been close to 24 hours and no response to my original question. If ANYONE has an answer as to how I can get a user to simply select a Country, then State, then City based on previous fields, I’d greatly appreciate it. Also if someone could please tell me how to prevent users from modifying certain fields that would be appreciated as well.

    Thanks

    #176084
    CliffDillard
    Participant

    I have an alumni site and added fields for Graduation Year (drop down) and current residence (City (optional), State (drop down) and Country (drop Down) and About Me (multi line text)
    I also added fields for current last name versus name while in school.
    The registration form looks fine but when I pull up a member record the data is messed up. An example would be
    Last Name while in school: John Smith
    Last Name current: EH
    First Name: CM
    Class of : 1995
    City: WK
    State: MB Manitoba
    Country: Swaziland
    About me: BD

    The class of is a drop down and the 1995 is correct.
    The State is a drop down but MB was not correct for this person.
    Country is a drop down but Swaziland is incorrect for this person.

    I read that changing the name of the Name field might cause a problem but that post was 2 years ago and appears to have been corrected.

    Any ideas what I set up incorrectly?

    Note: Some registrations go through cleanly but most are coming through with these types of errors.

    #173397
    mikepaxton
    Participant

    After uploading users via CSV, the users show in the member listings area, but do not filter properly based on criteria like gender / age / etc…. are there areas that have to have data that i may have missed on upload?

    Fields Uploaded:
    user_login
    user_email
    display_name
    user_pass
    last_name
    first_name
    Full Name
    Gender
    City
    State
    Zip Code
    Country
    Languages
    Marital status
    In search of
    Birthday
    Ethnicity
    Schooling
    Occupation
    avatar
    user_registered
    last_activity
    membership_id
    membership_enddate
    membership_subscription_transaction_id
    membership_gateway

    #171378
    dmpastuf
    Participant

    When I post my custom form on a custom tab, I get a wordpress “Are you sure?” page (i.e. a wp_nonce_ays). Not so much an error as a failure (i.e. I’d expect nonce to be causing what its causing, but have no idea what field is doing so).

    Here’s the code I’m using for one of the two form tabs:

    
    add_action('bp_init', 'bpcivi_addgroupeditnav1');
    
    function bpcivi_addgroupeditnav1() {
    if ( class_exists( 'BP_Group_Extension' ) ) { // Recommended, to prevent problems during upgrade or when Groups are disabled
      //Run to find out if a chapter
     	global $wpdb;
    	global $bp;
     	$bpcivi_ck_currgroup = $bp->groups->current_group->id;
     	if(is_numeric($bpcivi_ck_currgroup)) { //Check if the group is set
     		$bpcivi_ck_querytext = 'SELECT * FROM <code>wp_bpcivi_groupsync</code> WHERE <code>buddypress_group</code> =' . $bpcivi_ck_currgroup;
    		$bpcivi_ck_settinggroups = $wpdb->get_results($bpcivi_ck_querytext);
     	}
        class BPCivigroupedit extends BP_Group_Extension {
     		 function __construct() {
            	$this->name = 'Edit Chapter Info';
                $this->slug = 'bpcivi-groupedit';
                $this->nav_item_position = 2;
                $this->visibility = 'private';
                $this->enable_nav_item = false;
                $this->enable_create_step = false;
    		}
            /**
             * The content of the My Group Extension tab of the group admin
             */
    	function edit_screen() {
    	    if ( !bp_is_group_admin_screen( $this->slug ) )
    			return false;
        //Include Files
    	include_once(ABSPATH  . '/wp-blog-header.php');
    	include_once(ABSPATH  . 'wp-content/plugins/civicrm/civicrm.settings.php');
    	include_once(ABSPATH  . 'wp-content/plugins/civicrm/civicrm/CRM/Core/Config.php');
    	include_once(ABSPATH  . 'wp-content/plugins/civicrm/civicrm/civicrm.config.php');
    	$config = CRM_Core_Config::singleton();
    	global $wpdb;
    	global $bp;
    	//Current Buddypress Group
    		$bpcivi_currgroup = $bp->groups->current_group->id;
    	//Run Query on DB
    		$bpvivi_querytext = 'SELECT * FROM <code>wp_bpcivi_groupsync</code> WHERE <code>buddypress_group</code> =' . $bpcivi_currgroup;
    		$bpcivisync_settinggroups = $wpdb->get_results($bpvivi_querytext);
    	//Assign to array from first membership found - oldest set effectively
    		$bpcivi_groupsettings = get_object_vars($bpcivisync_settinggroups[0]);
    	//Form Reaction TODO
    		if (isset($_POST['groupeditsubmit'])) {
    		//Contact Update
    		$bpcivi_groupupdateparams = array('version' => 3,'page' => 'CiviCRM','q' => 'civicrm/ajax/rest','sequential' => 1,
    		'id' => $bpcivi_groupsettings['orgid'],
    		'organization_name' => $_POST['orgname'],
    		'legal_name' => $_POST['legalname'],
    		'nick_name' =>$_POST['nickname'],
    		);
    		$bpcivi_groupeditpostresult = civicrm_api('Contact', 'create', $bpcivi_groupupdateparams);
    		//Address Update 
    		$bpcivi_groupaddressupdateparams = array('version' => 3,'page' => 'CiviCRM','q' => 'civicrm/ajax/rest','sequential' => 1,
    		'id' => $_POST['addressid'],
    		'street_address' => $_POST['street1'],
    		'supplemental_address_1' => $_POST['street2'],
    		'supplemental_address_2' => $_POST['street3'],
    		'city' => $_POST['city1'],
    		'geo_code_1' => $_POST['latitude'],
    		'geo_code_2' => $_POST['longitude'],
    		'state_province_id' => $_POST['state'],
    		);
    		$bpcivi_groupaddresseditpostresult = civicrm_api('Address', 'create', $bpcivi_groupaddressupdateparams);
    		//Website Update
    		$bpcivi_groupwebupdateparams = array('version' => 3,'page' => 'CiviCRM','q' => 'civicrm/ajax/rest','sequential' => 1,
    		'id' => $_POST['webid'],
    		'url' => $_POST['website1'],
    		);
    		$bpcivi_groupwebupdateresult = civicrm_api('Website', 'create', $bpcivi_groupwebupdateparams);
    		
    		/*//Diagnostics
    		echo "Being Sent to API - Address: <pre>";
    		print_r($bpcivi_groupwebupdateresult);
    		echo "<pre>";*/
    		}
    	
    	
    	
    	//Run Query API Against Group
    		$bpcivi_groupeditparams = array('version' => 3,'page' => 'CiviCRM','q' => 'civicrm/ajax/rest','sequential' => 1,
    			'contact_id' => $bpcivi_groupsettings['orgid'],);
    		$bpcivi_groupeditresult = civicrm_api('Contact', 'get', $bpcivi_groupeditparams);
    		 //Array of assignments	
    			$bpcivi_groupedit_orgname = $bpcivi_groupeditresult['values'][0]['organization_name'];
    			$bpcivi_groupedit_legalname = $bpcivi_groupeditresult['values'][0]['legal_name'];
    			$bpcivi_groupedit_nickname = $bpcivi_groupeditresult['values'][0]['nick_name'];
    			$bpcivi_groupedit_streetaddress = $bpcivi_groupeditresult['values'][0]['street_address'];
    			$bpcivi_groupedit_supplemental_address_1 = $bpcivi_groupeditresult['values'][0]['supplemental_address_1'];
    			$bpcivi_groupedit_supplemental_address_2 = $bpcivi_groupeditresult['values'][0]['supplemental_address_2'];
    			$bpcivi_groupedit_city = $bpcivi_groupeditresult['values'][0]['city'];
    			$bpcivi_groupedit_geo_code_1 = $bpcivi_groupeditresult['values'][0]['geo_code_1'];
    			$bpcivi_groupedit_geo_code_2 = $bpcivi_groupeditresult['values'][0]['geo_code_2'];
    			$bpcivi_groupedit_state_province_id = $bpcivi_groupeditresult['values'][0]['state_province_id'];
    			$bpcivi_groupedit_country_id = $bpcivi_groupeditresult['values'][0]['country_id'];
    			
    	//Organization Website Query
    		$bpcivi_groupeditwebsiteparams = array('version' => 3,'page' => 'CiviCRM','q' => 'civicrm/ajax/rest','sequential' => 1,
    			'contact_id' => $bpcivi_groupsettings['orgid'],);
    		$bpcivi_groupeditwebsiteresult = civicrm_api('Website', 'get', $bpcivi_groupeditwebsiteparams);
    		$bpcivi_groupedit_website1 = $bpcivi_groupeditwebsiteresult['values'][0]['url'];
    	//Get the states list
    		$bpcivi_statesparams = array('version' => 3,'page' => 'CiviCRM','q' => 'civicrm/ajax/rest','name' => 'stateProvince',);
    		$bpcivi_statesresult = civicrm_api('Constant', 'get', $bpcivi_statesparams);
    		$bpcivi_statesresultarr = $bpcivi_statesresult['values'];
    		$bpcivi_statesresultarrkeyd = array_values($bpcivi_statesresultarr);
    		$bpcivi_statesresultarrkeys = array_keys($bpcivi_statesresultarr);
    	//Get the Countries list
    		$bpcivi_countriesparams = array('version' => 3,'page' => 'CiviCRM','q' => 'civicrm/ajax/rest','name' => 'country',);
    		$bpcivi_countriesresult = civicrm_api('Constant', 'get', $bpcivi_countriesparams);
    		$bpcivi_countriesresultarr = $bpcivi_countriesresult['values'];
    		$bpcivi_countriesresultarrkeyd = array_values($bpcivi_countriesresultarr);
    		$bpcivi_countriesresultarrkeys = array_keys($bpcivi_countriesresultarr);
    	//Display Form
    		echo '<div id="bpcivigroupeditform">';
    		echo '<form action="" method="post">';
    		echo '<input type="hidden" name="addressid" value="' . $bpcivi_groupeditresult['values'][0]['address_id'] . '">';
    		echo '<input type="hidden" name="webid" value="' . $bpcivi_groupeditwebsiteresult['values'][0]['id'] . '">';
    		echo '<table border=1>';
    		echo "<tr><td>" . "Organization Name" . "</td><td>" . '<input type="text" name="orgname" value="' .$bpcivi_groupedit_orgname  . '"></td><tr>';
    		echo "<tr><td>" . "Legal Name" . "</td><td>" . '<input type="text" name="legalname" value="' .$bpcivi_groupedit_legalname  . '"></td><tr>';
    		echo "<tr><td>" . "Nickname" . "</td><td>" . '<input type="text" name="nickname" value="' .$bpcivi_groupedit_nickname  . '"></td><tr>';
    		echo "<tr><td>" . "Website" . "</td><td>" . '<input type="url" name="website1" value="' .$bpcivi_groupedit_website1  . '"></td><tr>';
    		echo "<tr><td>" . "Street Address" . "</td><td>" . '<input type="text" name="street1" value="' .$bpcivi_groupedit_streetaddress  . '"></td><tr>';
    		echo "<tr><td>" . "Street Address 2" . "</td><td>" . '<input type="text" name="street2" value="' .$bpcivi_groupedit_supplemental_address_1  . '"></td><tr>';
    		echo "<tr><td>" . "Street Address 3" . "</td><td>" . '<input type="text" name="street3" value="' .$bpcivi_groupedit_supplemental_address_2  . '"></td><tr>';
    		echo "<tr><td>" . "City" . "</td><td>" . '<input type="text" name="city1" value="' .$bpcivi_groupedit_city  . '"></td><tr>';
    		echo "<tr><td>" . "Latitude" . "</td><td>" . '<input type="text" name="latitude" value="' .$bpcivi_groupedit_geo_code_1  . '"></td><tr>';
    		echo "<tr><td>" . "Longitude" . "</td><td>" . '<input type="text" name="longitude" value="' .$bpcivi_groupedit_geo_code_2  . '"></td><tr>';
    		echo "<tr><td>" . "State" . "</td><td>" . '<select name="state">';
    		for ($i=0;$i<count($bpcivi_statesresultarr);$i++) {
    			if ($bpcivi_statesresultarrkeys[$i] == $bpcivi_groupedit_state_province_id) {
    			echo '<option value="' . $bpcivi_statesresultarrkeys[$i] . '" selected>' . $bpcivi_statesresultarrkeyd[$i] . '</option>';	
    			} else {
    			echo '<option value="' . $bpcivi_statesresultarrkeys[$i] . '">' . $bpcivi_statesresultarrkeyd[$i] . '</option>';
    			}
    		}
    		echo '</select></td><tr>';
    		//value="' .$bpcivi_groupedit_state_province_id  . '"
    		echo "<tr><td>" . "Country" . "</td><td>" . '<input type="text" name="orgname" disabled value="' .$bpcivi_countriesresultarr[$bpcivi_groupedit_country_id]  . '"></td><tr>';
    		echo '<tr><td colspan="2">' . '<input id="bpedit_submit" type="submit" name="groupeditsubmit" value="Submit">' . '</td></tr>';
    		echo "</table></form>";
    		echo "</div>";
    	//Diagnostics
    	/*
    		echo "<br>Post: <pre>";
    		print_r($_POST);
    		echo "</pre>";
            echo "<br>API Call: <pre>";
    		print_r($bpcivi_groupeditwebsiteresult);
    		echo "</pre>";        
    		*/
            }
    
    }
    if(count($bpcivi_ck_settinggroups) > 0) { //Make it so that the group exension is only used for chapter
    	bp_register_group_extension( 'BPCivigroupedit' );
    }
    }
    }
    

    This code is the initial code before I started adding the nonces to see if the problem could be resolved.

    #163743
    Nanaimomen
    Participant

    Hi All

    We are having some issues with the registration page. We have customized it with a bunch of ‘required’ fields including name, city, province/state, country and also added some optional checkboxes including a Terms and Conditions Checkbox.

    However when we go to Dashboard – Users – All users and click on any profile, the only information it displays is:

    Name
    First name
    last name
    username

    and email address.

    All the other fields are non existent. Any idea how to view this information or where the information is at?

    Thanks!

    bp-help
    Participant

    @walid3
    Glad I could help but realistically that would take a huge amount of effort for the BP Dev team to integrate every country, every state, and every city in the world into BP so I don’t think they would look too seriously at something of this nature. But then again that is just my opinion.

Viewing 25 results - 1 through 25 (of 46 total)
Skip to toolbar