Install Prestashop 1.6.0.9 MariaDB Galera Cluster

[aepnea]

Hi,

 

i got some experience in Prestashop stand alone installation, but now i need install prestashop with high availability.

So, i've installed a MariaDB Galera Cluster with HAProxy as load balancer, and another apache machine i want to install prestashop 1.6.0.9, but i've got this error in the "create sample data" step (56% installation bar).

[Tue Jul 28 11:02:39 2015] [error] [client 192.168.133.1] PHP Fatal error:  Uncaught exception 'PrestaShopException' with message 'Property Order->id_address_delivery is empty' in /var/www/presta.nodriza.cl/classes/ObjectModel.php:846\nStack trace:\n#0 /var/www/presta.nodriza.cl/classes/ObjectModel.php(260): ObjectModelCore->validateFields()\n#1 /var/www/presta.nodriza.cl/classes/order/Order.php(284): ObjectModelCore->getFields()\n#2 /var/www/presta.nodriza.cl/classes/ObjectModel.php(605): OrderCore->getFields()\n#3 /var/www/presta.nodriza.cl/classes/order/OrderHistory.php(441): ObjectModelCore->update()\n#4 /var/www/presta.nodriza.cl/install_bak/classes/xmlLoader.php(445): OrderHistoryCore->add(true, false)\n#5 /var/www/presta.nodriza.cl/install_bak/classes/xmlLoader.php(310): InstallXmlLoader->createEntity('order_history', 'order_history_1', 'OrderHistory', Array, Array)\n#6 /var/www/presta.nodriza.cl/install_bak/classes/xmlLoader.php(214): InstallXmlLoader->populateEntity('order_history')\n#7 /var/www/presta.nodriza.cl/install_bak/models/install.php(730): InstallXmlLoader->populateFromXmlF in /var/www/presta.nodriza.cl/classes/ObjectModel.php on line 846, referer: http://presta.nodriza.cl/install_bak/index.php 

So, i tried the same but in stand alone MariaDB server and works fine.

 

 i've tried with the following ways:

• Installing in a Stand Alone MariaDB Server (works fine)
• Adding the Stand Alone MariaDB Server to cluster ( Prestashop shows "error 500")
• Installing Prestashop directly by the load balancer (the installation show the previous stack trace)

If someone have some idea how to do a detailed debug or maybe, if someone know how to install prestashop manually to improve my debug, i would appreciate.

 

 

 

EDIT:

 

i've installed the prestashop 1.6.0.9 but excluding the sample data by the installer option, now, when a trying to add a new product i have this problem

[PrestaShopException]

Root category must be an integer value
at line 125 in file classes/helper/HelperTreeCategories.php

119. 	}
120. 
121. 	public function setRootCategory($value)
122. 	{
123. 		if (!Validate::isInt($value))
124. 			throw new PrestaShopException('Root category must be an integer value');
125. 
126. 		$this->_root_category = $value;
127. 		return $this;
128. 	}
129. 
HelperTreeCategoriesCore->setRootCategory - [line 3017 - controllers/admin/AdminProductsController.php] - [1 Arguments]
AdminProductsControllerCore->initFormAssociations - [line 2688 - controllers/admin/AdminProductsController.php] - [1 Arguments]
AdminProductsControllerCore->renderForm - [line 1775 - classes/controller/AdminController.php]
AdminControllerCore->initContent - [line 2356 - controllers/admin/AdminProductsController.php]
AdminProductsControllerCore->initContent - [line 180 - classes/controller/Controller.php]
ControllerCore->run - [line 373 - classes/Dispatcher.php]
DispatcherCore->dispatch - [line 54 - admin/index.php]

any ideas?

Edited July 28, 2015 by aepnea (see edit history)

[aepnea]

i've tried with Prestashop 1.6.0.10, but in the database configuration step, shows me a message like "auto increment must be set to 1", interesting.

Then, i was to the MaríaDB backends, and saw the auto_increment_increment  and auto_increment_offset variables 

 

The first node

MariaDB [(none)]> SHOW VARIABLES LIKE 'auto_inc%';
+--------------------------+-------+
| Variable_name            | Value |
+--------------------------+-------+
| auto_increment_increment | 2     |
| auto_increment_offset    | 1     |
+--------------------------+-------+

The second node:

MariaDB [(none)]> SHOW VARIABLES LIKE 'auto_inc%';
+--------------------------+-------+
| Variable_name            | Value |
+--------------------------+-------+
| auto_increment_increment | 2     |
| auto_increment_offset    | 2     |
+--------------------------+-------+
2 rows in set (0.00 sec)

so, when i try to change the variables values with

SET [spam-filter]auto_increment_increment=1;
SET [spam-filter]auto_increment_offset=1;

but don't change it.

 

any ideas?

 

resolve this could be a great help to community! 

 

Come on!