Checkout Confirmation Error

[Guest]

Hello,

 

If anyone can help, I'm going nuts here.

 

When I get to the checkout_confirmation.php page, it shows all the persons info and order info, but at the bottom of the page where its suppose to say "confirm order" it has the following error message.

 

1146 - Table 'mostly_osc1.TABLE_COUPONS' doesn't exist

 

select coupon_code from TABLE_COUPONS where coupon_id=''

 

[TEP STOP]

 

I'm not the techy that I want to be yet, can anyone help me?

 

Thanks in advance...

 

Mike

[♥yesudo]

Re-check the install instructions on the coupon module you have installed, as a database table definition appears to be missing.

[Gameprodigy]

It looks like this table Table 'mostly_osc1.TABLE_COUPONS' doesn't exist

was not installed, there should be something in the instructions about using phpmyadmin to install this table.

 

My best guess is that you install "easy coupons" contribution which requires the table coupons you should see some install instructions with code like this:

 

#
# Table structure for table 'coupons'
#

DROP TABLE IF EXISTS coupons;
CREATE TABLE coupons (
 id int(11) unsigned NOT NULL auto_increment,
 orders_id_issued int(11) unsigned NOT NULL default '0',
 orders_id_used int(11) unsigned default NULL,
 code varchar(19) NOT NULL default '',
 discount float(5,2) NOT NULL default '0.00',
 type char(1) NOT NULL default 'p',
 enddate date default NULL,
 used tinyint(1) NOT NULL default '0',
 PRIMARY KEY  (id),
 KEY code (code,used),
 KEY issued (orders_id_issued),
 KEY used (orders_id_used)
) TYPE=MyISAM;



#
# Table structure for table 'coupons_a'
#

DROP TABLE IF EXISTS coupons_a;
CREATE TABLE coupons_a (
 id int(11) unsigned NOT NULL auto_increment,
 orders_id_issued int(11) unsigned NOT NULL default '0',
 orders_id_used int(11) unsigned default NULL,
 code char(19) NOT NULL default '',
 discount float(5,2) NOT NULL default '0.00',
 type char(1) NOT NULL default 'p',
 enddate date default NULL,
 used tinyint(1) NOT NULL default '0',
 PRIMARY KEY  (id),
 KEY code (code,used)
) TYPE=MyISAM;

 

If easy coupons was not the contribution you used then these are not the correct tables, but the instructions would have a similiar look for creating database tables.

 

If you need help with tables you might want to email or Pm someone who can help, its something that can be done using C-Panel - phpmyadmin if your host supports it.

[Guest]

Thank you for the response, I am grateful.

 

I will see what I can do about this, but I think I am over my head with this part as I am not that much of a tech.

 

Hope this works!

 

Mike

[Guest]

Thank you for the response, I am grateful.

 

I will see what I can do about this, but I think I am over my head with this part as I am not that much of a tech.

 

Hope this works!

 

Mike

 

10/31/06

 

I dont seem to be able to get this working. There is nothing in the instructions for setup. If anyone wants to give it the old college try...

 

I'd be grateful

 

Mike

[Gameprodigy]

If easy Coupons was the mod you added, and if you have access to phpmyadmin using C-panel I could help you PM me.

[Guest]

If easy Coupons was the mod you added, and if you have access to phpmyadmin using C-panel I could help you PM me.

 

Hello, I do not know how to add the easy coupons. What is PM? I do have cpanel access with MyPHPAdmin.

[Gameprodigy]

Easy Coupons is refering to the name of the contribution, I don't what contribution you installed so to get the right instructions we need to find out which one was added to your site, there are quite a few different coupon contributions.

 

PM = Private message

[Guest]

Easy Coupons is refering to the name of the contribution, I don't what contribution you installed so to get the right instructions we need to find out which one was added to your site, there are quite a few different coupon contributions.

 

PM = Private message

 

When i PM you is that just to your username?

 

Im new at this here.

 

Mike

[Gameprodigy]

yes,

 

And do you know which coupon module was installed?

[Guest]

yes,

 

And do you know which coupon module was installed?

 

 

No I dont

[boxtel]

Hello,

 

If anyone can help, I'm going nuts here.

 

When I get to the checkout_confirmation.php page, it shows all the persons info and order info, but at the bottom of the page where its suppose to say "confirm order" it has the following error message.

 

1146 - Table 'mostly_osc1.TABLE_COUPONS' doesn't exist

 

select coupon_code from TABLE_COUPONS where coupon_id=''

 

[TEP STOP]

 

I'm not the techy that I want to be yet, can anyone help me?

 

Thanks in advance...

 

Mike

 

if you see references like "TABLE_XXXXX" then that means that the define for that table is not present in the includes/database_tables.php file.

 

as in :

 

define('TABLE_COUPONS', 'whatever the table is really called');

[Gameprodigy]

1146 - Table 'mostly_osc1.TABLE_COUPONS' doesn't exist

 

this error according to the coupon mod which is CCGV(trad) that table isn't supposed to exist. I was going over the install instructions and the instruction for the database tables are all mangled into one large paragrah so Im trying to decifer them, to see if your missing a table. So far it looks like they are all there. In your database_tables.php file there arn't any define(Coupons' , 'coupons'); there are no defined database tables relating to any coupon install. so i am checking that as well.