Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

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


lilitoy

Recommended Posts

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...