• Gestroud

    (@gestroud)


    Followed all of the upgrade instructions. Plugin killed my category, post2cat and linktocat database tables. My site is in an endless “Your WordPress database is out of date” loop. Thank God for database backups.

    Organize Series

Viewing 14 replies - 1 through 14 (of 14 total)
  • gestroud, you missed one very important instruction. Organize Series is ONLY FOR WordPress versions 2.3 and up. If you have “category”, post2cat, and linktocat database tables you are using a WordPress version prior to 2.3.

    That “your WordPress database is out of date” loop is probably because you upgraded to 2.5 and never upgraded your database. In which case, you’d want to follow the instructions here

    If after following all these instructions you still have problems then feel free to continue to post in this thread OR in the Organize Series Support Forums

    btw, if a mod could change the title to this post. It’s very misleading and because the feed shows up on the plugin page it could deter people from trying it out.

    Thread Starter Gestroud

    (@gestroud)

    Sorry, nerrad, you’re totally wrong. It clearly states that the plugin is compatible with WP 2.5. Moderators, please leave the post title alone. It is accurate and I am using WP 2.5.

    successlieswithme

    (@successlieswithme)

    hey gestroud,
    please confirm where your site is working properly or not,

    because i liked this plugin verymuch and want to use in my site, but not sure whether i should do that or not now.

    if you say, your site is back with everything now, i can install it.

    First off, gestroud, did you even read my first reply? The problems you are describing have nothing to do with Organize Series. The database tables you are describing being “killed” by Organize Series are in fact non-existant in WordPress 2.5 databases. So how then, can Organize Series kill something that doesn’t exist?

    Before posting any more I really suggest you investigate some of the suggestions I gave you in my first reply – otherwise you simply look foolish. Believe me, I’m trying to help – but your title is NOT accurate based on the problem you’ve described!

    Oh, in case it’s not clear. I’ve never said in this thread that Organize Series is not compatible with 2.5 – all I’ve written, is that based on the problem you described – it looked like you have a pre-WP2.3 database. Organize Series 2.0.x only works for WordPress versions 2.3 and up (including 2.5).

    moshu

    (@moshu)

    1. Since version 2.3. there is no post2cat table, for sure:
    WordPress_Taxonomy

    2. Let’s see what happened and we will decide what to do with the title.

    EDIT.
    3. The title is not accurate because the plugin doesn’t ruin anything. I installed it on a real 2.5 and it works perfectly.

    So, you either prove me that the right version of the plugin on a 2.5 ruined the database… or I’ll delete the whole topic.

    Thanks moshu for your attention to this πŸ™‚

    Thread Starter Gestroud

    (@gestroud)

    1. I have been working on the site since January. It was originally a WordPress 2.3.3 site. It is not yet open to the public.

    2. When WordPress 2.5 RC1 came out in the middle of March, I installed it on the site, since it’s not open to the public yet. I wanted to see how well it worked.

    3. When WordPress 2.5 came out as a full package, I installed it on the site. Everything worked fine.

    4. I noticed an update to the Organize Series plugin.

    5. I read the readme.txt file. There is a section in there written in all caps regarding the upgrade process. I read it. I also visited the plugin’s homepage for further instructions and to read the comments.

    6. Everything looked good and I installed the plug and followed the upgrade instructions.

    7. I tried to enter a new series. I was taken to a screen that said I needed to upgrade my wordpress database. Why? I don’t know. WordPress 2.5 had already been installed for over a week and the database upgraded.

    8. I clicked the link that said Upgrade now.

    9. I was redirected to a page that said the Upgrade process had successfully completed.

    10. I clicked the Continue link.

    11. I was taken back to the Your WordPress database needs to be upgraded. On the page were several error messages clearlyl stating that the database tables I mentioned were not there.

    12. I clicked continue again. The cycle repeated with the same messages.

    13. I deleted the plugin and restored my old database. I still have my posts. I still have my categories, but they don’t recognize each other.

    ——————————————————-

    Why is it necessary for the both of you to be so hostile? It really makes no sense – none at all. Why can’t you just say, “Hey, there may be a real problem here that needs looking into.” It would be a lot more professional.

    @moshu – I’m glad the plugin worked for you on a “real 2.5” install. I hope it works for everyone who tries it. But I also had it installed on a “real 2.5” install. It didn’t work for me.

    moshu

    (@moshu)

    There maybe a real problem – with your upgrade. If after upgrading to 2.3.3 or 2.5 you have post2cat table in your database… something went wrong with that upgrade, sorry.
    If you clicked on the Taxonomy link I gave above, you could read:

    This new schema replaces the categories, post2cat, and link2cat tables with three new tables that are more flexible.

    1. wp_terms
    2. wp_term_relationships
    3. wp_term_taxonomy

    On the other hand it is might happen that you installed a version of the plugin that was meant to work with earlier WP versions and indeed was looking for the post2cat table, as it should, when working with pre-2.3 WP.

    There is no hostility here… but stating that in 2.5 you had post2cat table is nonsense. Period.

    No hostility from me either gestroud. I just didn’t think your title was appropriate based on the scenario you gave for your problem.

    Here’s a couple questions I would ask to help troubleshoot your difficulties. Thank for the further details with what happened as you are describing but let me explain a couple of things about how Organize Series works so you’ll understand what happens on the backend.

    1. Organize Series 1.6.3 and earlier integrated with categories in pre WordPress 2.3 (i.e. post2cat, and categorie tables) BUT did not do any custom writes to the db. All it did is read the database information and optimized “series” categories for display. So… at worst, if you installed an older version of Organize Series 1.6.3 on a WP2.3+ blog you’ll simply get a query error because the post2cat and categories tables no longer exist).

    2. Organize Series 2.0+ integrates with the new taxonomy system of WordPress and reads and writes to the new tables (wp_terms, wp_term_relationships, and wp_term_taxonomy) using the plugin api WordPress provides. It is technically impossible for Organize Series 2.0 to delete any of the post2cat, and categories tables UNLESS there are incorrect WordPress core files in your install (files that did not replaced in the upgrade process from pre 2.3 to 2.3.3 and 2.5). In this case the plugin hooks that Organize Series 2.0 are definitely not functiong as expected because they aren’t the right ones. In this case , it is not the fault of Organize Series but the fault of a bad WordPress upgrade.

    3. The import function of Organize Series for people upgrading to a new version simply copies over information from the previous category structure that orgSeries 1.6.3 and lower used to the new taxonomy structure in orgSeries 2.0 and greater. Again, this import procedures uses all the core WordPress plugin api hooks and does not carry out direct custom db queries so on it’s own OrgSeries will not delete any existing WordPress tables.

    4. OrgSeries 2.0 does create a new table at activation of the plugin for storage of series icons but that won’t lead to the symptoms you described.

    My suggestion and what I think is the root of your problem…
    When you upgraded your WordPress install from pre 2.3 to WP2.3 (or imported a pre WordPress 2.3 database file into your WordPress 2.3+ install) there were some core WordPress files that didn’t get copied properly and so you may have thought everything was working properly but in fact you were running some sort of “hybrid” and for some reason it worked fine until Organize Series exposed the problem.
    A FIX:

    • Make sure you delete all the WordPress core files from your server and then install a fresh copy of WordPress 2.5.
    • Import your database backup file and set it up.
    • Run the WordPress upgrade script manually (…/wp-admin/upgrade.php)
    • Check your database structure and make sure post2cat, link2cat, and categories tables are NOT present (If they are then something is wrong with your WordPress install).
    • Check out WordPress admin and front end and make sure everything works as expected
    • Install Organize Series and it should work fine

    Report back here how things went. BUT in the meantime, can we please have a title change? My suggestion, “Upgrade loop with Organize Series?” – it’s a little less alarming (and not misleading) and still provides a clue as to what the thread is about.

    moshu

    (@moshu)

    [mod: title of topic changed]

    Thread Starter Gestroud

    (@gestroud)

    I’d pretty much done most of that after I encountered the difficulty – new WP install, restore database, update db, etc.

    The thing that puzzles me is that I was able to create posts after I upgraded to WP 2.5. Didn’t have any problems until the plugin update. Peculiar.

    I’ll post an update, but I won’t be working on that particular site again until the weekend.

    mjesales

    (@mjesales)

    I’ve never heard of the plugin mentioned here – but i’m having the same issue on one blog… not the other 10 that went smoothly…

    I just started looking for some of these things that you mentioned here – but they don’t exist in my database.

    I went from wp 2.33 to wp 2.5. I deleted the wp-admin and wp-includes and made sure everything got uploaded correctly.

    Now i’m stuck with this endless cycle of upgrade your database — your database has been upgraded — etc

    mjesales

    (@mjesales)

    I fixed this problem by going into /wp-admin/admin.php file and removing the if statement that looks for the database version. Not sure if this is a good fix or not. But I did it only after it had run the database version upgrade and the new version is posted in the options table.

Viewing 14 replies - 1 through 14 (of 14 total)
  • The topic ‘[Plugin: Organize Series WordPress Plugin] Upgrade loop with Organize Series?’ is closed to new replies.