WordPress.org

Forums

My "terribly broken" code still not working... (3 posts)

  1. grungepuppy
    Member
    Posted 8 years ago #

    I noticed that a portion of my WP site wasn't working, suddenly without me touching it ( http://www.qrow.com/gallery/ ). I looked for a solution through WP support documents and found the "terribly broken" artical ( http://wordpress.org/development/2004/12/terribly-broken/ ) which seemed to reflect my situation. I contacted my host as recomended who've said to check if the version of WP i was using was compliant with their version of PHP. I wasn't sure why that'd matter since WP's requirments are "PHP 4.2 or greater". My host uses PHP 4.4.2. I then noticed that the artical in question was fairly old. At the time i was using WP 2.0 but then upgraded to 2.0.3 with no change.

    Does anyone have any ideas as to why it's doing this, or how i might be able to fix it? this is the information my host sent me:

    PHP 4.4.2 (cli) (built: May 30 2006 16:27:58)
    Copyright (c) 1997-2006 The PHP Group
    Zend Engine v1.3.0, Copyright (c) 1998-2004 Zend Technologies
    with Zend Extension Manager v1.0.9, Copyright (c) 2003-2006, by Zend Technologies
    with Zend Optimizer v2.6.2, Copyright (c) 1998-2006, by Zend Technologies

    I have a feeling it is an issue with my host but have not idea how to go about addressing it, or if they'll even do anything to fix it.

    Thanks for any help.

  2. grungepuppy
    Member
    Posted 8 years ago #

    can anyone tell me, then, if this version of zend is out of date with this verion of php? from what i can tell it's current. i'm still puzzled by the fact that this error happened out of nowhere without even touching it.

    does anyone know the nature of this error?

    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 '-1' at line 1]
    SELECT DISTINCT * FROM wp_posts , wp_post2cat WHERE post_date <= '2006-06-13 08:43:53' AND (post_status = 'publish') AND wp_posts.ID = wp_post2cat.post_id AND wp_post2cat.category_id = 9 GROUP BY wp_posts.ID ORDER BY post_date DESC LIMIT 0,-1

    for the record, this is the cooresponding wp code:

    <?php
    $posts = get_posts('numberposts=-1&category=9');
    foreach ($posts as $post) : start_wp(); ?>

    <a href="<?php the_permalink() ?>"><img src="http://www.qrow.com/art/thumbnails/drawings/<?php echo $post->post_name; ?>.gif" alt="" class="galimg"></a>

    <?php endforeach; ?>

    <?php rewind_posts(); ?>

    thank you for any information.

  3. grungepuppy
    Member
    Posted 8 years ago #

    nm, i found a way to fix it. thanks anyway!

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags