thetoolman123

Hi there,

Do you have an email address I can contact you on directly?

Thanks

Hi there,

I’m not sure and I wouldn’t know how to use it.

I’m guessing it might be a matter of going through every entry of the database to change the URL?

Apart from the database, do you know what else would cause teh styles in admin to disappear? I’m literally just changing it out of a directory into the root.

Hi,

I have now found this code:

UPDATE wp_options SET option_value = replace(option_value, 'Existing URL', 'New URL') WHERE option_name = 'home' OR option_name = 'siteurl';
UPDATE wp_posts SET post_content = replace(post_content, 'Existing URL', 'New URL');
UPDATE wp_postmeta SET meta_value = replace(meta_value,'Existing URL','New URL');
UPDATE wp_usermeta SET meta_value = replace(meta_value, 'Existing URL','New URL');
UPDATE wp_links SET link_url = replace(link_url, 'Existing URL','New URL');
UPDATE wp_comments SET comment_content = replace(comment_content , 'Existing URL','New URL');

Can someone tell me if the following will work? I’m wondering if this will update all areas in the database and also if I have the slash in the right places?

UPDATE wp_options SET option_value = replace(option_value, 'https://www.website.com/phase-2/', 'https://www.website.com/') WHERE option_name = 'home' OR option_name = 'siteurl';
UPDATE wp_posts SET post_content = replace(post_content, 'https://www.website.com/phase-2/', 'https://www.website.com/');
UPDATE wp_postmeta SET meta_value = replace(meta_value,'https://www.website.com/phase-2/','https://www.website.com/');
UPDATE wp_usermeta SET meta_value = replace(meta_value, 'https://www.website.com/phase-2/','https://www.website.com/');
UPDATE wp_links SET link_url = replace(link_url, 'https://www.website.com/phase-2/','https://www.website.com/');
UPDATE wp_comments SET comment_content = replace(comment_content , 'https://www.website.com/phase-2/','https://www.website.com/');

Thank you

Thanks for the reply.

Yes, I have the same URL and the correct URL in both but still there are no styles

Thanks, I created one using this post:
https://spidergems.com/create-shortcode-wordpress-page-title/

Hi there,

Thanks for the reply.

I have had a look and it looks like I need to use the %%excerpt%% variable in the meta description field. I have tested it by adding %%excerpt%% in the description and it adds the forum post in there.

I am not sure how I get this to happen automatically though. I guess I will need to edit my functions.php file?

I’m not using any, that’s what I’m asking for 🙂