Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

1054 - Unknown column 'popt.products_options_track_stock' in 'field list'


catalepticstate

Recommended Posts

I have modified a RC2a shop and added a few mods.

 

1 was to add on lightbox 2.04

2 was to add on MULTI IMAGES //May 07, 2008 version

The above mods do not change any other files just product_info.php.

 

There is nothing else that I have changed but whenever I click on add to cart and the site goes to shopping_cart.php it gives me this:

 

 

1054 - Unknown column 'popt.products_options_track_stock' in 'field list'

 

select popt.products_options_name, popt.products_options_track_stock, poval.products_options_values_name, pa.options_values_price, pa.price_prefix from products_options popt, products_options_values poval, products_attributes pa where pa.products_id = '26' and pa.options_id = '3' and pa.options_id = popt.products_options_id and pa.options_values_id = '8' and pa.options_values_id = poval.products_options_values_id and popt.language_id = '1' and poval.language_id = '1'

 

[TEP STOP]

 

 

I do not think I have installed anything wrong. I was missing a chunk in payment.php:

function checkout_initialization_method() {

$initialize_array = array();

 

if (is_array($this->modules)) {

reset($this->modules);

while (list(, $value) = each($this->modules)) {

$class = substr($value, 0, strrpos($value, '.'));

if ($GLOBALS[$class]->enabled && method_exists($GLOBALS[$class], 'checkout_initialization_method')) {

$initialize_array[] = $GLOBALS[$class]->checkout_initialization_method();

}

}

}

 

return $initialize_array;

}

 

help :'(

Link to comment
Share on other sites

anyone?

 

I have modified a RC2a shop and added a few mods.

 

1 was to add on lightbox 2.04

2 was to add on MULTI IMAGES //May 07, 2008 version

The above mods do not change any other files just product_info.php.

 

There is nothing else that I have changed but whenever I click on add to cart and the site goes to shopping_cart.php it gives me this:

 

 

1054 - Unknown column 'popt.products_options_track_stock' in 'field list'

 

select popt.products_options_name, popt.products_options_track_stock, poval.products_options_values_name, pa.options_values_price, pa.price_prefix from products_options popt, products_options_values poval, products_attributes pa where pa.products_id = '26' and pa.options_id = '3' and pa.options_id = popt.products_options_id and pa.options_values_id = '8' and pa.options_values_id = poval.products_options_values_id and popt.language_id = '1' and poval.language_id = '1'

 

[TEP STOP]

 

 

I do not think I have installed anything wrong. I was missing a chunk in payment.php:

function checkout_initialization_method() {

$initialize_array = array();

 

if (is_array($this->modules)) {

reset($this->modules);

while (list(, $value) = each($this->modules)) {

$class = substr($value, 0, strrpos($value, '.'));

if ($GLOBALS[$class]->enabled && method_exists($GLOBALS[$class], 'checkout_initialization_method')) {

$initialize_array[] = $GLOBALS[$class]->checkout_initialization_method();

}

}

}

 

return $initialize_array;

}

 

help :'(

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...