Full service web hosting, great prices and support. Starts at $1.99/month!
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
    Contribute If you enjoy reading the
    content here, click the below
    image to support our site.
    Click Here To Contribute To Our Site

    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,137
    Contribute If you enjoy reading the
    content here, click the below
    image to support our site.
    Click Here To Contribute To Our Site

    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
    Contribute If you enjoy reading the
    content here, click the below
    image to support our site.
    Click Here To Contribute To Our Site

    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,137
    Contribute If you enjoy reading the
    content here, click the below
    image to support our site.
    Click Here To Contribute To Our Site

    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
    Contribute If you enjoy reading the
    content here, click the below
    image to support our site.
    Click Here To Contribute To Our Site

    Total Contributions For

    Dan305     $ 0.00
    Rep Power
    0


    1 out of 1 members found this post helpful.

    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
    Contribute If you enjoy reading the
    content here, click the below
    image to support our site.
    Click Here To Contribute To Our Site

    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

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
  •