Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13
  1. #11
    Join Date
    Jul 2012
    Posts
    16,718
    Plugin Contributions
    17

    Default Re: Listing Sort Order by Date Added

    Quote Originally Posted by simon1066 View Post
    Sure, will do.

    Edit:



    Can I ask what you mean by 'database mode', is it innodb/myisam?
    Not necessarily those, but in some modes, attempting to sort a data set on a field that is not being returned in the SELECT statement can cause a sql "error"... If the database mode (sql_mode) includes: ONLY_FULL_GROUP_BY then grouping by a field that is not in the select list of that query will cause an error (e.g. ORDER BY clause is not in SELECT list ......) such as if running this query:
    Code:
    SELECT products_price FROM products ORDER BY products_id;
    Would either, use a sub-query to return both the products_id and products price sorted on the desired order to then select from that list just the products_price or just use a single query that returns both fields and only use the field(s) necessary...
    Last edited by mc12345678; 13 Oct 2021 at 05:54 PM.
    ZC Installation/Maintenance Support <- Site
    Contribution for contributions welcome...

  2. #12
    Join Date
    Nov 2005
    Location
    los angeles
    Posts
    2,669
    Plugin Contributions
    9

    Default Re: Listing Sort Order by Date Added

    Quote Originally Posted by swguy View Post
    AHEM! I spend the morning documenting sort order on the store front. How 'bout you step up?
    i was being a bit facetious.... as i never intended to disparage the work that you do.

    if i were to set the odds of said change getting merged into the repo, they would not be very high, as the complexity for said change is a bit high.

    as such, i will take a pass...

    best.
    author of square Webpay.
    mxWorks has premium plugins. donations: venmo or paypal accepted.
    premium consistent excellent support. available for hire.

  3. #13
    Join Date
    Jan 2004
    Location
    N of San Antonio TX
    Posts
    9,107
    Plugin Contributions
    11

    Default Re: Listing Sort Order by Date Added

    Quote Originally Posted by girlboheme View Post
    I used a one click install from my hosting company.
    To me, this is the most concerning part of the post.
    I've yet to find a one-click that doesn't have some little difference that winds up being a big difference later.
    I've often seen one-clicks whose internal settings are in direct opposition to the server setup of the host providing the one-click.

    Consider getting the real zip and extracting it into a test folder. Run the install then bring over your current database. It may save you some headaches down the road.

 

 
Page 2 of 2 FirstFirst 12

Similar Threads

  1. v151 Change sort order of products to date added to category
    By Bee01 in forum Customization from the Admin
    Replies: 2
    Last Post: 25 May 2013, 02:21 PM
  2. sort by price, date added, etc
    By RollzRoyce in forum Templates, Stylesheets, Page Layout
    Replies: 1
    Last Post: 5 Aug 2010, 05:03 PM
  3. Sort by Date Added New to Old (etc) on Product Listing Pages?
    By limelites in forum Templates, Stylesheets, Page Layout
    Replies: 1
    Last Post: 25 May 2009, 09:21 PM
  4. Sort by Date Added/Product ID
    By edadk in forum Setting Up Categories, Products, Attributes
    Replies: 0
    Last Post: 10 Nov 2008, 04:56 PM
  5. Sort By Date Added!!
    By brotherhud in forum Setting Up Categories, Products, Attributes
    Replies: 3
    Last Post: 21 Feb 2007, 01:39 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR