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

[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 ...

[timb22]

You ROCK, It's fixed for new orders. Thank you so much. I was freaking out

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 ...

[Ajeh]

Thanks for the update that you were able to make the change ...

Be sure to check all is working by ordering with your test customer account a number of Products with long names and make sure that you get the full order and that no debug logs are generated ...

NOTE: you should never have debug logs and if you do you should fix the issues ...

NOTE: upgrading to v154 is also a good idea ... I would suggest using a Test database and a Test working area on your domain to test the upgrade and make any updates that are needed on your working site to ensure all works before upgrading your Live site ...

[timb22]

I'm going to host a completely separate site and get it running properly before I switch it over. I have another domain name so it shouldn't be a problem. Thanks for the advise.