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 = 'https://subdomain.localhost/about/' OR redirect_from = 'https://subdomain.localhost/about' OR redirect_from = '/about' OR redirect_from = '/about/' OR redirect_from = 'about' OR redirect_from = 'about/' OR redirect_from = 'https://subdomain.localhostabout/' OR redirect_from = 'https://subdomain.localhostbout/' OR redirect_from = 'bout/' OR redirect_from = 'about' OR redirect_from = 'bout' OR redirect_from = 'about/' OR redirect_from = 'https://subdomain.localhost/about/' OR redirect_from = 'https://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 ('https://subdomain.localhost/about/' regexp regex or 'https://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)

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

    Thread Starter Storm Rockwell

    (@stormrockwell)

    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 = 'https://localhost/' OR redirect_from = 'https://localhost' OR redirect_from = '' OR redirect_from = '/' OR redirect_from = '' OR redirect_from = '' OR redirect_from = 'https://localhost' OR redirect_from = 'https://localhost' OR redirect_from = '' OR redirect_from = '' OR redirect_from = '' OR redirect_from = '/' OR redirect_from = 'https://localhost/' OR redirect_from = 'https://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 ('https://localhost/' regexp regex or 'https://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)

    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.

    Thread Starter Storm Rockwell

    (@stormrockwell)

    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.

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

    Thread Starter Storm Rockwell

    (@stormrockwell)

    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)
  • The topic ‘Doesn’t handle migration too well’ is closed to new replies.