Author Missing from query and pagination incorrect

Question

Hi, for the most part everything has been working wonderfully, but recently I found three issues.

Configuration:

• IIS 7.5
• PHP 5.3.14 VC9 x86
• SQL Server 2008 R2 (different server)
• SQL 2008 Native Client
• WordPress DB Abstraction 1.1.4
• Microsoft Drivers 2.0 for PHP for SQL server (php_sqlsrv_53_nts_vc9.dll)

Issues:

1. inserting two backslashes (\\) in the body of a post breaks the php code which replaces ticks (`).
    - used SQL profile to see the broken query
    - not an issue for me I can work around this
    - logged here too (http://wordpress.org/support/topic/plugin-wp-db-abstraction-tick-symbol-showing-in-sql-queries)
2. clicking on an author's name shows their posts but the title of the page says "Posts By:" with no author name after
3. clicking on page 2 of a blog listing more than 10 posts takes me to the same exact page as page 1, pages 3 and 4 show different posts, but I'm curious if the last page is missing

Just remember, I have applied the following fix to resolve an issue where none of my posts were showing in the admin section. I'm curious if this change is causing the new issues. I will report back if this change is the cause of the pagination or author issues listed above.

UPDATE: after resetting the translations.php file to the original I get an error on the home page saying "Something is Missing" and no posts show.

Answer 1

This seems a bit random on its own...

I'm just guessing but it probably relates to a different thread which Luke contributed to:

http://social.msdn.microsoft.com/Forums/en-US/sqldriverforphp/thread/4c2b11ee-7137-4f33-879b-82827e2cef1b/#464421c9-5dbe-4bd5-b3ce-f92909a1ec42

---

Rob

Answer 2

Rob,

I'm unsure how the two would be related. My only customization to the base install is the linked fix to translations.php which I have tested and confirmed it is not the source of my issues. Are there undocumented compatibility issues with the 2.0 driver and the latest version of PHP? Let me know, thanks!

Answer 3

Luke

Apologies.  I didn't see a question in your post related to the driver, so assumed it was connected to your other discussion about Wordpress.

The driver is written by MSFT to the PHP PDO specification.  That spec might be open to interpretation, but it's not for MSFT to change the driver because Wordpress isn't working, unless a bug can be identified.

It's really up to the author of the Wordpress DB abstraction module to make Wordpress work with the driver.

It might be best to post your question to a Wordpress forum, where the issues can be identified as either driver problems or Wordpress coding problems.  Since this is not a Wordpress forum, the probability of getting an answer here is diminished.

You seem to have got beyond the installation of Wordpress, and I noticed that there was a link from Brian Swan's excellent blog pages posted to your other question - but here is a great page showing Brian's experience installing Wordpress, which ended in success: http://blogs.msdn.com/b/brian_swan/archive/2010/05/12/running-wordpress-on-sql-server.aspx

---

Rob