[wp-testers] Error in SQL syntax?

Dr. Mike Wendell theapparatus at gmail.com
Wed Jan 31 17:56:32 GMT 2007


This is probably more for the support forums but you may want to
review the template tags page in the codex.  The way categories work
have been changed.

http://codex.wordpress.org/Template_Tags

Hope this helps,
-drmike

On 1/31/07, Alex Leung <sixsteps at gmail.com> wrote:
> I just realized that I'm getting this error on my Links page:
> http://www.sixsteps.org/links/
>
> *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 '' at line 1]
> SELECT cat_id, cat_name FROM
>
> *** Can anybody shed some light on this?  I upgraded to WP 2.1 from 2.0.5..
> I'm thinking maybe it's an issue with my current theme's template?  (I'm
> working on switching to a new 2.1 compatible theme)
> Here's the links list template code that's used in my theme:
>
> > <?php
> > /*
> > Template Name: Links List for Squible
> > */
> > ?>
> >
> > <?php get_header(); ?>
> >
> > <div id="toppanel">
> >  <div id="posts">
> >  <div class="storycontent">
> >
> >    <div class="post">
> >     <?php if (have_posts()) : while (have_posts()) : the_post();?>
> >     <h2 class="storytitle"><?php the_title(); ?></h2>
> >     <?php endwhile; endif; ?>
> >     <?php $link_cats = $wpdb->get_results("SELECT cat_id, cat_name FROM
> > $wpdb->linkcategories");
> >     foreach ($link_cats as $link_cat) {
> >     ?>
> >     <h3><?php echo $link_cat->cat_name; ?></h3>
> >     <ul>
> >     <?php wp_get_links($link_cat->cat_id); ?>
> >     </ul>
> >     <?php } ?>
> >    </div>
> >
> >  </div>
> >  </div>
> >
> > </div>
> >
> > <?php get_footer(); ?>
> >
>
>
> --
> Alex Leung
> more than a name, it's a value--a way of life: "worship with poles."
> 2 Samuel 6:13 - http://www.sixsteps.org
> _______________________________________________
> wp-testers mailing list
> wp-testers at lists.automattic.com
> http://lists.automattic.com/mailman/listinfo/wp-testers
>


-- 
Blog: http://tdjc.be
Kim Possible: Remixed: http://kpremixed.tdjc.be
Get your own free hosted WordPress Blog today: http://daria.be


More information about the wp-testers mailing list