Attribute Puzzle!

[Goshawk]

Hi,

I have taken data from a MySQL 4.0 Database, and inserted this in a new MySQL 5.0 database. Everything is going well, apart from the attributes. I have started with completely empty tables in the database for:

• products_options
• products_options_values
• products_options_values_to_products_options

Now when I create a new option name, and assign option values to this, I will not be able to insert the various options in my products.
What happens is that for the option name, I get a list of only option value 1, that keeps repeating for all the values that I have created.
Also if I create another option name, it repeats the value of option 1 several times.

180537 Contrast Colour 45 White + 0.0000 + 0
180538 Contrast Colour 45 White + 0.0000 + 0

And so on.

I think it has something to do with the number 180537 and ..538 etc, as it is a new database it surely should be starting with 000001 ..etc. But I have not been able to find that table, so I can reset it to 1.

So what ever I do, I can create several option names, but my customers will only ever be able to choose the first value of option 1

Any one know how to fix this?

Many thanks,

Goshawk

[DrByte]

Does this happen on a clean database too ?

You said you copied data from a v4 database to a v5 database. So, next question is ... does it happen if you follow the same process to a 2nd, new, v4 database as well ?

What version of Zen Cart are you using?
What addons/contributions are installed ?

[Goshawk]

I have not inserted this info in another V4 database, I am using the latest V1.3.7 Zen Cart, with the following plugins installed:

• Column Layout
• Google Froogle
• Google Sitemap
• Maxmind Orders
• Direct One Payment Module

All but Maxmind orders I have used before without a problem, I have not been able to test the Maxmind module yet.

Thanks,

Goshawk

[DrByte]

... and if you *do* set up another MySQL 4 database and follow the same steps, what happens ?

[Goshawk]

Am on to it..LOL going to try.

[Goshawk]

Hi DrByte,

I have made a backup of my MySQL 5 database, and created a new MySQL 4.1 database, and inserted the backup data.

The same is happening, only value 1 of the first option name is inserted, as many times as I have values for that option name.

Goshawk

[Ajeh]

Look at the table for:
products_options_values_to_products_options

Is the field:
products_options_values_to_products_options_id

set to auto_increment in the Extra column?

[DrByte]

Ajeh's got a good point there. When moving between MySQL versions sometimes the auto-increment setting can get dropped by the export process depending on the options selected when preparing to do the export. There are about 65 tables using auto-increment in Zen Cart.

[Goshawk]

Hi Ajey and DrByte,

Yes that is set to auto_increment.

I have a backup copy of the SQL file attached, maybe it is something quite obvious.

Goshawk