Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

discount codes error


Guest

Recommended Posts

Hi, me again!

 

I have put all of the files into my shop via my FTP - just dragged them from the Win folder to FTP.

 

My shop now shows 'Discount codes' on the side, but when I try and go in it says:

 

1146 - Table 'vangoghp_osc1.discount_coupons' doesn't exist

 

select count(*) as total from discount_coupons AS dc left join discount_coupons_to_orders AS dcto ON dc.coupons_id = dcto.coupons_id

 

What have I done wrong? How can I fix it?

 

Thank you! Helen

Link to comment
Share on other sites

I'm guessing you never ran the SQL file to add the table to the DB.

:blush:

If I suggest you edit any file(s) make a backup first - I'm not perfect and neither are you.

 

"Given enough impetus a parallelogramatically shaped projectile can egress a circular orifice."

- Me -

 

"Headers already sent" - The definitive help

 

"Cannot redeclare ..." - How to find/fix it

 

SSL Implementation Help

 

Like this post? "Like" it again over there >

Link to comment
Share on other sites

I'm guessing you never ran the SQL file to add the table to the DB.

:blush:

 

no I never, how do I do that? is there an sql file in the package?

 

thank you so much for your quick response!!

Link to comment
Share on other sites

i found the installer.sql.

 

is this where i go into my cpanel, then phpmyadmin

 

click on my database

 

click on sql

 

copy and the paste the installer text into there and 'run'?

 

(I did this before with something else).

 

Your help is so appreciated you have no idea!

Link to comment
Share on other sites

Right, I've ran the sql and everything's much better.

 

now it says I have to configure my discount by going into Modules - Order Total - Discounts - and configure it there. But, 'Discounts' isn't part of the 'Order total', I only have Shipping, Sub total, tax, and Total. If I click on 'Install Module' it just takes me to 'Low Order Fee' module for install.

 

Can anyone help again?

 

Many thanks, Helen

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...