zedomax

Another note,

Maximize your php.ini server settings for script execution time:

max_execution_time = 90
max_input_time = 95
memory_limit = 128M

I had it like this which kept freezing the screen:

max_execution_time = 10
max_input_time = 35
memory_limit = 128M

You can temporarily change the values higher like above during tag import then change it back to your favorite value later.

Damn you WordPress developers!

I had to hack your utw.php to import my tags!!!

Well, here’s my hack:
I changed it around so it limites the number of tags you can import at a time and also only fetch 100 tags per MySql Query:

(Basically replace the tag2post() function with this one)

(Since the WordPress keeps breaking or freezing on me,
you can change the startvalue and endvalue to do them in small ranges…)

function tag2post ( ) {

// get the tags and posts we imported in the last 2 steps
$tags = get_option('utwimp_tags');
$posts = get_option('utwimp_posts');

global $wpdb;
$startvalue=0;
$endvalue=5000;
$ct=$startvalue;

while($ct<$endvalue) {

$posts_query = "SELECT tag_id, post_id FROM " . $wpdb->prefix . "post2tag"." LIMIT ".$ct.",100";
$posts = $wpdb->get_results($posts_query);

if($posts) {
// null out our results
$tags_added = 0;

// loop through each post and add its tags to the db
foreach ( $posts as $this_post ) {

$the_post = (int) $this_post->post_id;
$the_tag = (int) $this_post->tag_id;

// what's the tag name for that id?
$the_tag = $tags[$the_tag];

// screw it, just try to add the tag
wp_add_post_tags($the_post, $the_tag);
$tags_added++;
echo "Num: ".$tags_added." - ".$the_tag."";

}

}
echo "HACKED by Max Lee from http://zedomax.com yey!";
$ct=$ct+100;
}

// that's it, all posts should be linked to their tags properly, pending any errors we just spit out!
return $tags_added;

}

for others having the “0 tags were added!” problem,
try adding this line to your /etc/my.cnf

set-variable = max_allowed_packet=1024M

Then restart the mysqld server:

/sbin/service mysqld restart

I downgraded to 2.3.1 RC and now I get an extra error message that might help:

WordPress database error: [Got a packet bigger than ‘max_allowed_packet’ bytes]

I do have about 2 years worth of tags…

I’ve also tried changing my.cnf file for max_allowed_packet to 1024M, but still same error….