charliebrimm

Thanks. I have actually tracked it down to two plugins. You are correct DM has nothing to do with it.

On the custom user links page or the page that people we transferred to after logging in. I was just able to solve this by turning off the user links module in each one of the sites in our network (10) and turning back on and they showed up. Probably had something to do with the upgrade or something was cached or stuck in a previous state.

To be clear this was a link added in the admin area and does not show up. Any link I add to the page under user links does not show.

Which version are you using for wordpress? I just updated to 3.4.2 in a testing environment and it doesn’t work. It did work with 3.4.1

Turns out after several times of setting permalinks to default, hitting the blog, setting them back to the desired structure and hitting the blog again fixed the problem. I discovered this only after deleting all content, menus, cats, everything from a test import and the problem was still there.

I had reset permalinks several times without hitting the blog after to no avail.

SQL Server 2008. If I imported batches of posts with their corresponding attachments the images remained attached. The images were over 100 mb and the transfer from the previous host seemed to be the slow part and the import would time out.

Anyway I have the issue I have now so I hae to fix it. Do you have any ideas or suggestions of what might be causing this?

I will have to try that approach for the others, but it is too late for these. They way I was doing it also seemed like the only way to have the images stay attached to the posts. The blogs imported were around 100 posts with right around 1mb for the import file and would never actually complete and change the img urls in posts etc…

Anyway I still have this issue and am looking for the fix. This one query on rewrite rules fires constantly which isn’t normal and it fails every time for every blog. It is the only major repetitive error. There are others the occur occasionally and I’ll tackle those, but cannot figure this one out.

Thanks.

Just removed items by hand. Leaving the headers and everything in place I would grab about 2000 lines at a time and paste in and import taking care not to break the xml.

[Microsoft][SQL Server Native Client 10.0][SQL Server]Violation of UNIQUE KEY constraint '<strong>sh_13_options_option_name</strong>'. Cannot insert duplicate key in object 'dbo.sh_13_options'.";s:7:"message";s:176:"[Microsoft][SQL Server Native Client 10.0][SQL Server]Violation of UNIQUE KEY constraint 'sh_13_options_option_name'. Cannot insert duplicate key in object 'dbo.sh_13_options'.";}i:1;a:6:{i:0;s:5:"01000";s:8:"SQLSTATE";s:5:"01000";i:1;i:3621;s:4:"code";i:3621;i:2;s:88:"[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.";
s:7:"message";s:88:"[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.";}}

I also noticed that while importing posts there were several that had video embeds that made it into the export but were stripped when imported.

I used the import/export tool but had to break up the files because they were not importing properly. It appears after some searching a few minutes again that the N is what makes sql handle nvarchar which probably isn’t the issue at this point.

Still the blogs that were not imported are not having this particular error which is thrown every time a page loads. I reset permalinks to no avail.

I was just wondering since no matter what I do on a small import the images don’t attach to their posts, but I can at least change the img urls in the posts with this tool.

This worked! I was putting the switch in the wrong place so it was firing regardless>

function alter_the_query( $request ) {
    $new_cat_query = new WP_Query();  // the query isn't run if we don't pass any query vars
    $new_cat_query->parse_query( $request );

    // this is the actual manipulation; do whatever you need here
    if ( $new_cat_query->is_category()  ) {
		switch_to_blog(10);
	}
    return $request;
}
add_filter( 'request', 'alter_the_query' );

Thanks again for your time.

I’m trying to externalize the query to functions.php to get it to query from another blog in a multisites without using query posts because the pagination doesn’t work correctly inside category.php. The switch_to_blog makes it query another table. I am trying to display categories from another blog where posts from all blogs are stored. Without the if of is_category the query runs fine and everything works as expected but it causes other queries to fail like multisite search and login pages which are all redirected to blog 1.

Hope that explains it clearly.

Hmm still not working. Perhaps you can see what is going on.

function alter_the_query( $request ) {

	global $blog_id;

	if ($blog_id == 1 && is_category()) {
		if (is_category()) {
		switch_to_blog(10);
		} else {
		restore_current_blog();
		}
	}
    $new_cat_query = new WP_Query();
    $new_cat_query->parse_query( $request );

    return $request;
}
add_filter( 'request', 'alter_the_query' );

if I put !is_category the query fires but it breaks other pages and the query doesn’t fire as written.

I think I had it in the wrong place. On your suggestion I reapplied and it worked fine. I must’ve put it in the wrong place previously. Thanks!