@tejastra
We replicate the issue at our end, got the same error you were getting while connecting cloud SQL database with qloapps :-

Storage engine MyISAM is disabled (Table creation is disallowed).

Here is the workaround of your problem:-

Open the file located at :- PATH_TO_QLOAPPS_FILES/classes/db/DbMySQLi.php
look for this funtion :-
checkCreatePrivilege($server, $user, $pwd, $db, $prefix, $engine = null)

under this look for -

if ($engine === null) {
$engine = 'MyISAM';
}

and patch like this:

if ($engine === null) {
$engine = 'InnoDB';
}

save the changes, and then you should be able to successfully connect your Cloud SQL database with Qloapps.

Do let us know how it goes,
Thanks

@anteestenc i get the same error but i get back and first i check the connection to the database. when it says successful the error goes away.

@shreesh Thanks this solved the problem. I had to separately give access to files though i already gave for the folders.

Thank you, @Sumit . Will get this checked & let you know. Thank you!

Hello @gero

To move QloApps, please perform the following procedure: https://webkul.com/blog/move-prestashop-to-new-server/.
As QloApps is built on PrestaShop, The procedure to move QloApps to another server is similar to that of Prestashop.

Note: Do not forget to take the backup of files and database. So that in case any issue occurs, you can rollback to the previous state.

Hi @codeware We have not faced such an issue on our end. So we will have to check it on your server.
So please raise a ticket and provide us your FTP details and the URL on which you are trying to do the installation.
https://webkul.uvdesk.com/en/customer/create-ticket/

Hi @sdo1web
Yes, this can be achieved. You can install QloApps on your sub-domain. And then you will have to contact your hosting provider to work on your URL so that user does not come to know that it is a sub-domain.

Hello @sdo1web
We will have to check the issue on your system. So we will need your FTP details and QloApps backoffice Admin Credentails.

Ergo, please raise a ticket at https://webkul.uvdesk.com/en/customer/create-ticket/
and share your details over the ticket only.

Note: Please do not share your details over the public forum.

Thank You. I will do that now.

To resolve the issue,

Please set 'allow_url_fopen = On' and 'allow_url_include = On' in php.ini

Also please make sure that there issue no issue in your internet connection because many times this error arises due to a connection problem.

Also, make sure that your server configuration is compatible with QloApps. You can find the required configuration in this guide.
https://qloapps.com/install-qloapps/

Please go through the guide very carefully. And if still there is an issue then please share your FTP details and URL on which you are trying to install QloApps over the ticket.
https://webkul.uvdesk.com/en/customer/create-ticket/

@lafora

This issue might occur because of server request timeout.

Please make sure your server is configured with the recomended setting for QloApps : https://qloapps.com/install-qloapps/#section-8
Make sure to set server max_execution_time to 500.

If the issue still persist, do let us know.

Hello @Sheik
I have already mentioned this error and its solution in one of the topic.
Please follow this link to get the solution: https://forums.qloapps.com/topic/8/error-during-installation-all-parts-of-a-primary-key-must-be-not-null-if-you-need-null-in-a-key-use-unique-instead-error-sql-has-happened

Hello @Mikel
I suggest you go through this guide carefully: https://qloapps.com/install-qloapps/
And please make sure your server configuration is compatible with QloApps. The required server configurations are also given in the guide.

Then try to install fresh QloApps once again.

If still, you face any issue then please share your FTP details and the URL on which you are trying to install QloApps on the ticket.
https://webkul.uvdesk.com/en/customer/create-ticket/

Hi @pnamgay

You have raised the same issue on the forum before also and I have replied you there only.
Please find my reply here: https://forums.qloapps.com/topic/84/an-error-occurred-during-installation

And we are working on your ticket to resolve the issue.
Please expect our response on this issue on ticket only.

Thanks

This issue generally arises because of the sql_mode variable value of your database.
We have resolved the issue. Please download a fresh QloApps and replace attached files in the below paths respectively.

hotelcommerce/classes/db/DbPDO.php hotelcommerce/install/data/db_structure.sql

After replacing the files install QloApps again.
Hope it will be installed successfully.
attachements.zip

Hi @pnamgay
This issue comes because of the MySQL version.
We are working on it and this issue will be resolved in our next version of QloApps releasing soon.

But for now, please replace the attached file on this path: hotelcommerce/install/data
Then try to install QloApps again, you will be able to install QloApps successfully.

0_1551259388625_db_structure.sql

@Amir
Please provide us your apache config file and the full path where you put your hotelcommerce folder .

@lilyandy The value of 60000 for max_input_vars is more than enough. QloApps shows warning if this value needs to be increased. What error message do you get when saving translations. Please share the screenshot for more details.

@6u2snpaul7pj please allow some time, you will be contacted soon.