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

[FunkyM]

I have just installed this module V5.10c and installed everything as per the instructions, uploaded all the files and changed the other files yet I am getting this error when I try to access the Vouchers / Coupons admin section.

 

Yes I have ran the SQL and all the tables seem to exist.

 

---------------------------------------------------------------------------------------

 

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

 

select count(*) as total from TABLE_COUPONS where coupon_active='Y' and coupon_type != 'G'

 

[TEP STOP]

 

---------------------------------------------------------------------------------------

 

I have been searching through the forum section but to no avail.

 

Any help would be very much appreciated.

 

Regards

 

Funkym

Edited August 9, 2004 by FunkyM

[Guest]

this means the sql file was not executed, to update the database. go back thru the instructions, look for the sql file in the contribution or in the instructions where it tells you to update the database

[FunkyM]

Thanks John I woked out it wasn't that it was database_tables.php didn't have the tables defined. Funny thing is the instructions didn't tell me to do this either

[Sanguinarius]

Thanks John I woked out it wasn't that it was database_tables.php didn't have the tables defined. Funny thing is the instructions didn't tell me to do this either

<{POST_SNAPBACK}>

 

What needs to be changed/added/edited in database_tables.php? I'm having this same problem when I try to sign up as a new customer AND CLICK TO SUBMIT THE INFO:

 

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

 

select * from TABLE_COUPONS where coupon_code = 'newcust'

 

[TEP STOP]

 

(I'm using the current version of the CCGV module, 5.14, installed on top of a virgin copy of oSC2 ms2 if that helps.)

[Sanguinarius]

I am *THINKING* that TABLE_COUPONS should actually be just COUPONS..?

 

I ran the order_total_gv.sql sql query to create the tables. It refers to COUPONS but no TABLE_COUPONS. All the ccgv php files refer to TABLE_COUPONS but nothing about just COUPONS.

 

If I'm thinking rightly, should I change all the TABLE_COUPONS text in the php files to COUPONS, or should I change the COUPONS table in the database to be TABLE_COUPONS? The former would be more work, but probably more accurate and better in the longrun, right??

 

Also, -- just an FYI to those ferretting out French to translate to English, -- I change some French alt text (for the email, edit, delete & Report buttons) to English on coupon_admin.php...

[Sanguinarius]

I was not thinking rightly. :>

[neugi]

I was not thinking rightly. :>

 

hi i got it working:

 

in database_tables.php

 

add a line with thisc code

 

  define('TABLE_COUPONS', 'coupons');

 

best

[snazzytr]

hi i got it working:

 

in database_tables.php

 

add a line with thisc code

 

  define('TABLE_COUPONS', 'coupons');

 

best

 

my error says:

 

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

 

select count(*) as total from discount_coupons cd

 

 

i've tried adding the 'coupons' code you gave but it hasn't had any effect at all

and i can't find anything in the manual

 

any help??

[kbleyth]

I have this error appearing when I log into my admin panel as well as when I tried to register a new account through my store, a page appeared with this information on it. I am not sql knowledgeable so please bare with me in explaining if possible.

 

1146 - Table 'onlinestore.orders' doesn't exist

 

select o.orders_id, o.customers_name, greatest(o.date_purchased, ifnull(o.last_modified, 0)) as date_last_modified, s.orders_status_name, ot.text as order_total from orders o, orders_total ot, orders_status s where o.orders_id = ot.orders_id and ot.class = 'ot_total' and o.orders_status = s.orders_status_id and s.language_id = '1' order by date_last_modified desc limit 6

 

I have 2 databases installed, one is called shopping and the other is onlinestore. I am currently using my onlinestore database if this information helps. I searched to see if there was a table in the shopping db but there isnt that I could tell. I want to open my store but am afraid this is keeping customers from purchasing from me and/or even creating an account being that I got the error above when creating an account myself thru my store. Any Help is greatly Appreciated!

 

Thanks!

Kimberly

[♥geoffreywalton]

my error says:

 

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

 

select count(*) as total from discount_coupons cd

 

 

i've tried adding the 'coupons' code you gave but it hasn't had any effect at all

and i can't find anything in the manual

 

any help??

 

Emma

 

Looks like you have this in your /includes/database_tables.php

 

define('TABLE_COUPONS', 'discount_coupons');

 

This thread indicates it should be

 

define('TABLE_COUPONS', 'coupons');

 

Have a look and see what the table name should actually be.

[♥geoffreywalton]

I have this error appearing when I log into my admin panel as well as when I tried to register a new account through my store, a page appeared with this information on it. I am not sql knowledgeable so please bare with me in explaining if possible.

 

1146 - Table 'onlinestore.orders' doesn't exist

 

select o.orders_id, o.customers_name, greatest(o.date_purchased, ifnull(o.last_modified, 0)) as date_last_modified, s.orders_status_name, ot.text as order_total from orders o, orders_total ot, orders_status s where o.orders_id = ot.orders_id and ot.class = 'ot_total' and o.orders_status = s.orders_status_id and s.language_id = '1' order by date_last_modified desc limit 6

 

I have 2 databases installed, one is called shopping and the other is onlinestore. I am currently using my onlinestore database if this information helps. I searched to see if there was a table in the shopping db but there isnt that I could tell. I want to open my store but am afraid this is keeping customers from purchasing from me and/or even creating an account being that I got the error above when creating an account myself thru my store. Any Help is greatly Appreciated!

 

Thanks!

Kimberly

 

Kimberley

 

Have a look in your db onlinestore.

 

Does a table called orders exist?

 

A clean install of osc rc2a has 46 tables in it.

[kbleyth]

Kimberley

 

Have a look in your db onlinestore.

 

Does a table called orders exist?

 

A clean install of osc rc2a has 46 tables in it.

 

 

OK, I have 2 databases installed. One was the original store "shopping". We were having issues with the easypopulate and bulk uploading, so the administrator that was helping me created an additional database "onlinestore" to work on. I figured out the issue in easy populate. but I didnt realize that I was still using the (2nd) database when I began uploading products and doing attributes on them.. I looked and found the orders table under the original store database but there is NOT one under the Secondary Database "onlinestore" which has all my products in it :(

 

What happens now with all the products I've input? and how do I switch it over to the original database. or can i continue using the secondary onlinestore database and just import the missing table?

 

Ive been trying to install the Ajax Attribute Manager and am at whits end. I have approx 3000 products and doing attribs one by one. oscommerce makes me wanna pull my hair out! and I need my hair!!! LOL!

:blush:

[kbleyth]

Oh Dear God, I just found out whats wrong I think. most of the tables are disabled or no index found its saying when choose the table to view, at the bottom it says no index found in alot of them. One said disabeled, cant remember which one. am I SOL on all the work ive done so far to this database? :(

Edited January 22, 2009 by kbleyth