Page 3 of 3 FirstFirst 123
Results 21 to 25 of 25
  1. #21
    Join Date
    Jan 2004
    Posts
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: 1146 Table Error, confused -Newsletter Discount

    Quote Originally Posted by thegolfguru View Post
    this is the error in the admin:
    1146 Table 'ncb.ncb_customers' doesn't exist
    in:
    [select count(*) as count from ncb_customers]



    and this is the error on the website when customers try to create an account or contact us:
    1146 Table 'ncb.ncb_customers' doesn't exist
    in:
    [select customers_email_format from ncb_customers where customers_email_address= '[email protected]']
    "ncb.ncb_customers"
    "ncb." is the database-name followed by a dot
    "ncb_" is the table prefix, which would match your configure.php file setting
    "customers" is the rest of the table name.

    Quote Originally Posted by thegolfguru View Post
    My prefix in both configuration files is 'ncb_' and that is the same prefix in phpmyadmin.

    However there is not a table titled 'ncb_customers'
    Correct. The error message confirms that.

    Something you (or someone/something) has done has deleted that table.
    You'll need to restore it from one of the backups you'd made before installing addons.

    Your entire store won't be able to function without that table.
    .

    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.

  2. #22
    Join Date
    Nov 2005
    Posts
    70
    Plugin Contributions
    0

    Default Re: 1146 Table 'ncb.ncb_customers' doesn't exist

    Thanks Dr. Byte. I had never accessed any tables to delete them so I'm not sure how I did it. Also I usually only backup the files I'm editing, not the db (looks like that's a lesson learned), so I have no idea how to restore my db. Do you have any suggestions of how I can fix my db that I accidentally "broke"? I see an option in my hosting admin that mentions restoring a db, will that work for me even if I don't manually backup the db?

  3. #23
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,761
    Plugin Contributions
    9

    Default Re: 1146 Table 'ncb.ncb_customers' doesn't exist

    Using a backup depends upon the date and if the table existed then

    Do you have or did you have any suctomers?

    If not, this table can be re-created as an empty table

    If you had customers you will need to find a backup somewhere to restore them
    Zen-Venom Get Bitten

  4. #24
    Join Date
    Jan 2004
    Posts
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: 1146 Table 'ncb.ncb_customers' doesn't exist

    .

    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.

  5. #25
    Join Date
    Nov 2005
    Posts
    70
    Plugin Contributions
    0

    Default Re: 1146 Table 'ncb.ncb_customers' doesn't exist

    YAY! I was able to restore the table and everything works!! Thanks for all your help Kobra and Drbyte! I will definitely be more careful next time :)

 

 
Page 3 of 3 FirstFirst 123

Similar Threads

  1. 1146 Table doesn't exist
    By Bryan G in forum Addon Payment Modules
    Replies: 9
    Last Post: 30 Jul 2011, 03:06 PM
  2. 1146 Table doesnīt exist...
    By ppsoyal in forum General Questions
    Replies: 0
    Last Post: 29 Jan 2011, 10:37 PM
  3. 1146 Table 'XXXX.zen_configuration' doesn't exist in: [db_cache table]
    By CheapStairParts in forum General Questions
    Replies: 1
    Last Post: 4 Jan 2011, 12:39 AM
  4. 1146 Table Doesn't Exist
    By pazdar in forum Templates, Stylesheets, Page Layout
    Replies: 2
    Last Post: 3 Jan 2008, 07:44 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
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR