PHP Fatal error: 1109: Unknown table 'p' in field list

[bobc]

I constantly get the following error after 24/48 hours on my site which prevents both the site and admin areas from functioning at all. This requires a complete reinstall of ZenCart, and a restore of the database.

PHP Fatal error: 1109:Unknown table 'p' in field list :: select count(p.products_id) as total ==> (as called by) /home/black137/public_html/includes/classes/split_page_results.php on line 78 <== in /home/black137/public_html/includes/classes/db/mysql/query_factory.php on line 155


I have used the Developers toolkit to search for 'select count(p.products_id) as total' and this is not found, I have also used Dreamweaver to search the entire site and this is not found in any file. I am unsure why this being thrown-up but maybe somebody here has encountered this problem and/or can advise how I overcome this problem.

Bob

[bobc]

Hi All,

I have discovered that this problem is thrown up ONLY when somebody clicks the 'All Products' link on the site!

Any help would be much appreciated.

[DivaVocals]

Hi All,

I have discovered that this problem is thrown up ONLY when somebody clicks the 'All Products' link on the site!

Any help would be much appreciated.

and what modules have you installed??? because this is likely some issue cause by a bad module install versus Zen Cart out the box..

[Ajeh]

Are you able to reproduce this error every time you you click on All Products?

And each time, does it generate the exact same debug log that you posted:

PHP Fatal error:  1109:Unknown table 'p' in field list :: select  count(p.products_id) as total  ==> (as called by)  /home/black137/public_html/includes/classes/split_page_results.php on  line 78 <== in  /home/black137/public_html/includes/classes/db/mysql/query_factory.php  on line 155

[bobc]

In answer to Diva Vocals - The only addon module I have is DHL Express XML.

In Answer to Ajeh - Yes it is the same error each time the 'All Products' is clicked. And each time it is clicked, I have start again with the ZC Install, and re-import the database! For the moment, I have swithched off the 'All products' Link.

[Ajeh]

Very odd ... I was expecting this error from either the Product Listing or the Advanced Search or the Search ...

If you get bored, with nothing to do, and want to hunt this down more, you could make a Test site with a Test database so that this could be examined further ...

[lat9]

You could also try installing myDEBUG Backtrace (http://www.zen-cart.com/downloads.php?do=file&id=1879), which will further identify the errant caller of the split_page_result.php class function.

[twitchtoo]

Hi All,

I have discovered that this problem is thrown up ONLY when somebody clicks the 'All Products' link on the site!

Any help would be much appreciated.

This error points at includes/classes/split_page_results.php
line 74 - 78
$count_query = "select count(" . $count_string . ") as total " . substr($this->countQuery, $pos_from, ($pos_to - $pos_from));
if ($debug) {
echo 'count_query=' . $count_query . '<br /><br />';
}
$count = $db->Execute($count_query);


Clicking that button pulls these files:

includes/templates/YOUR_TEMPLATE/templates/tpl_products_all_default.php
line 63
<div id="allProductsListingBottomLinks" class="navSplitPagesLinks forward"><?php echo TEXT_RESULT_PAGE . ' ' . $products_all_split->display_links(MAX_DISPLAY_PAGE_LINKS, zen_get_all_get_params(array('page', 'info', 'x', 'y', 'main_page'))); ?></div>


includes/templates/YOUR_TEMPLATE/templates/tpl_modules_products_all_listing.php
line 22 - 23 if ($products_all_split->number_of_rows > 0) {
$products_all = $db->Execute($products_all_split->sql_query);includes/modules/pages/products_all/header_php.php
line 66
if ( (($how_many > 0 and $show_submit == true and $products_all_split->number_of_rows > 0) and (PRODUCT_ALL_LISTING_MULTIPLE_ADD_TO_CART == 1 or PRODUCT_ALL_LISTING_MULTIPLE_ADD_TO_CART == 3)) ) {


What are the chances your template changed any of these files or what happens when you switch back to the classic template with the products_all turned on?

[DrByte]

Additionally, in Admin->Configuration->Maximum Values, what's your setting for Maximum Display of Products All Page ?
And also all the settings in Admin->Configuration->All Listing ?

[answer=42]

This error points at includes/classes/split_page_results.php
line 74 - 78
$count_query = "select count(" . $count_string . ") as total " . substr($this->countQuery, $pos_from, ($pos_to - $pos_from));
if ($debug) {
echo 'count_query=' . $count_query . '<br /><br />';
}
$count = $db->Execute($count_query);


Clicking that button pulls these files:

includes/templates/YOUR_TEMPLATE/templates/tpl_products_all_default.php
line 63
<div id="allProductsListingBottomLinks" class="navSplitPagesLinks forward"><?php echo TEXT_RESULT_PAGE . ' ' . $products_all_split->display_links(MAX_DISPLAY_PAGE_LINKS, zen_get_all_get_params(array('page', 'info', 'x', 'y', 'main_page'))); ?></div>


includes/templates/YOUR_TEMPLATE/templates/tpl_modules_products_all_listing.php
line 22 - 23 if ($products_all_split->number_of_rows > 0) {
$products_all = $db->Execute($products_all_split->sql_query);includes/modules/pages/products_all/header_php.php
line 66
if ( (($how_many > 0 and $show_submit == true and $products_all_split->number_of_rows > 0) and (PRODUCT_ALL_LISTING_MULTIPLE_ADD_TO_CART == 1 or PRODUCT_ALL_LISTING_MULTIPLE_ADD_TO_CART == 3)) ) {


What are the chances your template changed any of these files or what happens when you switch back to the classic template with the products_all turned on?

I have the same problem when “All products or Special products” are clicked
I am using Winchester responsive template, Zen cart v1.5.5d, Ceon Advanced Shipper 5.0.2 and Sitemap XML
Lines 74-78 in includes/classes/split_page_results.php show:

$count_query = "select count(" . $count_string . ") as total " . substr($this->countQuery, $pos_from, ($pos_to - $pos_from));
if ($debug) {
  echo 'count_query=' . $count_query . '<br /><br />';
}
$count = $db->Execute($count_query);

includes/templates/YOUR_TEMPLATE/templates/tpl_products_all_default.php shows:

<div class="centerColumn" id="allProductsDefault">
<h1 id="allProductsDefaultHeading"><?php echo HEADING_TITLE; ?></h1>
<?php
require($template->get_template_dir('/tpl_modules_listing_display_order.php',DIR_WS_TEMPLATE, $current_page_base,'templates'). '/tpl_modules_listing_display_order.php');
require($template->get_template_dir('tpl_modules_product_listing.php',DIR_WS_TEMPLATE, $current_page_base,'templates'). '/tpl_modules_product_listing.php');
?>
</div>

lines 22-23 in includes/templates/YOUR_TEMPLATE/templates/tpl_modules_products_all_listing.php shows:

if ($products_all_split->number_of_rows > 0) {
  $products_all = $db->Execute($products_all_split->sql_query);

includes/modules/pages/products_all/header_php.php
line 66-74 shows:

if ( (($how_many > 0 and $show_submit == true and $products_all_split->number_of_rows > 0) and (PRODUCT_ALL_LISTING_MULTIPLE_ADD_TO_CART == 1 or  PRODUCT_ALL_LISTING_MULTIPLE_ADD_TO_CART == 3)) ) {
  $show_top_submit_button = true;
} else {
  $show_top_submit_button = false;
}
if ( (($how_many > 0 and $show_submit == true and $products_all_split->number_of_rows > 0) and (PRODUCT_ALL_LISTING_MULTIPLE_ADD_TO_CART >= 2)) ) {
  $show_bottom_submit_button = true;
} else {
  $show_bottom_submit_button = false;
}

If I change to the default template, the products display fine without a myDEBUG error.