Problem with updating catalog database

[nightd]

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:

[Aodhan]

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