error 1146 after installation

GK User
Thu Jan 08, 2015 10:07 am
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.
User avatar
Fresh Boarder

GK User
Thu Jan 08, 2015 10:09 am
Supplement. I used gk_storefront_quickstart_J! 3.zip.
User avatar
Fresh Boarder

GK User
Thu Jan 08, 2015 10:49 am
it is resolved

I do not know why, but after installing via chrome it works
User avatar
Fresh Boarder

GK User
Thu Jan 08, 2015 10:59 am
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.
User avatar
Fresh Boarder

GK User
Thu Jan 08, 2015 3:40 pm
I have the same problem!
User avatar
Fresh Boarder

GK User
Fri Jan 09, 2015 12:01 pm
Same here :?
User avatar
Senior Boarder

GK User
Sat Jan 10, 2015 4:16 pm
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.
User avatar
Fresh Boarder

GK User
Sat Jan 10, 2015 4:29 pm
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.
User avatar
Fresh Boarder

GK User
Sat Jan 10, 2015 5:16 pm
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.
User avatar
Fresh Boarder

GK User
Mon Jan 12, 2015 10:25 am
Support works here at all ??? More than 4 days and no response :-(
User avatar
Fresh Boarder

GK User
Mon Jan 12, 2015 11:33 am
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...
User avatar
Fresh Boarder

GK User
Mon Jan 12, 2015 11:45 am
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.
User avatar
Fresh Boarder

GK User
Mon Jan 12, 2015 12:09 pm
got the same error
I see there is no solution
User avatar
Fresh Boarder

GK User
Mon Jan 12, 2015 12:34 pm
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 ...
User avatar
Fresh Boarder

GK User
Mon Jan 12, 2015 3:02 pm
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
User avatar
Fresh Boarder

GK User
Fri Jan 23, 2015 1:13 pm
There's support ??? My question is old for more than two weeks and still no official support or help.
User avatar
Fresh Boarder

GK User
Sun Jan 25, 2015 8:15 pm
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
User avatar
Junior Boarder

GK User
Wed Jan 28, 2015 9:59 am
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
User avatar
Senior Boarder

GK User
Wed Jan 28, 2015 1:10 pm
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.
User avatar
Fresh Boarder

teitbite
Mon Feb 02, 2015 10:45 am
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.
User avatar
Moderator

GK User
Wed Feb 11, 2015 7:35 pm
visability wrote: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..!
User avatar
Senior Boarder

teitbite
Fri Feb 13, 2015 9:40 pm
Hi

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

GK User
Wed Apr 29, 2015 5:12 pm
same here, Im using english language, and keep getting same same error on clean new database, something is missing.???
User avatar
Fresh Boarder

teitbite
Thu Apr 30, 2015 8:12 pm
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.
User avatar
Moderator

GK User
Thu Oct 15, 2015 3:11 pm
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.
User avatar
Expert Boarder

teitbite
Sun Oct 18, 2015 11:05 am
Hi

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

GK User
Wed Feb 03, 2016 5:28 pm
THIS WORKED GREAT!

mavievs wrote: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.
User avatar
Junior Boarder

teitbite
Tue Feb 09, 2016 10:40 am
Hi

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


cron
Remember me
Register New Account
If you are old Gavick user, click HERE for steps to retrieve your account.