Support » Plugin: WordPress Popular Posts » Problems after domain name change

Viewing 11 replies - 1 through 11 (of 11 total)
  • Plugin Author Héctor Cabrera

    (@hcabrera)

    Hi @johngranovski,

    Not sure how I can help here as this is a WordPress issue, not something caused by the plugin. From my own experience it seems the migration to the new domain wasn’t done correctly though, you need to check that the URLs were correctly updated in the database and everywhere else as well (eg. wp-config.php if you changed the domain name via PHP constants).

    Plugin Author Héctor Cabrera

    (@hcabrera)

    For migration I used this script: (…)

    I’m sorry but a script that requires you to submit your personal data to an unknown person/company so you can download it seems a bit sketchy to me so I’ll pass.

    The problem arises only with WordPress Popular Posts.

    No idea to be honest. I can’t replicate the problem and the fact that you seem to be the only one experiencing this issue (so far at least) makes me believe that this is still a WordPress problem.

    I am available for freelance work if you need a developer to look into this issue for you. If you’re interested, get in touch with me.

    What is a script for change the domain name, you can recommend?

    Plugin Author Héctor Cabrera

    (@hcabrera)

    Most of the times I just log in into phpMyAdmin (or whichever database management tool I have available at the moment) and run these four queries:

    UPDATE wp_options SET option_value = replace(option_value, 'http://www.old-domain.com', 'http://www.new-domain.com') WHERE option_name = 'home' OR option_name = 'siteurl';
    
    UPDATE wp_posts SET guid = replace(guid, 'http://www.old-domain.com', 'http://www.new-domain.com');
    
    UPDATE wp_posts SET post_content = replace(post_content, 'http://www.old-domain.com', 'http://www.new-domain.com');
    
    UPDATE wp_postmeta SET meta_value = replace(meta_value, 'http://www.old-domain.com', 'http://www.new-domain.com');

    You need to change:

    1. The database prefix wp_ into the one your site uses.
    2. http://www.old-domain.com into the old domain name.
    3. http://www.new-domain.com into the new domain name.

    And that’s it.

    Of course in your case it might not be that simple. I don’t know how that script you used works or if it broke anything on your new domain’s database or not so I’d start over and run these queries on an untouched dump of your old domain’s database, then import that dump into the new domain’s database and see if that fixes the problem.

    • This reply was modified 2 months, 2 weeks ago by Héctor Cabrera. Reason: Improved wording for clarity
    Plugin Author Héctor Cabrera

    (@hcabrera)

    It seems the reply I left yesterday got caught in the moderation queue…

    Anyways, what I usually do is run some specific queries via phpMyAdmin (or whichever database management tools I have at hand) and that generally takes care of everything for me. Just now I ran into this SQL queries generator which does some extra queries I wasn’t aware of so you might want to give it a shot.

    Note that in your case since I have no idea what that script you ran did to your database it might be a good idea to start from scratch and download/get a SQL dump from the old domain’s database, run these queries on that dump, and then import it into the new domain’s database and see whether that fixes the problem or not.

    I looked at the logs, domain name change has not caused the problem. The problem started after the plugin updated to the 5.0.0 version. Version 4.2.2 works well.

    On my VPS I am using Vesta Control Panel (VestaCP) and i have many WP sites with WordPress Popular Posts plugin. Only one site does not have this problem.

    If I will delete all files of 5.0.0 version and upload files of 4.2.2 version, will everything work without bugs?

    Plugin Author Héctor Cabrera

    (@hcabrera)

    If I will delete all files of 5.0.0 version and upload files of 4.2.2 version, will everything work without bugs?

    It should be fine. However, don’t expect any support from me if you decide on using an older version of the plugin.

    Looks like I found the cause. It is XCache 3.2.0 on my VPS.
    When the site is accessed for the first time, xCache caches the URL, after that on other sites on the VPS we get incorrect URLs.

    Will it be fixed in future versions of the plugin?

    Plugin Author Héctor Cabrera

    (@hcabrera)

    Nothing to fix on WPP’s end my friend because -as you said yourself- the problem was being caused by xCache and not by the plugin itself. Clearing xCache’s cache should fix the problem (and I even mention this every time I push a new version of the plugin).

    Thanks for letting me know though. I’m sure other users using xCache and this plugin will appreciate it!

    Looks like installing Zend OPcache instead XCache solves the problem.

    Thank you very much for the great plugin and excellent and quick support.)

    Regards.

Viewing 11 replies - 1 through 11 (of 11 total)
  • You must be logged in to reply to this topic.