Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Problem with updating catalog database


nightd

Recommended Posts

Hello all!

 

I've a problem: after updating db structure (by altering of PRODUCTS with column adding), admin mode can't assign name to newly created category, so it was created, but had empty name. Do I think right if categories db representations are independent of product db representations? Where should I find a solution?

 

I use the snapshot from 11.15.2002

Thank you!

:cry:

Link to comment
Share on other sites

Hello all!

 

I've a problem: after updating db structure (by altering of PRODUCTS with column adding), admin mode can't assign name to newly created category, so it was created, but had empty name. Do I think right if categories db representations are independent of product db representations? Where should I find a solution?

 

I use the snapshot from 11.15.2002

Thank you!

:cry:

 

Not exactly sure what you are asking....it sounds more like something is whonky with your DB setup.

 

Categories are associated with products via their ID's in a table called products_to_categories. If you have altered the product table, it shouldn't have an effect on the category table when creating new categories.

 

One thing...if you made the change in the oscommerce.sql file to add the product in the install procedure, make sure you add a value for it in the insert into products part of the same file. Otherwise, you end up with a really screwed up DB install. (Been there, farked it all up)

 

Aodhan

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...