WordPress.org

1. jdw001
   Member
   Posted 1 year ago #

   Hey there. I'm migrating my site from a custom CMS to WordPress, importing a dataset on the fly from SQL to MySQL. My buddy wrote a plugin to do this, and we had no problems pulling our members from the non-WP compatible database and into the new one.

   We're now running in to a problem when we're trying to pass our posts and comments in to WP. The maddening problem is that the importing works fine on the development Ubuntu 10.10 server, apache 2.2.16, php 5.3.3, mysql 5. Everything imports over, comments and all. But when we go to the production machine, running Windows server 2008 r2, IIS 7, PHP 5.2.14, Mysql 5.1.51, it craps out.

   We get an error around this bit of code:

   SELECT TOP 50 [BlogID], [ClientID], [BlogTitle], [BlogText], [BlogTime], (SELECT COUNT(*) FROM [DQDB].[dbo].[blogCommentBoard] WHERE blogID = [DQDB].[dbo].[Blogs].[BlogID]) AS [NoComments] FROM [DQDB].[dbo].[Blogs] WHERE BlogID IN ( )

   Can anyone see a problem with this bit of code? Is there something in WP that we missed? Why does it work on the Ubuntu but not the Windows server? Thanks.

2. jdw001
   Member
   Posted 1 year ago #

   Slight edit.

   I confused two errors. The code error in the middle of the post was fixed. The import error still remains, a mismatch between the two set ups.

   Here's a better post:

   Sam and I keep running into a snag while importing the posts and comments to the rebooted site. User import went fine, but not the posts keep giving problems, erroring out.

   When we use Sam's custom plugin, it works fine on an Ubuntu 10.10 server, apache 2.2.16, php 5.3.3, mysql 5. Everything imports over, comments and all. But when we go to the production machine running Windows server 2008 r2, IIS 7, PHP 5.2.14, Mysql 5.1.51, it doesn't work.

Topic Closed

This topic has been closed to new replies.