weird thing with product variant or normal?

Christofer · #1 05-06-2009, 12:08 PM

Hello there, today i added a product and i putted 3 product variants :
Black
Pink
Silver

I went to see the product but i saw only :
Pink
Silver

I went to admin and changed it to :
Black
Pink
Silver
Black

I went again to product and i saw :
Pink
Silver
Black

Is that normal? Why the first option doesn't appear?

balinor · #2 05-06-2009, 12:17 PM

Do you have a stock level set for it?

Christofer · #3 05-06-2009, 12:34 PM

yes i have

balinor · #4 05-06-2009, 12:37 PM

Sounds buggy...

Christofer · #5 05-06-2009, 12:38 PM

well when i go to product option now i see :
black
black
silver
pink

when i go to edit the product variants i see:
black
silver
pink

cflsystems · #6 05-06-2009, 03:25 PM

All option/variant works fine for me - 4.2.1
Maybe if you repair tables...?

Christofer · #7 05-06-2009, 04:06 PM

how to repair?

cflsystems · #8 05-06-2009, 06:20 PM

phpMyAdmin or in your xcart admin backend go to the Tools section and click on "Optimize Tables". You can also do the "Check database integrity"

gb2world · #9 05-06-2009, 07:52 PM

You may as well also select Force Cache Generation as long as you are in the tools section. This rebuilds all the variants in the cache.

Christofer · #10 05-07-2009, 10:27 AM

with x-cart check database integrity i got those :
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Wrong: The table xcart_register_field_values contains some records for which related data in the table xcart_register_fields has not been found:
fieldid: 2
fieldid: 2
fieldid: 2
. . . . . . . . . . . . . . . . .

what is that?

EDIT : i found what it is, before a few days i added and extra field on register, and now i deleted it. So what i have to do with those tables? delete them?
i also did the :
Optimize tables and force cache generation
but the problem still is here..

I opened ticket to quality team. They answered me : "This is not an x-cart bug, if you see our demo it works ok. I can investigate the problem, it will cost you 40 points. Probably it is a problem by some mod you added"
But the true is that i don't have many mods.. And i think the problem was there from the start. And also many other things works on their demo, but they don't on the default x-cart 4.2 installation, like the "Save %" icon.. You have to edit the code to work. anyway