Error 1146

Hello:

I installed the Joomla! 3.x quick start package and I right away got an error code "1146". I've had this problem it seems with all of the VirtueMart templates that Gavick provides. The error is listed below:

Code: Select all

Table 'jmosij_cor.z10x2_virtuemart_categories_en_gb' doesn't exist SQL=SELECT DISTINCT c.virtuemart_category_id AS CID FROM z10x2_virtuemart_product_categories AS cx LEFT JOIN z10x2_virtuemart_categories_en_gb AS c ON cx.virtuemart_category_id = c.virtuemart_category_id LEFT JOIN z10x2_virtuemart_products_en_gb AS content ON cx.virtuemart_product_id = content.virtuemart_product_id LEFT JOIN z10x2_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 )

Any help with this would be greatly appreciated!

Thanks,

Michael K.

Please check this documentation:
https://www.gavick.com/documentation/jo ... quickstart

Please check this documentation:
https://www.gavick.com/documentation/jo ... quickstart

Okay, so I followed the above provided steps for the English US language twice and now I have received the following error code both times.

Code: Select all

Table 'jmosij_cor.tkct7_virtuemart_products_en_gb' doesn't exist SQL=SELECT `tkct7_virtuemart_products`.* ,`tkct7_virtuemart_products_en_gb`.* FROM `tkct7_virtuemart_products` INNER JOIN `tkct7_virtuemart_products_en_gb` using (`virtuemart_product_id`) WHERE `tkct7_virtuemart_products`.`virtuemart_product_id` = "1"

Hey kbigmike2121, I had the same issue when I started mine, what you have to do is load it with an additional language (I used Australian) and then once loaded, switch back to US English....

I had the same issue altough I followed the installation manual very carefully. The thing is that virtuemart packed in the quickstart package want to use mysql tables ending with _en_gb, but the installer never create any, no matter what language you chose. (wasted days experimenting different combinations, none was working)

I've chosen Hungarian language and Installer created tables ending _hu_hu. What I've done is selected all tables ending with _hu_hu, duplicated them with something different prefix and then renamed the duplicated ones to the correct prefix and also ending _en_gb.

All working now, happy days. Just pissed a bit...

I had the same issue altough I followed the installation manual very carefully. The thing is that virtuemart packed in the quickstart package want to use mysql tables ending with _en_gb, but the installer never create any, no matter what language you chose. (wasted days experimenting different combinations, none was working)

I've chosen Hungarian language and Installer created tables ending _hu_hu. What I've done is selected all tables ending with _hu_hu, duplicated them with something different prefix and then renamed the duplicated ones to the correct prefix and also ending _en_gb.

All working now, happy days. Just pissed a bit...

Can you please elaborate a little more on this? Like what process you did this at?

Please install quickstart with English (UK) - it should create correct tables.
Also please check VM configuration if it has correct languages selected.

Please install quickstart with English (UK) - it should create correct tables.
Also please check VM configuration if it has correct languages selected.

Installing with English - UK is what I did on the very first attempt. With both English - UK and English - US, when I travel to the VirtueMart configuration page, I get the bellow error:

Code: Select all

 1146 Table 'jmosij_cor.tkct7_virtuemart_shipmentmethods_en_gb' doesn't exist SQL=SELECT virtuemart_shipmentmethod_id,shipment_name FROM tkct7_virtuemart_shipmentmethods INNER JOIN tkct7_virtuemart_shipmentmethods_en_gb USING (virtuemart_shipmentmethod_id) WHERE published="1"

Have you checked current quickstart (there was a bug in package few days ago which should be already fixed)

I had the same issue altough I followed the installation manual very carefully. The thing is that virtuemart packed in the quickstart package want to use mysql tables ending with _en_gb, but the installer never create any, no matter what language you chose. (wasted days experimenting different combinations, none was working)

I've chosen Hungarian language and Installer created tables ending _hu_hu. What I've done is selected all tables ending with _hu_hu, duplicated them with something different prefix and then renamed the duplicated ones to the correct prefix and also ending _en_gb.

All working now, happy days. Just pissed a bit...

Can you please elaborate a little more on this? Like what process you did this at?

You have to go to your phpMyAdmin where you can find the database your site uses. Find and select tables like this: ywchq_virtuemart_categories_hu_hu
The prefix (ywchq_) and the end of the table name (_hu_hu in my case) will be different in your database. There should be 7 of those tables I think, so select them by ticking the tickbox.
Then scroll down where you can find a droplist which says 'With selected:' and chose 'Copy table with prefix'
On the next screen in the 'To' field write '_' so it will create the new tables with the same names but beginning with this: _
Now you should see the newly copied tables in the list. Switch to the SQL tab.
You have to run sql command there for renaming the tables. Use this command:

Rename table _ywchq_virtuemart_categories_hu_hu TO ywchq_virtuemart_categories_en_gb

Don't forget to use the correct prefix and language tag your database uses as the example above is taken from mine.
Use this command on all of your copied tables.

I hope it helps and is understandable enough

Guys, it's more easy then table renaming and stuff..

Just install your language in the backend, which is normal working.
After that install your VirtueMart Language as well, through the backend.
Add in language manager your language tag.

After this it al works well.

Exactly as @Newllander said - if during installation anything went wrong, install missing language for Joomla and VM (VM has its own language configuration inside its settings).

Ok guys, I'm still not there, help me, coz I'm completely lost. English (UK) and Hungarian languages are installed in Joomla, Hungarian has been set as default for frontend and backend. Both of those languages are installed for VM too.

If I create a product or category or whatever in VM, it puts it in the table ending '_hu_hu' thats fine,
BUT I can't see it unless I put it manually into the table ending '_en_gb'

It seems to me that VM uses the _hu_hu tables but Joomla gets the datas from _en_gb but I can't get that why.
Any ideas what I have missed?

I unfortunately had to go with a completely different template. I just could not get this to work and time was of most importance. Unfortunate but just part of the business I guess.

I think I got it. In my Joomla there was a missing flag which I didn't notice. Since I created it in Extensions -> Language manager -> Contents, everything seems working now. Actually VM was showing a notice about that missing flag but I didn't know what was that for... my dumbness

@latskoo I'm glad you could figure it out.