Menu Content

Support

> Forums, FAQs & Paid Support
Welcome, Guest
Username Password: Remember me

Virtuemart ext fails to filer on the third type
(1 viewing) (1) Guest
Support forum for customers who have purchased paid JoomSEF extension. Archive only, no new post can be added.

NOTE: This category has been locked. If you have purchased paid version, please, use our Support Ticket system instead. If you are using free edition, please see the Community Support section.
  • Page:
  • 1

TOPIC: Virtuemart ext fails to filer on the third type

Virtuemart ext fails to filer on the third type 11 years, 10 months ago #30589

Hi

I'm having problems with JoomSEF when a third of 4 types is used to filter Virtuemart products.

The first two types filter fine and the correct products are displayed.

The product are all in a top level category and there a minimum of 8 per category. When filtering is applied without JoomSEF as the handler there are a minimum of 4 products left in the list.

When any third filter is applied all products are displayed.

When I set the handler extension parameters on the common tab to "Default Joomla! route" the products get filtered properly using the third and forth types, here's the url below:

/component/virtuemart/?page=shop.browse&category_id=0&limitstart=0&product_type_id=1&product_type_1_Make_comp=find_in_set&product_type_1_Make=BMW&product_type_1_Model_comp=find_in_set&product_type_1_Model=3+Series+E36&product_type_1_Year_comp=find_in_set&product_type_1_Year=1996



... And here's the URL when JoomSEF handler is set:

/MBW/3+Series+E36/1996 


I've tried various different configurations but can get it to work. Here are both JoomSEF and Virtuemart JoomSEF and the Cherry Picker parameters:


JoomSEF Virtuemart:

EXTENSION
 
Product Name 1st part = '---'
Product Name 2st part = '---'
Product Name 3st part = '---'
Number Duplicate product names = No
Add manufacturer to URL = No
Add manufacturer ID to = 'No'
Add categories to URL = 'No'
Add category ID to URL = No
Add categories to product URL's = 'No'
Add file ID to URL = '
No'
Flypage handling = '
Never add to URL'
Default flypage = '
flypage_tpl'
Ignore multiple categories = '
No'
SEF Cart URLs = '
All Links'
SEF Checkout URLs = '
Yes'


CHERRY PICKER MODULE URLs
 
Add product type to URL = 'No'
Add product ID to URL = 'No'
Add parameter comparison to URL = 'No'
 

COMMON
 
Number duplicate URLs = 'Yes'
Automatic canonical link generation = 'Yes'
Ignore multiple sources = 'No'
Itemid handling = 'Use Global'
Override ItemID = ''
Ignore ItemID = ''
Items per page = ''
Handling = 'JoomSEF handler'
Custom non-SEF variables = ''
Do not SEF URLs matching regular expression = ''
 

All other Setting for the JoomSEF virtuemart extension are as default.


JOOMSEF CONFIG

Main Configeration
 
JoomSEF Enabled? = Yes
Disable creation of new SEF URLs? = No
Enable proffesional mode = Yes
 

Basic Configuration
 
File suffix = No
Use Title or Alias? = No
All lowercase? = Yes
www and non-www domain handling = Dont Handle
Number duplicate URLs? = Yes
Replacement character = -
Page spacer character = -
Strip characters = ,|~|!|@|%|^|*|(|)|+|<|>|:|;|{|}|[|]|---|--|..|.
Trim friendly characters = -|.
Page text = JText::_('PAGE')-%s
 

ADVANCED
 
Allow UTF-8 characters in URL: Yes
Non-ASCII char replacements: Yes
Be tolerant to trailing slash: No
Remove trailing slash?: Yes
Parse Joomla SEO links: Yes
Redirect Joomla SEO to JoomSEF: Yes
Set page base href value: Yes Always use only base URL
Fix index.php links: Yes
Fix missing question mark: Yes
Fix document format: No
Change index.php to current menu: Yes
 
Ask before saving URL to Moved Permanently table: Yes
Autolock created URLs: Yes
 
Redirect nonSEF URLs to SEF: Yes
Append non-SEF variables to URL: No
Prevent non-SEF variables from overwriting the parsed ones: Yes
Custom non-SEF variables:
Automatic canonical link generation: Yes
SEF URLs using component template: No
Trim spaces around URL: No
Filter variable values: Yes
Filter these words: http:// http// https:// https// www. @
Variables to exclude from filtering:
Filter system variables: Yes
 
Exclude source info (Itemid): No
Reappend source (Itemid): Yes
Ignore multiple sources (Itemids): no
 


THE CHERRY PICKER MODULE PARAMETERS
 
Cherry Picker Mode: Single
Cherry Picker Type: Dropdown
Show filters of this Product Type ID= 1
 
 
Use See More...? Yes
Use Smart Search? No
Use Search by Price? No
Show Trackbar? No
Use cache? No
Fill META-TITLE with selected filters? no
Hide parameters with 1 filter? Yes
 
Include only chosen parameters? ..when hack applied: No
 
 
Mark
ID 23447
Joomla Version 1.5.23
JoomSEF 3.9.5
Virtuemart 1.1.7
Virtuemart Extension Version 2.0.34

AND

JoomSEF Version 4.2.9
Virtuemart Cart 2.0.8e
Last Edit: 11 years, 10 months ago by markkenyon.
The topic has been locked.

Re: Virtuemart ext fails to filer on the third type 11 years, 10 months ago #30600

  • dajo
  • OFFLINE
  • Posts: 5069
Hi,
There's usually a problem when filtering by more than two parameters with JoomSEF, that the original non-SEF URL is too long to be stored in JoomSEF's database table. Use phpMyAdmin or some similar tool to access your website's database and in the jos_sefurls table change the type of origurl column from VARCHAR(255) to TEXT, so longer URLs than 255 characters can be stored.
ARTIO Support Team
The topic has been locked.

Re: Virtuemart ext fails to filer on the third type 11 years, 10 months ago #30608

Thanks! dajo

I read a similar solution in another thread but while trying the solution mysql returned an error and I was uncertain how the changes would affect the operation of the table. I found an explanation of the problem here: www.mydigitallife.info/mysql-error-1170-...ithout-a-key-length/

THE SOLUTION
If anyone else has the same problem of trying to change the origurl column from VARCHAR to TEXT, Backup any URL rows that you wish to keep then dump the column from the table.

Create a new column with the same name of "origurl" type "TEXT" in the same position within the table structure.

Then import the URLs you backed up.
Mark
ID 23447
Joomla Version 1.5.23
JoomSEF 3.9.5
Virtuemart 1.1.7
Virtuemart Extension Version 2.0.34

AND

JoomSEF Version 4.2.9
Virtuemart Cart 2.0.8e
The topic has been locked.

Re: Virtuemart ext fails to filer on the third type 11 years, 10 months ago #30613

  • dajo
  • OFFLINE
  • Posts: 5069
You're right, the problem is that the origurl column is being used in the origurl index (which contains the origurl and Itemid columns).
So maybe for someone following may be an easier solution:
1. Drop the origurl index from the table
2. Now you can change the type of origurl column from VARCHAR to TEXT
3. Create new index containing columns origurl and Itemid, specifying a prefix length for origurl column:
CREATE INDEX origurl ON jos_sefurls (origurl (255), Itemid);
ARTIO Support Team
The topic has been locked.

Re: Virtuemart ext fails to filer on the third type 11 years, 10 months ago #30615

So what's that doing doja? Is the query something I need to run in order for the index to be created for origurl?
Mark
ID 23447
Joomla Version 1.5.23
JoomSEF 3.9.5
Virtuemart 1.1.7
Virtuemart Extension Version 2.0.34

AND

JoomSEF Version 4.2.9
Virtuemart Cart 2.0.8e
The topic has been locked.

Re: Virtuemart ext fails to filer on the third type 11 years, 10 months ago #30624

  • dajo
  • OFFLINE
  • Posts: 5069
Yes, it should make search queries for SEF URLs faster.
ARTIO Support Team
The topic has been locked.
  • Page:
  • 1
User Login Empty