Hi Twitch,
Thanks for your plugin, it is exactly what I need.
Unfortunately, I have the same problem with gearheadniko, that I can't see any products displayed in Categories/Product.
A error occurred: "WARNING: An Error occurred, please refresh the page and try again."
(Before & After)
http://i58.tinypic.com/dlt0ew.jpg
I take a look at my log file, it said:
[19-Mar-2015 17:02:26 Asia/Hong_Kong] PHP Fatal error: 1054:Unknown column 'p.products_model_spoon' in 'field list' :: select p.products_type, p.products_id, pd.products_name, p.products_quantity, p.products_image, p.products_price, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p.products_model, p.products_model_spoon, p.products_quantity_order_min, p.products_quantity_order_units, p.products_priced_by_attribute, p.product_is_free, p.product_is_call, p.products_quantity_mixed, p.product_is_always_free_shipping, p.products_quantity_order_max, p.products_sort_order from products p, products_description pd, products_to_categories p2c where p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = '23' order by p.products_sort_order, pd.products_name limit 0, 10 in /home/brightenbookscom/public_html/includes/classes/db/mysql/query_factory.php on line 120
Therefore, I went for the php file it mentioned:
/public_html/includes/classes/db/mysql/query_factory.php
Here is line 120, but I don't know how to fix the code.
[PHP]trigger_error($this->error_number . ':' . $this->error_text . ' :: ' . $this->zf_sql, E_USER_ERROR);[/PHP]
Could you please help me to due with this problem?
Thanks,
Eva
----------------------------------------------------------------------------------------------------------------
P.S. Since you may want to know more information, here is line 110~137 in query_factory.php:
[PHP] function show_error() {
if ($this->error_number == 0 && $this->error_text == DB_ERROR_NOT_CONNECTED && !headers_sent() && file_exists('nddbc.html') ) include('nddbc.html');
echo '<div class="systemError">';
if (defined('STRICT_ERROR_REPORTING') && STRICT_ERROR_REPORTING == true)
{
echo $this->error_number . ' ' . $this->error_text;
echo '<br />in:<br />[' . (strstr($this->zf_sql, 'db_cache') ? 'db_cache table' : $this->zf_sql) . ']<br />';
} else {
echo 'WARNING: An Error occurred, please refresh the page and try again.';
}
trigger_error($this->error_number . ':' . $this->error_text . ' :: ' . $this->zf_sql, E_USER_ERROR);
if (defined('IS_ADMIN_FLAG') && IS_ADMIN_FLAG==true) echo 'If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.<br />';
echo '</div>';
}
function Execute($zf_sql, $zf_limit = false, $zf_cache = false, $zf_cachetime=0) {
// bof: collect database queries
if (defined('STORE_DB_TRANSACTIONS') && STORE_DB_TRANSACTIONS=='true') {
global $PHP_SELF, $box_id, $current_page_base;
if (strtoupper(substr($zf_sql,0,6))=='SELECT' /*&& strstr($zf_sql,'products_id')*/) {
$f=@fopen(DIR_FS_SQL_CACHE.'/query_selects_' . $current_page_base . '_' . time() . '.txt','a');
if ($f) {
fwrite($f, "\n\n" . 'I AM HERE ' . $current_page_base . /*zen_get_all_get_params() .*/ "\n" . 'sidebox: ' . $box_id . "\n\n" . "Explain \n" . $zf_sql.";\n\n");
fclose($f);
}
unset($f);
}
}[/PHP]
----------------------------------------------------------------------------------------------------------------
