Need Help – SQL error & IE issue

  • 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?

Viewing 5 replies - 1 through 5 (of 5 total)

  • 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?

    Thread Starter nitecloak

    (@nitecloak)

    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?

    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.

    Thread Starter nitecloak

    (@nitecloak)

    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='https://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="https://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="https://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="https://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="https://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="https://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="https://www.aarpmagazine.org/" title="AARP The Magazine -
World's Largest Circulation Magazine for Seniors" target="_blank">AARP
Online Magazine</a></li>

<li><a href="https://www.topix.net/city/howell-mi" title="Great Local Howell News
Updated BY Local People">Howell News - Topix.net</a></li>
<li><a href="https://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?

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

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Need Help – SQL error & IE issue’ is closed to new replies.

Tags