Error after updating language file

Hello:

I'm getting this error code after updating languages and getting rid of the 1146 error code. The error is as follows:

Code: Select all

YOU HAVE AN ERROR IN YOUR SQL SYNTAX; CHECK THE MANUAL THAT CORRESPONDS TO YOUR MYSQL SERVER VERSION FOR THE RIGHT SYNTAX TO USE NEAR ')' AT LINE 18 SQL=SELECT DISTINCT C.VIRTUEMART_CATEGORY_ID AS CID FROM JOS_VIRTUEMART_PRODUCT_CATEGORIES AS CX LEFT JOIN JOS_VIRTUEMART_CATEGORIES_EN_US AS C ON CX.VIRTUEMART_CATEGORY_ID = C.VIRTUEMART_CATEGORY_ID LEFT JOIN JOS_VIRTUEMART_PRODUCTS_EN_US AS CONTENT ON CX.VIRTUEMART_PRODUCT_ID = CONTENT.VIRTUEMART_PRODUCT_ID LEFT JOIN JOS_VIRTUEMART_CATEGORIES AS CAT ON C.VIRTUEMART_CATEGORY_ID = CAT.VIRTUEMART_CATEGORY_ID WHERE ( CONTENT.VIRTUEMART_PRODUCT_ID = )

Any help with this matter would be greatly appreciated as I can not even use my site right now. If you need the site URL it is here:http://shop.koernervisions.com.

Thanks in advance,

Michael K.

Hi

Looks like there is no product ID in the query. Do You know what is causing it ? If it's a module than You need to take a closer look into settings of its source. If it's a component than there is most probably nothing selected in menu manager for this menu item.

I'm sorry, but can you elaborate a little more? I don't even know where to start looking with what you are referring to.

Thanks,

Michael K.

Hi, there i have the same problem with this template.
Something is bad in quick install, can someone from gavick take a look and help us???

Thank you

Hi, there i have the same problem with this template.
Something is bad in quick install, can someone from gavick take a look and help us???

Thank you

Yes Please?

Hi

Och, so it's a quickstart installation. Than I believe I know where the problem can be. I believe You have not selected English (United Kingdom) language during quickstart installation process. This is necessary, because VM creates tables only for installed languages and our demo is prepared for English (United Kingdom). If You have selected different language than there will be no tables in database and also no products because of this.

help me please https://yadi.sk/i/GTwUEHDwetk9J

Same problem when I publish Nsp Gk 5 after latest february update

http://lecanzonidamore.it/

Hi

Och, so it's a quickstart installation. Than I believe I know where the problem can be. I believe You have not selected English (United Kingdom) language during quickstart installation process. This is necessary, because VM creates tables only for installed languages and our demo is prepared for English (United Kingdom). If You have selected different language than there will be no tables in database and also no products because of this.

Hi

Have anyone of You been able to check if what I adviced works ? I need to know if it's a known problem caused by joomla update or something different.

please tell me how to check this?

Hi

By settings English (United Kingdome) as a default language. Please read this to learn more about the problem: https://www.gavick.com/documentation/jo ... quickstart

Привет, настройки английский (Соединенное Королевство) в качестве языка по умолчанию. Пожалуйста, прочитайте это, чтобы узнать больше о проблеме: https://www.gavick.com/documentation/jo ... quickstart

Can I fix it already on the live site?

Привет, настройки английский (Соединенное Королевство) в качестве языка по умолчанию. Пожалуйста, прочитайте это, чтобы узнать больше о проблеме: https://www.gavick.com/documentation/jo ... quickstart

Can I fix it already on the live site?

I wrote all of that ??

Yes You can fix it on a live website. You just need to check what is the default language used by VM. Best option is to look into dtatabase and see what are the tables names for vm products. It should have a language tag. Than You need to switch VM to that language. In NSP modules You may need to use this tag in VM overrides to force it to use this tables instead.

the problem is that when I want to display news K2, and SQL error indicates virtuemart tables. How are they linked? But another tab correctly shows the virtuemart products. That is, the module works, but not toggle "data source". the tables in the database match the language of virtumart. Any ideas?

the problem is that when I want to display news K2, and SQL error indicates virtuemart tables. How are they linked? But another tab correctly shows the virtuemart products. That is, the module works, but not toggle "data source". the tables in the database match the language of virtumart. Any ideas?

The only way for me to fix this problem was to do a re-install and select English (United Kingdom). I tried everything I possibly could to not have to do that, but had no success. Hope you can find a solution.

Hi

I had the same problem on one of mine websites and all I've done was to install English (United Kingdom) next to the Italian I used during installation of the quickstart. Than I selected English as a default and changed all NSP instances with VM to overwrite language table suffix to "en_en" (or "_en_en" I do not remember exactly).

One of the users has solved this problem by simply renaming suffixes in database to His default language. I have not tried that, but He claimed it's working.