PROBLEM with database .. HELP ME URGENT

cynia Well-Known Member

Messages:: 890

Likes Received:: 9

Best Answers:: 0

Trophy Points:: 140

Digital Goods:: 1

#1

Hello

i kindly ask for your help as my self have no clue on this

i tried to install a script at my new site ebookdigistore.com and i thought i did it right

The site loads ok but when i try to do something like browse,search etc i get this

1054 - Unknown column 'p.products_id' in 'on clause'

select count(p.products_id) as total from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '6'

[TEP STOP]
Click to expand...

Can anyone help me?

cynia, Jun 10, 2008 IP

cynia Well-Known Member

Messages:: 890

Likes Received:: 9

Best Answers:: 0

Trophy Points:: 140

Digital Goods:: 1

#2

I also get this error when i try to complete the installation and fix the admin settings

I try to get in the admin area and get this

Fatal error: Cannot re-assign $this in /home/italosm/public_html/admin/includes/classes/upload.php on line 24
Click to expand...

If i could get to the admin area i could fix this i think

cynia, Jun 10, 2008 IP

Nepopec Peon

Messages:: 40

Likes Received:: 1

Best Answers:: 0

Trophy Points:: 0

#3

check your php code!
100 % trouble there

Nepopec, Jun 10, 2008 IP

Freewebspace Notable Member

Messages:: 6,213

Likes Received:: 370

Best Answers:: 0

Trophy Points:: 275

#4

cynia said: ↑

Hello

i kindly ask for your help as my self have no clue on this

i tried to install a script at my new site ebookdigistore.com and i thought i did it right

The site loads ok but when i try to do something like browse,search etc i get this

Can anyone help me?
Click to expand...

It says there is no column like this..

Freewebspace, Jun 10, 2008 IP

cynia likes this.

cynia Well-Known Member

Messages:: 890

Likes Received:: 9

Best Answers:: 0

Trophy Points:: 140

Digital Goods:: 1

#5

What should i do to be fixed?
Is it a sql problem?

cynia, Jun 12, 2008 IP

cynia Well-Known Member

Messages:: 890

Likes Received:: 9

Best Answers:: 0

Trophy Points:: 140

Digital Goods:: 1

#6

Can anyone lend a hand ?

cynia, Jun 12, 2008 IP

cynia Well-Known Member

Messages:: 890

Likes Received:: 9

Best Answers:: 0

Trophy Points:: 140

Digital Goods:: 1

#7

This is the whole index.html
This is what gives the order which produces the error

Can anyone help?

<?php /* */

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 HTML 4.01 Transitional//EN">
<html <?php echo HTML_PARAMS; ?>>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">

<title><?php echo TITLE; ?> : <?php if (isset($HTTP_GET_VARS['manufacturers_id'])) {
$category_query = tep_db_query("select manufacturers_name from " . TABLE_MANUFACTURERS . " where manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'");
$category = tep_db_fetch_array($category_query);
if ($category['manufacturers_name'] != "") {echo $category['manufacturers_name'] . '';} else { echo HEADING_TITLE;}
} else {
$category_query = tep_db_query("select cd.categories_name 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);
if ($category['categories_name'] != "") {echo $category['categories_name'];} else { echo HEADING_TITLE;}
}
?> : <?php echo STORE_SLOGAN; ?></title>
<META NAME="DESCRIPTION" CONTENT="<?php echo TITLE; ?> - <?php echo STORE_SLOGAN; ?> - <?php echo META_DESCRIPTION; ?>">

<META NAME="KEYWORDS" CONTENT="<?php echo TITLE; ?>, <?php echo META_KEYWORDS; ?>">

<META NAME="LANGUAGE" CONTENT="EN">
<META NAME="ROBOTS" CONTENT="INDEX, FOLLOW">
<META NAME="REVISIT-AFTER" CONTENT="7 DAYS">

<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">

<?php require(DIR_WS_INCLUDES . 'header.php'); ?>



<table border="0" width="100%" cellspacing="3" cellpadding="3">
<tr>
<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">

<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>

</table></td>

<?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="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td>
<img src="/images/pixel_trans.gif" width="100%" height="2"><br>
<table width="100%" cellspacing="0" cellpadding="5" >
<tr class="infoBoxHeading">
<td class="infoBoxHeading"><?php echo HEADING_TITLE; ?></td>
</tr>
</table>

</td>
</tr>
<tr>
<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
</tr>
<tr>
<td>

<table border="0" width="100%" cellspacing="0" cellpadding="1" class="infoBox">
<tr>
<td>
<table width="100%" border="0" cellpadding="4" cellspacing="4" class="infoBoxContents">
<tr>
<td class="boxtext" valign="top">

<table border="0" width="100%" cellspacing="0" cellpadding="2">
<tr>
<td><table border="0" width="100%" cellspacing="0" cellpadding="2" class=boxtext>
<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="main" width="' . $width . '" valign="top">

<a href="' . tep_href_link(FILENAME_DEFAULT, $cPath_new) . '"><u>' . $categories['categories_name'] . '</a></u></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>
<tr>
<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
</tr>
</table></td>
</tr>
</table>
</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_INFO' => PRODUCT_LIST_INFO, '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_INFO':
$select_column_list .= 'pd.products_info, ';
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, pd.products_info, 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, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id 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, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id 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, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id 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, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id 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_INFO':
$listing_sql .= "pd.products_info ". ($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"><table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td>

<img src="/images/pixel_trans.gif" width="100%" height="2"><br>
<table width="100%" cellspacing="0" cellpadding="5" >
<tr class="infoBoxHeading">
<td class="infoBoxHeading">

<?php if (isset($HTTP_GET_VARS['manufacturers_id'])) {
$category_query = tep_db_query("select manufacturers_name from " . TABLE_MANUFACTURERS . " where manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'");
$category = tep_db_fetch_array($category_query);
if ($category['manufacturers_name'] != "") {echo $category['manufacturers_name'] . '     CDs released by this label <a href="' . tep_href_link(FILENAME_DEFAULT, 'manufacturers_id=' . $manufacturer['manufacturers_id']) . '">' . $manufacturer['manufacturers_name'] . '</a>';} else { echo HEADING_TITLE;}
} else {
$category_query = tep_db_query("select cd.categories_name 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);
if ($category['categories_name'] != "") {echo $category['categories_name'];} else { echo HEADING_TITLE;}
}
?>

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

</td>
</tr>
<tr>
<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
</tr>
<tr>
<td>
<?php include(DIR_WS_MODULES . FILENAME_PRODUCT_LISTING); ?>

</td>
</tr>
</table></td>
<?php
} else { // default page
?>
<td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr>

<td class=main><img src="pixel_trans.gif" width="100%" height="2"><br>

<?php include(DIR_WS_MODULES . FILENAME_THUMBADS); ?></td>
</tr>
<tr><td>

<?php include(DIR_WS_MODULES . FILENAME_NEW_PRODUCTS); ?> </td></tr> <tr><td>

<?php
include(DIR_WS_MODULES . FILENAME_UPCOMING_PRODUCTS);
?>
</table></td>
<?php
}
?>

<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">

<?php require(DIR_WS_INCLUDES . 'column_right.php'); ?>

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



<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>

<br>
</body>
</html>
<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>
Click to expand...

cynia, Jun 12, 2008 IP

kmap Well-Known Member

Messages:: 2,215

Likes Received:: 29

Best Answers:: 2

Trophy Points:: 135

#8

contact me i can fix both issues $20

in 5 min
50% advance

PM me if that suits u

Regards

Alex

kmap, Jun 13, 2008 IP

eli03 Well-Known Member

Messages:: 2,887

Likes Received:: 98

Best Answers:: 0

Trophy Points:: 175

#9

the problem was a missing field name "p" under the table name products_id or the code is not updated with the database. are you working with fresh install or upgrading ?

eli03, Jun 13, 2008 IP

cynia Well-Known Member

Messages:: 890

Likes Received:: 9

Best Answers:: 0

Trophy Points:: 140

Digital Goods:: 1

#10

eli03 said: ↑

the problem was a missing field name "p" under the table name products_id or the code is not updated with the database. are you working with fresh install or upgrading ?
Click to expand...

I am working with a fresh install

Can you help me?

What should i change to fix this?

cynia, Jun 14, 2008 IP

cynia Well-Known Member

Messages:: 890

Likes Received:: 9

Best Answers:: 0

Trophy Points:: 140

Digital Goods:: 1

#11

kmap said: ↑

contact me i can fix both issues $20

in 5 min
50% advance

PM me if that suits u

Regards

Alex
Click to expand...

I am interested if you can help

Go to this site where i have an open prroject there and make your bid
http://freelancerboss.com

cynia, Jun 14, 2008 IP

Log in or Sign up

PROBLEM with database .. HELP ME URGENT

cynia Well-Known Member

cynia Well-Known Member

Nepopec Peon

Freewebspace Notable Member

cynia Well-Known Member

cynia Well-Known Member

cynia Well-Known Member

kmap Well-Known Member

eli03 Well-Known Member

cynia Well-Known Member

cynia Well-Known Member

Useful Searches