stipto

Ipstenu, my favorite support guru! ??

Indeed, the blog/ prefix sucks.
I understand your point about sitewide plugins and SEO, but why does it only list a few of my posts to the global posts blog and not all?

I think I’ll go with the duplicate post option, copy all posts to the global posts blog and then delete all posts from the main blog. With a plugin called Diamnond Recent Posts I can still show a summary of all posts on my main site, while the actual posts reside in my global posts blog.

So then I would get:
Main site > no posts but mimicking the posts loop with Diamond Recent Posts plugin
News (posts) site > global posts blog wich lists all posts and has a database of posts of it’s own. This will be a subdirectory of the main site. So mainsite.com/news/
Sub-site 1 > Has it’s own posts but also broadcasts to News (posts) site via the Global posts plugin
Sub-site 2 > the same.

Hope this works out! First… a backup ??
And thanks Ipstenu, you’re a real life saver in these forums. Keep on helping people, you might become the next Buddha.

You’re totally right! Thanks!! I’m able to do everything I need now.

+1 for you.

Do you mean that I didn’t fill in the string? The actual queries I’m trying are like this:

update wp_posts set post_name = replace(post_name, ‘:’, ‘-‘);

Or

update wp_posts set post_name = replace(post_name, ‘?’, ‘-‘);

Now I don’t know what ‘smart’ quotes mean.
Hey and thanks for helping me this much, really appreciate it!! ??

I have solved it. In the path where you specify the place your .htaccess resides, you have to include the text .htaccess at the end. Then try to change permissions on your htaccess file untill it works.

And I got it to work!
Turns out when specifying the path where your .htaccess resides, you have to include the text “.htaccess” at the end.

Hope this helps someone out!

Hey Ipstenu,

Thanks for your help. I couldn’t fix it yet though.. I know the basic SQL query but the special characters give errors. This is what I got thusfar:

update wp_posts set post_name = replace(post_name, ‘find this string’, ‘replace found string with this string’);

As I found out, the slug is in the post_name field in wp_posts.
The only thing I need to know is how insert those special characters into the ‘find this string’ part. If I insert a ‘ then it gives me this error: #1064 – 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 ”a€?, a€?-a€?)’ at line 1

Hey,

Have you solved this one? Having the exact same issue.

Thanks.

Found out part of the answer! You can select the Apache module, wich will write to your .htaccess file. This is, as far as I know, the best method for Search Engines.

Didn’t get it to work yet, maybe a problem with permissions…

Hello Chris,

Did you solve this one? I need to do some serious redirects too. I’m looking into using this plugin: https://www.ads-software.com/extend/plugins/redirection/

But this needs to use 301 redirects the same way .htaccess can do, for Search Engine friendlyness and Pagerank. I don’t know yet if it can do this.

So if you found a solution for your issue let me know.

Hi Anrkist,

You say “not very friendly to search engine”. Do you happen to know if the Redirect Plugin is? I’m thinking about using it for 301 redirects for a transfer from old to new site but if it just uses meta refresh it’s bad. I have to keep the PageRank of the old links alive.

Would be great if you knew this!
Cheers and @bookworm316: sorry for hijacking your thread, but I think this might also be useful to you.

I’m still in the middle of the process and like to keep the site private while developing. What do you want to know exactly?
As I said, I have succesfully imported all posts from Drupal to WP.
The categories didn’t come along ok, so I’m in the process of re-assigning posts to categories.

You have to understand these basic principles before you migrate:
– Drupal and WP both use a MySQL database.
– They use the same kind of principles like a post, category, permalink, etc.
– The trick is to import all data from Drupal’s database into an empty WP database and then say: This belongs here and this here etc.

This can be done with the method described here

So the steps to follow:
– Use PHPMyadmin for database managment (it’s the best)
– In this program, follow the steps from the above link
– Check out what has gone wrong and ask me, maybe I can help

Good luck!

Ha! That’s only a last-resort-solution with over 5.000 posts.

It also happens with characters like ! and ‘ so not only the /
And this problem only occurs on my imported articles. When I create a new one, it generates a good slug.

So maybe I can perform a query in SQL that finds all url’s that have these reserved characters and replaces them by valid things? Only I wouldn’t know how to write this.

Hello, seeing as you don’t have an answer yet you may have solved this already or are still waiting. I’m working on a similar project now and I can share with you what I have done thusfar.

Firstly: There are no easy plugins for this, you’ll have to do it manually. Both Drupal and WP use a MySQL database. The trick is to install a fresh WP site and import Drupal’s MySQL into that of WP.
Then you need to add all the post info, URL info, etc. into the corresponding tables in the WP database. I used this article for that.

Now I am stuck with a problem keeping the old URL’s working, but I don’t know if that applies to your situation.

If, after following the instructions on the above website, you have all these posts with wrong or no categories, I’d recommend these plugins: Assign missing categories and Batch assign categories

Hope this helps! (And hope someone can help me)

I forgot one important part: The new website will have the same base adress as the old one. It’s just the CMS that changes…
So that changes problem #1 a bit I guess.