Home page blocks not showing - by Kishpr

This topic has 7 replies, 2 voices, and was last updated 5 years, 1 months ago ago by Rose Tyler

  • Avatar: Kishpr
    Kishpr
    Participant
    March 22, 2019 at 15:59

    I have hosted the website designed using Xstore theme in Digital Ocean. In that home page blocks are not displayed. Can you please guide me. The URL of the website is http://royaldress.com/

    6 Answers
    Avatar: Rose Tyler
    Rose Tyler
    Support staff
    March 22, 2019 at 16:10

    Hello,

    Try to disable 3rd party plugins, clear cache and check how the Home page works then.

    Regards

    Avatar: Kishpr
    Kishpr
    Participant
    March 22, 2019 at 16:16

    Hi,

    I have done that, still it is not working

    Avatar: Rose Tyler
    Rose Tyler
    Support staff
    March 22, 2019 at 16:19

    Hello,

    Enable WP debug mode https://codex.wordpress.org/WP_DEBUG to find out what error appears on your site, it will point you in the right direction what needs to be fixed.

    Regards

    Avatar: Kishpr
    Kishpr
    Participant
    March 22, 2019 at 16:40

    Hi,

    Thanks, I was able to fix using wp-debug, but this is showing me MYSQL error in category page “WordPress database error: [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 ‘) GROUP BY terms.term_id’ at line 15]
    SELECT COUNT( DISTINCT royal_posts.ID ) as term_count, terms.term_id as term_count_id FROM royal_posts INNER JOIN royal_term_relationships AS term_relationships ON royal_posts.ID = term_relationships.object_id INNER JOIN royal_term_taxonomy AS term_taxonomy USING( term_taxonomy_id ) INNER JOIN royal_terms AS terms USING( term_id ) LEFT JOIN royal_term_relationships ON (royal_posts.ID = royal_term_relationships.object_id) WHERE royal_posts.post_type IN ( ‘product’ ) AND royal_posts.post_status = ‘publish’ AND ( royal_posts.ID NOT IN ( SELECT object_id FROM royal_term_relationships WHERE term_taxonomy_id IN (7) ) AND royal_term_relationships.term_taxonomy_id IN (94) )AND terms.term_id IN () GROUP BY terms.term_id”

    Avatar: Kishpr
    Kishpr
    Participant
    March 22, 2019 at 16:41

    Also the website loads very slowly royaldress.com

    Avatar: Rose Tyler
    Rose Tyler
    Support staff
    March 22, 2019 at 16:57

    Hello,

    Did you make changes in DB?
    Was prefix of tables changed?
    Is the error there if all 3rd party plugins are disabled?
    If “Search by SKU” is enabled in Theme Options > Header > Search, try to disable it.
    Let me know results.

    Read this topic – https://www.8theme.com/topic/the-subject-is-slow/

    Please create different topics for different questions.

    Regards

  • Viewing 7 results - 1 through 7 (of 7 total)

You must be logged in to reply to this topic.Log in/Sign up

We're using our own and third-party cookies to improve your experience and our website. Keep on browsing to accept our cookie policy.