Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

product names not showing totally (limitation of number of caracters?)


VladDrakul

Recommended Posts

I'm getting names of the products cut in the middle.

The product names are limited to a certain number of letters?

How can I increase it?

Are product names limited to 64 letters?

 

As far as i can remember, product name are limited to 64 characters in the products_description table.

 

Log into your MySQL and edit the product_name field to varchar(255)

 

Lots more space :)

Link to comment
Share on other sites

I'm not a expert in mysql.

can I do that through Cpanel ?

 

I need to enter in the mysql database? and change varchar(64) to varchar(255) ?

 

You will need access to your mysql database.

 

Your web hosting company should give you some sort of access to this. phpmyadmin maybe?

 

If you do get access to a sql interface you want to run this query:

 

ALTER TABLE `products_description` CHANGE `products_name` `products_name` VARCHAR( 255 );

 

I think this should fix your problems with the end of your product name being cut off.

 

Kindest regards,

 

Harris

Link to comment
Share on other sites

I'm not a expert in mysql.

can I do that through Cpanel ?

 

I need to enter in the mysql database? and change varchar(64) to varchar(255) ?

 

Use phpMyAdmin, log in, look at the list of tables on the left. Select products_description, when you click it a new window will open.

 

proddesc.png

 

Click the little pencil icon in the products_name row, you get a new window, change length/values to a higher value.

 

If you want to change the actual length of the input field in your admin see this thread:

 

http://www.oscommerce.com/forums/index.php?showtopic=48052

Local: Mac OS X 10.5.8 - Apache 2.2/php 5.3.0/MySQL 5.4.10 • Web Servers: Linux

Tools: BBEdit, Coda, Versions (Subversion), Sequel Pro (db management)

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...