Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Product Name Length


Guest

Recommended Posts

The length of my product name field seems to be limited to 64 characters. Any idea on how to change this?

 

Mandy, did you try changing the products_name in the products_description table to something larger than 64 characters?

Bill Kellum

 

Sounds Good Productions

STS Tutorials & more: STSv4.6, STS Add-ons (STS Power Pack), STS V4 Forum STS Forum FREE TEMPLATE

Link to comment
Share on other sites

Mandy, did you try changing the products_name in the products_description table to something larger than 64 characters?

 

Bill,

 

Where would I find the products_description table to change that field? It's been a while since I've messed with our webstore. It's been running sucessfully for 3 years now. We recently wanted to add package deals, hence the need for a longer field name. Can you point me in the right direction for how to make that change? Thanks so much!

Link to comment
Share on other sites

Bill,

 

Where would I find the products_description table to change that field? It's been a while since I've messed with our webstore. It's been running sucessfully for 3 years now. We recently wanted to add package deals, hence the need for a longer field name. Can you point me in the right direction for how to make that change? Thanks so much!

 

Okay, after a little searching and thinking, I remembered how to get to the database that you are describing. I logged onto my sql server and searched for the "products_description" table and then changed the "products_name" field to 255 characters. That was the maximum that it could be set to. I've made these notes here just in case someone searches for the same need that I was having. Thanks for pointing me in the right direction.

Link to comment
Share on other sites

Okay, after a little searching and thinking, I remembered how to get to the database that you are describing. I logged onto my sql server and searched for the "products_description" table and then changed the "products_name" field to 255 characters. That was the maximum that it could be set to. I've made these notes here just in case someone searches for the same need that I was having. Thanks for pointing me in the right direction.

 

Yes, that would be correct. Most hosts allow you to use phpMyAdmin, which is a simple interface for your MySQL database, to make modifications and even backup your entire database.

Bill Kellum

 

Sounds Good Productions

STS Tutorials & more: STSv4.6, STS Add-ons (STS Power Pack), STS V4 Forum STS Forum FREE TEMPLATE

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...