2 very simple problems for someone? please help

September 9, 2008

hey guys, thanks for taking the time to have a look at my problems... first look at my site

the first problem is very simple to fix i think, its the catagory column on the left, there is a line through the compact mirrors because it had to go onto 2 lines, i would like a way to change this so it does a vertical wrap, so if the name goes onto two lines, the box will automatically 'grow' lol, it looks like its fixed atm...

secondly, click on 'new products', and you get this message:

1054 - Unknown column 'p.products_status' in 'where clause'

select count(*) as total from products_description pd where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1'

[TEP STOP]

edit: a 3rd problem i forgot about, if you go to the link above, you will see one product, 'Silver Heart Shape By', it is supposed to be Silver Heart Shape, the 'by' part, used to be followed by the manufacturer name because this was a template, i no longer need any manufacturers, but cannot get rid of the 'by' bit...

someone please help! it worked earlier tonight and i dont know what i've changed :(

thanks again everyone

September 9, 2008

First problem in index.php

Find this line:

and change it to :

or just change the <td height="31" to height="35" or as big as needed to include both lines

--------------------------------------------------------------------------------------------------------------------------------

second problem

Try uploading a fresh copy of products_new.php or if you previously changed the DB to remove the column, I would reinstall your backup.

-------------------------------------------------------------------------------------------------------------------------------------

Third problem

I am sorry I can't help you with because I can't see the changes made by the template creator. I would check the english.php for that description.

Chris

September 9, 2008

First problem in index.php

Find this line:

<td height="31" class="infoBoxHeading" nowrap><img src="images/infobox/corner_right.gif" border="0" alt="" width="2" height="31"></td>

and change it to :

<td height="31" class="infoBoxHeading" wrap><img src="images/infobox/corner_right.gif" border="0" alt="" width="2" height="31"></td>

or just change the <td height="31" to height="35" or as big as needed to include both lines

--------------------------------------------------------------------------------------------------------------------------------

second problem

Try uploading a fresh copy of products_new.php or if you previously changed the DB to remove the column, I would reinstall your backup.

-------------------------------------------------------------------------------------------------------------------------------------

Third problem

I am sorry I can't help you with because I can't see the changes made by the template creator. I would check the english.php for that description.

Chris

Hey, thanks alot for your help, I fixed the products_new problem by uploading a fresh one like you said, works perfect...

In catalog/includes/languages/english.php, i found this line:

define('TEXT_BY', ' by ');

do you think this could have something to do with my 3rd problem? I tried removing it but it didnt change anything...

Unfortunately, the line that you stated is not to be found anywhere in my index.php, take a look at this:

<?php
/*
 $Id: index.php,v 1.1 2003/06/11 17:37:59 hpdl Exp $

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

 Copyright (c) 2003 osCommerce

 Released under the GNU General Public License
*/

 require('includes/application_top.php');

// the following cPath references come from application_top.php
 $category_depth = 'top';
 if (isset($cPath) && tep_not_null($cPath)) {
$categories_products_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS_TO_CATEGORIES . " where categories_id = '" . (int)$current_category_id . "'");
$cateqories_products = tep_db_fetch_array($categories_products_query);
if ($cateqories_products['total'] > 0) {
  $category_depth = 'products'; // display products
} else {
  $category_parent_query = tep_db_query("select count(*) as total from " . TABLE_CATEGORIES . " where parent_id = '" . (int)$current_category_id . "'");
  $category_parent = tep_db_fetch_array($category_parent_query);
  if ($category_parent['total'] > 0) {
	$category_depth = 'nested'; // navigate through the categories
  } else {
	$category_depth = 'products'; // category has no products, but display the 'no products' message
  }
}
 }

 require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_DEFAULT);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html <?php echo HTML_PARAMS; ?>>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">
<title><?php echo TITLE; ?></title>
<base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>">
<link rel="stylesheet" type="text/css" href="stylesheet.css">
</head>
<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0">
<!-- header //-->
<?php require(DIR_WS_INCLUDES . 'header.php'); ?>
<!-- header_eof //-->

<!-- body //-->
<table border="0" width="769" cellspacing="0" cellpadding="0" bgcolor="#FFFFFF" style="padding-bottom:3px; ">
 <tr>
  <td align="center">
<table border="0" width="769" cellspacing="0" cellpadding="0">
 <tr>
<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="0">
<!-- left_navigation //-->
<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>
<!-- left_navigation_eof //-->
</table></td>
<!-- body_text //-->
<?php
 if ($category_depth == 'nested') {
$category_query = tep_db_query("select cd.categories_name, c.categories_image from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.categories_id = '" . (int)$current_category_id . "' and cd.categories_id = '" . (int)$current_category_id . "' and cd.language_id = '" . (int)$languages_id . "'");
$category = tep_db_fetch_array($category_query);
?>
<td width="120%" valign="top" style="padding:0px 4px; "><table border="0" width="120%" cellspacing="0" cellpadding="0">

  <tr>
	<td valign="top"><table border="0" width="120%" cellspacing="0" cellpadding="0">
	  <!--<tr>
		<td valign="top"><table border="0" width="120%" cellspacing="0" cellpadding="0">
		  <tr>-->
<?php
if (isset($cPath) && strpos('_', $cPath)) {
// check to see if there are deeper categories within the current category
  $category_links = array_reverse($cPath_array);
  for($i=0, $n=sizeof($category_links); $i<$n; $i++) {
	$categories_query = tep_db_query("select count(*) as total from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '" . (int)$category_links[$i] . "' and c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "'");
	$categories = tep_db_fetch_array($categories_query);
	if ($categories['total'] < 1) {
	  // do nothing, go through the loop
	} else {
	  $categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.categories_image, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '" . (int)$category_links[$i] . "' and c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "' order by sort_order, cd.categories_name");
	  break; // we've found the deepest category the customer is in
	}
  }
} else {
  $categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.categories_image, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '" . (int)$current_category_id . "' and c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "' order by sort_order, cd.categories_name");
}

$number_of_categories = tep_db_num_rows($categories_query);

$rows = 0;
while ($categories = tep_db_fetch_array($categories_query)) {
  $rows++;
  $cPath_new = tep_get_path($categories['categories_id']);
  $width = (int)(100 / MAX_DISPLAY_CATEGORIES_PER_ROW) . '%';
 // echo '				<td align="center" class="smallText" width="' . $width . '" valign="top"><a href="' . tep_href_link(FILENAME_DEFAULT, $cPath_new) . '">' . tep_image(DIR_WS_IMAGES . $categories['categories_image'], $categories['categories_name'], SUBCATEGORY_IMAGE_WIDTH, SUBCATEGORY_IMAGE_HEIGHT) . '<br>' . $categories['categories_name'] . '</a></td>' . "\n";
  if ((($rows / MAX_DISPLAY_CATEGORIES_PER_ROW) == floor($rows / MAX_DISPLAY_CATEGORIES_PER_ROW)) && ($rows != $number_of_categories)) {
 //   echo '			  </tr>' . "\n";
 //   echo '			  <tr>' . "\n";
  }
}

// needed for the new products module shown below
$new_products_category_id = $current_category_id;
?>
		 <!-- </tr>
		</table></td>
	  </tr>-->

	 <?php include(DIR_WS_MODULES . FILENAME_NEW_PRODUCTS); ?>
	 <tr>
	  <td height="103" width="100%" align="center" style="padding:3px 0px 0px 0px; "><a href="<?php echo FILENAME_DEFAULT.'?cPath=31_34'; ?>"><img src="images/eyes.jpg" width="410" height="103" border="0" /></a></td>
  </tr>  
	</table></td>
  </tr>
</table></td>
<?php
 } elseif ($category_depth == 'products' || isset($HTTP_GET_VARS['manufacturers_id'])) {
// create column list
$define_list = array('PRODUCT_LIST_MODEL' => PRODUCT_LIST_MODEL,
					 'PRODUCT_LIST_NAME' => PRODUCT_LIST_NAME,
					 'PRODUCT_LIST_MANUFACTURER' => PRODUCT_LIST_MANUFACTURER,
					 'PRODUCT_LIST_PRICE' => PRODUCT_LIST_PRICE,
					 'PRODUCT_LIST_QUANTITY' => PRODUCT_LIST_QUANTITY,
					 'PRODUCT_LIST_WEIGHT' => PRODUCT_LIST_WEIGHT,
					 'PRODUCT_LIST_IMAGE' => PRODUCT_LIST_IMAGE,
					 'PRODUCT_LIST_BUY_NOW' => PRODUCT_LIST_BUY_NOW);

asort($define_list);

$column_list = array();
reset($define_list);
while (list($key, $value) = each($define_list)) {
  if ($value > 0) $column_list[] = $key;
}

$select_column_list = '';

for ($i=0, $n=sizeof($column_list); $i<$n; $i++) {
  switch ($column_list[$i]) {
	case 'PRODUCT_LIST_MODEL':
	  $select_column_list .= 'p.products_model, ';
	  break;
	case 'PRODUCT_LIST_NAME':
	  $select_column_list .= 'pd.products_name, ';
	  break;
	case 'PRODUCT_LIST_MANUFACTURER':
	  $select_column_list .= 'm.manufacturers_name, ';
	  break;
	case 'PRODUCT_LIST_QUANTITY':
	  $select_column_list .= 'p.products_quantity, ';
	  break;
	case 'PRODUCT_LIST_IMAGE':
	  $select_column_list .= 'p.products_image, ';
	  break;
	case 'PRODUCT_LIST_WEIGHT':
	  $select_column_list .= 'p.products_weight, ';
	  break;
  }
}

// show the products of a specified manufacturer
if (isset($HTTP_GET_VARS['manufacturers_id'])) {
  if (isset($HTTP_GET_VARS['filter_id']) && tep_not_null($HTTP_GET_VARS['filter_id'])) {
// We are asked to show only a specific category
	$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$HTTP_GET_VARS['filter_id'] . "'";
  } else {
// We show them all
	$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'";
  }
} else {
// show the products in a given categorie
  if (isset($HTTP_GET_VARS['filter_id']) && tep_not_null($HTTP_GET_VARS['filter_id'])) {
// We are asked to show only specific catgeory
	$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['filter_id'] . "' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'";
  } else {
// We show them all
	$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'";
  }
}

if ( (!isset($HTTP_GET_VARS['sort'])) || (!ereg('[1-8][ad]', $HTTP_GET_VARS['sort'])) || (substr($HTTP_GET_VARS['sort'], 0, 1) > sizeof($column_list)) ) {
  for ($i=0, $n=sizeof($column_list); $i<$n; $i++) {
	if ($column_list[$i] == 'PRODUCT_LIST_NAME') {
	  $HTTP_GET_VARS['sort'] = $i+1 . 'a';
	  $listing_sql .= " order by pd.products_name";
	  break;
	}
  }
} else {
  $sort_col = substr($HTTP_GET_VARS['sort'], 0 , 1);
  $sort_order = substr($HTTP_GET_VARS['sort'], 1);
  $listing_sql .= ' order by ';
  switch ($column_list[$sort_col-1]) {
	case 'PRODUCT_LIST_MODEL':
	  $listing_sql .= "p.products_model " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name";
	  break;
	case 'PRODUCT_LIST_NAME':
	  $listing_sql .= "pd.products_name " . ($sort_order == 'd' ? 'desc' : '');
	  break;
	case 'PRODUCT_LIST_MANUFACTURER':
	  $listing_sql .= "m.manufacturers_name " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name";
	  break;
	case 'PRODUCT_LIST_QUANTITY':
	  $listing_sql .= "p.products_quantity " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name";
	  break;
	case 'PRODUCT_LIST_IMAGE':
	  $listing_sql .= "pd.products_name";
	  break;
	case 'PRODUCT_LIST_WEIGHT':
	  $listing_sql .= "p.products_weight " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name";
	  break;
	case 'PRODUCT_LIST_PRICE':
	  $listing_sql .= "final_price " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name";
	  break;
  }
}
?>
<td width="100%" valign="top" style="padding:0px 5px; "><table border="0" width="100%" cellspacing="0" cellpadding="0">
  <tr>
	<td><table border="0" width="100%" cellspacing="0" cellpadding="0">
	  <tr>
		<td class="pageHeading">
<?php



// optional Product List Filter
if (PRODUCT_LIST_FILTER > 0) {
  if (isset($HTTP_GET_VARS['manufacturers_id'])) {
	$filterlist_sql = "select distinct c.categories_id as id, cd.categories_name as name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where p.products_status = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and p2c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "' and p.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "' order by cd.categories_name";
  } else {
	$filterlist_sql= "select distinct m.manufacturers_id as id, m.manufacturers_name as name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_MANUFACTURERS . " m where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and p.products_id = p2c.products_id and p2c.categories_id = '" . (int)$current_category_id . "' order by m.manufacturers_name";
  }
  $filterlist_query = tep_db_query($filterlist_sql);
  if (tep_db_num_rows($filterlist_query) > 1) {
	$txt= '			' . tep_draw_form('filter', FILENAME_DEFAULT, 'get') . '     ';
	if (isset($HTTP_GET_VARS['manufacturers_id'])) {
	  $txt.=tep_draw_hidden_field('manufacturers_id', $HTTP_GET_VARS['manufacturers_id']);
	  $options = array(array('id' => '', 'text' => TEXT_ALL_CATEGORIES));
	} else {
	  $txt.=tep_draw_hidden_field('cPath', $cPath);
	  $options = array(array('id' => '', 'text' => TEXT_ALL_MANUFACTURERS));
	}
	$txt.=tep_draw_hidden_field('sort', $HTTP_GET_VARS['sort']);
	while ($filterlist = tep_db_fetch_array($filterlist_query)) {
	  $options[] = array('id' => $filterlist['id'], 'text' => $filterlist['name']);
	}
	$txt.=tep_draw_pull_down_menu('filter_id', $options, (isset($HTTP_GET_VARS['filter_id']) ? $HTTP_GET_VARS['filter_id'] : ''), 'onchange="this.form.submit()"');
	$txt.='</form></div></td>' . "\n";
  }
}

// Get the right image for the top-right
$image = DIR_WS_IMAGES . 'table_background_list.gif';
if (isset($HTTP_GET_VARS['manufacturers_id'])) {
  $image = tep_db_query("select manufacturers_image from " . TABLE_MANUFACTURERS . " where manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'");
  $image = tep_db_fetch_array($image);
  $image = $image['manufacturers_image'];
} elseif ($current_category_id) {
  $image = tep_db_query("select categories_image from " . TABLE_CATEGORIES . " where categories_id = '" . (int)$current_category_id . "'");
  $image = tep_db_fetch_array($image);
  $image = $image['categories_image'];
}
if (!isset($HTTP_GET_VARS['manufacturers_id']))
{
$cat='SELECT categories_id, language_id , categories_name FROM categories_description WHERE categories_id = '.(int)$current_category_id.' AND language_id = '.(int)$languages_id.' LIMIT 0, 30 ';
  $cat=tep_db_query($cat);
$cat = tep_db_fetch_array($cat);
$info_box_contents = array();
$info_box_contents[] = array('text' => $cat['categories_name'].$txt); new infoBoxHeading($info_box_contents, true, true, false); 

}
else
{
$cat='SELECT manufacturers_name FROM '. TABLE_MANUFACTURERS .' WHERE manufacturers_id = '.$HTTP_GET_VARS['manufacturers_id'].' LIMIT 0, 30 ';
  $cat=tep_db_query($cat);
$cat = tep_db_fetch_array($cat);
$info_box_contents[] = array('text' => $cat['manufacturers_name'].$txt); new infoBoxHeading($info_box_contents, true, true, false); 

}	


?>

	  </tr>
	</table></td>
  </tr>
<tr>
			<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '1'); ?></td>
  </tr>
  <tr>
	  <td  valign="top" height="430" class='infoBox1'>
		<table border="0" cellpadding="0" cellspacing="0" width="100%" >
		  <tr>
			<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
		  </tr>
		  <tr>
			<td bgcolor="#FFFFFF" style="padding:0px 5px; " height="352" valign="top"><?php include(DIR_WS_MODULES . FILENAME_PRODUCT_LISTING); ?></td>
		  </tr>
		 </table>
		</td>
	</tr>	

</table></td>
<?php
 } else { // default page
?>
<td width="100%" valign="top" style="padding:0px 4px; "><table border="0" width="100%" cellspacing="0" cellpadding="0">

  <tr>
	<td><table border="0" width="100%" cellspacing="0" cellpadding="0">
	   <?php include(DIR_WS_MODULES . FILENAME_NEW_PRODUCTS); ?>
<?php
//include(DIR_WS_MODULES . FILENAME_UPCOMING_PRODUCTS);
?>
	</table></td>
  </tr>
 <tr>
	  <td height="103" width="100%" align="center" style="padding:3px 0px 0px 0px; "><a href="<?php echo FILENAME_DEFAULT.'?cPath=31_34'; ?>"><img src="images/eyes.jpg" width="410" height="103" border="0" /></a></td>
  </tr>
</table></td>
<?php
 }
?>
<!-- body_text_eof //-->
<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH_RIGHT; ?>" cellspacing="0" cellpadding="0">
<!-- right_navigation //-->
<?php require(DIR_WS_INCLUDES . 'column_right.php'); ?>
<!-- right_navigation_eof //-->
</table></td>
 </tr>

</table>
	</td>
  </tr>
</table>

<!-- body_eof //-->

<!-- footer //-->
<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>
<!-- footer_eof //-->
<br>
</body>
</html>
<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

September 9, 2008

Hi Chris

Your right, that line would more than likely be found in column_left.php or categories.php. It was late when I responded.

In the english file, the define('TEXT_BY', ' by '); change it to define('TEXT_BY', ' '); and see what happens. It sounds like that is it.

Chris

September 9, 2008

Hi Chris,

right i changed it to ('TEXT_BY', 'by') to ('TEXT_BY',' '); yet nothing changed, i also tried removing the line altogether, but the site still didn't change, which is really confusing me now...

also, that line is not in column_left.php or catagories.php either :( any other ideas? or would you like me to post the code from any of my files incase the line is slightly different to what you posted?

thanks again for all this

Chris

♥geoffreywalton · September 9, 2008

Is your code for mysql 4 and you are running it on mysql5. See my patches link, Mysql5 compatbility

September 9, 2008

i honestly have no idea, i just installed the template, is there a way i can check?

♥geoffreywalton · September 9, 2008

Server info in your admin area

September 9, 2008

under serverinfo it says:

Database: MySQL 5.0.32-Debian_7etch6-log

so mysql 5 but i dont know what the original code was written for, unless thats under serverinfo somewhere too...

♥geoffreywalton · September 9, 2008

My sql 5 compatibility patches can be found by following the patches link in my signature block.

September 9, 2008

i dont mean to be rude but what problem will these patches help with?

♥geoffreywalton · September 9, 2008

The problem that the syntax of mysql command changed between version 4 and 5. Or if you prefer the problem that you get error messages like this

1054 - Unknown column 'p.products_status' in 'where clause'

select count(*) as total from products_description pd where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1'

[TEP STOP]

Your site was developed in the days of mysql4, now you are running it on a server using mysql5.

September 9, 2008

oh right ok, i just tried installing the patches but the lines i was supposed to add, where already there, not the ones i was supposed to change?

also, i fixed that p.products_status problem by uploading a fresh products_new.php :)

September 10, 2008

I'm still lost on the 'by' problem and also the layout problem with the catagories box :(

lindsayanng · September 10, 2008

does that "by" only show on the featured products??

if so, post your catalog.includes/modules/featured_products.php file.

We can probably completely remove that.

oh yea.. your site is really wacky in firefox. Your top header links (about us, specials, advanced search) are listed vertically and the box is super wide.. your categories box is screwy.. the product info page is REALLY bad. it expands across the entire screen (not centered)

persoanlly, i think you could be ok skipping the template the building a similar site yourself..

FIMBLE · September 10, 2008

Possibly something to do with ultra pics?

The rest of the pages seem OK (for a template)

Its the same in IE and Chrome.

I agree with Lindsay, better to DIY

Nic

September 11, 2008

thanks for your input guys... but it looks wrong in your browsers really? thats kinda strange, I use IE, opera and firefox and it looks perfect on them all to me... on 2 different computers, hmmm...

in regards to the 'by' thing, yeah its just on the items on the front page, if you actually click on new products or somethin, the 'by' isnt there... but i do not have a catalog.includes/modules/featured_products.php file :S

and about the DIY thing, i really wish i could, I have virtually no experience in php...

thanks again everyone

lindsayanng · September 12, 2008

yes.. it looks realy wrong in firefox for me. I think i explained the alignment thing above.. I cant image the screen size would have anything to do with it, but it MIGHT, i have a widescreen hi res.

About your "no experience"

YOu dont need NO EXPERIENCE.. you almost need MORE experience to be able to fix and work with a table! I didnt even know what FTP was. Just about a year ago, i had NO CLUE how to take a basic html website i made in dreamweaver and put it onto a website. I had NO CLUE that there was any other type of website code other than HTML, and has NO CLUE what server side meant, and didnt know that PHP existed.

Here i am, one year later, successfully working on TWO website and getting pretty far with them!

If you wanna se what a newbie with no experience could do, look here:

bscphoto

furry family

both are still under construction and NEED more work, but you can see a bunch of GOOD changes i made with my VERY little knowldge.. I dont have VERY LITTLE KNOWLEDGE anymore because i bought books and read a bunch of stuff in them AND on the net.. its awesome, and i learned something new!!

September 12, 2008

I am actually learning some stuff as i go along and i think im doing ok, these two small problems just have me stumped, i have checked everything I can think of. I see using and editing a template as a faster way to learn than starting fresh as I am under pressure and unfortunately don't have a year to learn everything like you did. I was recently diagnosed with cancer and therefore cannot work and have no income, But I DO have the equipment and stock to make the business work, I am just looking for a little help with the site, i.e. the 'by' thing and the problem with the way the catagories table looks as mentioned above...

I have books and dvds on html, php and flash and am slowly working through them all, i try skipping ahead to catch up faster but find myself not knowing what its talking about so i have to go back to the basics...

p.s. I am using a 24" monitor at 1920x1200 so I don't think it will be the res, and I have tried it on another computer since we spoke last which also works so I really dont know why its giving some peoples browsers a hard time :(

September 12, 2008

Update: I fixed the catagories problem, the table now looks better, still having trouble with the 'by' problem though :(

lindsayanng · September 12, 2008

your tables are still screwy though. Product info pages are REALLY bad!!

heres a screen shot of whats going on

September 14, 2008

ok this is kinda embarrassing but thats exactly how it looks on mine, which i was happy with,,, what part do you see as 'REALLY' bad in your opinion?

lindsayanng · September 15, 2008

see how when you look at the site on the main page, everything is centered and organized right under the banner. nothing goes outside of that box.. here, the columns on the right and left go WAY outside the box all the way to the edges. it SHOULD be all neatly put underneath the header.

basically, you page's size and shape should be the same through out. If the main page is centered, the rest should be centered.

I am TELLING you. You will get a lot further, more quickly if you ditch the template. I couldnt help you with fixing this.. its beyond me.

September 15, 2008

oh i see what you mean yeah, that would look alot neater,,, i'm gonna start designing a new one from scratch under a different name so i can still use this one until it's ready, thank you for your help and advice. I have 2 more questions i hope you can help with before i start the new one... How would i go about adding a new text field to the customer create new account page so a customer can input a username from my friends site to confirm a discount? this would be stored along with the rest of their details... also, in my admin, customers section, it shows 3 customers per page which is silly, how can i change this to around 40?

September 15, 2008

Hey Lindsay, take a look at the product info page now, i done a bit of fiddling with the code (i actually learnt a bit from building from blank like you said :)) an i think i made it look like what you had in mind.... get back to me, your input is always valued

2 very simple problems for someone? please help

Recommended Posts

Guest

Guest

Guest

Guest

Guest

♥geoffreywalton

Guest

♥geoffreywalton

Guest

♥geoffreywalton

Guest

♥geoffreywalton

Guest

Guest

lindsayanng

FIMBLE

Guest

lindsayanng

Guest

Guest

lindsayanng

Guest

lindsayanng

Guest

Guest

Archived

Browse

Activity