Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

product name length


stephanon

Recommended Posts

:P

 

The variable for the length of charactors in "product_name" is established in the mysql DB. By default it's set to only 64 chars.

 

here's the mySQL code to change it to 255 chars (the maximum allowed in MySQL):

 

ALTER TABLE products_description CHANGE products_name products_name VARCHAR(255) NOT NULL;

 

(the above should all fit on 1 line)

 

if you don't know how to run MySql commands on your server, here's the lowdown:

 

1) You first need shell access to your server. Telnet in (preferably via ssh)

 

2) type the following at a command prompt:

 

/usr/local/mysql/bin/mysql -h mysql.yourdomain.com -u username -p databasename

 

(ask your server for the proper location and/or MySQL domain name.

 

3) you will be prompted for a password. Enter your MySQL password.

 

then copy and paste this at the "mysql >" prompt:

 

ALTER TABLE products_description CHANGE products_name products_name VARCHAR(255) NOT NULL;

 

4) type exit and hit [ENTER]

 

DONE!

 

easy as pie.

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...