Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    New to the CF scene
    Join Date
    Feb 2009
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    SQL Error:Resource is not really a resource

    Hey guys! I'm going nuts here as i've never seen this error before nor can google find any solutions! I was just checking my cart admin section that records errors and i have a list of errors that go like this:

    Error [Expand log message] Database N/A Resource is not really a resource 1st Mar 2009 @ 2:47 AM

    Location:
    /home/interscr/public_html/includes/classes/class.checkout.php (Line 3147)

    Followed by:

    Error [Expand log message] Database N/A You have an error in your SQL syntax; check the manual that correspond... 1st Mar 2009 @ 2:47 AM

    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 ')' at line 1

    SELECT * FROM products WHERE productid IN ()
    Location:
    /home/interscr/public_html/includes/classes/class.checkout.php (Line 3146)

    What in the world is that all about and how do i go about fixing it please!!

    PHP Version: 5.2.6
    MySQL Version: 5.0.67-community-log
    Server Software: Apache/2.2.10 (Unix) mod_ssl/2.2.10 OpenSSL/0.9.8b mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635 PHP/5.2.6
    Operating System: Linux caracas.footholds.net 2.6.18-53.el5PAE #1 SMP Mon Nov 12 02:55:09 EST 2007 i686
    GD Version: bundled (2.0.34 compatible)
    Safe Mode: Disabled
    Remote Connection Support: CURL
    fopen (Remote URLs Enabled)
    Multi-byte Functionality: Multibyte
    iconv
    PSpell Functionality: Enabled

  • #2
    Supreme Master coder! abduraooft's Avatar
    Join Date
    Mar 2007
    Location
    N/A
    Posts
    14,861
    Thanks
    160
    Thanked 2,223 Times in 2,210 Posts
    Blog Entries
    1
    Error [Expand log message] Database N/A Resource is not really a resource 1st Mar 2009 @ 2:47 AM
    Could you post your code(without the secure informations like username/password) that used for connecting host and selecting DB?
    The Dream is not what you see in sleep; Dream is the thing which doesn't let you sleep. --(Dr. APJ. Abdul Kalam)


  •  

    Posting Permissions

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