Prime 357

We'll learn something

Site Menu

  • Home
  • Recent Posts
  • Forum
    • Programming Languages
      • C++
    • Website Design & Content Management
      • Wordpress >> Drupal
  • Blogs
  • Topics
    • C++
    • Changing hosts - Dummies Guide
    • Wordpress >> Drupal
  • Download Centre
  • Contact us
Home Forums Website Design & Content Management Systems Wordpress to Drupal


Image - OpenID

User login

What is OpenID?
  • Log in using OpenID
  • Cancel OpenID login
  • Create new account
  • Request new password

Navigation

  • Recent posts

Topics

  • C++ (The Book)
  • Changing Hosts - a Dummies Guide
  • Wordpress to Drupal

Recent comments

  • Got it solved This page here
    3 hours 17 min ago
  • Links working
    1 day 3 hours ago
  • Thanks... I may be able to
    1 day 8 hours ago
  • 3306 by default
    1 day 19 hours ago
  • Is this the right place to
    1 day 19 hours ago
  • Figured
    3 weeks 6 days ago
  • I'm guessing at this stage
    3 weeks 6 days ago
  • WordPress MU?
    4 weeks 3 hours ago
  • Thanks
    10 weeks 1 day ago
  • I'm running the conversion
    11 weeks 5 days ago

New forum topics

  • What should the port number be
  • WordPress MU?
  • funny little bug in mac version
  • Error: Unable to Insert into Node_revisions table when converting from wordpress 2.6.0 to drupal 6.4
  • index.php?
more

Who's online

There are currently 1 user and 0 guests online.

Online users

  • Steve

Who's new

  • oODeathStormOo
  • leruffiant
  • Emtee
  • mnogodet
  • ZioMimmo

[Solved] WordPress 2.3.1 conversion bombed

  • View
  • Revisions
24 replies
Sat, 10 May, 2008 - 20:07
DeeZone
Joined: 10 May 2008
User offline. Last seen 23 weeks 4 days ago.

Just for the record, attempting to convert WordPress 2.3.1 bombed using the OSX version the converter with the error:

dbTargetError - BuildTermData() function.

etc...

Connecting to the databases appeared to work but the actual conversion process failed.

I'm now proceeding to update the WordPress site to 2.5, will check back later.

Top
  • 407 reads
Sat, 10 May, 2008 - 21:15
#1
Steve
Joined: 27 Mar 2008
User is online
Thanks, please let me know.

Thanks, please let me know. I'm unable to test anything relating to the Mac. I'll update the page relating to the fact that Wordpress 2.3 is a problem re - converting.

Steve
My running website

Top
Sun, 11 May, 2008 - 20:11
#2
DeeZone
Joined: 10 May 2008
User offline. Last seen 23 weeks 4 days ago.
Bomb on WP2.5 conversion

I have a WordPress 2.5 site which I'm trying to import in to a Drupal 5.7 site. Both are on my OSX 10.4 system running as "localhost". When I run your import application it reports that it's able to connect to both databases for each of the sites. Once I attempt to do the import the following error is reported:

dbTarget.Error - BuildTermData() function.

... six times then

dbTargetError: Function ProcessCategoryHierachy
Message is: Duplicate entry '111-0' for key 1

dbTargetError: Function ProcessCategoryHierachy
Message is: Duplicate entry '127-117' for key 1

dbTargetError: Function ProcessCategoryHierachy
Message is: Duplicate entry '156-0' for key 1

dbTargetError: Function ProcessCategoryHierachy
Message is: Duplicate entry '182-0' for key 1

dbTargetError: Function ProcessCategoryHierachy
Message is: Duplicate entry '216-0' for key 1

and then proceeds to report that the import is done:

Categories: 113
Users: 2
Pages: 1
Posts: 365

NOTE: The numbers reported are wrong, it should be:

91 posts, 60 pages, 50 drafts, contained within 23 categories and 90 tags.

Top
Sun, 11 May, 2008 - 20:20
#3
Steve
Joined: 27 Mar 2008
User is online
Okay, any chance you can

Okay, any chance you can upload your Wordpress 2.5 back-up sql file. There's obviously something contained within the category system that the converter is not correctly accounting for.

I should be able to figure it out as I'm familiar with the error when last debugging but I could only debug against a smaller dataset.

For what it's worth, it's also given me heart in that at least the Mac version is working.

Steve
My running website

Top
Sun, 11 May, 2008 - 21:00
#4
DeeZone
Joined: 10 May 2008
User offline. Last seen 23 weeks 4 days ago.
WordPress db backup

I have the WordPress2.5 db backup file ready, where can I upload the file or perhaps suggets an email address.

Top
Sun, 11 May, 2008 - 21:03
#5
Steve
Joined: 27 Mar 2008
User is online
I sent an email via your

I sent you an email, via your contact form, with details.

Steve
My running website

Top
Sun, 11 May, 2008 - 21:10
#6
DeeZone
Joined: 10 May 2008
User offline. Last seen 23 weeks 4 days ago.
db Backup

db backup file sent via email. Please let me know if it works for you.

Top
Tue, 13 May, 2008 - 02:07
#7
Steve
Joined: 27 Mar 2008
User is online
Version 1.02 uploaded

I've fixed the problem and the new version can be downloaded from here.

Steve
My running website

Top
Tue, 13 May, 2008 - 02:11
#8
Steve
Joined: 27 Mar 2008
User is online
With the new version, 1.02,

With the new version, 1.02, any chance you could attempt to convert your Wordpress 2.3 file. I've got a feeling the problem relating to 2.3 was in fact the same problem that I've just addressed and fixed.

Steve
My running website

Top
Tue, 13 May, 2008 - 03:40
#9
DeeZone
Joined: 10 May 2008
User offline. Last seen 23 weeks 4 days ago.
No problem...

Sure, no problem... so WP2.3 to D5.7?

Top
Tue, 13 May, 2008 - 11:02
#10
Steve
Joined: 27 Mar 2008
User is online
Yes, if you can, no hurry

Yes, if you can, no hurry though.

Steve
My running website

Top
Sun, 18 May, 2008 - 19:48
#11
DeeZone
Joined: 10 May 2008
User offline. Last seen 23 weeks 4 days ago.
Still buggered...

I ran an import of WordPress 2.51

91 posts, 60 pages, 50 drafts, contained within 23 categories and 90 tags.

to Drupal 5.7 which produced:

113 categories, 2 users, 1 page, 365 posts.

is your application dealing with categories vs tags and does it also deal with posts that have not been published aka drafts?

Top
Sun, 18 May, 2008 - 20:02
#12
Steve
Joined: 27 Mar 2008
User is online
Drafts imported as unpublished

They are the same figures I got when testing your database.

The page number merely indicates how many times records were retrieved from the database in one hit. That is, if you left the default settings in place, the converter retrieves 200 records (posts) at one time. If there are more than 200 posts then the converter retrieves another 200 records (posts) and so on until all records (posts) are retrieved. The page number merely indicates how many times the converter went back to the database to retrieve records and has nothing to do with 'page' or 'post' entries.

Tags and Categories are the same thing. Wordpress separates them from a user's point of view. In Drupal, all your tags were imported into a separate vocabulary which you can rename to 'Tags' if you wish. Further, for that particular vocabulary, you'll be able to further edit the settings to make it a free-form tagging system (type the tags as you create/edit posts) the same way you were able to do with Wordpress.

The other categories are imported into another vocabulary, which you can further edit as per above.

Yes, your drafts were imported as well. If you check your Admin / Content Management / Content you will see that all your drafts are tagged or marked as unpublished.

Steve
My running website

Top
Sun, 18 May, 2008 - 20:39
#13
DeeZone
Joined: 10 May 2008
User offline. Last seen 23 weeks 4 days ago.
Thanks but...

Thanks for the explanation... you might want to change how the application reports the results as it's misleading.

Currently ALL transferred content was created as a blog entry thus there are NO page entries.

Confirmed that category and tag entries transferred as you described and published vs unpublished also appears to be correct.

Top
Sun, 18 May, 2008 - 21:11
#14
Steve
Joined: 27 Mar 2008
User is online
Blog, Page or Stroy

Yes, I agree with the misleading bit and will have to think of a new term for that activity (retrieving records from the db).

At the importing screen you could have selected 'page' as opposed to 'blog' and all posts would have been imported as 'page' entries or 'story' entries if story selected.

Steve
My running website

Top
Sun, 18 May, 2008 - 21:27
#15
DeeZone
Joined: 10 May 2008
User offline. Last seen 23 weeks 4 days ago.
Page vs Blog etc

Unfortunately with 50 pages and 200+ blog entries it's really not ideal to choose one or the other. Is it difficult for the transfer to respect the WordPress content type?

For what it's worth, I'm also seeing errors at the top of the page when I post me responce:

   * warning: strtr() [function.strtr]: The second argument is
not an array in home/yhostcom/public_html/cms/drupal-6.2/ modules/syslog/syslog.module on line 108.
    * warning: syslog() expects parameter 1 to be long, string
given in /home/yhostcom/public_html/cms/drupal-6.2/
modules/syslog/syslog.module on line 81.

Don't you just love me, an endless supply of bugs :)

Top
Sun, 18 May, 2008 - 22:42
#16
Steve
Joined: 27 Mar 2008
User is online
Drupal bugs - I'm aware of

Those annoying comment error messages are p..... me off as well. I've raised this issue over at drupal.org. Everytime I think I've fixed it, days later, it's back. It's a Drupal 6.x thing.

Regards associating Wordpress posts/pages to Drupal's story/blog/page, that is doable. Within Wordpress all your 'post-types' were either post, page or attachment. I'll have a look at incorporating that for the version after next (maybe the very next version).

Hey, I don't mind being told of problems whether it's the converter or this site. At least I can then address things.

Steve
My running website

Top
Sun, 18 May, 2008 - 23:07
#17
Steve
Joined: 27 Mar 2008
User is online
Advanced Forum was the culprit

For what it's worth, I'm also seeing errors at the top of the page when I post me responce:

* warning: strtr() [function.strtr]: The second argument is
not an array in home/yhostcom/ public_html /cms/drupal-6.2/

As you can tell, I've reverted back to the stock-standard Drupal forum. This particular bug appears to be related to the 'Advanced Forum' as the errors don't appear now.

update: spoke too soon, yes they do. Might as well revert back to Advanced Forum - at least it looks better (in my opinion).

n/a
Top
Sat, 14 Jun, 2008 - 17:57
#18
Admin
Joined: 27 Mar 2008
User offline. Last seen 1 day 14 hours ago.
No Drupal Errors

Well I hope the title of this comment doesn't make a liar of me.

On my test site I've updated to the latest 'Token' module and no errors are reported after posting comments.

Here's goes, about to 'save'.

Top
Sat, 14 Jun, 2008 - 17:59
#19
Admin
Joined: 27 Mar 2008
User offline. Last seen 1 day 14 hours ago.
Back to the drawing board.

Back to the drawing board. This is really p...... me off and I don't really understand why others over at Drupal.org are not ranting and raving about it.

Top
Sat, 14 Jun, 2008 - 18:04
#20
Steve
Joined: 27 Mar 2008
User is online
Maybe it would help if I

Maybe it would help if I actually activated the 'Token' module.

Update: same problem.....

Steve
My running website

Top
Sat, 14 Jun, 2008 - 18:09
#21
DeeZone
Joined: 10 May 2008
User offline. Last seen 23 weeks 4 days ago.
Progress?!?

Sooo... back to the oginal topic of this thread?!? Any progress on the WordPress2.5 to Drupal6 application?

Top
Sat, 14 Jun, 2008 - 18:18
#22
Steve
Joined: 27 Mar 2008
User is online
Two versions (I think) have

Two versions (I think) have been released since we last chatted. Version 1.03 which accounts for Drupal 6.x. Just the other day I released Version 1.04. For details of what's new in 1.04 click here.

I've also updated the manual and you'll note that each of the Wordpress page types and status can be specifically associated to a Drupal content type. Screen shots here.

Steve
My running website

Top
Sat, 14 Jun, 2008 - 18:37
#23
DeeZone
Joined: 10 May 2008
User offline. Last seen 23 weeks 4 days ago.
Sweet!

Sweet, thanks!

Top
Wed, 25 Jun, 2008 - 00:25
#24
Steve
Joined: 27 Mar 2008
User is online
Comment Errors - hidden

I've solved the problem of error messages appearing after each comment is posted. Well, haven't really solved it, just hidden the error display - so that it doesn't write to the page.

This is administered from Administer / Site Configuration / Error Reporting. Simply select the option to only report to the log, rather than the log and the screen.

It's a problem that still needs to be fixed.

Steve
My running website

Top

 Subscribe in a reader

free hit counter


RoopleTheme