Error 1064 with Virtuemart Products or Categories

Hi! I'm using StoreBox template on Joomla 3.3.1 with VirtueMart 2.9. I've also installed News Show Pro GK5 but the moment I try to use VM Categories or Products as source I get a 1064 Error.I couldn't find anything in the log, how could I fix this?
Thanks

Hi

This error is displayed when module is trying to show not existing content, so please check if IDs You are giving are correct and if language is set properly.

Hi there, I've already checked, all products and cateogories are correct, the fact is that the dialog in the Source tab of NSP GK5 isn't showing the VM categories list, so I guess that's why the module can't find the content.
By the way I had to uninstall VM because VM2.9 is only a beta version and is not suitable for production (many problems with multilingual management and so on), moreover the template StoreBox wasn't exaclty "ready" for this version of VM and all VM pages were a mess (in terms of css), so I decided to switch to HikaShop sorry!
I will definitely try again as soon as VM will be available for J3 and let you know.

Hi there, still me.... I've tried to use NSP GK5 with HikaShop, but as I try to switch from standard mode to another mode for the slider I get this message: "Specific data source is not supported by selected Portal Mode. Please change the data source or portal mode"
By the way, if I choose Standard Mode.. I still get the 1064 error (
Any suggestion?

Hi

NSP doesn't have a style supporting hikashop yet, but the newest version can support it with a normal style, so please try it.

The problem You had with NSP and VM was a wrong language table or lack of language table prefix selected. In such cases categories are not visible, because NSP is looking in a different language table for them.

Hi, thanks, As soon as VM will be fully compatible with J3 I will definitely try. I guess there was something else, because I added to the shop only four products, just to try the slider, and I added them in all three langs available on the web site, but still no success. The fact is, though, that multilang on VM2.9 for J3 wasn't actually working properly, and I guess it might be the cause of my error.
As for the newest version of NSP, when was updated? I downloaded the file three days ago, If there's a new version available now I will definitely try it with hika
Thanks again

Hi

You can check the history of module version update on our update page, but this should be ok. Anyway I think that forcing in NSP settings to use the language table with suffix "_en_en" should search for categories only in this one language. You can try with others and I bet one of them will respond.

Hi,

I have the same problem. And it really looks like, that the author create the demo page and for download they simple remove the content. The Quickstart Version looks nice, but after press once "save and exit" you have no working demo-page anymore.

Can you post a default setup for Thumbnails NSP GK5 for your storebox demo-page (in the downloadable version), so that we are able to reproduce at least the basic page.

I tried many setup, for example I setup to use virtuemart products for GK5, but the error message shows that this module still load k2-content.

SELECT content.id AS id FROM ras1_k2_items AS content WHERE content.published = 1 AND content.trash = 0 AND content.access IN (1,1,5) AND ( content.publish_up = '0000-00-00 00:00:00' OR content.publish_up <= '2015-04-26 01:50:38' ) AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2015-04-26 01:50:38' ) AND ( content.catid = 10 ) AND content.featured = 0 ORDER BY content. DESC LIMIT 0,4;

And I see ORDER BY content.
There a missing data, but where can I setup this order by parameter.
Can you help to make this template workable?

thanks
Joerg

Hi

Try update NSP to latest version. Than edit all NSP modules settings. Clear browser cache, check source configuration and save settings even if no changes was done.

Hi,

thanks for your answer. I updated already. Same result. But I saw that the NSP-Module is used 3 times in that template. Once is working, twice not. Also after new setup and cache deleting. So I copied the MySQL parameter field from working to the non working entries and now it works everywhere. Not the nicest way, but it works.

Hi

"MySQL parameter field" what do You mean by that ? A language table suffix which is used for VM source or something else.

I went to xxx_modules and searched for the module ID 214, there is "**SHOPS** __&__ TRENDS". This Module is working.
I copied the content of "params".
This one:
{"moduleclass_sfx":"bigtitle","module_unique_id":"","cache":"1","cache_time":"30","cachemode":"itemid","module_mode":"Product_Gallery","use_own_article_format":"0","article_format":"-1","article_format_text":"","data_source":"com_virtuemart_products","source_name":"com_virtuemart","com_content_articles":"","k2_articles":"","easyblog_articles":"","rss_feed":"","json_file":"-1","xml_file":"-1","com_virtuemart_products":"100,101,102,103","com_hikashop_products":"","jomsocial_user_status":"","jomsocial_user_photo":"","news_sort_order":"DESC","offset":"0","news_since":"","news_in":"","news_featured":"1","only_featured":"0","one_article_per_category":"0","news_unauthorized":"0","time_offset":"0","thumb_image_type":"full","com_content_comments_source":"none","com_content_text_type":"introtext","hide_current_com_content_article":"0","k2_comments_source":"k2","com_k2_text_type":"introtext","hide_current_k2_article":"0","k2_image_size":"Generic","k2_get_extra_fields":"0","hikashop_itemid":"9999","hikashop_out_of_stock":"1","hikashop_add_to_cart":"1","rss_cache_time":"60","easyblog_comments_source":"easyblog","hide_current_easyblog_article":"0","easyblog_image_size":"original","vm_itemid":"9999","vm_lang":"","vm_shopper_group":"-1","vm_out_of_stock":"1","vm_show_price_type":"salesPrice","vm_add_to_cart":"0","vm_show_discount_amount":"0","vm_show_tax":"0","vm_display_type":"price","vm_show_featured_badge":"0","portal_mode_news_gallery_amount":"8","portal_mode_news_gallery_cols":"4","portal_mode_news_gallery_pagination_type":"arrows","portal_mode_news_gallery_autoanimation":"1","portal_mode_news_gallery_autoanimation_time":"5000","portal_mode_product_gallery_amount":"8","portal_mode_product_gallery_cols":"4","portal_mode_product_gallery_nav":"1","portal_mode_product_gallery_autoanimation":"0","portal_mode_product_gallery_autoanimation_time":"5000","portal_mode_product_gallery_2_rows":"2","portal_mode_product_gallery_2_cols":"4","portal_mode_product_gallery_2_button":"cart","portal_mode_news_blocks_cols":"2","portal_mode_news_blocks_rows":"2","portal_mode_title_overlay_text_pos":"top","portal_mode_title_overlay_text_padding":"30px","portal_mode_title_overlay_text_bg":"transparent","portal_mode_title_overlay_text_width":"100","portal_mode_centered_title_overlay_text_bg":"","portal_mode_centered_title_limit_type":"chars","portal_mode_centered_title_limit":"40","portal_mode_centered_text_limit_type":"words","portal_mode_centered_text_limit":"30","portal_mode_portfolio_initial_anim":"0","portal_mode_portfolio_cols":"3","portal_mode_portfolio_rows":"3","portal_mode_portfolio_pages":"3","portal_mode_portfolio_link":"1","portal_mode_portfolio_link_url":"","portal_mode_portfolio2_cols":"3","portal_mode_portfolio2_rows":"3","portal_mode_portfolio2_filter":"1","portal_mode_portfolio2_popup":"1","portal_mode_speakers_list_cols":"2","portal_mode_speakers_list_rows":"2","portal_mode_grid_title_overlay_text_pos":"none","portal_mode_grid_title_overlay_text_color":"light","portal_mode_grid_title_overlay_text_padding":"30px","portal_mode_frontpage_image_overlay_text_color":"light","portal_mode_frontpage_image_overlay_title":"1","portal_mode_frontpage_image_overlay_text":"1","portal_mode_frontpage_image_overlay_text_limit":"100","portal_mode_frontpage_image_overlay_readon":"1","portal_mode_frontpage_image_overlay_readon_text":"","portal_mode_highlights_readmore":"","portal_mode_highlights_amount":"7","portal_mode_highlights_date_format":"","portal_mode_highlights_title_limit_type":"chars","portal_mode_highlights_title_limit":"40","portal_mode_video_gallery_popup":"1","portal_mode_video_gallery_popup_x":"640","portal_mode_video_gallery_popup_y":"480","portal_mode_video_gallery_pages":"2","portal_mode_video_gallery_per_page":"3","portal_mode_video_gallery_title_limit_type":"chars","portal_mode_video_gallery_title_limit":"40","portal_mode_video_gallery_text_limit_type":"chars","portal_mode_video_gallery_text_limit":"60","portal_mode_video_gallery_autoanimation":"5000","portal_mode_video_list_popup":"1","portal_mode_video_list_popup_x":"640","portal_mode_video_list_popup_y":"480","portal_mode_video_list_pages":"2","portal_mode_video_list_per_page":"3","portal_mode_video_list_title":"1","portal_mode_video_list_date":"1","portal_mode_video_list_title_limit_type":"chars","portal_mode_video_list_title_limit":"40","portal_mode_events_list_cols":"2","portal_mode_events_list_rows":"2","portal_mode_jomsocial_photos_total":"8","portal_mode_jomsocial_photos_amount":"4","portal_mode_jomsocial_photos_width":"310","portal_mode_jomsocial_photos_animation":"0","portal_mode_grid_news_cols":"2","portal_mode_grid_news_rows":"2","portal_mode_grid_news_title_length":"40","portal_mode_grid_news_title_length_type":"chars","portal_mode_grid_news_date_format":"f J, Y","portal_mode_grid_news_text_length":"40","portal_mode_grid_news_text_length_type":"chars","portal_mode_grid_news_url":"","portal_mode_grid_news_link_text":"Find more news","portal_mode_portfolio_grid_amount":"20","portal_mode_portfolio_grid_cols":"5","portal_mode_portfolio_grid_cols_small_desktop":"4","portal_mode_portfolio_grid_cols_tablet":"3","portal_mode_portfolio_grid_cols_small_tablet":"2","portal_mode_portfolio_grid_cols_mobile":"1","portal_mode_portfolio_grid_title_length":"40","portal_mode_portfolio_grid_title_length_type":"chars","portal_mode_portfolio_grid_title_link":"1","portal_mode_portfolio_grid_overlay":"1","portal_mode_portfolio_grid_popup":"1","portal_mode_portfolio_grid_date_format":"f J, Y","portal_mode_portfolio_grid_author":"1","news_full_pages":"3","news_column":"1","news_rows":"1","top_interface_style":"arrows_with_pagination","open_links_window":"_self","news_content_header_pos":"left","news_content_header_float":"none","news_header_link":"1","news_header_first_word":"0","use_title_alias":"0","title_limit_type":"chars","title_limit":"40","news_content_image_pos":"left","news_content_image_float":"left","news_image_link":"1","news_image_modal":"0","news_content_text_pos":"left","news_content_text_float":"left","news_text_link":"0","news_limit_type":"words","news_limit":"30","clean_xhtml":"1","allowed_tags":"","more_text_value":"...","readmore_text":"","parse_plugins":"0","clean_plugins":"0","news_content_info_pos":"left","news_content_info_float":"none","news_content_info2_pos":"left","news_content_info2_float":"left","info_format":"%DATE %HITS %CATEGORY %AUTHOR","info2_format":"","category_link":"1","date_format":"d-m-Y","date_publish":"0","username":"users.name","user_avatar":"1","avatar_size":"16","art_padding":"0 20px 20px 0","news_header_order":"1","news_header_enabled":"1","news_image_order":"3","news_image_enabled":"1","news_text_order":"4","news_text_enabled":"1","news_info_order":"2","news_info_enabled":"1","news_info2_order":"5","news_info2_enabled":"1","news_content_readmore_pos":"right","news_readmore_enabled":"1","news_short_pages":"3","links_amount":"3","links_columns_amount":"1","links_image":"0","links_readmore":"0","bottom_interface_style":"arrows_with_pagination","links_margin":"0","links_position":"bottom","links_width":"50","list_title_limit_type":"words","list_title_limit":"20","list_text_limit_type":"words","list_text_limit":"30","links_title":"0","links_title_url":"","links_title_label":"","responsive_images":"1","wrap_content":"0","memory_limit":"128M","use_curl_download":"0","create_thumbs":"1","img_auto_scale":"1","img_keep_aspect_ratio":"0","img_width":"160","img_height":"200","img_margin":"0 0 20px 0","links_img_width":"160","links_img_height":"120","links_img_margin":"6px 14px 0 0","img_bg":"#ffffff","img_stretch":"0","img_quality":"60","thumbs_cache_time":"30","simple_crop_top":"0","simple_crop_bottom":"0","simple_crop_left":"0","simple_crop_right":"0","crop_rules":"","grayscale_filter":"0","sepia_filter":"0","blur_filter":"0","brightness_filter":"0","smooth_filter":"0","pixelate_filter":"0","contrast_filter":"0","filter_arg":"0","autoanim":"0","hover_anim":"0","animation_speed":"400","animation_interval":"5000","animation_function":"Fx.Transitions.Expo.easeIn","useCSS":"0","useScript":"2","engine_mode":"mootools","include_jquery":"0","url_overrides":"0","module_tag":"div","bootstrap_size":"0","header_tag":"h3","header_class":"","style":"0"}

And I copied this into the param field of ID 212 & 213, this module produce the error. After changing the content of param field everything is working. So there must be an error in the default param in your template.

However, now everything is working.

Thanks
Joerg

Hi

Try update NSP to latest version. Than edit all NSP modules settings. Clear browser cache, check source configuration and save settings even if no changes was done.

Please look at what I posted already. There were couple of new fields added between versions, this is why re saving the settings is important in every copy. This action will do the same as You've done in database.