Smile

I use Mollie PS version without any issue or tweak. Works like a charm. And just 3 days waiting 🙂

Well looking at the current field a serious merchant who preferers freedom would probably still choose for PS/TB, magento or Woocommerce. And i think when TB has good support and positive environment we can slow but steady grow. I guess its like a marathon and a new start for TB.

Apparently this tabel was not well copied adding it again solved the issue.

Taking over a business can take some time. Be positive I guess 😉 Also I expect the new team will not start working before the formalities are done. Would you start painting a house before buying it?

Hi, I copied the whole DB to a new server. All seems to go well, except from one thing. The products are not shown in FO and BO. In The bo on the product page I get the message: Bad SQL query Table 'useran_DBName6.ps_image' doesn't exist Does someone has a idea? I have overwritten the DB with the same backup, same issue.

I might have seen it before in PS, but normally I just delete the product and add it again. Then it is mostly sloved.

Its very irritating as when it happens in FO the order comes not through in BO when the customer comes back from payment provider. So the order is not seen in the orderlist and still payed. In cases it is not 0.00.

I don't think you have to worry for now. Such things just take time apparently.

I guess they buy it for business continuity and security. Probably no need to worry, we all know how Prestashop is going down now. Only thing is buying companies probalt takes months. So we have to be patient.

Yes it should become 0.00

I have the same error, happens both on FO and on BO side. It only happens in certain cases, not sure when it does and when it not happens. ## ThirtyBeesException **Property Order->total_paid_tax_excl is not valid** *at line* **1027** *in file* `classes/ObjectModel.php` ```php 1022. } 1023. 1024. $message = $this->validateField($field, $this->$field); 1025. if ($message !== true) { 1026. if ($die) { 1027. => throw new PrestaShopException($message); 1028. } 1029. 1030. return $errorReturn ? $message : false; 1031. } 1032. } ``` - **ObjectModelCore->validateFields** - [line `322` - `classes/ObjectModel.php`] ```php 317. * @since 1.0.0 318. * @version 1.0.0 Initial version 319. */ 320. public function getFields() 321. { 322. => $this->validateFields(); 323. $fields = $this->formatFields(static::FORMAT_COMMON); 324. 325. // For retro compatibility 326. if (Shop::isTableAssociated($this->def['table'])) { 327. $fields = array_merge($fields, $this->getFieldsShop()); ``` - **ObjectModelCore->getFields** - [line `285` - `classes/order/Order.php`] ```php 280. { 281. if (!$this->id_lang) { 282. $this->id_lang = Configuration::get('PS_LANG_DEFAULT', null, null, $this->id_shop); 283. } 284. 285. => return parent::getFields(); 286. } 287. 288. /** 289. * Add this Order 290. * ``` - **OrderCore->getFields** - [line `8` - `override/classes/order/Order.php`] ```php 3. { 4. public $payment_fee; 5. public $payment_fee_rate; 6. public function getFields() 7. { 8. => $fields = parent::getFields(); 9. $fields['payment_fee'] = (float)($this->payment_fee); 10. $fields['payment_fee_rate'] = (float)($this->payment_fee_rate); 11. return $fields; 12. } 13. } ``` - **Order->getFields** - [line `748` - `classes/ObjectModel.php`] ```php 743. 744. if (Shop::checkIdShopDefault($this->def['table']) && !$this->id_shop_default) { 745. $this->id_shop_default = (in_array(Configuration::get('PS_SHOP_DEFAULT'), $idShopList) == true) ? Configuration::get('PS_SHOP_DEFAULT') : min($idShopList); 746. } 747. // Database update 748. => if (!$result = Db::getInstance()->update($this->def['table'], $this->getFields(), '`'.pSQL($this->def['primary']).'` = '.(int) $this->id, 0, $nullValues)) { 749. return false; 750. } 751. 752. // Database insertion for multishop fields related to the object 753. if (Shop::isTableAssociated($this->def['table'])) { ``` - **ObjectModelCore->update** - [line `326` - `classes/order/Order.php`] - [1 Arguments] ```php 321. */ 322. public function update($nullValues = true) 323. { 324. $this->roundAmounts(); 325. 326. => return parent::update($nullValues); 327. } 328. 329. /** 330. * This function rounds all the decimal properties of this Object 331. * ``` ```Argument [0] 1 ``` - **OrderCore->update** - [line `1685` - `controllers/admin/AdminOrdersController.php`] ```php 1680. $order->total_paid_tax_incl -= $orderCartRule->value; 1681. $order->total_paid_tax_excl -= $orderCartRule->value_tax_excl; 1682. } 1683. 1684. // Update Order 1685. => $res &= $order->update(); 1686. } 1687. 1688. if ($res) { 1689. Tools::redirectAdmin(static::$currentIndex.'&id_order='.$order->id.'&vieworder&conf=4&token='.$this->token); 1690. } else { ``` - **AdminOrdersControllerCore->postProcess** - [line `251` - `classes/controller/Controller.php`] ```php 246. if ($this->checkAccess()) { 247. if (!$this->content_only && ($this->display_header || (isset($this->className) && $this->className))) { 248. $this->setMedia(); 249. } 250. 251. => $this->postProcess(); 252. 253. if (!empty($this->redirect_after)) { 254. $this->redirect(); 255. } 256. ``` - **ControllerCore->run** - [line `837` - `classes/Dispatcher.php`] ```php 832. if (isset($paramsHookActionDispatcher)) { 833. Hook::exec('actionDispatcher', $paramsHookActionDispatcher); 834. } 835. 836. // Running controller 837. => $controller->run(); 838. } catch (PrestaShopException $e) { 839. $e->displayMessage(); 840. } 841. } 842. ``` - **DispatcherCore->dispatch** - [line `63` - `admin/index.php`] ```php 58. if (!isset($_REQUEST['controller']) && isset($_REQUEST['tab'])) { 59. $_REQUEST['controller'] = strtolower($_REQUEST['tab']); 60. } 61. 62. // Prepare and trigger admin dispatcher 63. => Dispatcher::getInstance()->dispatch(); ``` After adding we get the error, then the discount is shown in the order but not working. @musicmaster was your solution a fix or a work around or?

Good news, hope it works out well.

In general I expect that is has to do with htaccess, did you enable debugging using ftp?

We are just working on Odoo nexterp is nicer opensource wise but has not so many functions jet....

A smaller group is thinking working and thinking about a plan. Maybe it works maybe not but I expect in a few weeks we will know where we are heading.

I love that idea!

I don't know a better open source system on the market at the moment. Open source is key of TB/PS. Beside that would you migrate when you site is running the bigger business and all is connected to WMS, PIM, CRM ect. Well then 500,- is not that much anymore I can tell you. As stated above I love the Odoo model where there is also an enterprise model.

Please make it a big bigger. To use some flight example: Platinum $500 per month Gold $250 Silver $100 Bronze $50 Generous backers < 50 So we have a more defined view on income.

I am working with a implementing party to get a connector or integration for Odoo that works with Thirty bees. If someone is interested in this as well send me a private message so that we can discuss to join the project.

According to the association or something like that I am willing to setup legal part as well as financial part. Considering we run it under a dutch flag.

Just a comment on the side. We are a serious business and there are more people like me I guess. For my business I could think about hiring a developer. But we don't have enough work for it or time to work out all projects. But we just need 10-30 bigger sites running TB and tipingin to make a serious association or consortium. 20 x 250 per month = a reasonable salary to start with. And 250 is like not much for the bigger stores in my opinion? I mean I like to keep it mostly open source..... But like how it works with Odoo as an example. There is a community edition and a Enterprise version (Database managed). With functions you would need being a bigger store. For example think about API access, advanced vouchers, hreflangs .... ect. Maybe we should run a online meetup for all interested.... I did not read the full topic and all lesley's ideas about it.

I am generally very busy so I can't help to much in time. But my company is running on TB and I have quite some employees running around. I mean like many others it is serious business. We even work on a connector for Odoo and I can tell you this is a huge investment. I would be happy to tip in a monthly fee. @wakabayashi As a user for many years I surely know what is definitely needed and not. What about making a association of it? We also could work with crowdsourcing major improvements. We just need a mastermind what has time and devotion to run it, and a steady financial income.

Great guys, I will see the update in a next version thanks!

I see indeed that it is only the case for bankwire. Not sure how to add a payment and not sure we like to do that manual 😉 When status changes to payment accepted you would expect it to change automatically.

Well seems a bug or the same misconfiguration? 🤔