Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Weird Problem - Can't fill Products Description


longbeachjamie

Recommended Posts

Have you changed anything yet...edited any of the php files?

 

I've added several contributions, but nothing that edits that particular page.. I'm wondering if it might be a value in the DB? What specific table is that controlled in?

Link to comment
Share on other sites

The name of the db table is products_description

 

Then the code the draws the box is catalog/admin/categories.php

 

I've added several contributions, but nothing that edits that particular page.. I'm wondering if it might be a value in the DB? What specific table is that controlled in?
Link to comment
Share on other sites

I really don't know if something in categories.php would mess that up. I'm just going by what I would look at if this happened to me. OK, end of disclaimer :D

 

But just in case, it's worth looking at. These are lines 533-541 of a brand new categories.php file.

 

		  <tr>
		<td class="main" valign="top"><?php if ($i == 0) echo TEXT_PRODUCTS_DESCRIPTION; ?></td>
		<td><table border="0" cellspacing="0" cellpadding="0">
		  <tr>
			<td class="main" valign="top"><?php echo tep_image(DIR_WS_CATALOG_LANGUAGES . $languages[$i]['directory'] . '/images/' . $languages[$i]['image'], $languages[$i]['name']); ?> </td>
			<td class="main"><?php echo tep_draw_textarea_field('products_description[' . $languages[$i]['id'] . ']', 'soft', '70', '15', (isset($products_description[$languages[$i]['id']]) ? stripslashes($products_description[$languages[$i]['id']]) : tep_get_products_description($pInfo->products_id, $languages[$i]['id']))); ?></td>
		  </tr>
		</table></td>
	  </tr>

 

If you haven't made any changes to categories.php ...it might be worth downloading a fresh copy of that file...it can't hurt.

 

Checked the db values, everything matches up with the default - categories.php doesn't appear to be changed.... damn.
Link to comment
Share on other sites

I'm still just guessing..but

 

it is having trouble drawing text fields on any other pages, like

 

checkout_payment.php

checkout_shipping.php

contact_us.php

product_reviews_write.php

 

 

 

Still the same, damn!! I even replaced it with the a fresh original and it still appears the same...
Link to comment
Share on other sites

How about on the admin side, in the places where e-mail is sent, newsletters written, and the banner manager.

 

I do get another error (not sure if this is related) when trying to write a review: - YES NOT RELATED, fixed this error message.
Link to comment
Share on other sites

Check your catalog\admin\includes\functions\html_output.php. Have you made changes there or accidentally overrided that file with the one from the catalog?

Link to comment
Share on other sites

I checked other admin Text Areas, all are functioning correctly.

 

I also checked and used Beyond Compare to check the html_output.php file to that of the original catalog - it appears to be the same. Are you suggesting that it shouldn't be the same as the original catalog?

Link to comment
Share on other sites

I checked other admin Text Areas, all are functioning correctly.

 

I also checked and used Beyond Compare to check the html_output.php file to that of the original catalog - it appears to be the same. Are you suggesting that it shouldn't be the same as the original catalog?

there are 2 html_output.php files.

 

catalog\includes\functions\html_output.php

catalog\admin\includes\functions\html_output.php

 

they are not the same. You can get the originals from the downloads section of osc.

Link to comment
Share on other sites

there are 2 html_output.php files.

 

catalog\includes\functions\html_output.php

catalog\admin\includes\functions\html_output.php

 

they are not the same. You can get the originals from the downloads section of osc.

 

 

Both match up fine with the originals....

Link to comment
Share on other sites

Backup your categories.php file then change this code from the earlier post

 

		  <tr>
		<td class="main" valign="top"><?php if ($i == 0) echo TEXT_PRODUCTS_DESCRIPTION; ?></td>
		<td><table border="0" cellspacing="0" cellpadding="0">
		  <tr>
			<td class="main" valign="top"><?php echo tep_image(DIR_WS_CATALOG_LANGUAGES . $languages[$i]['directory'] . '/images/' . $languages[$i]['image'], $languages[$i]['name']); ?> </td>
			<td class="main"><?php echo tep_draw_textarea_field('products_description[' . $languages[$i]['id'] . ']', 'soft', '70', '15', (isset($products_description[$languages[$i]['id']]) ? stripslashes($products_description[$languages[$i]['id']]) : tep_get_products_description($pInfo->products_id, $languages[$i]['id']))); ?></td>
		  </tr>
		</table></td>
	  </tr>

 

to this

 

		  <tr>
		<td class="main" valign="top"><?php if ($i == 0) echo TEXT_PRODUCTS_DESCRIPTION; ?></td>
		<td><table border="0" cellspacing="0" cellpadding="0">
		  <tr>
			<td class="main" valign="top"><?php echo tep_image(DIR_WS_CATALOG_LANGUAGES . $languages[$i]['directory'] . '/images/' . $languages[$i]['image'], $languages[$i]['name']); ?> </td>
			<td class="main"><?php echo tep_draw_textarea_field('products_description[' . $languages[$i]['id'] . ']', 'soft', '70', '15', 'Hard-coded String'); ?></td>
		  </tr>
		</table></td>
	  </tr>

 

Check if the text area field shows properly and then restore the original file.

Link to comment
Share on other sites

ok with the code I posted you should had a text area box with 70 columns and 15 rows. By columns I mean you should be able to fit in a single line 70 characters.

 

If you see less post your catalog\admin\includes\functions\html_output.php file.

Link to comment
Share on other sites

ok with the code I posted you should had a text area box with 70 columns and 15 rows. By columns I mean you should be able to fit in a single line 70 characters.

 

If you see less post your catalog\admin\includes\functions\html_output.php file.

 

Yes, saw less, Here is the html_output.php file:

 

<?php
/*
 $Id: html_output.php,v 1.29 2003/06/25 20:32:44 hpdl Exp $

 osCommerce, Open Source E-Commerce Solutions
 http://www.oscommerce.com

 Copyright (c) 2003 osCommerce

 Released under the GNU General Public License
*/

////
// The HTML href link wrapper function
 function tep_href_link($page = '', $parameters = '', $connection = 'NONSSL') {
if ($page == '') {
  die('</td></tr></table></td></tr></table><br><br><font color="#ff0000"><b>Error!</b></font><br><br><b>Unable to determine the page link!<br><br>Function used:<br><br>tep_href_link(\'' . $page . '\', \'' . $parameters . '\', \'' . $connection . '\')</b>');
}
if ($connection == 'NONSSL') {
  $link = HTTP_SERVER . DIR_WS_ADMIN;
} elseif ($connection == 'SSL') {
  if (ENABLE_SSL == 'true') {
	$link = HTTPS_SERVER . DIR_WS_ADMIN;
  } else {
	$link = HTTP_SERVER . DIR_WS_ADMIN;
  }
} else {
  die('</td></tr></table></td></tr></table><br><br><font color="#ff0000"><b>Error!</b></font><br><br><b>Unable to determine connection method on a link!<br><br>Known methods: NONSSL SSL<br><br>Function used:<br><br>tep_href_link(\'' . $page . '\', \'' . $parameters . '\', \'' . $connection . '\')</b>');
}
if ($parameters == '') {
  $link = $link . $page . '?' . SID;
} else {
  $link = $link . $page . '?' . $parameters . '&' . SID;
}

while ( (substr($link, -1) == '&') || (substr($link, -1) == '?') ) $link = substr($link, 0, -1);

return $link;
 }

 function tep_catalog_href_link($page = '', $parameters = '', $connection = 'NONSSL') {
if ($connection == 'NONSSL') {
  $link = HTTP_CATALOG_SERVER . DIR_WS_CATALOG;
} elseif ($connection == 'SSL') {
  if (ENABLE_SSL_CATALOG == 'true') {
	$link = HTTPS_CATALOG_SERVER . DIR_WS_CATALOG;
  } else {
	$link = HTTP_CATALOG_SERVER . DIR_WS_CATALOG;
  }
} else {
  die('</td></tr></table></td></tr></table><br><br><font color="#ff0000"><b>Error!</b></font><br><br><b>Unable to determine connection method on a link!<br><br>Known methods: NONSSL SSL<br><br>Function used:<br><br>tep_href_link(\'' . $page . '\', \'' . $parameters . '\', \'' . $connection . '\')</b>');
}
if ($parameters == '') {
  $link .= $page;
} else {
  $link .= $page . '?' . $parameters;
}

while ( (substr($link, -1) == '&') || (substr($link, -1) == '?') ) $link = substr($link, 0, -1);

return $link;
 }

////
// The HTML image wrapper function
 function tep_image($src, $alt = '', $width = '', $height = '', $parameters = '') {
$image = '<img src="' . tep_output_string($src) . '" border="0" alt="' . tep_output_string($alt) . '"';

if (tep_not_null($alt)) {
  $image .= ' title=" ' . tep_output_string($alt) . ' "';
}

if (tep_not_null($width) && tep_not_null($height)) {
  $image .= ' width="' . tep_output_string($width) . '" height="' . tep_output_string($height) . '"';
}

if (tep_not_null($parameters)) $image .= ' ' . $parameters;

$image .= '>';

return $image;
 }

////
// The HTML form submit button wrapper function
// Outputs a button in the selected language
 function tep_image_submit($image, $alt = '', $parameters = '') {
global $language;

$image_submit = '<input type="image" src="' . tep_output_string(DIR_WS_LANGUAGES . $language . '/images/buttons/' . $image) . '" border="0" alt="' . tep_output_string($alt) . '"';

if (tep_not_null($alt)) $image_submit .= ' title=" ' . tep_output_string($alt) . ' "';

if (tep_not_null($parameters)) $image_submit .= ' ' . $parameters;

$image_submit .= '>';

return $image_submit;
 }

////
// Draw a 1 pixel black line
 function tep_black_line() {
return tep_image(DIR_WS_IMAGES . 'pixel_black.gif', '', '100%', '1');
 }

////
// Output a separator either through whitespace, or with an image
 function tep_draw_separator($image = 'pixel_black.gif', $width = '100%', $height = '1') {
return tep_image(DIR_WS_IMAGES . $image, '', $width, $height);
 }

////
// Output a function button in the selected language
 function tep_image_button($image, $alt = '', $params = '') {
global $language;

return tep_image(DIR_WS_LANGUAGES . $language . '/images/buttons/' . $image, $alt, '', '', $params);
 }

////
// javascript to dynamically update the states/provinces list when the country is changed
// TABLES: zones
 function tep_js_zone_list($country, $form, $field) {
$countries_query = tep_db_query("select distinct zone_country_id from " . TABLE_ZONES . " order by zone_country_id");
$num_country = 1;
$output_string = '';
while ($countries = tep_db_fetch_array($countries_query)) {
  if ($num_country == 1) {
	$output_string .= '  if (' . $country . ' == "' . $countries['zone_country_id'] . '") {' . "\n";
  } else {
	$output_string .= '  } else if (' . $country . ' == "' . $countries['zone_country_id'] . '") {' . "\n";
  }

  $states_query = tep_db_query("select zone_name, zone_id from " . TABLE_ZONES . " where zone_country_id = '" . $countries['zone_country_id'] . "' order by zone_name");

  $num_state = 1;
  while ($states = tep_db_fetch_array($states_query)) {
	if ($num_state == '1') $output_string .= '	' . $form . '.' . $field . '.options[0] = new Option("' . PLEASE_SELECT . '", "");' . "\n";
	$output_string .= '	' . $form . '.' . $field . '.options[' . $num_state . '] = new Option("' . $states['zone_name'] . '", "' . $states['zone_id'] . '");' . "\n";
	$num_state++;
  }
  $num_country++;
}
$output_string .= '  } else {' . "\n" .
				  '	' . $form . '.' . $field . '.options[0] = new Option("' . TYPE_BELOW . '", "");' . "\n" .
				  '  }' . "\n";

return $output_string;
 }

////
// Output a form
 function tep_draw_form($name, $action, $parameters = '', $method = 'post', $params = '') {
$form = '<form name="' . tep_output_string($name) . '" action="';
if (tep_not_null($parameters)) {
  $form .= tep_href_link($action, $parameters);
} else {
  $form .= tep_href_link($action);
}
$form .= '" method="' . tep_output_string($method) . '"';
if (tep_not_null($params)) {
  $form .= ' ' . $params;
}
$form .= '>';

return $form;
 }

////
// Output a form input field
 function tep_draw_input_field($name, $value = '', $parameters = '', $required = false, $type = 'text', $reinsert_value = true) {
$field = '<input type="' . tep_output_string($type) . '" name="' . tep_output_string($name) . '"';

if (isset($GLOBALS[$name]) && ($reinsert_value == true) && is_string($GLOBALS[$name])) {
  $field .= ' value="' . tep_output_string(stripslashes($GLOBALS[$name])) . '"';
} elseif (tep_not_null($value)) {
  $field .= ' value="' . tep_output_string($value) . '"';
}

if (tep_not_null($parameters)) $field .= ' ' . $parameters;

$field .= '>';

if ($required == true) $field .= TEXT_FIELD_REQUIRED;

return $field;
 }

////
// Output a form password field
 function tep_draw_password_field($name, $value = '', $required = false) {
$field = tep_draw_input_field($name, $value, 'maxlength="40"', $required, 'password', false);

return $field;
 }

////
// Output a form filefield
 function tep_draw_file_field($name, $required = false) {
$field = tep_draw_input_field($name, '', '', $required, 'file');

return $field;
 }

// BOE Access with Level Account (v. 2.2a) for the Admin Area of osCommerce (MS2) 1 of 1
// reverse comments to below lines to disable this contribution
////
// Output a selection field - alias function for tep_draw_checkbox_field() and tep_draw_radio_field()
//  function tep_draw_selection_field($name, $type, $value = '', $checked = false, $compare = '') {
//	$selection = '<input type="' . tep_output_string($type) . '" name="' . tep_output_string($name) . '"';
//
//	if (tep_not_null($value)) $selection .= ' value="' . tep_output_string($value) . '"';
//
//	if ( ($checked == true) || (isset($GLOBALS[$name]) && is_string($GLOBALS[$name]) && ($GLOBALS[$name] == 'on')) || (isset($value) && isset($GLOBALS[$name]) && (stripslashes($GLOBALS[$name]) == $value)) || (tep_not_null($value) && tep_not_null($compare) && ($value == $compare)) ) {
//	  $selection .= ' CHECKED';
//	}
//
//	$selection .= '>';
//
//	return $selection;
//  }
//
////
// Output a form checkbox field
//  function tep_draw_checkbox_field($name, $value = '', $checked = false, $compare = '') {
//	return tep_draw_selection_field($name, 'checkbox', $value, $checked, $compare);
//  }
//
////
// Output a form radio field
//  function tep_draw_radio_field($name, $value = '', $checked = false, $compare = '') {
//	return tep_draw_selection_field($name, 'radio', $value, $checked, $compare);
//  }
////
// Output a selection field - alias function for tep_draw_checkbox_field() and tep_draw_radio_field()
 function tep_draw_selection_field($name, $type, $value = '', $checked = false, $compare = '', $parameter = '') {
$selection = '<input type="' . $type . '" name="' . $name . '"';
if ($value != '') {
  $selection .= ' value="' . $value . '"';
}
if ( ($checked == true) || ($GLOBALS[$name] == 'on') || ($value && ($GLOBALS[$name] == $value)) || ($value && ($value == $compare)) ) {
  $selection .= ' CHECKED';
}
if ($parameter != '') {
  $selection .= ' ' . $parameter;
}
$selection .= '>';

return $selection;
 }

////
// Output a form checkbox field
 function tep_draw_checkbox_field($name, $value = '', $checked = false, $compare = '', $parameter = '') {
return tep_draw_selection_field($name, 'checkbox', $value, $checked, $compare, $parameter);
 }

////
// Output a form radio field
 function tep_draw_radio_field($name, $value = '', $checked = false, $compare = '', $parameter = '') {
return tep_draw_selection_field($name, 'radio', $value, $checked, $compare, $parameter);
 }
// EOE Access with Level Account (v. 2.2a) for the Admin Area of osCommerce (MS2) 1 of 1

////
// Output a form textarea field
 function tep_draw_textarea_field($name, $wrap, $width, $height, $text = '', $parameters = '', $reinsert_value = true) {
$field = '<textarea name="' . tep_output_string($name) . '" wrap="' . tep_output_string($wrap) . '" cols="' . tep_output_string($width) . '" rows="' . tep_output_string($height) . '"';

if (tep_not_null($parameters)) $field .= ' ' . $parameters;

$field .= '>';

if ( (isset($GLOBALS[$name])) && ($reinsert_value == true) ) {
  $field .= tep_output_string_protected(stripslashes($GLOBALS[$name]));
} elseif (tep_not_null($text)) {
  $field .= tep_output_string_protected($text);
}

$field .= '</textarea>';

return $field;
 }

////
// Output a form hidden field
 function tep_draw_hidden_field($name, $value = '', $parameters = '') {
$field = '<input type="hidden" name="' . tep_output_string($name) . '"';

if (tep_not_null($value)) {
  $field .= ' value="' . tep_output_string($value) . '"';
} elseif (isset($GLOBALS[$name]) && is_string($GLOBALS[$name])) {
  $field .= ' value="' . tep_output_string(stripslashes($GLOBALS[$name])) . '"';
}

if (tep_not_null($parameters)) $field .= ' ' . $parameters;

$field .= '>';

return $field;
 }

////
// Output a form pull down menu
 function tep_draw_pull_down_menu($name, $values, $default = '', $parameters = '', $required = false) {
$field = '<select name="' . tep_output_string($name) . '"';

if (tep_not_null($parameters)) $field .= ' ' . $parameters;

$field .= '>';

if (empty($default) && isset($GLOBALS[$name])) $default = stripslashes($GLOBALS[$name]);

for ($i=0, $n=sizeof($values); $i<$n; $i++) {
  $field .= '<option value="' . tep_output_string($values[$i]['id']) . '"';
  if ($default == $values[$i]['id']) {
	$field .= ' SELECTED';
  }

  $field .= '>' . tep_output_string($values[$i]['text'], array('"' => '"', '\'' => ''', '<' => '<', '>' => '>')) . '</option>';
}
$field .= '</select>';

if ($required == true) $field .= TEXT_FIELD_REQUIRED;

return $field;
 }
?>

Link to comment
Share on other sites

ok, that looks like the default. Going back to the code posted change it to this and try it.

 

'style="width: 100%"

 

		 <tr>
		<td class="main" valign="top"><?php if ($i == 0) echo TEXT_PRODUCTS_DESCRIPTION; ?></td>
		<td><table border="0" cellspacing="0" cellpadding="0">
		  <tr>
			<td class="main" valign="top"><?php echo tep_image(DIR_WS_CATALOG_LANGUAGES . $languages[$i]['directory'] . '/images/' . $languages[$i]['image'], $languages[$i]['name']); ?> </td>
			<td class="main"><?php echo tep_draw_textarea_field('products_description[' . $languages[$i]['id'] . ']', 'soft', '70', '15', (isset($products_description[$languages[$i]['id']]) ? stripslashes($products_description[$languages[$i]['id']]) : tep_get_products_description($pInfo->products_id, $languages[$i]['id'])), 'style="width:100%"'); ?></td>
		  </tr>
		</table></td>
	  </tr>

 

and try it. The text area field should alocate the full width this time. But of course is not the root of the problem. Something else must override it. Check also the catalog\admin\includes\stylesheet.css Search that file for

input

 

If there is nothing in the css you will have to post the categories.php

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...