Don R. Soucy Posted January 22, 2022 Share Posted January 22, 2022 Hi Folks. I have a store installation which failed to survive a hosting company change in 2018. I need to resolve with repair to 2.3.1 or a method to upgrade to whatever. 1. Could I export data and "fashion" some kind of sql tool to allow importation into "NEW" version. 2. if upgrade is unrealistic can I find solutions to the following errors 1055 - 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'upcomgro_shelver.o.date_purchased' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by select distinct op.products_id from orders o, orders_products op, products p where o.customers_id = '563' and o.orders_id = op.orders_id and op.products_id = p.products_id and p.products_status = '1' group by products_id order by o.date_purchased desc limit 6 THese and various others refer to "ORDER BY clause is not in GROUP BY clause". THis is deeper than I go. Can I hire someone to help me set this install right? Let me know if you are interested. Don Link to comment Share on other sites More sharing options...
osCommerce-Official Posted January 22, 2022 Share Posted January 22, 2022 1 hour ago, Don R. Soucy said: Hi Folks. I have a store installation which failed to survive a hosting company change in 2018. I need to resolve with repair to 2.3.1 or a method to upgrade to whatever. 1. Could I export data and "fashion" some kind of sql tool to allow importation into "NEW" version. 2. if upgrade is unrealistic can I find solutions to the following errors 1055 - 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'upcomgro_shelver.o.date_purchased' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by select distinct op.products_id from orders o, orders_products op, products p where o.customers_id = '563' and o.orders_id = op.orders_id and op.products_id = p.products_id and p.products_status = '1' group by products_id order by o.date_purchased desc limit 6 THese and various others refer to "ORDER BY clause is not in GROUP BY clause". THis is deeper than I go. Can I hire someone to help me set this install right? Let me know if you are interested. Don Don, we would recommend v4 once it is out. Let us know if you'd like to try Beta 2 of osCommerce v4 Link to comment Share on other sites More sharing options...
Don R. Soucy Posted January 22, 2022 Author Share Posted January 22, 2022 I would indeed consider V4 (I assume that is V2,4,1) Tell me please where I can download the most suitable (remember I am coming from V2.3.1 and want the least troublesome process. I haven't coded MySql for a long long time so I need the help of some experienced "others". Thanks Link to comment Share on other sites More sharing options...
osCommerce-Official Posted January 23, 2022 Share Posted January 23, 2022 That is v4, the actual 4th version. You can read more about it here https://wiki.oscommerce.com/ Link to comment Share on other sites More sharing options...
Don R. Soucy Posted January 23, 2022 Author Share Posted January 23, 2022 I've heard about a "responsive" version called Phoenix. Can you point me to some info about it. Link to comment Share on other sites More sharing options...
Demitry Posted January 23, 2022 Share Posted January 23, 2022 Google is your friend. osCommerce: made for programmers, ...because store owners do not want to be programmers. https://trends.google.com/trends/explore?date=all&geo=US&q=oscommerce Link to comment Share on other sites More sharing options...
Don R. Soucy Posted January 24, 2022 Author Share Posted January 24, 2022 18 minutes ago, Demitry said: Google is your friend. And the page you sent has zero instances of Phoenix LOL. OsCommerce I know well I have used it for 15 years. Thanks Don Link to comment Share on other sites More sharing options...
Demitry Posted January 24, 2022 Share Posted January 24, 2022 Zombie Phoenix is not part of osCommerce, though you would know that if you used osCommerce for 15 years. Do you not know how to use Google? osCommerce: made for programmers, ...because store owners do not want to be programmers. https://trends.google.com/trends/explore?date=all&geo=US&q=oscommerce Link to comment Share on other sites More sharing options...
Hotclutch Posted January 24, 2022 Share Posted January 24, 2022 On 1/22/2022 at 11:21 PM, Don R. Soucy said: 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'upcomgro_shelver.o.date_purchased' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by select distinct op.products_id from orders o, orders_products op, products p where o.customers_id = '563' and o.orders_id = op.orders_id and op.products_id = p.products_id and p.products_status = '1' group by products_id order by o.date_purchased desc limit 6 This is not stock osC SQL - its an addon or custom work. Even if you manage to upgrade to some fork of osC, you will still have this problem to deal with. Link to comment Share on other sites More sharing options...
Jack_mcs Posted January 24, 2022 Share Posted January 24, 2022 On 1/22/2022 at 4:21 PM, Don R. Soucy said: Can I hire someone to help me set this install right? Please see the PM I sent. Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.