Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Description Length of Products


Milmod

Recommended Posts

Posted

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

Posted
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

Posted

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

Posted

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.

Posted

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

Posted

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

Posted

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

Posted

sounds like the configure.php got changed

Posted

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

Posted

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

 

David

Posted
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

Archived

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

×
×
  • Create New...