WordPress.org

1. smashingred
   Member
   Posted 3 years ago #

   I have recently updgraded two blogs using the manual upgrade with WPAU and all seemed to go well but it seems that something has gone wrong. On a recent visit to the site I noticed that the Categories are no longer visible. I also cannot see the archives.

   As an additional issue (that I am sure is related) is that the authors (or more specifically one author in particular) doesn't show up when another author is on the same page but when called via pagination it the author name shows up. I have checked the tables in the db and they all seem as they should. I verified that the current tables have all the columns as they should (as far as I can tell).

   I would prefer not to restore my 2.3 backup as I would have to repost a number of posts from after the upgrade and would dramatically increase the timeline for the client but if it is the only solution I guess I have little choice.

   Any help or guidance is appreciated.

   Cheers,

   Jay

2. smashingred
   Member
   Posted 3 years ago #

   Still looking for help here. Anyone?

3. smashingred
   Member
   Posted 3 years ago #

   I finally found the answer to my question. A plugin I was using: CoppermineSC was the root of my problems. Where it was making a DB connection it was killing the WP db connection. After nearly 8 hours of wasted time I did a Google search to find this solution. Apparently the plugin didn't use the newlink param of the mysql_connect() and therefore was starting a new connection to the WP DB instead of starting a new one.

   If you are using CoppermineSC make sure you change the following line (around 1096) from :
   $this->cpgscdbh = @mysql_connect($dbhost, $dbuser, $dbpassword);

   to:

   $this->cpgscdbh = @mysql_connect($dbhost, $dbuser, $dbpassword, TRUE);

   In addition any plugins that are accessing the db should include this the newlink param value or you could end up breaking your WP.

   Cheers

   Jay

   PS: Stack on which I had issues was LAMP, Apache 2.2, MySQL 5.0.25, PHP 5.2.5. WordPress 2.5.1 and Coppermine 1.44.

Topic Closed

This topic has been closed to new replies.