Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Description Length of Products


Milmod

Recommended Posts

Hi All

 

I am trying to find out how I can adjust the length of my products discription, at the moment it seems to be set at something like 65 characters or so. I would like to extend this to a larger number so that when a customer clicks on this product they will get the full description of the item.

 

If anyone can help this would be much appreciated.

 

Thanks.

 

 

David

Link to comment
Share on other sites

Hi All

 

I am trying to find out how I can adjust the length of my products discription, at the moment it seems to be set at something like 65 characters or so. I would like to extend this to a larger number so that when a customer clicks on this product they will get the full description of the item.

 

If anyone can help this would be much appreciated.

 

Thanks.

David

 

 

David,

 

I'm not sure what you are asking for, osCommerce already works this way. When you click on a products name link it takes you to the product_info.php page to view the full product description.

 

However, the products_description and products_name fields can be found in the products_description table of your MySql database. You can change to length of the field using phpmyAdmin which you proberbly have in your control panel with your hosting company.

 

Good luck,

 

Matt

Matt Peace

Link to comment
Share on other sites

Hi Matt

 

If you go to my site www.milmod-hobbies.com and then click on Products carried.

Then choose Miniatures, Historical and 20mm from the left hand box.

 

Now you will see a whole group of Manufacturers, if you choos Battlefield Miniatures and then choose 1 of the ranges within this you will notice that the products in this have a description of the products, and if it goes too long then half of it is cut off.

 

I thought this was just the case for here, so I clicked on 1 of the items and noticed on this page that also the description isnt reading the full description of the item.

 

Its hard to explain unless you have a look at it for yourself.

 

I have heard of phpMyAdmin, but have yet to find it. I am using Oscommerce 2.2 not OScMax.

 

Ive been using Oscommerce for awhile now but still am only new at it and have alot of questions which I will ask over time.

 

Thanks for your reply, and if you can understand what I mean this would be great. If not dont worry Im sure I will work something out.

 

David

Link to comment
Share on other sites

PHPMyAdmin is what you can use to make changes to your osC DataBase. Look in your control panel (the one that came with your hosting account) and you will find something like "Mysql Databases". If you click on that you should see a link to PHPMyAdmin.

Link to comment
Share on other sites

David:

 

I tried to find the problem you described, but I didn't see where the descriptions are cut off.

 

Did notice that the site is S-L-O-W. traceroute to your server seems fine (even from N. America), so you might want to consider optimizing your oscommerce.

 

Also, a few missing images here:

http://www.milmod-hobbies.com/oscommerce/i...29_602_606_1043

 

Cheers.

"Buy the ticket, take the ride..." -HST

Link to comment
Share on other sites

I found an example of what you are trying to fix " NKVD Officer with suspects documents, wearing leather coat & pea"

 

And as above you need to access the sql database through your web hosting control panel. You then need to change to size of the field by navigating to the table products_description the field you need to change is products_name at the moment it is proberbly set to VARCHAR(65) you can change that any where up to VARCHAR(255) although the larger you have it the slower the database will run.

 

Matt

Matt Peace

Link to comment
Share on other sites

Hi Matt

 

I have done what you suggested but when I tried going into my site I got this message:

 

Warning: mysql_connect(): Access denied for user: 'mil@localhost' (Using password: YES) in /home/virtual/site27/fst/var/www/html/oscommerce/includes/functions/database.php on line 19

Unable to connect to database server!

 

What does this mean???

 

I cant access my site beyond the initial first page.

 

David

Link to comment
Share on other sites

Oh dear,

 

Changing the field size in phpmyadmin would not have had that effect on your site, something else went wrong.

 

check in the 'catalog/includes/configuration.php file' to make sure that your settings are correct.

Matt Peace

Link to comment
Share on other sites

What should the catalog/includes/configuration file read like?

 

David

 

David,

 

Only you can know that, it contains your database name, login id, password, cookie directories and domains. What you need to make sure is that the mySql username and password are correct, and if they are then check to make sure that the database server name you are using is correct also.

 

I would suggest an email to your hosting company to ask them what the i.p address or domain name of your database server is.

 

Matt

Matt Peace

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...