multi site & SQL Azure

  • Posts: 26
  • Thank you received: 0
10 years 6 months ago #190967

-- HikaShop version -- : 2.3.0

Hi Guys

I need some guidance and answers on a couple questions please.

My client sells equestrian bits and accessories and has a large and vast amount of items. We are using Hikashop Business as the shopping cart/e-comm component. There are going to be different websites for different countries US,UK,ZA etc.

The database guy would like to use SQL Azure and have all the sites installed and reading from that one SQL Azure database, is this achievable if so how and are there any short falls to this?

Your help would be greatly appreciated.

Thanks

Please Log in or Create an account to join the conversation.

  • Posts: 26265
  • Thank you received: 4044
  • MODERATOR
10 years 6 months ago #191004

Hi,

Unfortunately HikaShop is not compatible with SQL Azure, it only works with MySQL.
When HikaShop was created, the multi-database system was not exist in Joomla ; so the queries are made and optimized for MySQL.

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.
The following user(s) said Thank You: Oneplanet

Please Log in or Create an account to join the conversation.

  • Posts: 26
  • Thank you received: 0
10 years 6 months ago #191023

Hi Jerome

Thanks so much for the response, For interest sake what would happen if it was installed on Azure?

Thanks

Please Log in or Create an account to join the conversation.

  • Posts: 26265
  • Thank you received: 4044
  • MODERATOR
10 years 6 months ago #191035

Hi,

Basically, Joomla won't install HikaShop and the different queries will not work.

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

  • Posts: 26
  • Thank you received: 0
10 years 6 months ago #191092

Ok awesome, good thing i checked :)

Please Log in or Create an account to join the conversation.

  • Posts: 26
  • Thank you received: 0
10 years 6 months ago #191771

OK so my client has now created a WebMatrix account, So my original question comes into play again. Can i run Hikashop on WebMatrix?

Thanks

Please Log in or Create an account to join the conversation.

  • Posts: 26265
  • Thank you received: 4044
  • MODERATOR
10 years 6 months ago #191774

Hi,

WebMatrix can support MySQL ; so if you configure it right, yes HikaShop can work on it.

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

  • Posts: 26
  • Thank you received: 0
10 years 5 months ago #191901

that's great news, thanks. By "so if you configure it right" ... Do you mean that there is specific way to configure Hikashop on WebMatrix?

Please Log in or Create an account to join the conversation.

  • Posts: 84233
  • Thank you received: 13677
  • MODERATOR
10 years 5 months ago #191922

No, it's noting to do in HikaShop.
When you setup your Joomla website on WebMatrix, you need to use MySQL as the database.
Here is for example a tutorial for WordPress where this is done:
www.microsoft.com/web/post/your-first-website-using-webmatrix
Once you have your Joomla website on WebMatrix with MySQL, you can just normally install HikaShop on it and use it.

The following user(s) said Thank You: Oneplanet

Please Log in or Create an account to join the conversation.

  • Posts: 26
  • Thank you received: 0
10 years 5 months ago #192019

Jerome you are a rockstar, thank you very much my friend!

Last edit: 10 years 5 months ago by Oneplanet.

Please Log in or Create an account to join the conversation.

Time to create page: 0.072 seconds
Powered by Kunena Forum