prestashop error

[PrestaShopDatabaseException]

Unknown column 'id_lang' in 'field list'


            SELECT id_customer, customer_email, id_shop, id_lang
            FROM `ps_mailalert_customer_oos`
            WHERE `id_product` = 54 AND `id_product_attribute` = 0

at line 613 in file classes/db/Db.php
607.            WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);
608.        }
609.        else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))
610.        {
611.            if ($sql)
612.                throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');
613.            throw new PrestaShopDatabaseException($this->getMsgError());
614.        }
615.    }
616.
617.    /**
DbCore->displayError - [line 313 - classes/db/Db.php] - [1 Arguments]
307.        if ($sql instanceof DbQuery)
308.            $sql = $sql->build();
309.
310.        $this->result = $this->_query($sql);
311.        if (_PS_DEBUG_SQL_)
312.            $this->displayError($sql);
313.        return $this->result;
314.    }
315.
316.    /**
317.     * Execute an INSERT query
DbCore->query - [line 488 - classes/db/Db.php] - [1 Arguments]
482.        {
483.            $this->last_cached = true;
484.            return $result;
485.        }
486.
487.        $this->result = $this->query($sql);
488.        if (!$this->result)
489.            return false;
490.
491.        $this->last_cached = false;
492.        if (!$array)
DbCore->executeS - [line 284 - modules/mailalerts/MailAlert.php] - [1 Arguments]
278.        $sql = '
279.            SELECT id_customer, customer_email, id_shop, id_lang
280.            FROM `'._DB_PREFIX_.self::$definition['table'].'`
281.            WHERE `id_product` = '.(int)$id_product.' AND `id_product_attribute` = '.(int)$id_product_attribute;
282.
283.        return Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS($sql);
284.    }
285.
286. }
MailAlert::getCustomers - [line 175 - modules/mailalerts/MailAlert.php] - [2 Arguments]
169.
170.    public static function sendCustomerAlert($id_product, $id_product_attribute)
171.    {
172.        $link = new Link();
173.        $context = Context::getContext()->cloneContext();
174.        $customers = self::getCustomers($id_product, $id_product_attribute);
175.
176.        foreach ($customers as $customer)
177.        {
178.            $id_shop = (int)$customer['id_shop'];
179.            $id_lang = (int)$customer['id_lang'];
MailAlert::sendCustomerAlert - [line 486 - modules/mailalerts/mailalerts.php] - [2 Arguments]
480.                }
481.            }
482.        }
483.
484.        if ($this->_customer_qty && $quantity > 0)
485.            MailAlert::sendCustomerAlert((int)$product->id, (int)$params['id_product_attribute']);
486.    }
487.
488.    public function hookActionProductAttributeUpdate($params)
489.    {
490.        $sql = '
MailAlerts->hookActionUpdateQuantity - [line 457 - classes/Hook.php] - [1 Arguments]
451.            {
452.                $hook_args['altern'] = ++$altern;
453.
454.                // Call hook method
455.                if ($hook_callable)
456.                    $display = $moduleInstance->{'hook'.$hook_name}($hook_args);
457.                else if ($hook_retro_callable)
458.                    $display = $moduleInstance->{'hook'.$retro_hook_name}($hook_args);
459.                // Live edit
460.                if (!$array_return && $array['live_edit'] && Tools::isSubmit('live_edit') && Tools::getValue('ad') && Tools::getValue('liveToken') == Tools::getAdminToken('AdminModulesPositions'.(int)Tab::getIdFromClassName('AdminModulesPositions').(int)Tools::getValue('id_employee')))
461.                {
HookCore::exec - [line 450 - classes/stock/StockAvailable.php] - [2 Arguments]
444.                   array(
445.                    'id_product' => $id_product,
446.                    'id_product_attribute' => $id_product_attribute,
447.                    'quantity' => $stock_available->quantity
448.                   )
449.                  );
450.
451.        return true;
452.    }
453.
454.
StockAvailableCore::updateQuantity - [line 418 - classes/order/OrderDetail.php] - [3 Arguments]
412.    {
413.        if ($id_order_state != Configuration::get('PS_OS_CANCELED') && $id_order_state != Configuration::get('PS_OS_ERROR'))
414.        {
415.            $update_quantity = true;
416.            if (!StockAvailable::dependsOnStock($product['id_product']))
417.                $update_quantity = StockAvailable::updateQuantity($product['id_product'], $product['id_product_attribute'], -(int)$product['cart_quantity']);
418.
419.            if ($update_quantity)
420.                $product['stock_quantity'] -= $product['cart_quantity'];
421.
422.            if ($product['stock_quantity'] < 0 && Configuration::get('PS_STOCK_MANAGEMENT'))
OrderDetailCore->checkProductStock - [line 575 - classes/order/OrderDetail.php] - [2 Arguments]
569.        $productQuantity = (int)(Product::getQuantity($this->product_id, $this->product_attribute_id));
570.        $this->product_quantity_in_stock = ($productQuantity - (int)($product['cart_quantity']) < 0) ?
571.            $productQuantity : (int)($product['cart_quantity']);
572.
573.        $this->setVirtualProductInformation($product);
574.        $this->checkProductStock($product, $id_order_state);
575.
576.        if ($use_taxes)
577.            $this->setProductTax($order, $product);
578.        $this->setShippingCost($order, $product);
579.        $this->setDetailProductPrice($order, $cart, $product);
OrderDetailCore->create - [line 613 - classes/order/OrderDetail.php] - [7 Arguments]
607.
608.        $this->id_order = $order->id;
609.        $this->outOfStock = false;
610.
611.        foreach ($product_list as $product)
612.            $this->create($order, $cart, $product, $id_order_state, $id_order_invoice, $use_taxes, $id_warehouse);
613.
614.        unset($this->vat_address);
615.        unset($products);
616.        unset($this->customer);
617.    }
OrderDetailCore->createList - [line 279 - classes/PaymentModule.php] - [7 Arguments]
273.
274.                    $order_list[] = $order;
275.
276.                    // Insert new Order detail list using cart for the current order
277.                    $order_detail = new OrderDetail(null, null, $this->context);
278.                    $order_detail->createList($order, $this->context->cart, $id_order_state, $order->product_list, 0, true, $package_list[$id_address][$id_package]['id_warehouse']);
279.                    $order_detail_list[] = $order_detail;
280.
281.                    // Adding an entry in order_carrier table
282.                    if (!is_null($carrier))
283.                    {
PaymentModuleCore->validateOrder - [line 58 - modules/cashondelivery/controllers/front/validation.php] - [9 Arguments]
52.
53.         if (Tools::getValue('confirm'))
54.         {
55.             $customer = new Customer((int)$this->context->cart->id_customer);
56.             $total = $this->context->cart->getOrderTotal(true, Cart::BOTH);
57.             $this->module->validateOrder((int)$this->context->cart->id, Configuration::get('PS_OS_PREPARATION'), $total, $this->module->displayName, null, array(), null, false, $customer->secure_key);
58.             Tools::redirectLink(__PS_BASE_URI__.'order-confirmation.php?key='.$customer->secure_key.'&id_cart='.(int)$this->context->cart->id.'&id_module='.(int)$this->module->id.'&id_order='.(int)$this->module->currentOrder);
59.         }
60.     }
61.
62.     /**
CashondeliveryValidationModuleFrontController->postProcess - [line 158 - classes/controller/Controller.php] - [0 Argument]
152.            // setMedia MUST be called before postProcess
153.            if (!$this->content_only && ($this->display_header || (isset($this->className) && $this->className)))
154.                $this->setMedia();
155.
156.            // postProcess handles ajaxProcess
157.            $this->postProcess();
158.
159.            if (!empty($this->redirect_after))
160.                $this->redirect();
161.
162.            if (!$this->content_only && ($this->display_header || (isset($this->className) && $this->className)))
ControllerCore->run - [line 348 - classes/Dispatcher.php] - [0 Argument]
342.            // Execute hook dispatcher
343.            if (isset($params_hook_action_dispatcher))
344.                Hook::exec('actionDispatcher', $params_hook_action_dispatcher);
345.
346.            // Running controller
347.            $controller->run();
348.        }
349.        catch (PrestaShopException $e)
350.        {
351.            $e->displayMessage();
352.        }
DispatcherCore->dispatch - [line 28 - index.php] - [0 Argument]
22. *  @license    http://opensource.org/licenses/osl-3.0.php  Open Software License (OSL 3.0)
23. *  International Registered Trademark & Property of PrestaShop SA
24. */
25.
26. require(dirname(__FILE__).'/config/config.inc.php');
27. Dispatcher::getInstance()->dispatch();
28.