View more context

 

MrBenn

Does anyone know if it is possible when creating a custom SS SQLSelect to prevent the framework from adding a into the fields, as in “Select , field 1, field 2…“? I am using joins with group by clauses and it is causing me MySQL errors due to the “sql_mode=only_full_group_by” - if I can ditch the * and only select specific fields that should solve the problem.

dorsetdigital

What version of SS are you using? The later versions shouldn't have that issue in the ORM

MrBenn

Yes that did it, many thanks Tim!

dorsetdigital

With SQLSelect, you can use setSelect() to specify the columns

👍 (1)
Karina Gaulin

Is it difficult to upgrade an existing silverstripe project to the latest stable version?

dorsetdigital

Well, "difficult" is hard to define. It depends on where you're starting from, and what else is in the project (modules, custom code, etc.)

👍 (1)
dorsetdigital

An older SS4 to the latest SS4 is generally fairly straightforward

dorsetdigital

More recent SS3 to SS4 is OK, but some of the modules can be problematic sometimes