Thread Starter
riquez
(@riquez)
I also can’t find anywhere in the basket or checkout that a customer can enter a code – something odd is going on ??
Thread Starter
riquez
(@riquez)
I looked in the eshop-install.php file where the initial tables are created
I dont have
• eshop_discount_codes
• eshop_download_orders
but i seem to have all the others. Is that normal?
Thread Starter
riquez
(@riquez)
I ran the missing table instal queries “CREATE TABLE etc
& now of course everything is suddenly working – the checkout has a box for discount codes & I can create codes in admin.
You better have your plugin to check that the tables exist -I have no idea how the script managed to skip over those 2 tables, but it did.
This is not an issue we have encountered before in the plugin’s 8+ year history, so we can only assume that this was specific to your site/install. Glad to hear that you managed to fix it.
I am having the exact same problem on at least two shop sites. I’m missing the eshop_discount_codes. How do I get it back? I do not know what the tables settings are, please help…
Thread Starter
riquez
(@riquez)
Login to mySQL (for many people this will be phpmyadmin control panel on their hosting)
Select the correct database & run the query to create the table – If found the query in the eshop-install.php file, around line 749 in my version. This is the query in my version:
CREATE TABLE eshop_discount_codes (
id int(11) NOT NULL auto_increment,
dtype tinyint(1) NOT NULL default '0',
disccode varchar(255) NOT NULL default '',
percent float(5,2) NOT NULL default '0.00',
remain varchar(11) NOT NULL default '',
used int(11) NOT NULL default '0',
enddate date NOT NULL default '0000-00-00',
live char(3) NOT NULL default 'no',
PRIMARY KEY (id),
UNIQUE KEY disccode (disccode)
);
Note that i had to modify the code slightly to change the variables $table & $charset_collate
If this doesnt work or is complex, then I would suggest to try installing it again.
