To anybody who is still having problems getting the extra fields to show up in the catalogue (the products_info_ page.. After many hours of searching and checking, this worked for me.
In catalog\product_info.php
FIND around line 120:
<p><?php echo stripslashes($product_info['products_description']); ?></p>
And add this immediately below it:
<?PHP
// START: Extra Fields Contribution
$extra_fields_query = tep_db_query("
SELECT pef.products_extra_fields_status as status, pef.products_extra_fields_name as name, ptf.products_extra_fields_value as value
FROM ". TABLE_PRODUCTS_EXTRA_FIELDS ." pef
LEFT JOIN ". TABLE_PRODUCTS_TO_PRODUCTS_EXTRA_FIELDS ." ptf
ON ptf.products_extra_fields_id=pef.products_extra_fields_id
WHERE ptf.products_id=".$HTTP_GET_VARS['products_id']." and ptf.products_extra_fields_value<>'' and (pef.languages_id='0' or pef.languages_id='".$languages_id."')
ORDER BY products_extra_fields_order");
while ($extra_fields = tep_db_fetch_array($extra_fields_query)) {
if (! $extra_fields['status']) // show only enabled extra field
continue;
echo '<b>'.$extra_fields['name'].': </b>';
echo $extra_fields['value'].'<BR>';
}
// END: Extra Fields Contribution
?>
Hope this helps somebody out!
New 
