Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Search the Community

Showing results for tags 'sort order issue'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • News and Announcements
    • News and Announcements
  • osCommerce v4.x
    • General Support
    • Migration from old osCommerce
    • Design and Templates
    • Apps / Add-ons
    • Translations
    • API and import/export
    • Marketplace integration
    • Manuals and How-to
    • Blog's discussion
  • osCommerce Online Merchant v2.x
    • General Support
    • osCommerce Online Merchant Community Bootstrap Edition
    • Add-Ons
  • Development
  • General
    • General Discussions
    • Live Shop Reviews
    • Security
    • Commercial Support Inquiries
    • Developer Feedback

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


Real Name


Location


Interests


Website

Found 1 result

  1. A very important aspect to be fixed very soon!! Please help Sort order of option groups need to work some how a minor error is preventing it to work; This is the actual problem what someone figured out and wrote---- The contrib seems to work fine from the admin section for me, I can move option values up/down within each option group, and move option groups up/down in relation to other option groups. Looks PERFECT. however the reflection on my catalog is not perfect. The option values as ordered within option groups is retained, but the option group ordering is not reflected. Can any suggest why? I have double checked product_info.php, and both of the 2 queries there sort by products_options_sort_order. So my code from that section reads like this: [color="#000000"]$products_options_name_query [/color][color="#666600"]=[/color][color="#000000"] tep_db_query[/color][color="#666600"]([/color][color="#008800"]"select distinct popt.products_options_id, popt.products_options_name from "[/color] [color="#666600"].[/color][color="#000000"] TABLE_PRODUCTS_OPTIONS [/color][color="#666600"].[/color] [color="#008800"]" popt, "[/color] [color="#666600"].[/color][color="#000000"] TABLE_PRODUCTS_ATTRIBUTES [/color][color="#666600"].[/color] [color="#008800"]" patrib where patrib.products_id='"[/color] [color="#666600"].[/color] [color="#666600"]([/color][color="#000088"]int[/color][color="#666600"])[/color][color="#000000"]$HTTP_GET_VARS[/color][color="#666600"][[/color][color="#008800"]'products_id'[/color][color="#666600"]][/color] [color="#666600"].[/color] [color="#008800"]"' and patrib.options_id = popt.products_options_id and popt.language_id = '"[/color] [color="#666600"].[/color] [color="#666600"]([/color][color="#000088"]int[/color][color="#666600"])[/color][color="#000000"]$languages_id [/color][color="#666600"].[/color] [color="#008800"]"' order by popt.products_options_sort_order"[/color][color="#666600"]);[/color] [color="#000088"]while[/color] [color="#666600"]([/color][color="#000000"]$products_options_name [/color][color="#666600"]=[/color][color="#000000"] tep_db_fetch_array[/color][color="#666600"]([/color][color="#000000"]$products_options_name_query[/color][color="#666600"]))[/color] [color="#666600"]{[/color] [color="#000000"] $products_options_array [/color][color="#666600"]=[/color][color="#000000"] array[/color][color="#666600"]();[/color] [color="#000000"] $products_options_query [/color][color="#666600"]=[/color][color="#000000"] tep_db_query[/color][color="#666600"]([/color][color="#008800"]"select pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix from "[/color] [color="#666600"].[/color][color="#000000"] TABLE_PRODUCTS_ATTRIBUTES [/color][color="#666600"].[/color] [color="#008800"]" pa, "[/color] [color="#666600"].[/color][color="#000000"] TABLE_PRODUCTS_OPTIONS_VALUES [/color][color="#666600"].[/color] [color="#008800"]" pov where pa.products_id = '"[/color] [color="#666600"].[/color] [color="#666600"]([/color][color="#000088"]int[/color][color="#666600"])[/color][color="#000000"]$HTTP_GET_VARS[/color][color="#666600"][[/color][color="#008800"]'products_id'[/color][color="#666600"]][/color] [color="#666600"].[/color] [color="#008800"]"' and pa.options_id = '"[/color] [color="#666600"].[/color] [color="#666600"]([/color][color="#000088"]int[/color][color="#666600"])[/color][color="#000000"]$products_options_name[/color][color="#666600"][[/color][color="#008800"]'products_options_id'[/color][color="#666600"]][/color] [color="#666600"].[/color] [color="#008800"]"' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '"[/color] [color="#666600"].[/color] [color="#666600"]([/color][color="#000088"]int[/color][color="#666600"])[/color][color="#000000"]$languages_id [/color][color="#666600"].[/color] [color="#008800"]"' order by pa.products_options_sort_order"[/color][color="#666600"]);[/color] I noticed that if you have the attribute sort order contrib the last query there is sorted by attribute_sort. Not that using that helps either. Also in attributeManagerConfig.class.php is it correct that both AM_FIELD_OPTION_SORT_ORDER and AM_FIELD_OPTION_VALUE_SORT_ORDER use products_options_sort_order? Does nothing refer to the attribute_sort column created by the attribute sort order contrib? I don't see the need to install the attribute sort order contrib if the tablet column it creates isn't used. I installed it anyway. It seems this contrib uses the existing sort order columns from the 2 related tables in the DB. Incidentally, no values are being generated in the products_options_sort_order column of the products_options table. Perhaps that gives a clue. Any ideas appreciated, thanks for excellent config, presumably just missing something minor. Please Help soon!!!
×
×
  • Create New...