Short Description Problem

[skabullido]

Hey everybody, i need some help, i try to get more characters about short_descrip space. I think it have 250 but i try to  change this on the data base and nothing happens...

Please i appreciate your help.

[mygbn]

if its for your category page then go to components/com_virtuemart/views/category/tmpl/default.php on line about 232 you will see <?php echo shopFunctionsF::limitStringByWord($product->product_s_desc, 25, '...') ?> change the number at the end

[clementstigma]

Hi Skabullido,

Think you might be looking for changing the values of the short description.

I realised in VM2.0, besides changing the SQL DB's product_s_desc to "Text", we'll need to change the following file too:
- /administrator/components/com_virtuemart/helpers/tableupdater.php

From:
$fields['product_s_desc'] = 'varchar('.VmConfig::get('dbpsdescsize',2000).') '.$linedefault;


To:
$fields['product_s_desc'] = 'text('.VmConfig::get('dbpsdescsize',20000).') '.$linedefault;


For those of you who are wondering how to even begin changing your SQL Database:
1. Login to your MyPHPAdmin via your webhost, search for your database name which should look something like "_database name".
2. Look for the table name "prefixname_virtuemart_products_en_gb" (The prefix name should be something like abc1a)
3. A table should load, at the top of your page, you should see some navigation buttons, look at the navigation row, right below the breadcrumbs, it should be something like "Browse / Structure / SQL / Search...etc".
4. Click on "Structure"
5. Look for column name "product_s_desc" and click on the "change" button on the right side
6. Change the "Type" to "Text"
7. Delete whatever values/length there are, it should be a default of "2000", remove that completely.
8. Update your tableupdater.php as per the instructions above.