RockPOS payment type not working help needed

[kamranitsolution]

[PrestaShopDatabaseException]

Unknown column 'position' in 'field list'

 

SELECT SQL_CALC_FOUND_ROWS

                                a.`id_pospayment`, b.`payment_name` AS `payment_name`, b.`label` AS `label`, `position`

            , a.`active`

            FROM `ps_pospayment` a

            LEFT JOIN `ps_pospayment_lang` b ON (b.`id_pospayment` = a.`id_pospayment` AND b.`id_lang` = 2)

            LEFT JOIN `ps_pospayment_shop` ps ON (a.`id_pospayment` = ps.`id_pospayment` AND ps.`id_shop` = 1)

                        LEFT JOIN `ps_shop` shop ON (shop.`id_shop` = ps.`id_shop`)

             WHERE 1 AND ps.`id_shop` =1

            

             ORDER BY `position` ASC LIMIT 0, 50

at line 791 in file classes/db/Db.php

 

786. if ($webservice_call && $errno) {

787. $dbg = debug_backtrace();

788. WebserviceRequest::getInstance()->setError(500, '

 '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);

789. } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) {

790. if ($sql) {

791. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');

792. }

793.

794. throw new PrestaShopDatabaseException($this->getMsgError());

795. }

796. }

• DbCore->displayError - [line 425 - classes/db/Db.php] - [1 Arguments]
  420. $this->result = $this->_query($sql);

  421. }

  422. }

  423.

  424. if (_PS_DEBUG_SQL_) {

  425. $this->displayError($sql);

  426. }

  427.

  428. return $this->result;

  429. }

  430.

• DbCore->query - [line 643 - classes/db/Db.php] - [1 Arguments]
  638. throw new PrestaShopDatabaseException('Db->executeS() must be used only with select, show, explain or describe queries');

  639. }

  640. return $this->execute($sql, $use_cache);

  641. }

  642.

  643. $this->result = $this->query($sql);

  644.

  645. if (!$this->result) {

  646. $result = false;

  647. } else {

  648. if (!$array) {

• DbCore->executeS - [line 3207 - classes/controller/AdminController.php] - [3 Arguments]
  3202.                                 '.($this->_tmpTableFilter ? ' * FROM (SELECT ' : '').$this->_listsql.$sql_from.$sql_join.' WHERE 1 '.$sql_where.

  3203. $sql_order_by.$sql_limit;

  3204. $list_count = 'SELECT COUNT(*) AS `'._DB_PREFIX_.$this->table.'` '.$sql_from.$sql_join.' WHERE 1 '.$sql_where;

  3205. }

  3206.

  3207. $this->_list = Db::getInstance()->executeS($this->_listsql, true, false);

  3208.

  3209. if ($this->_list === false) {

  3210. $this->_list_error = Db::getInstance()->getMsgError();

  3211. break;

  3212. }

• AdminControllerCore->getList - [line 2326 - classes/controller/AdminController.php] - [1 Arguments]
  2321. public function renderList()

  2322. {

  2323. if (!($this->fields_list && is_array($this->fields_list))) {

  2324. return false;

  2325. }

  2326. $this->getList($this->context->language->id);

  2327.

  2328. // If list has 'active' field, we automatically create bulk action

  2329. if (isset($this->fields_list) && is_array($this->fields_list) && array_key_exists('active', $this->fields_list)

  2330. && !empty($this->fields_list['active'])) {

  2331. if (!is_array($this->bulk_actions)) {

• AdminControllerCore->renderList - [line 84 - modules/hspointofsalepro/abstract/controllers/admin/AdminHsPointOfSalePaymentAbstract.php]
  79. public function renderList()

  80. {

  81. $this->addRowAction('edit');

  82. $this->addRowAction('delete');

  83.

  84. return parent::renderList();

  85. }

  86.

  87. /**

  88. * Show form add payment.

  89. *

• AdminHsPointOfSalePaymentAbstract->renderList - [line 2027 - classes/controller/AdminController.php]
  2022. } elseif ($this->display == 'details') {

  2023. $this->content .= $this->renderDetails();

  2024. } elseif (!$this->ajax) {

  2025. $this->content .= $this->renderModulesList();

  2026. $this->content .= $this->renderKpis();

  2027. $this->content .= $this->renderList();

  2028. $this->content .= $this->renderOptions();

  2029.

  2030. // if we have to display the required fields form

  2031. if ($this->required_database) {

  2032. $this->content .= $this->displayRequiredFields();

• AdminControllerCore->initContent - [line 99 - modules/hspointofsalepro/abstract/controllers/admin/AbstractAdminHsPointOfSaleCommon.php]
  94. /**

  95. * @see AdminControllerCore::initContent()

  96. */

  97. public function initContent()

  98. {

  99. parent::initContent();

  100. $this->context->smarty->assign(array(

  101. 'is_collecting_payment' => $this->module->isCollectingPayment(),

  102. 'rockpos_version' => $this->module->version

  103. ));

  104. }

• AbstractAdminHsPointOfSaleCommon->initContent - [line 189 - classes/controller/Controller.php]
  184. if (!$this->content_only && ($this->display_header || (isset($this->className) && $this->className))) {

  185. $this->initHeader();

  186. }

  187.

  188. if ($this->viewAccess()) {

  189. $this->initContent();

  190. } else {

  191. $this->errors[] = Tools::displayError('Access denied.');

  192. }

  193.

  194. if (!$this->content_only && ($this->display_footer || (isset($this->className) && $this->className))) {

• ControllerCore->run - [line 367 - classes/Dispatcher.php]
  362. if (isset($params_hook_action_dispatcher)) {

  363. Hook::exec('actionDispatcher', $params_hook_action_dispatcher);

  364. }

  365.

  366. // Running controller

  367. $controller->run();

  368. } catch (PrestaShopException $e) {

  369. $e->displayMessage();

  370. }

  371. }

  372.

• DispatcherCore->dispatch - [line 58 - admin/index.php]
  53. if (!isset($_REQUEST['controller']) && isset($_REQUEST['tab'])) {

  54. $_REQUEST['controller'] = strtolower($_REQUEST['tab']);

  55. }

  56.

  57. // Prepare and trigger admin dispatcher

  58. Dispatcher::getInstance()->dispatch();

[Tung at RockPOS.com]

Thanks mdekker for the help.

Next time, you guys can contact us directly at:

https://rockpos.com/contact-us

 

Cheers,