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!
Thread: 1146, table doesn't exist
Results 1 to 5 of 5
-
10 Dec 2010, 08:27 PM #1
New Zenner
- Join Date
- Apr 2008
- Location
- Cape Cod, Massachusetts, USA
- Posts
- 26
- Plugin Contributions
- 0
1146, table doesn't exist
"It is better to be thought a fool, than to speak and remove all doubt."
~ Mark Twain
-
10 Dec 2010, 08:34 PM #2
Black Belt
- Join Date
- Aug 2005
- Location
- Arizona
- Posts
- 27,755
- Plugin Contributions
- 9
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 ZenCartZen-Venom Get Bitten
-
10 Dec 2010, 09:36 PM #3
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."It is better to be thought a fool, than to speak and remove all doubt."
~ Mark Twain
-
10 Dec 2010, 11:06 PM #4
Sensei
- Join Date
- Jan 2004
- Posts
- 66,443
- Plugin Contributions
- 279
Re: 1146, table doesn't exist
You're missing the file that defines the value for TABLE_IMAGES
.
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.
-
11 Dec 2010, 07:27 PM #5
New Zenner
- Join Date
- Apr 2008
- Location
- Cape Cod, Massachusetts, USA
- Posts
- 26
- Plugin Contributions
- 0
[SOLVED] Re: 1146, table doesn't exist
Dr. Byte totally ROCKS! Found the file, and added the definition. A hundred million thank yous!
"It is better to be thought a fool, than to speak and remove all doubt."
~ Mark Twain
Similar Threads
-
1146 Table doesn't exist
By Bryan G in forum Addon Payment ModulesReplies: 9Last Post: 30 Jul 2011, 03:06 PM -
1146 Table doesnīt exist...
By ppsoyal in forum General QuestionsReplies: 0Last Post: 29 Jan 2011, 10:37 PM -
1146 Table 'XXXX.zen_configuration' doesn't exist in: [db_cache table]
By CheapStairParts in forum General QuestionsReplies: 1Last Post: 4 Jan 2011, 12:39 AM -
1146 Table Doesn't Exist
By pazdar in forum Templates, Stylesheets, Page LayoutReplies: 2Last Post: 3 Jan 2008, 07:44 PM
