Problem with selection categories vituemart

Free responsive Joomla 2.5 and 3.x module to present your content with easy and intuitive way.
Rate this topic: Evaluations: 0, 0.00 on the average.Evaluations: 0, 0.00 on the average.Evaluations: 0, 0.00 on the average.Evaluations: 0, 0.00 on the average.Evaluations: 0, 0.00 on the average.Evaluations: 0, 0.00 on the average.
GK User
Mon Feb 20, 2012 2:05 pm
I have a problem with the module news_pro_gk4. When I want to do the source of articles, I can't select "Virtuemart categories". It shows message:
VirtueMart is not installed or any VirtueMart categories are available.
I have installed Virtuemart and it seems works fine.
Somebody can help me?

Thanks
User avatar
Fresh Boarder

GK User
Tue Feb 21, 2012 10:10 am
Hi Herman,

Please make sure that you are using latest version of the module, this seems to be a bug and has been fixed already. If you are but problem persists, then please send me a PM with backend and FTP access then I will check further for you.

Thanks,
User avatar
Platinum Boarder

GK User
Tue Feb 21, 2012 4:21 pm
Thanks Don.
I'm going totry download the lastest version and I'm going to re-install.
I'll tell you the results
User avatar
Fresh Boarder

GK User
Tue Feb 21, 2012 4:42 pm
Hi Don:
I've downloaded the GK4 v.3.3 and I've installed, but the problem is the same.
Can you tell me more explicitly wich do you need for your check?
Thanks
User avatar
Fresh Boarder

GK User
Wed Feb 22, 2012 12:14 am
Hermancollado wrote:I have a problem with the module news_pro_gk4. When I want to do the source of articles, I can't select "Virtuemart categories". It shows message:
VirtueMart is not installed or any VirtueMart categories are available.
I have installed Virtuemart and it seems works fine.
Somebody can help me?

Thanks


Got the same problem after switching to another language (fr) than the default language.
In fact, after switching to fr, every category in VM is gone (wich explains why no category can be selected in NSP). When I switch back to en, categories are back, and NSP is working well too.
User avatar
Fresh Boarder

GK User
Wed Feb 22, 2012 12:23 am
Yest the categories should gone because they were created for another language (in your case en-GB), please create some categories and set them to French language then you will see some items on list. It is correct approach because you can display products only for default language so products for English language are not available in French version.
User avatar
Platinum Boarder

GK User
Wed Feb 22, 2012 9:24 am
I think my problem it's not the same with the language.
My default language is spanish and the categories was created in spanish
User avatar
Fresh Boarder

GK User
Thu Feb 23, 2012 12:12 pm
Hermancollado wrote:Hi Don:
I've downloaded the GK4 v.3.3 and I've installed, but the problem is the same.
Can you tell me more explicitly wich do you need for your check?
Thanks


Hi Don:
Please, I'm waiting your answer.
What do you nedd for your check? If you need my backend you'll need my password. Can you give me a direct contact with tou for send you with security? or wich is the way?

Thanks
User avatar
Fresh Boarder

GK User
Thu Feb 23, 2012 12:19 pm
Hi,

Please contact bkrztuk, he is the responsive developer for this issue :)

@Bartek: Please help check this issue, I have seen somewhere you had fixed this problem already. Thanks!
User avatar
Platinum Boarder

GK User
Fri Feb 24, 2012 8:13 pm
I need to advance in my joomla project. I think this is an important point for my project and I've proved with a new installation of virtuemart, a new intallation of news gkpro, I've made news categories with new installations.... but the problem is the same:
"VirtueMart is not installed or any VirtueMart categories are available."
I have virtuemart 1.1.9 and joomla 1.5.25
Please....I've trusted in your develop and I'm a customer, I hope some interest by your side.
Thanks
User avatar
Fresh Boarder

GK User
Thu Mar 01, 2012 2:25 am
I am equally and with the same versione of joomla and vm
Language ES_es :blush:
User avatar
Fresh Boarder

GK User
Thu Mar 01, 2012 11:48 am
Please make sure that categories and products are set to this additional language, because when you firstly set VirtueMart component and then install another language the categories and products are available on for en_GB so obviously you can't see them on module.
User avatar
Platinum Boarder

GK User
Thu Mar 01, 2012 11:52 pm
Not only that, the classes in this module are for VirtueMart 2.0!.
Do not understand how nobody has said yet: (


$query_name = '
SELECT DISTINCT
c.virtuemart_category_id AS ID,
c.category_name AS name
FROM
#__virtuemart_product_categories AS cx
LEFT JOIN
#__virtuemart_categories_'.$lang.' AS c
ON
cx.virtuemart_category_id = c.virtuemart_category_id
LEFT JOIN
#__virtuemart_products_'.$lang.' 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
User avatar
Fresh Boarder

GK User
Fri Mar 02, 2012 9:19 am
So, is posible that the problem could be the version of virtuemart?. I have installed 1.1.9.

Bartek, I think it's not a problem with language, because I re-installed virtuemart a few years ago (without installation of new language) and I set categories in english, but the problem was the same.
User avatar
Fresh Boarder

GK User
Fri Mar 02, 2012 9:21 am
Hermancollado wrote:So, is posible that the problem could be the version of virtuemart?. I have installed 1.1.9.

Bartek, I think it's not a problem with language, because I re-installed virtuemart a few years ago (without installation of new language) and I set categories in english, but the problem was the same.



Sorry, I r-installed virtuemart a few days ago
User avatar
Fresh Boarder

GK User
Fri Mar 02, 2012 8:44 pm
Team, has some body fixed the problem with selection categories virtuemart?

I have the problem yet, i use virtuemart 2.02 e NewsPro GK4 3.03.

Please, some body help-me...

Thanks,

Leo
User avatar
Junior Boarder

GK User
Fri Mar 02, 2012 8:53 pm
leobarreto74 wrote:Team, has some body fixed the problem with selection categories virtuemart?

I have the problem yet, i use virtuemart 2.02 e NewsPro GK4 3.03.

In Data Source (NPG4) appear: VirtueMart is not installed or any VirtueMart categories are available.

Please, some body help-me...

Thanks,

Leo
User avatar
Junior Boarder

GK User
Fri Mar 02, 2012 10:46 pm
jo_maki wrote:Not only that, the classes in this module are for VirtueMart 2.0!.
Do not understand how nobody has said yet: (


$query_name = '
SELECT DISTINCT
c.virtuemart_category_id AS ID,
c.category_name AS name
FROM
#__virtuemart_product_categories AS cx
LEFT JOIN
#__virtuemart_categories_'.$lang.' AS c
ON
cx.virtuemart_category_id = c.virtuemart_category_id
LEFT JOIN
#__virtuemart_products_'.$lang.' 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



Please firstly login to your database and check VM tables before you write. Since VirtueMart 2.0 the products have different tables depends on language and this is why in this queries is $lang included. You can select product only from categories which are set to default language. Common problem is that after user install external language and set it as a default the product and categories are still available for en_GB so you can't see them. Is there anyone who have VirtueMart with default settings and NSP with this problem ?

One more thing, since VirtueMart component make different changes in code and component features the NSP in latest version support only VM in 2.0 and higher version, because there is no way to fork code to two such different versions.
User avatar
Platinum Boarder

GK User
Sat Mar 03, 2012 1:41 am
User avatar
Fresh Boarder

teitbite
Mon Mar 05, 2012 6:25 pm
Hi

I was asked by mail to join this conversation.

@Hermancollado - All You need to do is to download this download/file.php?id=4195 and overwrite module files by FTP.
User avatar
Moderator

GK User
Wed Mar 14, 2012 4:34 am
Hello - i'm having this same issue.

i have joomla 2.5.2 VM 2.0.2 and the latest gavick esport tempalte 2.7 and the latest news_pro_gk4 3.0.3

My website is in full russian as default language - VM only lang is Russian - yet i still get VirtueMart is not installed or any VirtueMart categories are available.

I have 4 categories.. the funny thing is that i udated the module and thats when it stopped working.. if i don't save (http://aleksandrshevchenko.org/store) the module it will work, however, if i want to make a change in the module settings - i will get "Error: No articles to display" after applying the changed. Obviously i already noticed that it said can't find the categories so i didn't save. However, i need to make some changes and this is no way around it of just not editing it.

What is the solution.

i've looked all over for the solution. Can't find one. I really need help. Can some one take a look at my site please and see what am i doing wrong.. however, it feels like it's a bug of some sort.
User avatar
Expert Boarder

GK User
Wed Mar 14, 2012 6:52 am
I did a quick test.. it seems that new pro gk 3.0.3 is less stable that 3.0 as everything worked there.. i just installed and updated everything but new_pro_gk and everything worked.. hmmm.. :(
User avatar
Expert Boarder

teitbite
Thu Mar 15, 2012 12:52 am
Hi

Please send me joomla panel access and ftp access a a site with this problem so I'll be able to pass this to programmers for permament fix.
User avatar
Moderator

GK User
Thu Mar 15, 2012 8:27 am
alright - i sent u the info.
User avatar
Expert Boarder

teitbite
Thu Mar 15, 2012 3:41 pm
Hi

Please just tell me on which page I can see a module with VM products.
User avatar
Moderator

GK User
Thu Mar 15, 2012 9:24 pm
sorry about that..

here it is: http://aleksandrshevchenko.org/store

module is "Popular Items"
User avatar
Expert Boarder

teitbite
Fri Mar 16, 2012 8:15 pm
Hi

Ok. Looks like a bug after all. I'm sending this to programers. Here is a screen of message in admin panel for better understanding.
User avatar
Moderator

GK User
Fri Mar 16, 2012 11:14 pm
thank you.
User avatar
Expert Boarder

teitbite
Sat Mar 17, 2012 12:45 am
Hi

Got an answer from programmer:

When the front-end language is russian and backed english module can display only categories from front-end default language - in this case there are any categories for English language. I've switched back-end language to russin and there is no problem, simply user have access only to data source for selected language this is logical solution because avoid problems in front-end display.
User avatar
Moderator

GK User
Sat Mar 17, 2012 2:22 am
oh my.. :) lol.. so when ever i want to make changes.. i have to change to RU in the BE.. thats cool.. :)

i will do that. Thank you. :) i guess this is solved.
User avatar
Expert Boarder

teitbite
Mon Mar 19, 2012 11:04 am
Hi

Ok. Good to hear that :)
User avatar
Moderator

GK User
Thu Mar 22, 2012 7:32 pm
teitbite wrote:Hi

I was asked by mail to join this conversation.

@Hermancollado - All You need to do is to download this download/file.php?id=4195 and overwrite module files by FTP.



Thanks, now I can select the virtuemart categories.
But in my front-end it shows an error message:

Notice: Undefined variable: sql_where2 in /home/u825077737/public_html/modules/mod_news_pro_gk4/gk_classes/gk.source.vm.php on line 261

Thank you for your help
User avatar
Fresh Boarder

teitbite
Fri Mar 23, 2012 1:35 am
Hi

Can You send me an access to FTP ? I'll fix it than.
User avatar
Moderator

GK User
Sat Mar 31, 2012 12:09 pm
teitbite wrote:Hi

Can You send me an access to FTP ? I'll fix it than.



Ok, I send you by mail.
Thanks
User avatar
Fresh Boarder

teitbite
Sat Mar 31, 2012 4:11 pm
Hi

I've edite mentioned file and added this line to line 73

Code: Select all
$sql_where2 = '';


Should be ok now. Please check it.
User avatar
Moderator

GK User
Sat Mar 31, 2012 6:19 pm
teitbite wrote:Hi

I've edite mentioned file and added this line to line 73

Code: Select all
$sql_where2 = '';


Should be ok now. Please check it.


No, I can´'t see now my front-end, it shows this message:

Parse error: syntax error, unexpected '&' in /home/u825077737/public_html/modules/mod_news_pro_gk4/gk_classes/gk.source.vm.php on line 74
User avatar
Fresh Boarder

GK User
Mon Apr 02, 2012 2:51 pm
Hermancollado wrote:
teitbite wrote:Hi

I've edite mentioned file and added this line to line 73

Code: Select all
$sql_where2 = '';


Should be ok now. Please check it.


No, I can´'t see now my front-end, it shows this message:

Parse error: syntax error, unexpected '&' in /home/u825077737/public_html/modules/mod_news_pro_gk4/gk_classes/gk.source.vm.php on line 74




I've repaired the mistake yet.
You had wrote "&" in the place of $.

Thanks for all
User avatar
Fresh Boarder

teitbite
Wed Apr 25, 2012 12:20 am
Hi

Sorry I got unsubscribed from this topic and now thans to Dziudek's script I was able to find it one more time.

Och my. Sorry for that. I must have deleted '&nspb;' sign and leave ampersant :(
User avatar
Moderator


cron