Catalog Page

[edge1234]

:-" Help!!! I am new to osCommerce and I am currently trying to setup the adminstration info. I did a test backup in the database backup but later deleted it. When I went to view the catalog site it was gone and the number 1146 and some other info was there. Can you help. I think it is a simple fix but I am having a hard time finding it in the documentation. Thanks B-

[gunfodder]

I'm still a noob, but will give a shot.

 

Are the index.php and other files still there?

Is it just the databases that are missing?

What changes have you made from the default install?

[edge1234]

I'm still a noob, but will give a shot.

 

Are the index.php and other files still there?

Is it just the databases that are missing?

What changes have you made from the default install?

 

 

Yes, the index.php files are still there?

what is missing is the catalog page that displays the products, and prices etc. It is the opening store page that is missing.

The only changes I have made was replacing the osCommerce logo and deleting the test backup I performed. Other than that, I have just started to fill in the info for the Admin section that's it. Thanks, B-

[♥geoffreywalton]

Hi

 

I have just googled "oscommerce 1146"

 

Most of the results are

 

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

 

select coupon_code from TABLE_COUPONS where coupon_id=''

 

[TEP STOP]

 

This information is really very helpfull when trying to debug remotely.

 

Please tell us your sites address and post the full error message.

 

It looks like you have either not installed a contribution correctly or there is a problem with the db but need more info.

 

Have you installed any contributions or changed the code in any way?

[edge1234]

Hi

 

I have just googled "oscommerce 1146"

 

Most of the results are

 

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

 

select coupon_code from TABLE_COUPONS where coupon_id=''

 

[TEP STOP]

 

This information is really very helpfull when trying to debug remotely.

 

Please tell us your sites address and post the full error message.

 

It looks like you have either not installed a contribution correctly or there is a problem with the db but need more info.

 

Have you installed any contributions or changed the code in any way?

[edge1234]

Thanks Geoffrey,

 

This is the result on my online catalog page:

 

1146 - Table 'howzeart_p_os1.zones_to_geo_zones' doesn't exist

 

select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '223') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '44') and tr.tax_class_id = '1' group by tr.tax_priority

 

[TEP STOP]

 

I have been researching the online documentation but can't seem to find a fix. I have not uploaded my sight to the web just yet-just started. I am talking about the online catalog that you view from the administration site, that is what's not there. Instead, i am getting the above message.

 

Thanks, B-

 

 

I will continue to view the documentation.

[♥geoffreywalton]

This indicate that a table called howzeart_p_os1.zones_to_geo_zones is missing.

 

Normally it would be looking for zones_to_geo_zones.

 

I suspect you have edited a configuration file so it is prefixing the table names with howzeart_p_os1

 

Can you search all your files on your local site for "howzeart_p_os1"?

[edge1234]

This indicate that a table called howzeart_p_os1.zones_to_geo_zones is missing.

 

Normally it would be looking for zones_to_geo_zones.

 

I suspect you have edited a configuration file so it is prefixing the table names with howzeart_p_os1

 

Can you search all your files on your local site for "howzeart_p_os1"?

 

 

 

I am going to search for this to see what I come up with. I will post back with my findings.

 

Thanks B-

[edge1234]

This indicate that a table called howzeart_p_os1.zones_to_geo_zones is missing.

 

Normally it would be looking for zones_to_geo_zones.

 

I suspect you have edited a configuration file so it is prefixing the table names with howzeart_p_os1

 

Can you search all your files on your local site for "howzeart_p_os1"?

 

I found on my personal desktop a file named db_howzeart_p_os1-20071005084642.sql. I believe this file was created when I selected restore backup in the database backup section of the administration. Should this file get uploaded in order to view the online catalog from the administration site?

 

 

Thanks, B-

[♥geoffreywalton]

Maybe I should have said search in all the files ending .php.

 

Window explorer (yeuch) can do this.

 

The sql file should contain statements that will rebuild the database behind the shop.