Smile

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? 🤔

Apparently I changed something a year ago in statuses and because of that the total amount of €.... sentence is not calculating right. Also the value at the end of a finished order is not showing the order value. It seems the only thing making a difference here is the "Consider the associated order as validated" I removed it form payment accepted as we like to check the order and make change before it goes to processing. Order processing does have "Consider the associated order as validated" thicked thoug, as do all the following order stages.... What is happening here?

I did remove all shops(Multistore) from one currency pounds. But then the whole currency did disappear. I then tried to add it but got the error: This currency already exists. Fixing it would be easy by adding it again to the table ps_currency_shop Can this be fixed like this? Or should I do more?

The error was something in the .htacces