My orders are coming in with only some of the products on them. Order total correct

[timb22]

How easy is it to upgrade to 1.5.4 without messing up all the work I've done to my site?

[Ajeh]

If you look at your database in phpMyAdmin and at table products_description how long is the field for products_name?

If you look at your database in phpMyAdmin and at table orders_products how long is the field for products_name?

[timb22]

Not sure how to check that, Is it in here somewhere?

Name.JPG
name2JPG.JPG

If you look at your database in phpMyAdmin and at table products_description how long is the field for products_name?

If you look at your database in phpMyAdmin and at table orders_products how long is the field for products_name?

[Ajeh]

You can check the fields by clicking on Structure when viewing the table ...

The products_name in the table orders_products appears to only be 64 characters ...

Check the tables again for:
products_description
orders_products

and see what the size of the field:
products_name

is set to ...

Most likely, you will find that in the table:
products_description

that the size is greater than it is in the table:
orders_products

You need to have those set to the same size ... in your case 96 or more ...

[mc12345678]

Not sure how to check that, Is it in here somewhere?

Name.JPG
name2JPG.JPG

You can check the fields by clicking on Structure when viewing the table ...

The products_name in the table orders_products appears to only be 64 characters ...

Check the tables again for:
products_description
orders_products

and see what the size of the field:
products_name

is set to ...

Most likely, you will find that in the table:
products_description

that the size is greater than it is in the table:
orders_products

You need to have those set to the same size ... in your case 96 or more ...

Just for summary, like in name2JPG.JPG (The Structure tab).

[timb22]

Do I need to change the type in this to "VARCHAR" then?

Type.JPG

[Ajeh]

The products_name in the table products already is varchar and appears to be set to 255 ...

Now if you go to the table orders_products and look at the Structure you will see that it is shorter ...

You should be able to edit that field and change in from 64 to 255 to match the size that is in the table products_description ...

[mc12345678]

How easy is it to upgrade to 1.5.4 without messing up all the work I've done to my site?

The database side is easy, the upgrade process takes care of that for the most part.

The file side depends on how you made the changes you did. More specifically, what files you modified. Hopefully you created a template folder in which to put all of your customizations. Even if not, it's not so much difficult as time consuming depending on the tools available and level of experience.

Guide to the process is brought to you by Dr. Byte: http://www.zen-cart.com/entry.php?3-...d-of-upgrading