Results 1 to 6 of 6

Thread: Cannot install OSCMax on server with MySQL v.5.7.25

  1. #1
    New Member
    Join Date
    Dec 2017
    Posts
    15
    Total Contributions For

    Dan305     $ 0.00
    Rep Power
    0


    Default Cannot install OSCMax on server with MySQL v.5.7.25

    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

  2. #2
    osCMax Development Team

    Cannot install OSCMax on server with MySQL  v.5.7.25

    ridexbuilder's Avatar
    Join Date
    Jul 2008
    Location
    Haggisland
    Posts
    4,132
    Total Contributions For

    ridexbuilder     $ 15.00
    Rep Power
    96


    Default Re: Cannot install OSCMax on server with MySQL v.5.7.25

    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.

    Developers resource at bitbucket
    *** *** ***
    oscmax.co.uk / ejsolutions.co.uk
    Hosting plans with installation, configuration, contributions, support and maintenance.
    *** FREE osCmax hosting available ***
    oscmaxtemplates.com

  3. #3
    New Member
    Join Date
    Dec 2017
    Posts
    15
    Total Contributions For

    Dan305     $ 0.00
    Rep Power
    0


    Default Re: Cannot install OSCMax on server with MySQL v.5.7.25

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

    Thanks,

    Dan

  4. #4
    osCMax Development Team

    Cannot install OSCMax on server with MySQL  v.5.7.25

    ridexbuilder's Avatar
    Join Date
    Jul 2008
    Location
    Haggisland
    Posts
    4,132
    Total Contributions For

    ridexbuilder     $ 15.00
    Rep Power
    96


    Default Re: Cannot install OSCMax on server with MySQL v.5.7.25


    Developers resource at bitbucket
    *** *** ***
    oscmax.co.uk / ejsolutions.co.uk
    Hosting plans with installation, configuration, contributions, support and maintenance.
    *** FREE osCmax hosting available ***
    oscmaxtemplates.com

  5. #5
    New Member
    Join Date
    Dec 2017
    Posts
    15
    Total Contributions For

    Dan305     $ 0.00
    Rep Power
    0


    Default Re: Cannot install OSCMax on server with MySQL v.5.7.25

    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

  6. #6
    Lurker
    Join Date
    Jun 2019
    Posts
    4
    Total Contributions For

    Sulforman9     $ 0.00
    Rep Power
    0


    Default Re: Cannot install OSCMax on server with MySQL v.5.7.25

    Quote Originally Posted by ridexbuilder View Post
    Thanks for sharing this information.

Similar Threads

  1. 2006 - mysql server has gone away
    By basnyd in forum osCmax v2 Customization/Mods
    Replies: 1
    Last Post: 07-08-2009, 09:23 PM
  2. 2006 - MySQL server has gone away
    By blioux in forum osCmax v2 Installation issues
    Replies: 3
    Last Post: 01-12-2006, 01:10 PM
  3. Can't connect to MySQL server on '207.44.142.34' (111)???
    By currie_muncher in forum osCommerce 2.2 Installation Help
    Replies: 2
    Last Post: 05-19-2005, 09:08 PM
  4. mysql error - ms2.2 - windows IIS server
    By red_fraggle in forum osCommerce 2.2 Discussion
    Replies: 1
    Last Post: 05-09-2005, 11:08 PM
  5. Install script fails to log into mysql server
    By bjrafferty in forum osCMax v1.7 Installation
    Replies: 7
    Last Post: 06-23-2004, 07:37 PM

Tags for this Thread

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
  •