WordPress.org

Ready to get started?Download WordPress

Forums

Need Help - SQL error & IE issue (6 posts)

  1. NiteCloak
    Member
    Posted 7 years ago #

    I'm hoping someone can help me with our WP 2.1 site.

    JustLikeHomeAFC.com

    Everything was running great 3 days ago. My wife and I went away for an extended weekend and when we return two things are happening which cannot be the result of something we did because we were not here.

    The first is, in FireFox we are getting the following error in the sidebar between the section called "Archives" and "Resource Links". This is what we see:

    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 '^([adObis]):/' at line 1]
    SELECT * , IF (DATE_ADD(link_updated, INTERVAL 120 MINUTE) >= NOW(), 1,0) as recently_updated FROM wp_links LEFT JOIN wp_link2cat ON (wp_links.link_id = wp_link2cat.link_id) WHERE 1=1 AND link_visible = 'Y' /^([adObis]):/�_id = 7 ) ORDER BY link_name ASC

    And the second issue is we are unable to get our webpage to load in Internet Explorer. IE just seems to be caught in a loop and never displays our page but all other sites I tried were fine, including another site I own which is also WP 2.1 driven.

    Please Help. I do not know SQL and I am at a total loss how to fix this or what has caused it. Have I been hacked?

  2. Glenn Ansley
    Member
    Posted 7 years ago #

    You need to open up your sidebar.php and see what code is directly under you wp_get_archives.

    Is it part of a plugins code?

  3. NiteCloak
    Member
    Posted 7 years ago #

    I'm using the WordPress Default theme v1.6 by Michael Heilemann and Sidebar Widgets instead of the default sidebar.php

    I don't know what to look for though because I am not a developer or coder, just a user, and even if I knew what to look for I wouldn't know what to do to rectify it.

    Can you offer me some guidance?

  4. Glenn Ansley
    Member
    Posted 7 years ago #

    Copy the code from your sidebar that lies between the wp_get_archives and the resource links and paste it in here.

    When you paste it here, make sure you surround it with backticks (`)or use the code button above the input screen.

  5. NiteCloak
    Member
    Posted 7 years ago #

    Well with me using sidebar widgets I cannot get to the widget code inside my admin dashboard. I went to my site and did "view source" and this is what I get:

    <li id="archives" class="widget widget_archives">                       <h2
    class="widgettitle">Archives</h2>
    
                           <ul>
                                   <li><a
    href='http://justlikehomeafc.com/?m=200703' title='March 2007'>March
    2007</a></li>
                           </ul>
                   </li>
    <div id='error'>
                           <p class='wpdberror'><strong>WordPress database
    error:</strong> [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
    '^([adObis]):/' at line 1]
    
                           <code>SELECT *  , IF (DATE_ADD(link_updated, INTERVAL
    120 MINUTE) >= NOW(), 1,0) as recently_updated   FROM wp_links  LEFT JOIN
    wp_link2cat ON (wp_links.link_id = wp_link2cat.link_id)  WHERE 1=1 AND
    link_visible = 'Y' /^([adObis]):/?_id = 6 )   ORDER BY link_name
    ASC</code>
    
                           </div><li id="linkcat-2" class="linkcat"><h2
    class="widgettitle">Resource Links</h2>
    
           <ul>
    <li><a
    href="http://www.cityofhowell.org/index.php?option=com_content&task=view&id=23&Itemid=58"
    title="City of Howell - Welcome to Howell, MI" target="_blank">About
    Howell</a></li>
    <li><a
    href="http://www.downtownhowell.org/index.php?option=displaypage&Itemid=60&op=page&SubMenu="
    title="Downtown Howell - Official Website" target="_blank">City of Howell
    History</a></li>
    
    <li><a
    href="http://www.aarp.org/families/caregiving/guide_to_longterm_care.html"
    title="&quot;The Cost of Long-term Care&quot; and more from AARP"
    target="_blank">Guide to Long-term Care</a></li>
    <li><a
    href="http://www.cityofhowell.org/index.php?option=com_content&task=view&id=55&Itemid=94"
    title="Howell Senior Center information via the official City of Howell
    website." target="_blank">Howell Senior Center</a></li>
    <li><a href="http://www.michigan.gov/miseniors" title="Michigan.gov website for
    Michigan Office of Services to the Aging" target="_blank">Michigan.gov MI
    Seniors</a></li>
    
           </ul>
    </li>
    <li id="linkcat-3" class="linkcat"><h2 class="widgettitle">Senior Links</h2>
    
           <ul>
    <li><a href="http://www.aarpmagazine.org/" title="AARP The Magazine -
    World's Largest Circulation Magazine for Seniors" target="_blank">AARP
    Online Magazine</a></li>
    
    <li><a href="http://www.topix.net/city/howell-mi" title="Great Local Howell News
    Updated BY Local People">Howell News - Topix.net</a></li>
    <li><a href="http://www.mem.com" title="Celebrate life and life events by
    preserving life stories to share with friends and family around the world for
    current and future generations.">Making Everlasting Memories</a></li>
    
           </ul>
    </li>

    I would post you the actual sidebar.php code but as I am not using the default sidebar.php, do you still need it?

  6. Glenn Ansley
    Member
    Posted 7 years ago #

    Hmmm. I've never used widgets. Can you turn them off one at a time?

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags