30knees Posted August 5, 2017 Share Posted August 5, 2017 Hi, I'm getting the following error when I try to finalise a purchase using this Bitcoin module. The orders are ultimately captured, however. Does anyone have an idea for a fix? Thank you [ThirtyBeesDatabaseException] Unknown column 'bitcoin_address' in 'field list' SELECT `bitcoin_address` FROM `tb_orders` WHERE `id_order` = '5' LIMIT 1 at line 797 in file classes/db/Db.php 792. if ($webserviceCall && $errno) { 793. $dbg = debug_backtrace(); 794. WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97); 795. } elseif (_PS_DEBUG_SQL_ && $errno && !defined('TB_INSTALLATION_IN_PROGRESS')) { 796. if ($sql) { 797. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>'); 798. } 799. 800. throw new PrestaShopDatabaseException($this->getMsgError()); 801. } 802. } DbCore->displayError - [line 460 - classes/db/Db.php] - [1 Arguments] DbCore->query - [line 710 - classes/db/Db.php] - [1 Arguments] DbCore->getRow - [line 740 - classes/db/Db.php] - [2 Arguments] DbCore->getValue - [line 741 - modules/bitcoinhd/bitcoinhd.php] - [1 Arguments] BitcoinHD->generateBitcoinAddress - [line 700 - modules/bitcoinhd/bitcoinhd.php] - [1 Arguments] BitcoinHD->hookActionGetExtraMailTemplateVars - [line 771 - classes/Hook.php] - [1 Arguments] HookCore::coreCallHook - [line 487 - classes/Hook.php] - [3 Arguments] HookCore::execWithoutCache - [line 280 - classes/Hook.php] - [7 Arguments] HookCore::exec - [line 389 - classes/Mail.php] - [4 Arguments] MailCore::Send - [line 510 - classes/order/OrderHistory.php] - [13 Arguments] OrderHistoryCore->sendEmail - [line 422 - classes/order/OrderHistory.php] - [2 Arguments] OrderHistoryCore->addWithemail - [line 949 - classes/module/PaymentModule.php] - [2 Arguments] PaymentModuleCore->validateOrder - [line 61 - modules/bitcoinhd/controllers/front/validation.php] - [9 Arguments] BitcoinHDValidationModuleFrontController->postProcess - [line 355 - classes/controller/Controller.php] ControllerCore->run - [line 743 - classes/Dispatcher.php] DispatcherCore->dispatch - [line 33 - index.php] ``` Link to comment Share on other sites More sharing options...
0 30knees Posted August 5, 2017 Author Share Posted August 5, 2017 OK, thanks for the tip. I'll look around for a different one. Which one do you use? Link to comment Share on other sites More sharing options...
Question
30knees
Hi,
I'm getting the following error when I try to finalise a purchase using this Bitcoin module. The orders are ultimately captured, however.
Does anyone have an idea for a fix?
Thank you
[ThirtyBeesDatabaseException]
Unknown column 'bitcoin_address' in 'field list'
SELECT `bitcoin_address` FROM `tb_orders` WHERE `id_order` = '5' LIMIT 1
at line 797 in file classes/db/Db.php
792. if ($webserviceCall && $errno) { 793. $dbg = debug_backtrace(); 794. WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97); 795. } elseif (_PS_DEBUG_SQL_ && $errno && !defined('TB_INSTALLATION_IN_PROGRESS')) { 796. if ($sql) { 797. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>'); 798. } 799. 800. throw new PrestaShopDatabaseException($this->getMsgError()); 801. } 802. }
```
Link to comment
Share on other sites
1 answer to this question
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now