error 1146 after installation

Hello,

twice I tried to install Joomla template storefront 3 and always I have error 1146.

The installation is performed correctly, but on the home page, I have only this:

1146
Table 'abc.bl9ye_virtuemart_categories_en_gb' does not exist SQL = SELECT DISTINCT FROM c.virtuemart_category_id AS CID bl9ye_virtuemart_product_categories AS cx LEFT JOIN bl9ye_virtuemart_categories_en_gb AS c ON cx.virtuemart_category_id c.virtuemart_category_id = LEFT JOIN AS bl9ye_virtuemart_products_en_gb content cx.virtuemart_product_id = ON LEFT content.virtuemart_product_id JOIN bl9ye_virtuemart_categories AS cat ON c.virtuemart_category_id = cat.virtuemart_category_id WHERE (c.virtuemart_category_id = 9 OR 14 OR = c.virtuemart_category_id c.virtuemart_category_id = 12)
It Appears the page You Were looking for does not exist. Sorry about that.

Nothing herein does not work ....

Please help.

Supplement. I used gk_storefront_quickstart_J! 3.zip.

it is resolved

I do not know why, but after installing via chrome it works

mistake again, absolutely unstable template: - (((

after installing localization (nothing more) the same error

1146
TABLE 'abc.B54UT_VIRTUEMART_CATEGORIES_CS_CZ' DOES NOT EXIST SQL = SELECT DISTINCT FROM C.VIRTUEMART_CATEGORY_ID AS CID B54UT_VIRTUEMART_PRODUCT_CATEGORIES CX AS LEFT JOIN B54UT_VIRTUEMART_CATEGORIES_CS_CZ AS C ON CX.VIRTUEMART_CATEGORY_ID C.VIRTUEMART_CATEGORY_ID = LEFT JOIN B54UT_VIRTUEMART_PRODUCTS_CS_CZ AS CONTENT ON CX.VIRTUEMART_PRODUCT_ID = LEFT CONTENT.VIRTUEMART_PRODUCT_ID JOIN B54UT_VIRTUEMART_CATEGORIES AS CAT ON C.VIRTUEMART_CATEGORY_ID = CAT.VIRTUEMART_CATEGORY_ID WHERE (C.VIRTUEMART_CATEGORY_ID = 9 OR 14 OR = C.VIRTUEMART_CATEGORY_ID C.VIRTUEMART_CATEGORY_ID = 12)

It Appears the page You Were looking for does not exist. Sorry about that.

Please help.

I have the same problem!

Same here

Table 'plazaria_ked.a0wis_virtuemart_categories_en_gb' doesn't exist SQL=SELECT DISTINCT c.virtuemart_category_id AS CID FROM a0wis_virtuemart_product_categories AS cx LEFT JOIN a0wis_virtuemart_categories_en_gb AS c ON cx.virtuemart_category_id = c.virtuemart_category_id LEFT JOIN a0wis_virtuemart_products_en_gb AS content ON cx.virtuemart_product_id = content.virtuemart_product_id LEFT JOIN a0wis_virtuemart_categories AS cat ON c.virtuemart_category_id = cat.virtuemart_category_id WHERE ( c.virtuemart_category_id = 8 OR c.virtuemart_category_id = 9 OR c.virtuemart_category_id = 10 OR c.virtuemart_category_id = 14 OR c.virtuemart_category_id = 11 OR c.virtuemart_category_id = 17 OR c.virtuemart_category_id = 13 OR c.virtuemart_category_id = 12 OR c.virtuemart_category_id = 1 OR c.virtuemart_category_id = 2 OR c.virtuemart_category_id = 3 OR c.virtuemart_category_id = 15 OR c.virtuemart_category_id = 4 OR c.virtuemart_category_id = 6 OR c.virtuemart_category_id = 16 OR c.virtuemart_category_id = 5 OR c.virtuemart_category_id = 7 )
It appears the page you were looking for doesn't exist. Sorry about that.

It seems that the problem came from this module...

Template, Quickstart - Instyle Joomla 3.

Best __Sellers__ mainbody News Show Pro GK5 Selected only Public All 684

Thanks.

Screen Shot 2015-01-11 at 12.15.23 AM.png

In fact The editing function for this module in the administrator page seems to be not working at all. Ther's no tabs and buttons after you click on the

Other modules seems to work fine.

Support works here at all ??? More than 4 days and no response

I've tried to install StoreFront J3 and same message error 1146.
I've installed French language (I'm french) et I've activated it on front and admin and all is OK.
If this solution could help someone...

After some tests :
If you install quickstart with english language of installation, it's ok
If you install quickstart with non-english language of installation, there is a 1146 error until you install your language and activate it as default in the admin panel for the "installed-site"
There would be a conflict in the language.

got the same error
I see there is no solution

to eln:

For me it did not work this way. I tried to manually override the database tables to my language (Czech). Again nothing. Again missing the English tables. So I created a copy. Then it worked. But .... my photos are stored in localized tables, name and notes in English tables. So useless.

Blog K2 constantly losing my images and place them appear empty original pictures from Gavick.

I made dozens of sites from templates, but this template is a nightmare.

And support sleeps ...

To Luke07

In my tests, all is OK once I install french language in the "Language Manager".
If it's not OK for you (Czech installation and czech languages ok in language manager), try to unpublisk the "New" module (Tab GK5).

If it's not OK, I don't what more. Sorry

There's support ??? My question is old for more than two weeks and still no official support or help.

I still having problems with this issue too.

After reinstalling the template and selecting the correct default language seems to work.

Now i have installed the spanish content language in Joomla and VM and there is no way to show products in news show pro 5

The same problem here:

ERROR 1146

TABLE 'B1311465_ASTOR.O41GF_VIRTUEMART_CATEGORIES_EN_GB' DOESN'T EXIST SQL=SELECT DISTINCT C.VIRTUEMART_CATEGORY_ID AS CID FROM O41GF_VIRTUEMART_PRODUCT_CATEGORIES AS CX LEFT JOIN O41GF_VIRTUEMART_CATEGORIES_EN_GB AS C ON CX.VIRTUEMART_CATEGORY_ID = C.VIRTUEMART_CATEGORY_ID LEFT JOIN O41GF_VIRTUEMART_PRODUCTS_EN_GB AS CONTENT ON CX.VIRTUEMART_PRODUCT_ID = CONTENT.VIRTUEMART_PRODUCT_ID LEFT JOIN O41GF_VIRTUEMART_CATEGORIES AS CAT ON C.VIRTUEMART_CATEGORY_ID = CAT.VIRTUEMART_CATEGORY_ID WHERE ( C.VIRTUEMART_CATEGORY_ID = 9 OR C.VIRTUEMART_CATEGORY_ID = 14 OR C.VIRTUEMART_CATEGORY_ID = 12 )

I tried to reinstall this template few times. As others mentioned, i used different languages - polish, english, german. There is still the same error in any cases.

Regards
Przemek

The way that I fixed this was to go to VirtueMart in admin. Under Configuration > Shop > Language settings i
I selected my language and saved. VirtueMart then created the missing tables and everything seems to be working well now.

Hi

I have no idea why this thread is marked as solved, probably someone has used a right answer and script thought it's over.

Here is an article in documentation about this: https://www.gavick.com/documentation/jo ... quickstart

BUT I've found it easier to install quickstart while using English (United Kingdom). This way there is no error at all.

The way that I fixed this was to go to VirtueMart in admin. Under Configuration > Shop > Language settings i
I selected my language and saved. VirtueMart then created the missing tables and everything seems to be working well now.

That was the easiest way for me too...!!! Thank you..!

Hi

Yes, when quickstart is installed than adding language manually and recreate tables with suffix for new language.

same here, Im using english language, and keep getting same same error on clean new database, something is missing.???

Hi

Please check if it's English (United Kingdom) and make sure VM recreate tebles, becuase it only install tables for languages configured for content.

For all searching for a quick solution.
This worked for me.
Go to Admin/Virtuemart/Configuration/Language settings
than select your language and press SAVE.
Virtuemart will create tables for your and you'll wont get error anymore.

Hi

Great solution. I was not aware of that, this is why it's always good to ask developer of the extension first

THIS WORKED GREAT!

For all searching for a quick solution.
This worked for me.
Go to Admin/Virtuemart/Configuration/Language settings
than select your language and press SAVE.
Virtuemart will create tables for your and you'll wont get error anymore.

Hi

I'm afraid this thread gone off topic, so I'm closing it now.