please help 1054 - Unknown column error in admin

[nihanshe]

Hi I hope you guys can help me on this, I spent hours trying to correct this 1054 - Unknown column 'p.large_products_image' in 'field list' message in my admin

 

anyone got any ideas this would be really helpful

 

My regards Mervyn

[dickysolo]

Hi I hope you guys can help me on this, I spent hours trying to correct this 1054 - Unknown column 'p.large_products_image' in 'field list' message in my admin

 

anyone got any ideas this would be really helpful

 

My regards Mervyn

 

hello...

the error is in ur admin/categories.php

 

find for the 'p.large_products_image' in admin/categories.php and remove it. Because in the products table there is no field/column name 'p.large_products_image' . It might be due to some plugins you installed. I think this might help you.

 

But pliz back up your original file before doing so.

[nihanshe]

hello...

the error is in ur admin/categories.php

 

find for the 'p.large_products_image' in admin/categories.php and remove it. Because in the products table there is no field/column name 'p.large_products_image' . It might be due to some plugins you installed. I think this might help you.

 

But pliz back up your original file before doing so.

 

 

Hi thanks for the reply, I have some problems finding the text 'p.large_products_image' in admin/categories.php I have been through the file five times to see if I can find the script to delete it but to no avail, Sorry!! any other ideas or suggestions would really great.

Kid regards Mervyn

[♥geoffreywalton]

You could try

 

\includes\modules\new_products.php

[nihanshe]

Hi all thanks for your reply, I believe I have found the text in admin/Categories.php highlighted in bold, I have removed this line but I still get the error.

 

Kind regards Mervyn

 

 

<!-- left_navigation_eof //-->

</table></td>

<!-- body_text //-->

<td width="100%" valign="top">

<?php

if ($action == 'new_product') {

$parameters = array('products_name' => '',

'products_description' => '',

'products_url' => '',

'products_id' => '',

'products_quantity' => '',

'products_model' => '',

'products_image' => '',

'large_products_image' => '', This line was removed but I still got the error 1054

'products_price' => '',

'products_weight' => '',

'products_date_added' => '',

'products_last_modified' => '',

'products_date_available' => '',

'products_status' => '',

'products_tax_class_id' => '',

'manufacturers_id' => '');

 

$pInfo = new objectInfo($parameters);

 

if (isset($HTTP_GET_VARS['pID']) && empty($HTTP_POST_VARS)) {

$product_query = tep_db_query("select pd.products_name, pd.products_description, pd.products_url, p.products_id, p.products_quantity, p.products_model, p.products_image, p.large_products_image, p.products_price, p.products_weight, p.products_date_added, p.products_last_modified, date_format(p.products_date_available, '%Y-%m-%d') as products_date_available, p.products_status, p.products_tax_class_id, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = '" . (int)$HTTP_GET_VARS['pID'] . "' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "'");

$product = tep_db_fetch_array($product_query);

 

 

My regards Mervyn

[nihanshe]

Hi all thanks for your reply, I believe I have found the text in admin/Categories.php highlighted in bold, I have removed this line but I still get the error.

 

Kind regards Mervyn

 

 

<!-- left_navigation_eof //-->

</table></td>

<!-- body_text //-->

<td width="100%" valign="top">

<?php

if ($action == 'new_product') {

$parameters = array('products_name' => '',

'products_description' => '',

'products_url' => '',

'products_id' => '',

'products_quantity' => '',

'products_model' => '',

'products_image' => '',

'large_products_image' => '', This line was removed but I still got the error 1054

'products_price' => '',

'products_weight' => '',

'products_date_added' => '',

'products_last_modified' => '',

'products_date_available' => '',

'products_status' => '',

'products_tax_class_id' => '',

'manufacturers_id' => '');

 

$pInfo = new objectInfo($parameters);

 

if (isset($HTTP_GET_VARS['pID']) && empty($HTTP_POST_VARS)) {

$product_query = tep_db_query("select pd.products_name, pd.products_description, pd.products_url, p.products_id, p.products_quantity, p.products_model, p.products_image, p.large_products_image, p.products_price, p.products_weight, p.products_date_added, p.products_last_modified, date_format(p.products_date_available, '%Y-%m-%d') as products_date_available, p.products_status, p.products_tax_class_id, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = '" . (int)$HTTP_GET_VARS['pID'] . "' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "'");

$product = tep_db_fetch_array($product_query);

 

 

My regards Mervyn

[nihanshe]

Hi all thanks for your reply, I believe I have found the text in admin/Categories.php highlighted in bold, I have removed this line but I still get the error.

 

Kind regards Mervyn

 

 

<!-- left_navigation_eof //-->

</table></td>

<!-- body_text //-->

<td width="100%" valign="top">

<?php

if ($action == 'new_product') {

$parameters = array('products_name' => '',

'products_description' => '',

'products_url' => '',

'products_id' => '',

'products_quantity' => '',

'products_model' => '',

'products_image' => '',

'large_products_image' => '', This line was removed but I still got the error 1054

'products_price' => '',

'products_weight' => '',

'products_date_added' => '',

'products_last_modified' => '',

'products_date_available' => '',

'products_status' => '',

'products_tax_class_id' => '',

'manufacturers_id' => '');

 

$pInfo = new objectInfo($parameters);

 

if (isset($HTTP_GET_VARS['pID']) && empty($HTTP_POST_VARS)) {

$product_query = tep_db_query("select pd.products_name, pd.products_description, pd.products_url, p.products_id, p.products_quantity, p.products_model, p.products_image, p.large_products_image, p.products_price, p.products_weight, p.products_date_added, p.products_last_modified, date_format(p.products_date_available, '%Y-%m-%d') as products_date_available, p.products_status, p.products_tax_class_id, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = '" . (int)$HTTP_GET_VARS['pID'] . "' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "'");

$product = tep_db_fetch_array($product_query);

 

 

My regards Mervyn

[dickysolo]

Hi all thanks for your reply, I believe I have found the text in admin/Categories.php highlighted in bold, I have removed this line but I still get the error.

 

Kind regards Mervyn

 

 

<!-- left_navigation_eof //-->

</table></td>

<!-- body_text //-->

<td width="100%" valign="top">

<?php

if ($action == 'new_product') {

$parameters = array('products_name' => '',

'products_description' => '',

'products_url' => '',

'products_id' => '',

'products_quantity' => '',

'products_model' => '',

'products_image' => '',

'large_products_image' => '', This line was removed but I still got the error 1054

'products_price' => '',

'products_weight' => '',

'products_date_added' => '',

'products_last_modified' => '',

'products_date_available' => '',

'products_status' => '',

'products_tax_class_id' => '',

'manufacturers_id' => '');

 

$pInfo = new objectInfo($parameters);

 

if (isset($HTTP_GET_VARS['pID']) && empty($HTTP_POST_VARS)) {

$product_query = tep_db_query("select pd.products_name, pd.products_description, pd.products_url, p.products_id, p.products_quantity, p.products_model, p.products_image, p.large_products_image, p.products_price, p.products_weight, p.products_date_added, p.products_last_modified, date_format(p.products_date_available, '%Y-%m-%d') as products_date_available, p.products_status, p.products_tax_class_id, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = '" . (int)$HTTP_GET_VARS['pID'] . "' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "'");

$product = tep_db_fetch_array($product_query);

 

 

My regards Mervyn

 

removing that line only will not help. You have to remove every occurrence of that thing. Remove that marked in red also.