- Posts: 3
 - Thank you received: 0
 
        
                Error category list products language pt-br SOLVED
            
    - Marcio Nunes
 - 
            
Topic Author
 - Offline
 - Fresh Boarder
 - 
            
         
        Less
        More
        
            
    
        
            
            13 years 4 months ago     -  13 years 4 months ago    #1580
    by Marcio Nunes
    
    
            
            
            
            
                                
                            
                    
    
        Error category list products language pt-br SOLVED was created by Marcio Nunes            
    
        Hello!
When install and set as default language portuguese brazil, show this error:
vmError: exeSortSearchListQuery Table 'db420890594.oamxh_virtuemart_products_pt_br' doesn't exist SQL=SELECT SQL_CALC_FOUND_ROWS * FROM `oamxh_virtuemart_products_pt_br` as l JOIN `oamxh_virtuemart_products` AS p using (`virtuemart_product_id`)group by p.`virtuemart_product_id` ORDER BY p.virtuemart_product_id DESC LIMIT 0, 10
vmError: exeSortSearchListQuery Table 'db420890594.oamxh_virtuemart_categories_pt_br' doesn't exist SQL=SELECT c.`virtuemart_category_id`, l.`category_description`, l.`category_name`, c.`ordering`, c.`published`, cx.`category_child_id`, cx.`category_parent_id`, c.`shared` FROM `oamxh_virtuemart_categories_pt_br` l JOIN `oamxh_virtuemart_categories` AS c using (`virtuemart_category_id`) LEFT JOIN `oamxh_virtuemart_category_categories` AS cx ON l.`virtuemart_category_id` = cx.`category_child_id` WHERE cx.`category_parent_id` = 0 ORDER BY category_name ASC
Add sufix in the table virtuemart "-pt-br".. whit others templates this do it!
Any help?
Thanks!
    When install and set as default language portuguese brazil, show this error:
vmError: exeSortSearchListQuery Table 'db420890594.oamxh_virtuemart_products_pt_br' doesn't exist SQL=SELECT SQL_CALC_FOUND_ROWS * FROM `oamxh_virtuemart_products_pt_br` as l JOIN `oamxh_virtuemart_products` AS p using (`virtuemart_product_id`)group by p.`virtuemart_product_id` ORDER BY p.virtuemart_product_id DESC LIMIT 0, 10
vmError: exeSortSearchListQuery Table 'db420890594.oamxh_virtuemart_categories_pt_br' doesn't exist SQL=SELECT c.`virtuemart_category_id`, l.`category_description`, l.`category_name`, c.`ordering`, c.`published`, cx.`category_child_id`, cx.`category_parent_id`, c.`shared` FROM `oamxh_virtuemart_categories_pt_br` l JOIN `oamxh_virtuemart_categories` AS c using (`virtuemart_category_id`) LEFT JOIN `oamxh_virtuemart_category_categories` AS cx ON l.`virtuemart_category_id` = cx.`category_child_id` WHERE cx.`category_parent_id` = 0 ORDER BY category_name ASC
Add sufix in the table virtuemart "-pt-br".. whit others templates this do it!
Any help?
Thanks!
        Last edit: 13 years 4 months ago  by Marcio Nunes.            
            Please Log in or Create an account to join the conversation.
- Linh Robert
 - 
            
 - Offline
 - Banned
 - 
            
         
        Less
        More
        
            
    
        - Posts: 908
 - Thank you received: 568
 
            
            13 years 4 months ago        #1582
    by Linh Robert
    
            
If you need to send us FTP access / host access, administrator access or any private information:
services(at)omegatheme(dot)com or drop a ticket www.omegatheme.com/member/
    
    
            
            
            
            
                                
                            
                    
    
        Replied by Linh Robert on topic Re: Error in category and list products language pt-br            
    
        Hi,
The template does not effect the VM database or any data. It just do the way information appear at front-end and the look&feel it them.
Your problem comes from the incorrect or missing of configuration/setup.
Please make sure you added Brazil language into multi language shop setting (Virtuemart back-end setting) and then translate categories, products into BR language.
Thanks for using our products!
            The template does not effect the VM database or any data. It just do the way information appear at front-end and the look&feel it them.
Your problem comes from the incorrect or missing of configuration/setup.
Please make sure you added Brazil language into multi language shop setting (Virtuemart back-end setting) and then translate categories, products into BR language.
Thanks for using our products!
If you need to send us FTP access / host access, administrator access or any private information:
services(at)omegatheme(dot)com or drop a ticket www.omegatheme.com/member/
        The following user(s) said Thank You: Marcio Nunes     
            Please Log in or Create an account to join the conversation.
- Marcio Nunes
 - 
            
Topic Author
 - Offline
 - Fresh Boarder
 - 
            
         
        Less
        More
        
            
    
        - Posts: 3
 - Thank you received: 0
 
            
            13 years 4 months ago        #1583
    by Marcio Nunes
    
            
            
            
            
            
                                
                            
                    
    
        Replied by Marcio Nunes on topic Re: Error in category and list products language pt-br            
    
        Thanks for quick support!
Exactly!
Add the new language in categories is fixed!
Thanks again!!!
    Exactly!
Add the new language in categories is fixed!
Thanks again!!!
Please Log in or Create an account to join the conversation.
- Marcio Nunes
 - 
            
Topic Author
 - Offline
 - Fresh Boarder
 - 
            
         
        Less
        More
        
            
    
        - Posts: 3
 - Thank you received: 0
 
            
            13 years 4 months ago     -  13 years 4 months ago    #1584
    by Marcio Nunes
    
    
            
            
            
            
                                
                            
                    
    
        Replied by Marcio Nunes on topic Re: Error in category and list products language pt-br            
    
        Hi again!
Sorry... but, why only show 5 feature productos in home page?
Have 20 productos set as feature and show only 5.. the template support 6 for perfect design!
Its is template configuration or VM parameters?
SOLVED forum.virtuemart.net/index.php?topic=99249.0
    Sorry... but, why only show 5 feature productos in home page?
Have 20 productos set as feature and show only 5.. the template support 6 for perfect design!
Its is template configuration or VM parameters?
SOLVED forum.virtuemart.net/index.php?topic=99249.0
        Last edit: 13 years 4 months ago  by Marcio Nunes.            
            Please Log in or Create an account to join the conversation.
- sohrab sohrab
 - 
            
 - Offline
 - Fresh Boarder
 - 
            
         
        Less
        More
        
            
    
        - Posts: 1
 - Thank you received: 0
 
            
            12 years 11 months ago        #2947
    by sohrab sohrab
    
            
            
            
            
            
                                
                            
                    
    
        Replied by sohrab sohrab on topic Re: Error category list products language pt-br SOLVED            
    
        this is not a template error , it's just Vm error and it means virtuemart does not have this language pack installed in it's administrator side. so you should upload them individually. I have the same problem with Persian language.    
    Please Log in or Create an account to join the conversation.
        Time to create page: 0.193 seconds    
