Cannot install OSCMax on server with MySQL v.5.7.25

**Dan305** · 03-27-2019, 02:50 PM

I have been using OSCMax for years. Recently I tried to install it on a server whose MySQL was recently updated to v.5.7.25 but it would not install. The server has one other OSCMax site on it and I checked it, it has also crashed. Does MySQL run on servers with updated MySQL? This is the error message I get:

3065 - Expression #1 of ORDER BY clause is not in SELECT list, references column 'toolsaus_selltools.p.products_ordered' which is not in SELECT list; this is incompatible with DISTINCT

select distinct p.products_id, pd.products_name from products p, products_description pd left join products_to_categories p2c using(products_id) left join categories c using(categories_id) where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '1' and find_in_set('0', p.products_hide_from_groups) = '0' order by p.products_ordered desc, pd.products_name limit 10

The PHP version is 5.6. The site that crashed ran fine before the MySQL update. The site I tried to set up today was with the OSCMax zip file I downloaded this morning, so it is current.

What can I do?

Dan

**ridexbuilder** · 03-27-2019, 03:04 PM

I came across a similar issue with some replacement servers that I have provisioned.
The fudge for the DISTINCT issue is to replace a directive in your my.cnf file.

Code:

# sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES 
sql_mode=NO_ENGINE_SUBSTITUTION

That worked for me, after I had downgraded to mySQL 5.6 (I googled how to do it for a cPanel/WMH environment). You could try the above first, before a downgrade but IIRC another issue raised its' head. I decided to downgrade rather than spend time fixing other problems. Note that this was with version 2.5.4 osCmax; using the development version might cure the issues - I noticed a few SQL commits.

**Dan305** · 03-27-2019, 06:33 PM

What is the link to the development version? I can't seem to find it on the site.

Thanks,

Dan

**ridexbuilder** · 03-27-2019, 11:41 PM

oscmax / oscmax2 / Downloads — Bitbucket

**Dan305** · 03-28-2019, 06:04 AM

I tried all of your suggestions short of downgrading the server. Finally I contacted the server tech for my server and he did the following. It resolved the issue. So now anyone can install OSCMax on a server with MySQL 5.7 after doing what he did.

we have edited the MySQL config file at /etc/my.cnf and set the SQL mode to an empty string to clear any mode.

Thanks for pointing me in the right direction,

Dan