Milmod Posted June 7, 2005 Posted June 7, 2005 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
MPeace Posted June 7, 2005 Posted June 7, 2005 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 <{POST_SNAPBACK}> 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
Milmod Posted June 7, 2005 Author Posted June 7, 2005 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
Guest Posted June 7, 2005 Posted June 7, 2005 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.
bglkk Posted June 7, 2005 Posted June 7, 2005 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
MPeace Posted June 8, 2005 Posted June 8, 2005 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
Milmod Posted June 9, 2005 Author Posted June 9, 2005 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
MPeace Posted June 9, 2005 Posted June 9, 2005 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
Milmod Posted June 9, 2005 Author Posted June 9, 2005 What should the catalog/includes/configuration file read like? David
MPeace Posted June 10, 2005 Posted June 10, 2005 What should the catalog/includes/configuration file read like? David <{POST_SNAPBACK}> 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
Recommended Posts
Archived
This topic is now archived and is closed to further replies.