ExpressionEngine CMS
Open, Free, Amazing

Thread

This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.

The active forums are here.

Search Error

June 29, 2007 6:45pm

Subscribe [3]
  • #1 / Jun 29, 2007 6:45pm

    chiltonm

    16 posts

    When I try to search I get this error:

    MySQL ERROR:

    Error Number: 1064

    Description: 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 ‘WHERE search_date > ‘1183153136’ AND ip_address=‘81.153.179.167’’ at line 1

    Query: SELECT search_id FROM exp_search WHERE site_id = ‘1’ WHERE search_date > ‘1183153136’ AND ip_address=‘81.153.179.167’

    I have recently upgraded to 1.6.  I didn’t get the error before.

  • #2 / Jun 29, 2007 6:46pm

    Lisa Wess

    20502 posts

    Heya - can you try clearing your cookies and see if that clears the error? Thank you.

  • #3 / Jun 29, 2007 7:50pm

    chiltonm

    16 posts

    I take it you mean the cookies on my local machine?  (Thinks: surely there aren’t any on the server?)

    Done.  But I get the same error.

  • #4 / Jun 29, 2007 8:03pm

    Derek Jones

    7561 posts

    This was a bug in an early build of 1.6, please update to the latest where this has been fixed.

  • #5 / Jun 30, 2007 7:09pm

    chiltonm

    16 posts

    Well, I’m trying to access the download (on the EE site) but I get this:

    Disallowed Key Characters

  • #6 / Jul 01, 2007 11:13am

    Robin Sowell

    13255 posts

    chiltonm- this still a problem?  If so- what browser are you in, and where does it throw the error.  When you access the ‘My Downloads’ page or when you click the link to download- or click the ‘confirm’ on the license, or…  Er- walk me through it.

  • #7 / Jul 04, 2007 4:57pm

    chiltonm

    16 posts

    First of all, the search error is cured.  The latest build worked.

    But the My Downloads problem is not.  When I click on “My Downloads” I get “Disallowed Key Characters”.  I get this in Opera and IE7.  I get it no matter how I access “My Downloads”.

    However, when I go to my laptop and try the same thing… no problem.

  • #8 / Jul 05, 2007 7:16am

    nathanpitman

    531 posts

    This was a bug in an early build of 1.6, please update to the latest where this has been fixed.

    I’ve come up against this problem also. I just updated to the latest build and the problems is still persisting. Any ideas? My build # is: 20070621.

  • #9 / Jul 05, 2007 9:23am

    Derek Jones

    7561 posts

    The latest build is 20070627, Nathan. 😉  You may wish to subscribe to the Build Update feed

.(JavaScript must be enabled to view this email address)

ExpressionEngine News!

#eecms, #events, #releases