Virtuemart, 1146 AND English default

Guys,

Have been through the forum for both the Storefront and Storebox templates and can't find a solution. As with others, my error message on install is:

Table 'XXXXX_XXXXX.i8at0_virtuemart_vendors_en_gb' doesn't exist SQL=SELECT `i8at0_virtuemart_vendors`.* ,`i8at0_virtuemart_vendors_en_gb`.* FROM `i8at0_virtuemart_vendors` INNER JOIN `i8at0_virtuemart_vendors_en_gb` using (`virtuemart_vendor_id`) WHERE `i8at0_virtuemart_vendors`.`virtuemart_vendor_id` = "1"

1) Removing the GKTabs, as already documented helps in resolving ONLY the front page issue. Does nothing for being able to use Virtuemart. Running a Database fix from the J3 admin panel solves nothing.

2) Language is the default EN-GB.

3) Virtuemart AIO returns a 404 error in admin panel

4) Trying to access Virtuemart sections in Admin panel returns error messages, for instance:
Products: Table 'XXXX_XXXX.i8at0_virtuemart_products_en_gb' doesn't exist SQL=SELECT SQL_CALC_FOUND_ROWS p.`virtuemart_product_id` FROM `i8at0_virtuemart_products` as p INNER JOIN `i8at0_virtuemart_products_en_gb` as l using (`virtuemart_product_id`) group by p.`virtuemart_product_id` ORDER BY product_name DESC LIMIT 0, 20

Configuration: Table 'XXXX_XXXX.i8at0_virtuemart_shipmentmethods_en_gb' doesn't exist SQL=SELECT virtuemart_shipmentmethod_id,shipment_name FROM i8at0_virtuemart_shipmentmethods INNER JOIN i8at0_virtuemart_shipmentmethods_en_gb USING (virtuemart_shipmentmethod_id) WHERE published="1"

5) I also tried something totally different. Separate install of the Steakhouse Template, with a clean install of VM. Virtuemart works, VM AIO still returns a 404 error in admin panel.

Is the problem Virtuemart, and should we stop trying to get a solution? Alternatively, is it fixable, and we're all missing something painfully obvious?

Would really appreciate your help as i was hoping on moving away from J2.5 and Vm2 for these two projects i have in hand, but it seems to be, so far, impossible.

Seems like a problem with installation itself. Please reinstall and check this documentation:
http://www.gavick.com/documentation/joo ... quickstart

Thank you for your reply - but FAR from it.

Installation is in the default English. As mentioned in my original post.

And please, did you see how many people are reporting the same exact thing? Have been working with your templates and quickstarts for years now, can't have unlearnt how to all of sudden.

Now, back to my original question. Is it Virtuemart or your template? Please refer to my points numbered 1-5.

Having deleted the storefront installation, have to refer you to the same exact problem on the storebox quickstart.

http://id.com.mt/_hosted/newth/error/frontpage.png
http://id.com.mt/_hosted/newth/error/site_lang_ver.png
http://id.com.mt/_hosted/newth/error/vm_aio.png
http://id.com.mt/_hosted/newth/error/vm_categories.png
http://id.com.mt/_hosted/newth/error/vm_config.png

Is it VM3, the quickstart or something else?

For the record, in a moment of self doubt, went thru the hassle of another uplaod and install, following the instructions you linked me to, to the letter - including choosing Polish. Same exact result.

So what is it? Virtuemart or the Quickstart?

Would appreciate a concrete reply, not one where you treat your paying customers like idiots, leaving us without a proper answer.

Nobody treats noone like "idiots".
There seems to be something wrong. I'll inform our devteam to verify the quickstart.

PS - I have been able to install quickstart correctly in en/gb language but whenever I change default language to other - problem appears.
Must have been an issue with latest version as it was working before.
All other reports - are in all cases because in last step users didnt install language files correctly. Sadly Joomla installation cannot be hacked to force language installation with quickstart. Now it wouldn't affect normal Joomla quickstart, but VM added to it is specific and requires some additional steps to have correctly installed database.

Seems it can be fixed quickly by going to vm setup (after installation, even with error on frontend) Component->vm->configuration, then on shop tab, in language settings adding additional language in "Multilingual shop" field.

Seems it can be fixed quickly by going to vm setup (after installation, even with error on frontend) Component->vm->configuration, then on shop tab, in language settings adding additional language in "Multilingual shop" field.

Hi Cyberek - even when I go into VM component and try to select 'configuration' I get the attached error in the admin area. Is there a fix for this error?

I was able to fix it installing en/gb at first place without polish language, adding pl in administrator and adding in vm configuration.
Meanwhile our dev team has fixed quoickstarts - the problem source was a change in VM 3.0.6 behave.

Has this been fixed? I have did a complete fresh install of quickstart J30 storefront and the frontend gave me an error 1146-Error 1146. I uninstalled VM and the problem is still there.

TABLE 'Database.QKYAR_VIRTUEMART_CATEGORIES_EN_GB' DOESN'T EXIST SQL=SELECT DISTINCT C.VIRTUEMART_CATEGORY_ID AS CID FROM QKYAR_VIRTUEMART_PRODUCT_CATEGORIES AS CX LEFT JOIN QKYAR_VIRTUEMART_CATEGORIES_EN_GB AS C ON CX.VIRTUEMART_CATEGORY_ID = C.VIRTUEMART_CATEGORY_ID LEFT JOIN QKYAR_VIRTUEMART_PRODUCTS_EN_GB AS CONTENT ON CX.VIRTUEMART_PRODUCT_ID = CONTENT.VIRTUEMART_PRODUCT_ID LEFT JOIN QKYAR_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 )

How do I fix this issue. Is there something with VM latest edition or should I install a fresh install directly from the Virturemart site?

One more quick question, every time there is an update am I suppose unzip the files from gavick and copy them directly into the ftp root folder? installation instructions on gavick are vague and not very much clear.

Please Help
RJ

Please check documentation I have mentioned before - now it should work fine.
If it goest to template vs quickstart - its more like basic Joomla knowledge. Please read this article:
https://www.gavick.com/documentation/jo ... rt-package

I reinstalled a complete and fresh quickstart and after removing the installation folder at the end of the installation process I got the error below. How do I fix this?

TABLE 'STOREFRONT.P7RAG_VIRTUEMART_CATEGORIES_EN_GB' DOESN'T EXIST SQL=SELECT DISTINCT C.VIRTUEMART_CATEGORY_ID AS CID FROM P7RAG_VIRTUEMART_PRODUCT_CATEGORIES AS CX LEFT JOIN P7RAG_VIRTUEMART_CATEGORIES_EN_GB AS C ON CX.VIRTUEMART_CATEGORY_ID = C.VIRTUEMART_CATEGORY_ID LEFT JOIN P7RAG_VIRTUEMART_PRODUCTS_EN_GB AS CONTENT ON CX.VIRTUEMART_PRODUCT_ID = CONTENT.VIRTUEMART_PRODUCT_ID LEFT JOIN P7RAG_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 )

Please help. RJ

Seems it can be fixed quickly by going to vm setup (after installation, even with error on frontend) Component->vm->configuration, then on shop tab, in language settings adding additional language in "Multilingual shop" field.

This helps me. Thx.

Thanks I will try this and see what I come up with. Hopefully this will work. Thanks again!

RJ

@rojones31 please let me know if that helped.

Yes, Cyberek solution from above actually solve the problem for now. Thanks Cyberek. I did a fresh install of quickstartJ30 for storefront and followed the instructions and the error was cleared. Thanks again!

RJ

@rojones31 thanks for the info.
If you have any additional questions regarding this topic, please let me know.

@Cyberek - Thanks!