search

GavickPro / News-Show-Pro-GK5

Advanced Joomla! content module.
28 stars 37 forks source link

can't use News-Show-Pro-GK5 i get a 1064 error #353

Open Alexandra99 opened 8 years ago

Alexandra99 commented 8 years ago

Hello today i download the News show pro gk5 1.9.3.4 version. I have updated my site before from joomla 2.5 to 3.5,vm2 to vm3 and had news show pro gk4 (so i installed the new version). But then i make the extension enable and make a module and now i get a 1064 message, only if i disable the extension the site works fine: YOU HAVE AN ERROR IN YOUR SQL SYNTAX; CHECK THE MANUAL THAT CORRESPONDS TO YOUR MARIADB SERVER VERSION FOR THE RIGHT SYNTAX TO USE NEAR ')' AT LINE 18 SQL=SELECT DISTINCT C.VIRTUEMART_CATEGORY_ID AS CID FROM #VIRTUEMART_PRODUCT_CATEGORIES AS CX LEFT JOIN #VIRTUEMART_CATEGORIES_EL_GR AS C ON CX.VIRTUEMART_CATEGORY_ID = C.VIRTUEMART_CATEGORY_ID LEFT JOIN #__VIRTUEMART_PRODUCTS_EL_GR AS CONTENT ON CX.VIRTUEMART_PRODUCT_ID = CONTENT.VIRTUEMART_PRODUCT_ID LEFT JOIN #__VIRTUEMART_CATEGORIES AS CAT ON C.VIRTUEMART_CATEGORY_ID = CAT.VIRTUEMART_CATEGORY_ID WHERE ( CONTENT.VIRTUEMART_PRODUCT_ID = )

What can i do? sorry but i am newbie and still trying to learn

Alexandra99 commented 8 years ago

Also the other data source doesn't work. I have in VM both greek and english language. Any suggestion would help

dziudek commented 8 years ago

Hello,

Please make sure that you have set a language suffix in the VirtueMart data source settings properly (should be the same as the tables suffix with language)

Alexandra99 commented 8 years ago

Hello Dziudek and thank you for your reply. I try it that but with no luck. I don't know if I am doing something wrong. My site is multilanguage it has both Greek and English. I have set default template the Greek language so in the NSP i had try firstly the greek suffix, i save it and clean the cache of joomla and browser but it still shows 1064. Also tried in english but same i had 1064 error. I don't know if it has problem that my products are named by English and Greek name together. I have attached printscreens. Could it be that fault? nsp2 nsp1

dziudek commented 8 years ago

You have to put the table suffix with underscore: el_gr

Alexandra99 commented 8 years ago

Done that, nothing changed

dziudek commented 8 years ago

Ok, now I see your issue in the query - you have probably set the module to use products as a data source but you didn't specified product IDs separated by comma.

Alexandra99 commented 8 years ago

i choosed product categories and i select them from the textarea should i add ids?

dziudek commented 8 years ago

Do you have the same query in the error message?

Alexandra99 commented 8 years ago

this one again YOU HAVE AN ERROR IN YOUR SQL SYNTAX; CHECK THE MANUAL THAT CORRESPONDS TO YOUR MARIADB SERVER VERSION FOR THE RIGHT SYNTAX TO USE NEAR ')' AT LINE 18 SQL=SELECT DISTINCT C.VIRTUEMART_CATEGORY_ID AS CID FROM #VIRTUEMART_PRODUCT_CATEGORIES AS CX LEFT JOIN #VIRTUEMART_CATEGORIES_EN_GB AS C ON CX.VIRTUEMART_CATEGORY_ID = C.VIRTUEMART_CATEGORY_ID LEFT JOIN #__VIRTUEMART_PRODUCTS_EN_GB AS CONTENT ON CX.VIRTUEMART_PRODUCT_ID = CONTENT.VIRTUEMART_PRODUCT_ID LEFT JOIN #__VIRTUEMART_CATEGORIES AS CAT ON C.VIRTUEMART_CATEGORY_ID = CAT.VIRTUEMART_CATEGORY_ID WHERE ( CONTENT.VIRTUEMART_PRODUCT_ID = )

dziudek commented 8 years ago

Please send me screenshots of your configuration for the Data source tab.

Alexandra99 commented 8 years ago

Yes, of course, news_pro1 news_pro2

dziudek commented 8 years ago

Please try to change shopper group to "default". It is in general last chance as I have no other ideas for this issue :(

Alexandra99 commented 8 years ago

it didn't help. thank you though for the try :)