• Resolved agendaverlag

    (@agendaverlag)


    There’s a problem with the product-categories on our site.
    For example in category “Niederlande” http://agenda.de/produktkategorie/niederlande/ there are also products that belong to the category “ebooks & Hörbücher” and “Gesellschaft & Recht” (e.g. these: http://agenda.de/produkt/juergen-huebschen-opa-werden-das-ist-schwer-opa-sein-dann-gar-nicht-mehr-2/ http://agenda.de/produkt/franz-hubert-timmermann-der-baurechtliche-nachbarschutz/ ) despite the fact that both latter categories are neither sub-categories of “Niederlande” nor are the individual products of these assigned to “Niederlande” too.

    System status:

    
    ### WordPress Environment ###
    
    Home URL: http://agenda.de
    Site URL: http://agenda.de
    WC Version: 3.3.4
    Log Directory Writable: ✔
    WP Version: 4.9.4
    WP Multisite: –
    WP Memory Limit: 256 MB
    WP Debug Mode: –
    WP Cron: ✔
    Language: de_DE
    
    ### Server Environment ###
    
    Server Info: Apache/2.4.29
    PHP Version: 5.6.31
    PHP Post Max Size: 8 MB
    PHP Time Limit: 300
    PHP Max Input Vars: 1000
    cURL Version: 7.55.1
    OpenSSL/1.0.2l
    
    SUHOSIN Installed: –
    MySQL Version: 5.6.19
    Max Upload Size: 8 MB
    Default Timezone is UTC: ✔
    fsockopen/cURL: ✔
    SoapClient: ✔
    DOMDocument: ✔
    GZip: ✔
    Multibyte String: ✔
    Remote Post: ✔
    Remote Get: ✔
    
    ### Database ###
    
    WC Database Version: 3.3.4
    WC Database Prefix: pqrst_
    Datenbank-Gesamtgröße: 57.99MB
    Datenbank-Datengröße: 54.76MB
    Datenbank-Indexgröße: 3.23MB
    pqrst_woocommerce_sessions: Daten: 51.38MB + Index: 2.02MB
    pqrst_woocommerce_api_keys: Daten: 0.00MB + Index: 0.00MB
    pqrst_woocommerce_attribute_taxonomies: Daten: 0.00MB + Index: 0.01MB
    pqrst_woocommerce_downloadable_product_permissions: Daten: 0.00MB + Index: 0.00MB
    pqrst_woocommerce_order_items: Daten: 0.03MB + Index: 0.01MB
    pqrst_woocommerce_order_itemmeta: Daten: 0.13MB + Index: 0.10MB
    pqrst_woocommerce_tax_rates: Daten: 0.00MB + Index: 0.01MB
    pqrst_woocommerce_tax_rate_locations: Daten: 0.00MB + Index: 0.00MB
    pqrst_woocommerce_shipping_zones: Daten: 0.00MB + Index: 0.00MB
    pqrst_woocommerce_shipping_zone_locations: Daten: 0.00MB + Index: 0.00MB
    pqrst_woocommerce_shipping_zone_methods: Daten: 0.00MB + Index: 0.00MB
    pqrst_woocommerce_payment_tokens: Daten: 0.00MB + Index: 0.00MB
    pqrst_woocommerce_payment_tokenmeta: Daten: 0.00MB + Index: 0.00MB
    pqrst_woocommerce_log: Daten: 0.00MB + Index: 0.00MB
    pqrst_commentmeta: Daten: 0.00MB + Index: 0.00MB
    pqrst_comments: Daten: 0.02MB + Index: 0.02MB
    pqrst_links: Daten: 0.00MB + Index: 0.00MB
    pqrst_options: Daten: 0.40MB + Index: 0.06MB
    pqrst_postmeta: Daten: 1.60MB + Index: 0.76MB
    pqrst_posts: Daten: 1.15MB + Index: 0.13MB
    pqrst_termmeta: Daten: 0.00MB + Index: 0.01MB
    pqrst_terms: Daten: 0.00MB + Index: 0.01MB
    pqrst_term_relationships: Daten: 0.02MB + Index: 0.04MB
    pqrst_term_taxonomy: Daten: 0.00MB + Index: 0.01MB
    pqrst_usermeta: Daten: 0.03MB + Index: 0.03MB
    pqrst_users: Daten: 0.00MB + Index: 0.01MB
    pqrst_wc_download_log: Daten: 0.00MB + Index: 0.00MB
    pqrst_wc_webhooks: Daten: 0.00MB + Index: 0.00MB
    
    ### Post Type Counts ###
    
    attachment: 682
    nav_menu_item: 15
    page: 18
    post: 6
    product: 347
    revision: 166
    shop_order: 124
    wpcf7_contact_form: 1
    
    ### Security ###
    
    Secure connection (HTTPS): ❌Dein Shop benutzt kein HTTPS. Erfahre mehr über HTTPS und SSL-Zertifikate.
    Hide errors from visitors: ✔
    
    ### Active Plugins (5) ###
    
    Contact Form 7: von Takayuki Miyoshi – 5.0.1
    oik Weight/Country Shipping: von bobbingwide – 1.3.4 – Nicht getestest mit der aktiven WooCommerce-Version
    UpdraftPlus - Backup/Restore: von UpdraftPlus.Com
    DavidAnderson – 1.14.4
    
    German Market: von MarketPress – 3.5.6
    WooCommerce: von Automattic – 3.3.4
    
    ### Settings ###
    
    API Enabled: ✔
    Force SSL: –
    Currency: EUR (€)
    Currency Position: right_space
    Thousand Separator: .
    Decimal Separator: ,
    Number of Decimals: 2
    Taxonomies: Product Types: external (external)
    grouped (grouped)
    simple (simple)
    variable (variable)
    
    Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)
    exclude-from-search (exclude-from-search)
    featured (featured)
    outofstock (outofstock)
    rated-1 (rated-1)
    rated-2 (rated-2)
    rated-3 (rated-3)
    rated-4 (rated-4)
    rated-5 (rated-5)
    
    ### WC Pages ###
    
    Shop-Basis: #2 - /
    Warenkorb: #30 - /warenkorb/
    Kasse: #31 - /kasse/
    Mein Konto: #32 - /mein-konto/
    Geschäftsbedingungen: #53 - /allgemeine_geschaeftsbedingungen/
    
    ### Theme ###
    
    Name: Düsseldorf Child
    Version: 1.1
    Author URL: http://marketpress.com/
    Child Theme: ✔
    Parent Theme Name: Düsseldorf
    Parent Theme Version: 1.5.3
    Parent Theme Author URL: https://marketpress.cde/
    WooCommerce Support: ✔
    
    ### Templates ###
    
    Overrides: duesseldorf/woocommerce/archive-product.php Version - ist veraltet. Die Hauptversion ist 3.3.0
    duesseldorf/woocommerce/cart/cart.php Version - ist veraltet. Die Hauptversion ist 3.3.0
    duesseldorf/woocommerce/cart/mini-cart.php Version - ist veraltet. Die Hauptversion ist 3.3.0
    duesseldorf/woocommerce/checkout/payment.php Version - ist veraltet. Die Hauptversion ist 3.3.0
    duesseldorf/woocommerce/content-product.php Version - ist veraltet. Die Hauptversion ist 3.0.0
    duesseldorf/woocommerce/content-product_cat.php Version - ist veraltet. Die Hauptversion ist 2.6.1
    duesseldorf/woocommerce/content-single-product.php Version - ist veraltet. Die Hauptversion ist 3.0.0
    duesseldorf/woocommerce/content-widget-product.php Version - ist veraltet. Die Hauptversion ist 3.3.0
    duesseldorf-child-starter/emails/customer-on-hold-order.php
    duesseldorf/woocommerce/global/sidebar.php Version - ist veraltet. Die Hauptversion ist 1.6.4
    duesseldorf/woocommerce/global/wrapper-end.php Version - ist veraltet. Die Hauptversion ist 3.3.0
    duesseldorf/woocommerce/global/wrapper-start.php Version - ist veraltet. Die Hauptversion ist 3.3.0
    duesseldorf/woocommerce/loop/add-to-cart.php Version - ist veraltet. Die Hauptversion ist 3.3.0
    duesseldorf/woocommerce/loop/loop-end.php Version - ist veraltet. Die Hauptversion ist 2.0.0
    duesseldorf/woocommerce/loop/loop-start.php Version - ist veraltet. Die Hauptversion ist 3.3.0
    duesseldorf/woocommerce/loop/pagination.php Version - ist veraltet. Die Hauptversion ist 3.3.1
    duesseldorf/woocommerce/single-product/price.php Version - ist veraltet. Die Hauptversion ist 3.0.0
    duesseldorf/woocommerce/single-product/product-image.php Version - ist veraltet. Die Hauptversion ist 3.3.2
    duesseldorf/woocommerce/single-product/product-thumbnails.php Version - ist veraltet. Die Hauptversion ist 3.3.2
    duesseldorf/woocommerce/single-product/rating.php Version - ist veraltet. Die Hauptversion ist 3.1.0
    duesseldorf/woocommerce/single-product/related.php Version - ist veraltet. Die Hauptversion ist 3.0.0
    duesseldorf/woocommerce/single-product/review.php Version - ist veraltet. Die Hauptversion ist 2.6.0
    duesseldorf/woocommerce/single-product/tabs/description.php Version - ist veraltet. Die Hauptversion ist 2.0.0
    duesseldorf/woocommerce/single-product/tabs/tabs.php Version - ist veraltet. Die Hauptversion ist 2.4.0
    duesseldorf/woocommerce/single-product/title.php Version - ist veraltet. Die Hauptversion ist 1.6.4
    duesseldorf/woocommerce/single-product-reviews.php Version - ist veraltet. Die Hauptversion ist 3.2.0
    duesseldorf/woocommerce/single-product.php Version - ist veraltet. Die Hauptversion ist 1.6.4
    
    Outdated Templates: ❌Erfahre
    wie du aktualisieren kannst
    
    

    The page I need help with: [log in to see the link]

Viewing 8 replies - 1 through 8 (of 8 total)
  • Joel Williams

    (@joelwills)

    Automattic Happiness Engineer

    Hi there!

    Usually issues like this may be caused by either a conflict with your theme or with another WordPress plugin. We address this type of problem by asking you to temporarily disable all plugins except for WooCommerce (and the extension), and switch back to a default WordPress theme like Twenty Seventeen or Storefront – http://www.woothemes.com/storefront/.

    If that resolves the issue, then slowly re-enable the theme first, and then plugins one at a time until you find the one that’s causing the conflict.

    If you don’t want to do these tests on your live site, many hosts provide a staging service – they clone your site onto a “stage” where you can do testing without affecting the live version. You can ask your host about this. If they don’t give you a staging site, we recommend using WP Staging – https://wordpress.org/plugins/wp-staging/ or Duplicator https://wordpress.org/plugins/duplicator/.

    Let us know if this works for you, thanks!

    Thread Starter agendaverlag

    (@agendaverlag)

    Hi Joel,
    we have a test site www. http://netzedit.de/agenda that should now have the same plugin versions installed as the live site (though not the same content). Interestingly the problem with the messed up categories does not appear on the test site, whereas it still appears on the live site (disabeling plugins didn’t help).
    Here’s the system status of the test site:

    
    ### WordPress Environment ###
    
    Home URL: http://netzedit.de/agenda
    Site URL: http://netzedit.de/agenda
    WC Version: 3.3.5
    Log Directory Writable: ✔
    WP Version: 4.9.5
    WP Multisite: –
    WP Memory Limit: 256 MB
    WP Debug Mode: –
    WP Cron: ✔
    Language: de_DE
    
    ### Server Environment ###
    
    Server Info: Apache/2.4.29
    PHP Version: 5.6.31
    PHP Post Max Size: 32 MB
    PHP Time Limit: 200
    PHP Max Input Vars: 1000
    cURL Version: 7.55.1
    OpenSSL/1.0.2l
    
    SUHOSIN Installed: –
    MySQL Version: 5.6.19
    Max Upload Size: 32 MB
    Default Timezone is UTC: ✔
    fsockopen/cURL: ✔
    SoapClient: ✔
    DOMDocument: ✔
    GZip: ✔
    Multibyte String: ✔
    Remote Post: ✔
    Remote Get: ✔
    
    ### Database ###
    
    WC Database Version: 3.3.5
    WC Database Prefix: pqrst_
    Datenbank-Gesamtgröße: 3.18MB
    Datenbank-Datengröße: 2.42MB
    Datenbank-Indexgröße: 0.76MB
    pqrst_woocommerce_sessions: Daten: 0.00MB + Index: 0.00MB
    pqrst_woocommerce_api_keys: Daten: 0.00MB + Index: 0.00MB
    pqrst_woocommerce_attribute_taxonomies: Daten: 0.00MB + Index: 0.01MB
    pqrst_woocommerce_downloadable_product_permissions: Daten: 0.00MB + Index: 0.00MB
    pqrst_woocommerce_order_items: Daten: 0.00MB + Index: 0.00MB
    pqrst_woocommerce_order_itemmeta: Daten: 0.01MB + Index: 0.01MB
    pqrst_woocommerce_tax_rates: Daten: 0.00MB + Index: 0.01MB
    pqrst_woocommerce_tax_rate_locations: Daten: 0.00MB + Index: 0.00MB
    pqrst_woocommerce_shipping_zones: Daten: 0.00MB + Index: 0.00MB
    pqrst_woocommerce_shipping_zone_locations: Daten: 0.00MB + Index: 0.01MB
    pqrst_woocommerce_shipping_zone_methods: Daten: 0.00MB + Index: 0.00MB
    pqrst_woocommerce_payment_tokens: Daten: 0.00MB + Index: 0.00MB
    pqrst_woocommerce_payment_tokenmeta: Daten: 0.00MB + Index: 0.00MB
    pqrst_woocommerce_log: Daten: 0.00MB + Index: 0.00MB
    pqrst_commentmeta: Daten: 0.00MB + Index: 0.00MB
    pqrst_comments: Daten: 0.00MB + Index: 0.01MB
    pqrst_links: Daten: 0.00MB + Index: 0.00MB
    pqrst_options: Daten: 0.23MB + Index: 0.04MB
    pqrst_postmeta: Daten: 1.17MB + Index: 0.49MB
    pqrst_posts: Daten: 0.98MB + Index: 0.10MB
    pqrst_termmeta: Daten: 0.00MB + Index: 0.01MB
    pqrst_terms: Daten: 0.00MB + Index: 0.01MB
    pqrst_term_relationships: Daten: 0.02MB + Index: 0.03MB
    pqrst_term_taxonomy: Daten: 0.00MB + Index: 0.01MB
    pqrst_usermeta: Daten: 0.01MB + Index: 0.01MB
    pqrst_users: Daten: 0.00MB + Index: 0.01MB
    pqrst_wc_download_log: Daten: 0.00MB + Index: 0.00MB
    pqrst_wc_webhooks: Daten: 0.00MB + Index: 0.00MB
    pqrst_woocommerce_termmeta: Daten: 0.00MB + Index: 0.00MB
    
    ### Post Type Counts ###
    
    attachment: 594
    nav_menu_item: 15
    page: 18
    post: 4
    product: 312
    revision: 119
    shop_order: 3
    wpcf7_contact_form: 1
    
    ### Security ###
    
    Secure connection (HTTPS): ❌Dein Shop benutzt kein HTTPS. Erfahre mehr über HTTPS und SSL-Zertifikate.
    Hide errors from visitors: ✔
    
    ### Active Plugins (5) ###
    
    Contact Form 7: von Takayuki Miyoshi – 5.0.1
    oik Weight/Country Shipping: von bobbingwide – 1.3.4 – Nicht getestest mit der aktiven WooCommerce-Version
    UpdraftPlus - Backup/Restore: von UpdraftPlus.Com
    DavidAnderson – 1.14.5
    
    German Market: von MarketPress – 3.5.8
    WooCommerce: von Automattic – 3.3.5
    
    ### Settings ###
    
    API Enabled: ✔
    Force SSL: –
    Currency: EUR (€)
    Currency Position: right_space
    Thousand Separator: .
    Decimal Separator: ,
    Number of Decimals: 2
    Taxonomies: Product Types: external (external)
    grouped (grouped)
    simple (simple)
    variable (variable)
    
    Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)
    exclude-from-search (exclude-from-search)
    featured (featured)
    outofstock (outofstock)
    rated-1 (rated-1)
    rated-2 (rated-2)
    rated-3 (rated-3)
    rated-4 (rated-4)
    rated-5 (rated-5)
    
    ### WC Pages ###
    
    Shop-Basis: #2 - /
    Warenkorb: #30 - /warenkorb/
    Kasse: #31 - /kasse/
    Mein Konto: #32 - /mein-konto/
    Geschäftsbedingungen: #53 - /allgemeine_geschaeftsbedingungen/
    
    ### Theme ###
    
    Name: Düsseldorf Child
    Version: 1.1
    Author URL: http://marketpress.com/
    Child Theme: ✔
    Parent Theme Name: Düsseldorf
    Parent Theme Version: 1.5.2
    Parent Theme Author URL: http://marketpress.com/
    WooCommerce Support: ✔
    
    ### Templates ###
    
    Overrides: duesseldorf/woocommerce/archive-product.php Version - ist veraltet. Die Hauptversion ist 3.3.0
    duesseldorf/woocommerce/cart/cart.php Version - ist veraltet. Die Hauptversion ist 3.3.0
    duesseldorf/woocommerce/cart/mini-cart.php Version - ist veraltet. Die Hauptversion ist 3.3.0
    duesseldorf/woocommerce/checkout/payment.php Version - ist veraltet. Die Hauptversion ist 3.3.0
    duesseldorf/woocommerce/content-product.php Version - ist veraltet. Die Hauptversion ist 3.0.0
    duesseldorf/woocommerce/content-product_cat.php Version - ist veraltet. Die Hauptversion ist 2.6.1
    duesseldorf/woocommerce/content-single-product.php Version - ist veraltet. Die Hauptversion ist 3.0.0
    duesseldorf/woocommerce/content-widget-product.php Version - ist veraltet. Die Hauptversion ist 3.3.0
    duesseldorf-child-starter/woocommerce/emails/customer-on-hold-order.php
    duesseldorf/woocommerce/global/sidebar.php Version - ist veraltet. Die Hauptversion ist 1.6.4
    duesseldorf/woocommerce/global/wrapper-end.php Version - ist veraltet. Die Hauptversion ist 3.3.0
    duesseldorf/woocommerce/global/wrapper-start.php Version - ist veraltet. Die Hauptversion ist 3.3.0
    duesseldorf/woocommerce/loop/add-to-cart.php Version - ist veraltet. Die Hauptversion ist 3.3.0
    duesseldorf/woocommerce/loop/loop-end.php Version - ist veraltet. Die Hauptversion ist 2.0.0
    duesseldorf/woocommerce/loop/loop-start.php Version - ist veraltet. Die Hauptversion ist 3.3.0
    duesseldorf/woocommerce/loop/pagination.php Version - ist veraltet. Die Hauptversion ist 3.3.1
    duesseldorf-child-starter/product-searchform.php Version 2.5.0 ist veraltet. Die Hauptversion ist 3.3.0
    duesseldorf/woocommerce/single-product/price.php Version - ist veraltet. Die Hauptversion ist 3.0.0
    duesseldorf/woocommerce/single-product/product-image.php Version - ist veraltet. Die Hauptversion ist 3.3.2
    duesseldorf/woocommerce/single-product/product-thumbnails.php Version - ist veraltet. Die Hauptversion ist 3.3.2
    duesseldorf/woocommerce/single-product/rating.php Version - ist veraltet. Die Hauptversion ist 3.1.0
    duesseldorf/woocommerce/single-product/related.php Version - ist veraltet. Die Hauptversion ist 3.0.0
    duesseldorf/woocommerce/single-product/review.php Version - ist veraltet. Die Hauptversion ist 2.6.0
    duesseldorf/woocommerce/single-product/tabs/description.php Version - ist veraltet. Die Hauptversion ist 2.0.0
    duesseldorf/woocommerce/single-product/tabs/tabs.php Version - ist veraltet. Die Hauptversion ist 2.4.0
    duesseldorf/woocommerce/single-product/title.php Version - ist veraltet. Die Hauptversion ist 1.6.4
    duesseldorf/woocommerce/single-product-reviews.php Version - ist veraltet. Die Hauptversion ist 3.2.0
    duesseldorf/woocommerce/single-product.php Version - ist veraltet. Die Hauptversion ist 1.6.4
    
    Outdated Templates: ❌Erfahre
    wie du aktualisieren kannst
    
    
    Plugin Support stephjacq a11n

    (@stephjacq)

    Automattic Happiness Engineer

    Hi there,

    You mentioned that the test site has the same plugins and it’s working there but not on the live site. Therefore there must be some differences between them. Did you create the test site so it is a copy of the live site? You mentioned that the products are different too, this could also have an impact. Other things to look for are ‘must use’ or ‘drop in’ plugins installed by your host, or security or optimization plugins on the live server.

    Once you’ve identified the difference and have the test site as a mirror of the live site, you should be able to identify the problem more easily.

    Hope this helps!

    Thread Starter agendaverlag

    (@agendaverlag)

    Hi Joel,
    you are right, there are some differences between this 2 sites.

    Meanwhile we tried another Theme (2016) and to disable all plugins without WooCommerce. The problem with categories remained unchanged.
    Also in the backend of WordPress, products are displayed in wrong categories.
    Screenshot: http://agenda.de/screen-1.png
    The problem appears only in main categories having subcategories.
    Products in sub-categories and in categories without sub-categories are o.k.
    Do you have any idea?
    Thank you.

    Joel Williams

    (@joelwills)

    Automattic Happiness Engineer

    Honestly I’m not sure if it is all working on the test site, something has affected the categories on the live site, perhaps a previously installed plugin or script.

    Can you manually fix them?

    Thread Starter agendaverlag

    (@agendaverlag)

    We have to fix them in which table? _terms, _termmeta, _term_taxonomy?

    Joel Williams

    (@joelwills)

    Automattic Happiness Engineer

    You can fix them in the wp-admin dashboard can’t you? Or is the problem deeper than that? If so, then yes you’d need to investigate the database tables and compare them to your working site to see what they need to be altered to.

    Thread Starter agendaverlag

    (@agendaverlag)

    No, it is deeper. As you can see on this screenshot
    http://agenda.de/screen-1.png
    for example the 1st produkt is associated to categories “Neuerscheinungen” and “e-books & Hörbücher”. This is right. But it appears when you choose category “Niederlande”. And on this screenshot are several other products like this. (Frontend shows the same behaviour)

    So the problem seems not, that categories and products have changed to wrong categories, but some (main-)categories show several products that do not belong to them.

    So to fix manually, in which database-table(s) can we fix this error?
    (Our working site is older – on the live-site are about 50 new products and other data like orders etc.)

Viewing 8 replies - 1 through 8 (of 8 total)

The topic ‘Product Categories messed up’ is closed to new replies.