Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

1146 - Table 'xxxx.discount' doesn't exist


lilitoy

Recommended Posts

Posted

Hello,

 

I need some help and maybe someone recognize this problem?

 

When I wont to delete a product in admin I get this error.

 

 

1146 - Table 'xxxx.discount' doesn't exist

delete from discount where products_id = '966'

 

 

It was being a long time that I have deleted a product so I have no clue when it started.

 

I have tried to make a Table Discount on my sql, but that was totally wrong.

 

Anyone can help me?

 

Thanks in advance

Lili

Posted

Looks like you should have a discount table with a field called products_id.

 

The question is what other fields should be there as well.

 

G

Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile

 

Virus Threat Scanner

My Contributions

Basic install answers.

Click here for Contributions / Add Ons.

UK your site.

Site Move.

Basic design info.

 

For links mentioned in old answers that are no longer here follow this link Useful Threads.

 

If this post was useful, click the Like This button over there ======>>>>>.

Posted

Hello,

 

I really don’t now.

 

When I look at My sql I have no “discount table”

 

These Tables I do have:

 

‘discount_categories’

‘products_discount plus’

‘products_to_discount_categories’

 

Would it be something to do with them?

 

Lili

Posted
When I look at My sql I have no “discount table”

 

Which is why you are getting this error message.....

Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile

 

Virus Threat Scanner

My Contributions

Basic install answers.

Click here for Contributions / Add Ons.

UK your site.

Site Move.

Basic design info.

 

For links mentioned in old answers that are no longer here follow this link Useful Threads.

 

If this post was useful, click the Like This button over there ======>>>>>.

Posted

Yes Geoffrey,

 

I have taking an other look at the latest contri's that I have installed, looked at my backups,

and I can't find any where a sql code for this table.

 

Would it be possible to try some sql codes and see what happens?

I have tried it myself but I really not skilled for it.

 

Lili

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...