REM State

34 Responses to “In Series 2.2.1”

1. Tim Posted: Feb 11th, 2007 at 09:40

   1 Hi - I’ve used the in-series plugin for quite a while an really like it. However, I wanted to let you know of an apparent compatibility issue with the theme “silver lexus” (I’m using wp2.1). After installing the theme I upgraded/activated in-series. Everything seemed to work fine but the next day when I went to login to the admin panel, all I could get was a blank screen. Anyway, after trying a bunch of “blank screen” fixes from the WP support forum, I was able to get into the admin panel (through another computer I had left logged in), deactivated in-series, removed code from the single.php file and this fixed the issue. I’m no programmer or anything but I’d to lose either the silver lexus theme or in-series. Thought you’d like to know and I hope there’s a fix so I can keep both. Thanks Reply to this comment.

2. Vishwas Posted: Feb 11th, 2007 at 10:44

   2 I upgraded my inseries from v 2.1 to 2.2.1 and get the following error while activating the plugin. Although the plugin works fine even after this error, I was wondering why I get this error. It occurs every time I enable the plugin WordPress database error: [You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ‘SELECT a.post_id,a.meta_value FROM (SELECT post_id,met] SELECT d.post_id,d.meta_value FROM (SELECT a.post_id,a.meta_value FROM (SELECT post_id,meta_value FROM wpi4f_postmeta WHERE meta_key=’_series_name’) a JOIN (SELECT post_id,meta_value FROM wpi4f_postmeta WHERE meta_key=’_series_order’) b ON a.post_id=b.post_id JOIN (SELECT ID FROM wpi4f_posts WHERE post_status=’publish’) c ON c.ID=a.post_id ORDER BY a.meta_value,CAST(b.meta_value AS SIGNED) ASC) d GROUP BY d.meta_value ORDER BY NULL Warning: Cannot modify header information - headers already sent by (output started at /hsphere/local/home/xvzx1/blog.xvzx.net/wp-includes/wp-db.php:121) in /hsphere/local/home/xvzx1/blog.xvzx.net/wp-includes/pluggable.php on line 275 Reply to this comment.

3. Vishwas Posted: Feb 11th, 2007 at 11:10

   3 I downgraded to 2.1 just in case something might screw up my DB, but it was too late I guess. Now every time I post an entry into a series (for. e.g. xyz) there is not a single series displayed in the drop down list on the write new post menu. The only option available is “–new series–”. But when I manually enter the name of the series “xyz” in the new series name, the entry is placed in the correct order in the original series and displays correctly in the navigation. Could you help me with this? Reply to this comment.

4. Quandary Posted: Feb 11th, 2007 at 15:48

   4 Author Comment @Tim Can you give me a link to where I can download/test the theme? The automatically generated navigation links have been tested only with the default WordPress theme (and my site’s theme, which is derived directly from the default). I can’t vouch for any other theme, but I’ll certainly look into the problem to see if it’s an issue on my end. However, it may be that the theme is not providing appropriate hooks that In Series needs to insert the navigation links. If this is the case, the theme itself has what could be considered a bug, and will require manual tag insertion. Reply to this comment.

5. Quandary Posted: Feb 11th, 2007 at 16:07

   5 Author Comment @Vishwas The error that you posted does not match with any actual SQL query in my code. It appears to be referencing the “get_all_series” function, however, I don’t understand why that code would be run immediately after activating the plug-in. Furthermore, the SQL query in the error you posted is malformed (there’s an errant ‘]’), but the SQL query in my code is not. I’m not supporting downgrades at the moment. It could be that I changed something in 2.2 that’s incompatible with 2.1, but I don’t know because I haven’t tested that scenario. Do you have direct access to your SQL database (i.e., can you run the mysql shell/manager)? Reply to this comment.

6. Quandary Posted: Feb 11th, 2007 at 18:55

   6 Author Comment @Vishwas Sorry, I didn’t quite finish either thought. Because there seems to be a discrepancy between the 2.2 version you are running, and the error code you posted, you should probably try to re-download 2.2.1 and try again. The proper md5 hash for the 2.2.1 in-series.php file is 08769c375555890a814150198917a25f. If the problem persists, I may need you to run some queries against the MySQL database to diagnose the problem. If that’s the case, it will be very helpful if you have access to the mysql shell. Reply to this comment.

7. Vishwas Posted: Feb 11th, 2007 at 20:54

   7 I double checked and re-uploaded & activated the 2.2.1 version. The problem still persists (I still get the error message). I’m quite a noob at DB’s as I earn my living as a doctor and so don’t know much about mysql shell. I have access to my DB through phpMyAdmin (I don’t know if that is a direct or indirect access) Reply to this comment.

8. Tim Posted: Feb 16th, 2007 at 11:52

   8 Here’s a link for the Siver Lexus theme (post 1 above). http://themes.wordpress.net/columns/3-columns/1252/silver-lexus-08/ Thanks for checking into this. Reply to this comment.

9. Ananda Posted: Feb 21st, 2007 at 07:25

   9 Hi there. First, great plugin! It was just what I was looking for. Unfortunately, I had the same problem as Vishwas mentioned having above. Is there anything else that we can send you to help trouble-shoot here? Other than that, as long as I enter the same text in the series name box each time I write a post, it gets sorted/displayed properly… Reply to this comment.

10. Quandary Posted: Feb 21st, 2007 at 07:57

    10 Author Comment @Ananda and Vishwas Clearly, I must have broken something. But I can’t reproduce this bug, so I have no idea what the problem is. Do you know what version of PHP you’re running? What about the version of MySQL? It could be that I’ve done something incompatible. Reply to this comment.

11. Ananda Posted: Feb 22nd, 2007 at 03:25

    11 PHP: 4.4.1 / MySQL: 12.22 Distrib 4.0.16 Thanks for taking time to look in to this… especially with your move and all… Reply to this comment.

12. Ananda Posted: Feb 22nd, 2007 at 03:32

    12 Sorry–my mistake. I’m actually running PHP 5.1.4 The information in my control panel appears to be out of date…. Reply to this comment.

13. Ananda Posted: Feb 22nd, 2007 at 03:47

    13 Really sorry about three posts in a row. (Where’s a delete comment button when you need one? Feel free to delete my earlier comments and consolidate the information!) I decided to run a phpinfo script on my site (don’t know why I didn’t do that in the first place) and it shows PHP as 5.1.4, and under MySQL, 5.0.21 I assume this would be the most accurate source of information (as opposed to what it says in my site’s control panel…) Reply to this comment.

14. Jim Posted: Feb 23rd, 2007 at 11:26

    14 Tried this out and unfortunately I got the same exact error message as posted above - is this going to screw up my database? If I deactivate it will all my information be saved? Hope this didn’t screw anything up… Reply to this comment.

15. Quandary Posted: Feb 23rd, 2007 at 21:27

    15 Author Comment @Jim All of the data is still there, but it’s “invisible” (it actually just has a “_” character prepended to the key names). For comparison: which version of PHP and MySQL are you using? Reply to this comment.

16. Anton Posted: Feb 24th, 2007 at 06:43

    16 Hi, I have used the in-series plugin for a long time, and am glad to see you continue to develop it. However, I tried the newest version on one of my sites and had to revert to the 2.0 version. That is because I miss two things in the new version: 1) the ability to insert articles at any point (and not just before and after the existing series.) 2) the ability to place the TOC anywhere on the page (instead of just above and under an article). Here is an example of the way I currently use it: http://www.apologeticsindex.org/477-local If I want to insert an article between, say, items 4 and 5, the 2.0 version allows me to do so. At the site on which I tried the latest version (not the one shown here) I only sporadically used the in-series plugin. After uninstalling the latest version, I could not get the old one to work, even after I restored the database from a backup. Reply to this comment.

17. Quandary Posted: Feb 24th, 2007 at 11:25

    17 Author Comment @Anton Inserting is tricky. You can’t really insert between 4 and 5 with the old In Series — at least, not without manually renumbering everything, or using non-consecutive numbers to help reduce the number of articles you have to renumber. Full insertion control will come back in some version of 3.x, but it’s just too big of a pain to try and code up a UI for that right now, let alone to make the renumbering happen in a sane/efficient manner. Thus, for now, I’ve provided only the common case. You can still place the TOC anywhere you want — you just have to modify your template. I can’t make it automagically appear anywhere; I have to pick a couple places and make it available via the UI. You are always free to turn off the automatic insertion, and do things the “old way.” Finally, I can see no reason why uninstall+restore should fail. The way that In Series 2.1+ works is that, when you activate the plugin in the control panel, this triggers a database upgrade. If you de-activate the plugin, the upgraded metadata still exists. If you then restore your database, everything should go back to exactly the way it was — unless you inadvertently re-activate the 2.1+ In Series plugin again (causing the conversiot to take place). Check that the series_name and series_order values are in your wp_postmeta table, as expected — if they aren’t, either your SQL restore did not work, or you have re-activated the newer In Series plugin after restore. Reply to this comment.

18. Quandary Posted: Feb 24th, 2007 at 11:41

    18 Author Comment @Tim Sorry for the long delay. Silver Lexus works just fine for me. I can’t reproduce your admin panel bug — if you could provide more information, that would be helpful. Reply to this comment.

19. Jim Posted: Feb 24th, 2007 at 13:04

    19 How can I find out what version of PHP and MySQL I’m running? Reply to this comment.

20. Quandary Posted: Feb 24th, 2007 at 13:32

    20 Author Comment @Jim Create a .php file with <?php phpinfo() ?> as its only contents, then view that file in your browser. This will give you the version of PHP you are running, and the MySQL version that PHP is talking to. Reply to this comment.

21. Mike Posted: Feb 25th, 2007 at 06:31

    21 Great job on the plugin. I don’t know if this is a bug or expected behavior. I set up a new series that now has 2 posts in it. I have all options enabled except for Insert Series Title prefix. The series stuff inserts itself at the bottom of my posts (good). On my main blog page I get just Next in series on the first post and on the second post I get Previous in series. If I go to a single page view of just the post I get: Article Series - New Book Releases 1. New Civil War Book Releases for January 2007 2. New Civil War Book Releases for February 2007 It seems like there should be the TOC on the multi views as well. Just Previous or Next in series doesn’t really inform the viewer that these posts are part of a series. I have the 2.2.1 version loaded. Mike Reply to this comment.

22. Quandary Posted: Feb 25th, 2007 at 08:42

    22 Author Comment @Mike This is expected behavior. It wouldn’t be too hard to add another drop-down and checkbox to allow for the ToC to show up in multi-view, but I thought that it would be too much clutter on already full pages (IMHO, I’m pushing it with the prev/next links). If you want it, though, I’ll put it on my to-do list. :) Reply to this comment.

23. Nick Young Posted: Feb 26th, 2007 at 02:44

    23 Quandary, First off I’d like to say that I love your plugin. Is there a way to remove the prev/next links from the multi page view? Another question, actually its a problem. On the single page view, I get a numbered list of the series. But under that list is a link for prev/next that doesn’t work. Its not getting the URL to the page. Is there a way to make it work? Even better, is there a way to remove it altogether? I’m using wordpress 2.1, the k2 theme, and in-series 2.2.1 if any of that matters :) Thanks in advance for your reply! Reply to this comment.

24. Nick Young Posted: Feb 26th, 2007 at 02:44

    24 Oh, if you’d like to see an example of this you can see this page: Reply to this comment.

25. Nick Young Posted: Feb 26th, 2007 at 02:45

    25 doh… this page Reply to this comment.

26. Mike Posted: Feb 26th, 2007 at 04:42

    26 Quandry, IMHO I would give users the option to use Next/Previous or display all the posts in the series (toc w/ post listings) so consider this an official request to add the functionality. Mike Reply to this comment.

27. Quandary Posted: Feb 26th, 2007 at 07:41

    27 Author Comment @Nick Young Check out the control panel — it’s under the Options tab, and the Series sub-tab. That has all of the feature on/off switches (including prev/next links in multi-view). As for the dead link… I’ll have to investigate that. It works fine for me, last time I checked; hopefully it’ll just be a quick bugfix. @Mike You’ll have to be a tad more specific. What’s different between what there is now, and what you would like to see? ToC is toggle-able, as are next/previous links; none, one, or both can be turned on. Each of those navigation features always shows up in each series article (if the feature is enabled). You’re asking for something different than this? Your first post indicates ToC in multi view; is this still what you’re asking for? Reply to this comment.

28. Nick Young Posted: Feb 26th, 2007 at 17:30

    28 Thanks Quandary. I don’t know how I missed that option, I tuess it was really late or something. As far as the show links for single view bug, I can’t get it to work. It works fine in multi view, but not in single page view. Reply to this comment.

29. Quandary Posted: Feb 26th, 2007 at 19:00

    29 Author Comment @Nick Young Yep, that’s a bug. I’m getting close to being moved in, so I might dedicate some time late this week to giving In Series some more attention — and investigating that bug will be a high priority. Reply to this comment.

30. Christoph Voigt Posted: Feb 27th, 2007 at 02:44

    30 Hey there, first things first - nice plugin :) I’m currently using it to create different series and it works quite well. It even works fine with the Page Post Plugin (http://blog.coolcode.cn/?p=115) But I have one problem: when writinig posts, I can create new series but I can’t access the already existing ones via the dropdown menu (running 2.2.1). But when I copy the name of an existing series and use it to create a new series with the same name - all posts are put togther in this series. Reply to this comment.

31. Quandary Posted: Feb 27th, 2007 at 19:27

    31 Author Comment @Christoph Voigt Thanks! Other folks have mentioned this problem. What version of PHP and MySQL are you running, please? Reply to this comment.

32. Christoph Voigt Posted: Feb 28th, 2007 at 00:04

    32 I’m running PHP 4.3.10-18 and MySQL 4.0.24 Reply to this comment.

33. Mike Posted: Feb 28th, 2007 at 04:38

    33 Yes, I was looking for the ToC in multi-post as well. Your option is just “Insert ToC”. Really this just inserts ToC in single post. Either have ToC in both single and multi or have 2 options - “Insert ToC in Single” and Insert ToC in Multi” Mike Reply to this comment.

34. Terabanitoss Posted: May 8th, 2007 at 00:38

    34 Hi You are The Best!!! Bye Reply to this comment.