Zen Cart Logo
Forums / General Questions / 1146, table doesn't exist

1146, table doesn't exist

Locked

Views: 1,765

Results 1 to 5 of 5
This thread is locked. New replies are disabled.
10 Dec 2010, 7:27 PM
#1
swanriver avatar

swanriver

New Zenner

Join Date:
Apr 2008
Location:
Cape Cod, Massachusetts, USA
Posts:
26
Plugin Contributions:
0

1146, table doesn't exist

Hello,

Upgraded to 1.3.9h, using MySQL 5. Yes, I did backups of both the files and the database (and I'm really glad I did). Now this is a customized cart, so I knew that some of the files might need a bit of messing around with.

Well, upgrade was complete and everything seemed to be O.K. until I ran a test order, and received a SQL syntax error. Oh, bummer. So, I unpacked my backups and did a whole lot of comparing files. Got everything back in, ran my test order, and now received:

1146 Table 'table_table.TABLE_IMAGES' doesn't exist
in:
[SELECT * FROM TABLE_IMAGES WHERE customers_id='' AND orders_id='']

I looked in PHPMyAdmin, and the table is there. This site is not live yet, so I don't think it has been hacked.

Any suggestions out there? I sure would appreciate it!

10 Dec 2010, 7:34 PM
#2
kobra avatar

kobra

Black Belt

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

Re: 1146, table doesn't exist

This is normally

account_name_prefix.table_name

Or

account_name_prefix.addresses

Yours is table_table.TABLE_IMAGES

Is that actually correct?

I do not recall a table named images in ZenCart

10 Dec 2010, 8:36 PM
#3
swanriver avatar

swanriver

New Zenner

Join Date:
Apr 2008
Location:
Cape Cod, Massachusetts, USA
Posts:
26
Plugin Contributions:
0

Re: 1146, table doesn't exist

Yes, you are correct. When the cart was customized, a table was created in the database called images.

Specifically, the error is:

1146 Table 'brenda_tysbook.TABLE_IMAGES' doesn't exist
in:
[SELECT * FROM TABLE_IMAGES WHERE customers_id='' AND orders_id='']

Apologies for any confusion.

10 Dec 2010, 10:06 PM
#4
drbyte avatar

drbyte

Sensei

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

Re: 1146, table doesn't exist

You're missing the file that defines the value for TABLE_IMAGES

11 Dec 2010, 6:27 PM
#5
swanriver avatar

swanriver

New Zenner

Join Date:
Apr 2008
Location:
Cape Cod, Massachusetts, USA
Posts:
26
Plugin Contributions:
0

Re: 1146, table doesn't exist

Dr. Byte totally ROCKS! Found the file, and added the definition. A hundred million thank yous! :clap: