Adding ability sort by date

ScrapOrchard · #11 06-13-2008, 08:10 AM

Would I go into phpMyAdmin and remove the add_date lines? Help?!

ScrapOrchard · #12 06-13-2008, 08:40 AM

I noticed in the SQL Patch information that was posted this:

('products_order','Select the order of
products to display within
category','orderby','Appearance',110,'selector','o rderby','add_date:
lbl_add_date\nproductcode:lbl_sku\ntitle:lbl_produ ct\norderby: lbl_default\nprice:lbl_price');

Would those spaces be the cause of the MySQL error JWait and I are experiencing..? If so, how would one go about fixing this?

JWait · #13 06-13-2008, 12:33 PM

See post #17 in this thread. I haven't figured out a solution, but if you do as post 17 instructs you will be able to have either "add_date" or "recommends" but not both. Either disable "recommends" or chose a method other than "add date" as the x-cart default and it should be ok. I am thinking it has to do with the "orderby" statement but since the same thing exists in "upselling" I can't figure out why it works there but not "recommends". Since "add date" was deemed by me to be more important than "recommends" I just disabled that until a solution can be found.

ScrapOrchard · #14 06-13-2008, 01:24 PM

Thanks.. at this point, I would just like to be able to remove this modification.. can someone give me some pointers on how to?

JWait · #15 06-13-2008, 03:13 PM

Selecting anything other than "Add Date" as default listing would do the same thing as removing the mod. You could always go back and remove all of the things you inserted as outlined in post #1, but choosing another default is easier.

ScrapOrchard · #16 06-13-2008, 08:54 PM

How would I get rid of the items that were changed/inserted during the MySQL Patch step? Can I go into phpMyAdmin and remove the two add_cart instances in the xcart_config file or is that not okay? Or more that needs to be done?

JWait · #17 06-14-2008, 05:42 AM

Most of the sql is simply adding language variables, and that isn't going to hurt anything. I guess you could go into the database with phpmyadmin and remove the reference to "add_date:lbl_add_date" from "products_order" in the "xcart_config" table so you couldn't inadvertently select "Add Date" as the default setting. Of course if you remove the entire mod your customers will not have the ability to sort by date either. Your choice.

ScrapOrchard · #18 06-14-2008, 05:53 AM

Thanks! The company I installed the mod for wantd the default to be to sort by date and they also want/need the Recommended Products.. so, I need to remove it and find something that won't cause those errors!

JWait · #19 06-14-2008, 06:33 AM

I haven't had time to trace it but I think the problem is with reccommends.php not the "add_date" mod

ScrapOrchard · #20 06-14-2008, 09:43 AM

I found a mod at BCSEngineering that lets you sort by Date, Bestseller, Highest Rater, Most Viewed.. and it's free! I am going to install it and see if it breaks anything. I'll keep you posted.

BTW, thank you so very much for answering my questions.. I have posted so many questions in other threads and it seems like I can never get anyone to respond. I really appreciate it!