Results 1 to 5 of 5

Thread: SQL error, need some help please

  1. #1
    Join Date
    Dec 2008
    Posts
    2

    Default SQL error, need some help please

    I'd be very grateful if anyone can let me know what the following error message means. This is what comes up when I try to submit a listing:


    SQL statement that failed below:
    ---------------------------------------------------------
    INSERT INTO default0_en_listingsdb (listingsdb_title, listingsdb_notes, userdb_id, listingsdb_active, listingsdb_mlsexport, listingsdb_creation_date, listingsdb_last_modified, listingsdb_expiration, listingsdb_hit_count, listingsdb_featured) VALUES ('test', 'test', '1', 'yes', 'no', '2008-12-09','2008-12-09 04:37:16',null,0,'no')

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

    ERROR REPORT www.dreams2properties.com: December 9, 2008, 4:37:16 am

    ---------------------------------------------------------
    SQL ERROR: INSERT INTO default0_en_listingsdb (listingsdb_title, listingsdb_notes, userdb_id, listingsdb_active, listingsdb_mlsexport, listingsdb_creation_date, listingsdb_last_modified, listingsdb_expiration, listingsdb_hit_count, listingsdb_featured) VALUES ('test', 'test', '1', 'yes', 'no', '2008-12-09','2008-12-09 04:37:16',null,0,'no')
    Server Type: Apache/2.2.4 (Win32) PHP/5.2.1
    Request Method: POST
    Query String: action=add_listing
    Refereer: http://www.dreams2properties.com/cre...property_class
    User Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv:1.9.0.4) Gecko/2008102920 Firefox/3.0.4
    Request URI: /crete/admin/index.php?action=add_listing
    POST Variables: array (
    'action' => 'create_new_listing',
    'title' => 'test',
    'notes' => 'test',
    'mlsexport' => 'no',
    'property_class' =>
    array (
    0 => '1',
    ),
    'brief' => 'test',
    'location' => 'test',
    'full_desc' => 'test',
    'Location_Details' => 'test',
    'development' => 'test',
    'properties' => 'test',
    'price' => '100000',
    )
    GET Variables: array (
    'action' => 'add_listing',
    'printer_friendly' => false,
    )

  2. #2
    Join Date
    Oct 2007
    Posts
    2

    Default Re: SQL error, need some help please

    I'm getting the following SQL error also, with version 2.5.5, when I try to do a New Listing. This is a new install, with NO CHANGES from the Download...


    SQL statement that failed below: ---------------------------------------------------------SELECT listingsformelements_required, listingsformelements_field_type, listingsformelements_field_name from default_en_listingsformelements WHERE listingsformelements_id IN (SELECT listingsformelements_id FROM default_classformelements WHERE class_id IN (1)) --------------------------------------------------------- ERROR REPORT 50sfood.com: December 12, 2008, 3:00:04 pm ---------------------------------------------------------SQL ERROR: SELECT listingsformelements_required, listingsformelements_field_type, listingsformelements_field_name from default_en_listingsformelements WHERE listingsformelements_id IN (SELECT listingsformelements_id FROM default_classformelements WHERE class_id IN (1))Server Type: ApacheRequest Method: POSTQuery String: action=add_listingRefereer: http://50sfood.com/admin/index.php?a...erty_classUser Agent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; SLCC1; .NET CLR 2.0.50727; .NET CLR 3.0.04506)Request URI: /admin/index.php?action=add_listingPOST Variables: array ('action' => 'create_new_listing','title' => 'home1','or_owner' => '3','notes' => '','mlsexport' => 'no','property_class' => array (0 => '1',),'address' => 'any','garage_size' => '','city' => 'any','state' => 'AK','zip' => '80504','country' => '','neighborhood' => '','price' => '','full_desc' => '','beds' => '','baths' => '','floors' => '','year_built' => '','sq_feet' => '','lot_size' => '','prop_tax' => '','status' => 'Active','mls' => '',)GET Variables: array ('action' => 'add_listing','printer_friendly' => false,)

  3. #3
    Join Date
    Jun 2008
    Location
    Lithuanian capital :)
    Posts
    278

    Default Re: SQL error, need some help please

    Hi, in you should run query that failed in phpmyadmin.
    Open it and in SQL window run:
    PHP Code:
    INSERT INTO default0_en_listingsdb (listingsdb_titlelistingsdb_notesuserdb_idlistingsdb_activelistingsdb_mlsexportlistingsdb_creation_datelistingsdb_last_modifiedlistingsdb_expirationlistingsdb_hit_countlistingsdb_featuredVALUES ('test''test''1''yes''no''2008-12-09','2008-12-09 04:37:16',null,0,'no'
    This will tell what is the problem with MYSQL.
    Make sure you are using suitable versions of MYSQL and php.

  4. #4
    Join Date
    Dec 2008
    Posts
    2

    Default Re: SQL error, need some help please

    To run phpmyadmin, you need access to the hosting control panel right? All I've been given is the database name, username and password by the webhost. Is it possible to do anything with only that information?

    Also, I've noticed when this error happens. I did a new installation and adding listings was fine up until I deleted the example listing of the whitehouse. Then I get the following again:

    SQL statement that failed below:
    ---------------------------------------------------------
    INSERT INTO default10_en_listingsdb (listingsdb_title, listingsdb_notes, userdb_id, listingsdb_active, listingsdb_mlsexport, listingsdb_creation_date, listingsdb_last_modified, listingsdb_expiration, listingsdb_hit_count, listingsdb_featured) VALUES ('test', '', '1', 'yes', 'no', '2009-01-06','2009-01-06 18:33:31',null,0,'no')

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

    ERROR REPORT www.dreams2properties.com: January 6, 2009, 6:33:31 pm

    ---------------------------------------------------------
    SQL ERROR: INSERT INTO default10_en_listingsdb (listingsdb_title, listingsdb_notes, userdb_id, listingsdb_active, listingsdb_mlsexport, listingsdb_creation_date, listingsdb_last_modified, listingsdb_expiration, listingsdb_hit_count, listingsdb_featured) VALUES ('test', '', '1', 'yes', 'no', '2009-01-06','2009-01-06 18:33:31',null,0,'no')
    Server Type: Apache/2.2.4 (Win32) PHP/5.2.1
    Request Method: POST
    Query String: action=add_listing
    Refereer: http://www.dreams2properties.com/cre...property_class
    User Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv:1.9.0.5) Gecko/2008120122 Firefox/3.0.5
    Request URI: /crete/admin/index.php?action=add_listing
    POST Variables: array (
    'action' => 'create_new_listing',
    'title' => 'test',
    'notes' => '',
    'mlsexport' => 'no',
    'property_class' =>
    array (
    0 => '1',
    ),
    'brief' => 'test',
    'location' => 'test',
    'full_desc' => '',
    'Location_Details' => '',
    'development' => '',
    'properties' => '',
    'price' => '',
    )
    GET Variables: array (
    'action' => 'add_listing',
    'printer_friendly' => false,
    )

  5. #5
    Join Date
    Jun 2008
    Location
    Lithuanian capital :)
    Posts
    278

    Default Re: SQL error, need some help please

    Try yourdomain.com/phpmyadmin

    If not, ask your hosting company how to connect to database management system

Similar Threads

  1. Error while upgrading ERROR - INSERT INTO default_classlistingsdb (class_id,listingsd
    By cellularguy in forum Installation/Configuration Help (CLOSED)
    Replies: 41
    Last Post: 03-05-2010, 06:56 AM
  2. Replies: 1
    Last Post: 09-29-2007, 08:02 PM
  3. Replies: 2
    Last Post: 04-28-2006, 12:11 AM
  4. error while upgrading LIVE SITE ERROR - ALTER TABLE default_en_memberformelements
    By cellularguy in forum Installation/Configuration Help (CLOSED)
    Replies: 6
    Last Post: 01-28-2006, 02:08 AM
  5. Installation error: Fatal error: Cannot instantiate non-existent class: misc
    By specialk in forum Installation/Configuration Help (CLOSED)
    Replies: 2
    Last Post: 11-07-2005, 02:10 PM

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
  •