Zen Cart Logo
Forums / All Other Contributions/Addons / 1146 Table 'ncb.ncb_customers' doesn't exist

1146 Table 'ncb.ncb_customers' doesn't exist

Locked

Views: 1,905

Results 21 to 25 of 25
This thread is locked. New replies are disabled.
28 Feb 2011, 11:42 PM
#21
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

1146 Table 'ncb.ncb_customers' doesn't exist

thegolfguru:

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.

thegolfguru:

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.

1 Mar 2011, 2:36 PM
#22
thegolfguru avatar

thegolfguru

New Zenner

Join Date:
Nov 2005
Posts:
68
Plugin Contributions:
0

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?

1 Mar 2011, 5:38 PM
#23
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

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

1 Mar 2011, 7:18 PM
#24
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

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.

2 Mar 2011, 3:09 PM
#25
thegolfguru avatar

thegolfguru

New Zenner

Join Date:
Nov 2005
Posts:
68
Plugin Contributions:
0

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 :)