Forums / Addon Templates / 1146 Table '****.TABLE_PRODUCT_EXTRA_DESCRIPTION_EXTRA' doesn't exist problem

1146 Table '****.TABLE_PRODUCT_EXTRA_DESCRIPTION_EXTRA' doesn't exist problem

Locked

Started by alepia on 12 Dec 2009, 6:01 PM · Views: 2,142

Results 1 to 11 of 11
This thread is locked. New replies are disabled.
12 Dec 2009, 6:01 PM
#1
alepia avatar

alepia

Zen Follower

Join Date:
Dec 2008
Posts:
158
Plugin Contributions:
0

1146 Table '****.TABLE_PRODUCT_EXTRA_DESCRIPTION_EXTRA' doesn't exist problem

I can't update any of my products and zen shows me this:

1146 Table 'alepiach_zc1.TABLE_PRODUCT_EXTRA_DESCRIPTION_EXTRA' doesn't exist

What's the problem and how can I adjust it?

www.alepia.ch Alepia suisse

12 Dec 2009, 6:03 PM
#2
alepia avatar

alepia

Zen Follower

Join Date:
Dec 2008
Posts:
158
Plugin Contributions:
0

Re: 1146 Table '****.TABLE_PRODUCT_EXTRA_DESCRIPTION_EXTRA' doesn't exist problem

in:
[update TABLE_PRODUCT_EXTRA_DESCRIPTION_EXTRA set products_code = null, file_1 = null, file_2 = null, file_3 = null, file_4 = null, file_1_title = null, file_2_title = null, file_3_title = null, file_4_title = null where products_id = '27']
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.

www.alepia.ch Alepia suisse

12 Dec 2009, 10:47 PM
#3
alepia avatar

alepia

Zen Follower

Join Date:
Dec 2008
Posts:
158
Plugin Contributions:
0

Re: 1146 Table '****.TABLE_PRODUCT_EXTRA_DESCRIPTION_EXTRA' doesn't exist problem

Maybe I should say, that I can access all my admin pages, but I can't create a new product or editing it!
Moreover the alepiach_zc1 database exists!

Thank you in advance for the reply

www.alepia.ch Alepia suisse

12 Dec 2009, 11:20 PM
#4
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: 1146 Table '****.TABLE_PRODUCT_EXTRA_DESCRIPTION_EXTRA' doesn't exist problem

Check your add on ... it looks like you did not install one or more files where you should have ...

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

12 Dec 2009, 11:41 PM
#5
alepia avatar

alepia

Zen Follower

Join Date:
Dec 2008
Posts:
158
Plugin Contributions:
0

Re: 1146 Table '****.TABLE_PRODUCT_EXTRA_DESCRIPTION_EXTRA' doesn't exist problem

well I tried to re-upload all the last day uploads... but it seems that they aren't the problem.
So how can I do to adjust it?

www.alepia.ch Alepia suisse

13 Dec 2009, 12:00 AM
#6
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: 1146 Table '****.TABLE_PRODUCT_EXTRA_DESCRIPTION_EXTRA' doesn't exist problem

There should be a define for the new table:
TABLE_PRODUCT_EXTRA_DESCRIPTION_EXTRA

was a new table added to your database?

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

13 Dec 2009, 12:05 AM
#7
alepia avatar

alepia

Zen Follower

Join Date:
Dec 2008
Posts:
158
Plugin Contributions:
0

Re: 1146 Table '****.TABLE_PRODUCT_EXTRA_DESCRIPTION_EXTRA' doesn't exist problem

how can I check it?

www.alepia.ch Alepia suisse

13 Dec 2009, 3:45 AM
#9
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: 1146 Table '****.TABLE_PRODUCT_EXTRA_DESCRIPTION_EXTRA' doesn't exist problem

Could you go to your Zen Cart Admin ... and in the Tools ... Developers Tool Kit ... do a search on:
TABLE_PRODUCT_EXTRA_DESCRIPTION_EXTRA

in the bottom input box and select Catalog/Admin and see what files are calling this?

That does not appear to have anything to do with the Tell a Friend add on that you listed ... :unsure:

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

13 Dec 2009, 7:39 AM
#10
drbyte avatar

drbyte

Sensei

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

Re: 1146 Table '****.TABLE_PRODUCT_EXTRA_DESCRIPTION_EXTRA' doesn't exist problem

Sounds like you maybe tried to install this addon ... but didn't upload all the .php files properly: http://www.zen-cart.com/index.php?main_page=product_contrib_info&products_id=1129

.
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.

14 Dec 2009, 7:48 PM
#11
alepia avatar

alepia

Zen Follower

Join Date:
Dec 2008
Posts:
158
Plugin Contributions:
0

Re: 1146 Table '****.TABLE_PRODUCT_EXTRA_DESCRIPTION_EXTRA' doesn't exist problem

that addons was the problem... thank you both DrByte and Ajeh for the help :D

All the best

www.alepia.ch Alepia suisse