Thread: database error

Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2006
    Posts
    93
    Plugin Contributions
    0

    Default database error

    what does this mean?

    1146 Table 'db172267970.store_featured' doesn't exist
    in:
    [select featured_id from store_featured where status = '0' and (((featured_date_available <= now() and featured_date_available != '0001-01-01') and (expires_date >= now())) or ((featured_date_available <= now() and featured_date_available != '0001-01-01') and (expires_date = '0001-01-01')) or (featured_date_available = '0001-01-01' and expires_date >= now())) ]
    If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

  2. #2
    Join Date
    Jan 2004
    Posts
    66,450
    Plugin Contributions
    81

    Default Re: database error

    It means that the table named 'store_featured' in your database named 'db172267970' cannot be accessed, presumably because the table doesn't exist.

    Zen Cart normally calls that table "featured", and since yours is calling it "store_featured", you most likely have a "table prefix" of "store_" defined in your configure.php files.

    Why the table doesn't exist is the real question, which cannot be answered without knowing a lot more about your configuration, what tables you "do" have, what your configure.php settings are, and so on.
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  3. #3
    Join Date
    Jul 2006
    Posts
    93
    Plugin Contributions
    0

    Default Re: database error

    I got it working. I had accidentally erased the table. :)

 

 

Similar Threads

  1. Error importing old database to the new database
    By wmorris in forum Upgrading to 1.5.x
    Replies: 1
    Last Post: 3 Jan 2012, 08:27 AM
  2. Replies: 4
    Last Post: 15 Oct 2010, 07:18 AM
  3. 500 Error - FastCGI error message after database installation page.
    By hungoveragain in forum Installing on a Windows Server
    Replies: 8
    Last Post: 24 Sep 2010, 03:37 PM
  4. PCI error: Potentially Exploitable Database Error Message -- links_alias table
    By srigari in forum All Other Contributions/Addons
    Replies: 5
    Last Post: 21 Jun 2009, 12:23 AM
  5. Replies: 2
    Last Post: 12 Aug 2008, 05:22 PM

Posting Permissions

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