Packing Slip attributes sorting randomly

[Alfonso2013]

Hi Linda.

This is what I get after I included 3 products with 26 attributes ( 2 of 7 and 1 of 12). I have never manipulated any value here. Are they ok? do you need another view?

Thanks again for your time and concern.

[Ajeh]

I was kind of hoping to see all the fields for your customers_id for all of the products/attributes added to the customers_basket_attributes to see what is being put in each of the fields ...

[Alfonso2013]

How can I show them to you? I don't know where to click.

[Ajeh]

Let's say your customers_id was 2, you could do a search for:

SELECT *
FROM zen_customers_basket_attributes
WHERE customers_id = 2;

and obtain all the fields from the customers_basket_attributes for just customers_id 2 ...

[Alfonso2013]

Ok I hope I did it ok. The first screen is the result of the search. The second one when I click on the first attribute. I don't know how to show a table with the values of all of them at the same time. I have to check them one by one.

Sincerely:

Alfonso

[Ajeh]

You have an odd phpMyAdmin that it does not display all the fields on 1 row per attribute ...

I was hoping to spot what might be causing this issue ...

Is this a clean install of Zen Cart v1.5.1 or an upgrade?

[Alfonso2013]

Ok, my host is GoDaddy ( I know, apparently not the best host). You can ask their customer service to install the application and they did it. It is a fresh new installation.

Is everything ok in the SCR4? in product_options_sort_order dropdown Function menu shouldn't be something chosen?

Thanks again.

[Alfonso2013]

Ok, now I am investigating more the SQL table and I have one question: I can see in SCR4 that the products_options_sort_order is defined as TEXT, and the value is 10.00001, where there should be a 10 alone.
Why is defined as text? shouldn't be defined as INT or MEDIUMINT or TINYINT (any numeric definition) so the table can read it as a number and to order the attributes in ascending order?

Will that be the problem? should I try to modify that definition?

[Alfonso2013]

Ok. I could finally take a picture of the sort order of the product_option_sort_order attributes. It looks pretty messy to me. Obviously there is a mistake since I define order in integer numbers of 2 in Zen Cart admin attributes order ( SCR6), and they appear with 5 decimals and in not ascendent order. How can I fix this mess? How can I define the ascendent order?

[Ajeh]

The Sort Order and what is store in the database table for the customers_basket_attributes will appear different, but they are looking more or less correct ...