can someone tell me what this might mean?

[Guest]

i had to install an inventory into OSC db via a converted xls file (and Navicat MySQL) using tables categories, categories_description, products, products_description and prods_to_categories -

 

all the products and categories appear fine, at first, BUT there are a few admin issue...

 

one issue i might have created by making product_id varchar(12) instead of int(11) since my client insists on AlphNumeric product_id's. consequesntly the autoincrement extra was removed. seems not to have caused a problem, but i'm not sure.

 

anyway, this is the error when certain products are clicked on in Admin to Edit:

 

Warning: reset(): Passed variable is not an array or object in [/path/to]/admin/includes/classes/object_info.php on line 6

Warning: Variable passed to each() is not an array or object in [/path/to/admin/includes/classes/object_info.php on line 7

 

can anyone tell me what problems they might see in my descriptions thus far, PLEASE?

 

regards,

gn

[Bushmaster]

Why would he care about it being alphanumeric you do not put in the product_id's or even see them unless you go into the data base. changing the product Id's just changed the way the database works.

[Guest]

well, actually She used the product_id as the model no as well, and so it is visible in the descriptions. i understand what you mean, though, it could just as easily be anything as long as the model no. is correct.

 

i wasn't aware that making product_id a varchar would mess things up - not even sure if that's the problem with the errors i'm getting when attempting to edit/copy products in Admin - we've found a discrepency in the number of prods and number of prods_to_cats - fising that right now

 

 

glenn

 

 

you think it's imperative that we correct all the prod_ids to int(11) and autoincrement?