Results 1 to 2 of 2

Thread: Recurring database error

  1. #1
    Join Date
    May 2007
    Posts
    33

    Default Recurring database error

    My site is v2.5.5
    I am hosted on godaddy.
    I get this erro at least once per day.
    Has anyone any ideas?

    SQL statement that failed below:
    ---------------------------------------------------------
    SELECT distinct(default_en_listingsdb.listingsdb_id), default_en_listingsdb.userdb_id, default_en_listingsdb.listingsdb_title FROM default_en_listingsdb, default_en_listingsimages ,default_en_listingsdbelements `country` ,default_en_listingsdbelements `sort1` WHERE (listingsdb_active = 'yes') AND (default_en_listingsdb.listingsdb_id = `country`.listingsdb_id) AND (default_en_listingsdb.listingsdb_id = `sort1`.listingsdb_id) AND (default_en_listingsimages.listingsdb_id = default_en_listingsdb.listingsdb_id) AND (`country`.listingsdbelements_field_name = 'country' AND `country`.listingsdbelements_field_value = 'France') AND (listingsdb_expiration > '2009-06-09') AND (sort1.listingsdbelements_field_name = 'beds') GROUP BY default_en_listingsdb.listingsdb_id, default_en_listingsdb.listingsdb_title ,sort1.listingsdbelements_field_valueORDER BY listingsdb_featured DESC, sort1.listingsdbelements_field_value ASC

    ---------------------------------------------------------

    ERROR REPORT www.mysite.co.uk: June 9, 2009, 3:24:15 am

    ---------------------------------------------------------
    SQL ERROR: SELECT distinct(default_en_listingsdb.listingsdb_id), default_en_listingsdb.userdb_id, default_en_listingsdb.listingsdb_title FROM default_en_listingsdb, default_en_listingsimages ,default_en_listingsdbelements `country` ,default_en_listingsdbelements `sort1` WHERE (listingsdb_active = 'yes') AND (default_en_listingsdb.listingsdb_id = `country`.listingsdb_id) AND (default_en_listingsdb.listingsdb_id = `sort1`.listingsdb_id) AND (default_en_listingsimages.listingsdb_id = default_en_listingsdb.listingsdb_id) AND (`country`.listingsdbelements_field_name = 'country' AND `country`.listingsdbelements_field_value = 'France') AND (listingsdb_expiration > '2009-06-09') AND (sort1.listingsdbelements_field_name = 'beds') GROUP BY default_en_listingsdb.listingsdb_id, default_en_listingsdb.listingsdb_title ,sort1.listingsdbelements_field_valueORDER BY listingsdb_featured DESC, sort1.listingsdbelements_field_value ASC
    Server Type: Apache
    Request Method: GET
    Query String: action=searchresults&sortby=beds&sorttype=ASC&coun try=France&imagesOnly=yes&pclass[]=
    Refereer: http://www.mysite.co.uk/index.php?co...&pclass%5B%5D=
    User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; InfoPath.2)
    Request URI: /index.php?action=searchresults&sortby=beds&sorttyp e=ASC&country=France&imagesOnly=yes&pclass[]=
    POST Variables: array (
    )
    GET Variables: array (
    'action' => 'searchresults',
    'sortby' => 'beds',
    'sorttype' => 'ASC',
    'country' => 'France',
    'imagesOnly' => 'yes',
    'pclass' =>
    array (
    0 => '',
    ),
    'printer_friendly' => false,
    'cur_page' => 0,
    )




    --------------------------------------------------------------------------------

  2. #2
    the_sandking's Avatar
    the_sandking is offline hadron remnant - Moderation Fachmann
    Join Date
    Apr 2003
    Location
    Nullspace
    Posts
    5,289

    Default Re: Recurring database error

    What happens when you run the query that is failing through PHPMyadmin or whatever you use to manager your mySQL databases? That could tell you a lot.

    There should also be a referring IP address included with this error, but it looks like you did not include that. My guess is it could be a search engine bot causing the error, but without the IP I cannot verify that.
    "Much of what looks like rudeness in hacker circles is not intended to give offense. Rather, it's the product of the direct, cut-through-the-BS communications style that is natural to people who are more concerned about solving problems than making others feel warm and fuzzy."

    "We gotta' go to the crappy town where I'm a hero!"
    -Hoban 'Wash' Washburne 2485-2519


    "When you’re born you get a ticket to the freak show. When you’re born in America, you get a front-row seat.."
    -George Carlin 1937-2008

    New to Open-Realty® and need help? Check the:
    -OR DOCUMENTATION -

    Important: Read this at least once in your lifetime
    How To Ask Questions The Smart Way

Similar Threads

  1. Database Error
    By Moxi in forum General Help (CLOSED)
    Replies: 3
    Last Post: 04-20-2006, 09:29 AM
  2. Database error ??
    By parke1 in forum General Help (CLOSED)
    Replies: 1
    Last Post: 05-23-2005, 01:55 PM
  3. Error database ??
    By resomnia in forum HELP (CLOSED)
    Replies: 11
    Last Post: 11-01-2003, 10:55 AM
  4. Error on DataBase
    By Anonymous in forum HELP (CLOSED)
    Replies: 2
    Last Post: 02-06-2003, 09:32 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •