Hi, I've just done a fresh install using the 'en_NZ' locale setting. (latest bundled silverstripe + silvercart).

I've added the test data (confirmed by doing a search on my site and there are products returned) but there are no products displaying on the front page.

I've read the other topic in which someone was having a similar issue: http://www.silvercart.org/forum/support-and-troubleshooting/show/921#post921

It says to check the "Use default language if no translation is found?" option and then select the "English (New Zealand)" item from the drop down list.

There is no "English (New Zealand)" option but there are three "English: English" options.

Here's a screenshot showing my problem: https://dl.dropbox.com/u/94497922/ss.png

I've tried selecting each of the three but none of the lead to me having products listed on the front page.

Help, please ;(

Hi cpt,

can you please check the locale of the products and the locale of your site tree objects in the database?

I assume they do not match.

Cheers
Ramon

Hi Ramon,

Sorry, but how exactly do I do that?

I'm installing this on a shared-hosting environment and I have access to phpMyAdmin, so I'm presuming I'm supposed to check there somewhere?

Hi cpt,

you can run the following 2 queries and check if the locales match. The products will only be shown if the SilvercartProductGroup has the same locale as the product.

First query:

Second query:

If you are not sure, you can post the results here.

Cheers
Ramon

Here's the results for the first query:

https://dl.dropbox.com/u/94497922/imgs/query1a.png
https://dl.dropbox.com/u/94497922/imgs/query1b.png

And here's the result for the second query:

https://dl.dropbox.com/u/94497922/imgs/query2.png

Hi cpt,

that's odd, it should show at least the en_US products when in the right context.

In which language context do you open your site?

You can try to add "&locale=en_US" to you URL.

Is your installation public and can you send me the link.

Cheers
Ramon

I'm not entirely sure what you mean by "which language context I open my site with" but when I installed SilverCart, I specified the "en_NZ" locale.

Here's the link to my current installation: http://bit.ly/Unx68s

Appending the text you specified did not do anything (at least I didn't notice anything) either.

Hi cpt,

not sure what's wrong here, but I assume it's language / locale specific.

Could you create a user for me so I can have a look in the backend?

Alternatively you could send me a dump of your database so I can install it here.

Cheers
Ramon