Forums | stripShow compatible with WordPress 2.3.1? Problem with mine...

You must be logged in to post Login Register

Search Forums:


 






stripShow compatible with WordPress 2.3.1? Problem with mine…

UserPost

8:18 pm
November 27, 2007


kdelapla

Member

posts 12

Hi,

I just installed the latest version of WordPress (2.3.1), a new install, no previous versions. And I installed the stripShow plugin. No comics added yet, but I get a database error report in the sidebar that I can't really understand.

Here's the link: http://www.philosophycomics.com

Might this be a compatibility problem with the 2.3.1 release?

8:23 am
November 28, 2007


kdelapla

Member

posts 12

Update.

I've added one comic to my "comics" folder. And I've got the ComicPress theme loaded in my themes folder. When I switch over to ComicPress the comic shows up fine, so at least that much is working fine. But when I switch back to stripShow the comic doesn't show up and I get the syntax error report under "Latest Blog Posts" in the sidebar.

I'd much prefer to use stripShow so I hope someone can help diagnose the problem.

http://www.philosophycomics.com

10:58 am
November 29, 2007


Brad

Admin

posts 233

Weird… I'm not sure what that error is. I'll have to look into it.

11:31 am
November 29, 2007


Brad

Admin

posts 233

So far no errors on my end using wp 2.3.1 — This only appears when using the recent_noncomics() tag? Are you using any parameters with it?

1:34 pm
November 29, 2007


kdelapla

Member

posts 12

I'm grateful that you're on the case!

I'm very new at all this, I'm not sure where to look for the information regarding the recent_noncomics()tag. Give me a little more direction and I'll pass on any information that might be useful.

FYI, I'm running stripShow straight out of the box, as it were; nothing's been modified.

2:24 pm
November 29, 2007


Brad

Admin

posts 233

The recent_noncomics() tag can be found, on your site, in the sidebar.php file in the theme. If you're using the stock theme, then I don't know what the issue is.

I thought maybe it was something with WP 2.3.1, so I did a fresh install of only that version, and still get no issue.

Tell you what, go into your Admin page and go to Options->StripShow, and  tell me what your settings are.

4:17 pm
November 29, 2007


kdelapla

Member

posts 12

Here are my current settings:

http://screencast.com/t/dksdziR6

(I'm using the new (free) product Jing from TechSmith to take these snaps. Cool product.)

4:22 pm
November 29, 2007


kdelapla

Member

posts 12

Well that's interesting, just looking at the settings. I've got the category mode set to single.

Let's switch that to multiple and see what happens…

Oh my.

This is what happens:

http://screencast.com/t/tufWwUFOCY

I've switched it back to single now, that was too horrible to look at!

4:27 pm
November 29, 2007


kdelapla

Member

posts 12

Here's my sidebar.php code:

<div id="sidebar">
<div class="loginlogout">
<?php wp_register('',''); ?> • <?php wp_loginout(); ?>
</div>

<table border="0" cellspacing="0" cellpadding="0" id="sidebarNavArrows">
<tr>
<td><span class="arrow"><span class="first_day"><?php first_comic('<img src="'.get_bloginfo('stylesheet_directory').'/images/first_day.gif" alt="First Comic" />') ?></span></span></td>
<td><span class="arrow"><span class="previous_day"><?php previous_comic('<img src="'.get_bloginfo('stylesheet_directory').'/images/previous_day.gif" alt="Previous Comic" />') ?></span></span></td>
<td><span class="arrow"><span class="next_day"><?php next_comic('<img src="'.get_bloginfo('stylesheet_directory').'/images/next_day.gif" alt="Next Comic" />') ?></span></span></td>
<td><span class="arrow"><span class="last_day"><?php last_comic('<img src="'.get_bloginfo('stylesheet_directory').'/images/last_day.gif" alt="Last Comic" />') ?></span></span></td>
</tr>
</table>

<?php storyline_dropdown(); ?>
Current story: <?php the_story(); ?><br/>
Part <?php story_part(); ?> of <?php story_parts(); ?><br />
<a href="<?php storyline_start_url(); ?>">Start of current story</a>

<!-- COMIC BOOKMARK BEGIN -->

<?php if ( is_page() || !is_single()) { ?> 
<?php } else { ?>
<div align="center">

<script language="javascript" type="text/javascript">
/*
Config Settings
*/
var cl = 31;
var imgTag = '<?php bloginfo('stylesheet_directory'); ?>/images/1.gif'; //add tag image.
var imgClearOff = '<?php bloginfo('stylesheet_directory'); ?>/images/3a.gif'; //no comic tagged, clear not possible
var imgGotoOff = '<?php bloginfo('stylesheet_directory'); ?>/images/2a.gif'; //no comic tagged, goto not possible
var imgClearOn = '<?php bloginfo('stylesheet_directory'); ?>/images/3.gif'; //clear a tag, shows when comic previously tagged
var imgGotoOn = '<?php bloginfo('stylesheet_directory'); ?>/images/2.gif'; //shows when a comic is tagged 
var imgInfo = '<?php bloginfo('stylesheet_directory'); ?>/images/4.gif';  //img that displays the help
var comicDir = '/'; //alter this if you run multiple comics in different directories on your site.

</script>
<script language="javascript" type="text/javascript" src="<?php bloginfo('stylesheet_directory'); ?>/tagger.js">Script is here</script>
</div>
<?php } ?>
<!-- COMIC BOOKMARK END -->
<?php
// The following global variables need to be set if, like me, you don't like to use date-and-title permalinks. (I just use title)
global $year, $monthnum;
$year = get_the_time('Y');
$monthnum = get_the_time('m');
?>
  <?php get_calendar(2); ?>

    <ul>

      <li>
      <?php /* If this is a 404 page */ if (is_404()) { ?>
      <?php /* If this is a category archive */ } elseif (is_category()) { ?>
      <hr /><p>You are currently browsing the archives for the <?php single_cat_title(''); ?> category.</p><hr />

      <?php /* If this is a yearly archive */ } elseif (is_day()) { ?>
<hr /><p>You are currently browsing the <a href="<?php bloginfo('home'); ?>/"><?php echo bloginfo('name'); ?></a> archives for the day <?php the_time('l, F jS, Y'); ?>.</p><hr />

<?php /* If this is a monthly archive */ } elseif (is_month()) { ?>
<hr /><p>You are currently browsing the <a href="<?php bloginfo('home'); ?>/"><?php echo bloginfo('name'); ?></a> archives for <?php the_time('F, Y'); ?>.</p><hr />

<?php /* If this is a yearly archive */ } elseif (is_year()) { ?>
<hr /><p>You are currently browsing the <a href="<?php bloginfo('home'); ?>/"><?php echo bloginfo('name'); ?></a> archives for the year <?php the_time('Y'); ?>.</p><hr />

<?php /* If this is a monthly archive */ } elseif (is_search()) { ?>
<hr /><p>You have searched the <a href="<?php echo bloginfo('home'); ?>/"><?php echo bloginfo('name'); ?></a> archives for <strong>'<?php the_search_query(); ?>'</strong>. If you are unable to find anything in these search results, you can try one of these links.</p><hr />

<?php /* If this is a monthly archive */ } elseif (isset($_GET['paged']) && !empty($_GET['paged'])) { ?>
<hr /><p>You are currently browsing the <a href="<?php echo bloginfo('home'); ?>/"><?php echo bloginfo('name'); ?></a> archives.</p><hr />

<?php } ?>
</li>

<?php wp_list_pages('title_li=<h2>Extras</h2>' ); ?>

  <li><h2>Latest Comics</h2><ul>
        <?php recent_comics(5,'<li>','</li>'); ?>
      </ul></li>
     
  <li><h2>Latest Blog Posts</h2><ul>
        <?php recent_noncomics(5,'<li>','</li>'); ?>
      </ul></li>

<li><h2>Monthly Archives</h2>
<ul>
<?php wp_get_archives('type=monthly'); ?>
</ul>
</li>

<?php wp_list_categories('show_count=1&title_li=<h2>Categories</h2>'); ?>

<li>
<?php include (TEMPLATEPATH . '/searchform.php'); ?>
</li>

</ul>
</div>

4:37 pm
November 29, 2007


Brad

Admin

posts 233

This keeps getting odder. Who is your web host? I'd like to see what version of MySQL they're using.

6:21 pm
November 29, 2007


kdelapla

Member

posts 12

I'm using 1&1.com: http://www.1and1.com

… on a Linux Shared Server. Here's the software versions: http://faq.1and1.com/miscellaneous/13.html

In this hosting package you can set up a WordPress blog from their control panel, but it has a restricted set of themes  and plugins that you can't edit or add to. I initially did this thinking I could import themes but soon discovered otherwise. So I deleted that blog and went ahead and loaded WordPress manually to my root directory and went on from there.

6:28 pm
November 29, 2007


kdelapla

Member

posts 12

Just to restate a point I made earlier, when I deactivate the stripShow plugin and switch to the default ComicPress theme, the site looks like this

http://screencast.com/t/vQTAxFhNz0G

which looks normal to me.

9:19 pm
November 29, 2007


Brad

Admin

posts 233

Found it!

Your MySQL version is 4.0.27, and it turns out that (unbeknownst to me) MySQL didn't support subqueries until 4.1

So, basically any function that I wrote that uses NOT IN (which is only recent_noncomics() in single-category mode, but nearly all the others in multiple-category mode) will fail on a version of MySQL earlier than 4.1… which explains why I wasn't able to get it to fail on my test boxes.

I don't know how to solve this, assuming you can't upgrade MySQL. I'm not sure how to rewrite these queries not to use this feature.

However, now that I read more of the article I linked to, I see that it can be done. I'll get to work on it.

10:14 pm
November 29, 2007


kdelapla

Member

posts 12

Fabulous news! Many thanks for your efforts on behalf of this problem. I do look forward to working with your great plugin.

Kevin

7:48 am
December 5, 2007


kdelapla

Member

posts 12

I managed to upgrade my database to MySQL 5 and that seems to have fixed the syntax problem.

So, don't feel the need to work on this issue on my behalf. But thanks again for your help in diagnosing the problem.



  • Donate

    While I don't maintain stripShow for a living, I wouldn't say no to a little donation, if you think the plugin is worth it...

  • Advertisements