Support » Plugin: SEO Redirection Plugin » Doesn’t handle migration too well

  • I’ve replaced the actual folder name with “somefoldername” and the domain for security reasons.

    Made a local environment and I get hit with these errors. I’ve updated the plugin

    WordPress database error: [File './somefoldername/wp_WP_SEO_Cache.MYD' not found (Errcode: 2 - No such file or directory)]
    select * from wp_WP_SEO_Cache where ID='121';
    
    WordPress database error: [File './somefoldername/wp_WP_SEO_Redirection.MYD' not found (Errcode: 2 - No such file or directory)]
    select * from wp_WP_SEO_Redirection where enabled=1 and regex='' and ( redirect_from = 'http://subdomain.localhost/about/' OR redirect_from = 'http://subdomain.localhost/about' OR redirect_from = '/about' OR redirect_from = '/about/' OR redirect_from = 'about' OR redirect_from = 'about/' OR redirect_from = 'http://subdomain.localhostabout/' OR redirect_from = 'http://subdomain.localhostbout/' OR redirect_from = 'bout/' OR redirect_from = 'about' OR redirect_from = 'bout' OR redirect_from = 'about/' OR redirect_from = 'http://subdomain.localhost/about/' OR redirect_from = 'http://subdomain.localhost/about' )
    
    WordPress database error: [File './somefoldername/wp_WP_SEO_Redirection.MYD' not found (Errcode: 2 - No such file or directory)]
    select * from wp_WP_SEO_Redirection where enabled=1 and regex<>'' and ('http://subdomain.localhost/about/' regexp regex or 'http://subdomain.localhost/about' regexp regex ) order by LENGTH(regex) desc
    
    WordPress database error: [File './somefoldername/wp_WP_SEO_Cache.MYD' not found (Errcode: 2 - No such file or directory)]
    insert IGNORE into wp_WP_SEO_Cache(ID,is_redirected,redirect_from,redirect_to,redirect_type) values(121,0,'','',0);
Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Author Fakhri Alsadi

    (@fakhris)

    hello,
    thank you for using our plugin,
    what is the plugin version? and could you please deactivate the plugin and activate is again?

    Version 4.16

    Went away eventually. Disable/enable doesn’t seem to immediately solve the issue.

    Occurred on another clients site when I transferred it to a local environment

    WordPress database error: [File './client/wp_WP_SEO_Cache.MYD' not found (Errcode: 2 - No such file or directory)]
    select * from wp_WP_SEO_Cache where ID='8';
    
    WordPress database error: [File './client/wp_WP_SEO_Redirection.MYD' not found (Errcode: 2 - No such file or directory)]
    select * from wp_WP_SEO_Redirection where enabled=1 and regex='' and ( redirect_from = 'http://localhost/' OR redirect_from = 'http://localhost' OR redirect_from = '' OR redirect_from = '/' OR redirect_from = '' OR redirect_from = '' OR redirect_from = 'http://localhost' OR redirect_from = 'http://localhost' OR redirect_from = '' OR redirect_from = '' OR redirect_from = '' OR redirect_from = '/' OR redirect_from = 'http://localhost/' OR redirect_from = 'http://localhost' )
    
    WordPress database error: [File './client/wp_WP_SEO_Redirection.MYD' not found (Errcode: 2 - No such file or directory)]
    select * from wp_WP_SEO_Redirection where enabled=1 and regex<>'' and ('http://localhost/' regexp regex or 'http://localhost' regexp regex ) order by LENGTH(regex) desc
    
    WordPress database error: [File './client/wp_WP_SEO_Cache.MYD' not found (Errcode: 2 - No such file or directory)]
    insert IGNORE into wp_WP_SEO_Cache(ID,is_redirected,redirect_from,redirect_to,redirect_type) values(8,0,'','',0);

    My process of migrating is pretty standard.

    Use wp-cli to export the database
    Transfer files with git
    wp-cli search-replace the db (url replacement)

    Plugin Author Fakhri Alsadi

    (@fakhris)

    hello,
    MySQL .MYD files are data files which contain the actual data. From the looks if it, the file has been deleted. I’d advise you contact your host to see if they’ve moved anything about.

    If you’ve got a recent backup then you’re in luck. Restore the backup and the issue will be fixed.

    This isn’t an issue with my host, this is an issue with migrating code bases.

    If the table fails to exist there should be checks in place to prevent this issue.

    Plugin Author Fakhri Alsadi

    (@fakhris)

    yes,
    as i understand, the issue is not related to our plugin, Am i right?

    From my experience normally plugins have checks to ensure issues like this don’t occur. If you feel it’s not needed that’s your call and totally fine. I just won’t be able to use this plugin for future projects.

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