Menu ▾ ▴

#24 Error Number: 1055

v2.1
closed
nobody
Bug / Error (3)
2018-07-06
2018-02-08
Anonymous
No

Originally created by: HendrikEduard

Expression [#1] of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'newdb.FI_page_blocks.dateCreated' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

SELECT MAX(blockID) as blockID FROM FI_page_blocks WHERE siteID = '1' AND versionID = '1' GROUP BY blockRef ORDER BY dateCreated DESC

Filename: libraries/Core.php

Line Number: 239

Related

Tickets: #1

Discussion

  • Anonymous

    Anonymous - 2018-02-09

    Originally posted by: Reconix

    What version of MySQL are you on ?

    Not getting this error on 5.6

    Also, you might want to consider: Disabling ONLY_FULL_GROUP_BY

     

  • Anonymous

    Anonymous - 2018-02-09

    Originally posted by: Reconix

    You might get the odd error due to a lot of the JS needing to be updated for jQuery 3 but not 404s or the rest.

    Do you mind letting me know what page you were on when getting these?

     

  • Anonymous

    Anonymous - 2018-02-09

    Originally posted by: HendrikEduard

    http://localhost/admin and all links in the admin menu.

    Home, Blog, Shop, Wiki, Events & Forums all work.

     

  • Anonymous

    Anonymous - 2018-02-09

    Originally posted by: Reconix

    Let me grab a coffee, download a fresh copy from here and test.

     

  • Anonymous

    Anonymous - 2018-02-09

    Originally posted by: Reconix

    I can't reproduce this other than changing file permissions on the folders.

    When you go to, for example :
    http://localhost/static/themes/anvil/plugins/jQueryUI/jquery-ui.min.js
    You see it's contents ?

    Thanks for pointing out the mistake on line 471, that static menu thankfully won't be there much longer.

     

  • Anonymous

    Anonymous - 2018-02-09

    Originally posted by: HendrikEduard

    /*! jQuery UI - v1.11.4 - 2015-03-11
    * http://jqueryui.com

    This being Localhost all file/folder permissions are 777

     

  • Anonymous

    Anonymous - 2018-02-10

    Originally posted by: Reconix

    Out of curiosity, does the latest commit get rid of some of those errors ?

     

  • Anonymous

    Anonymous - 2018-02-10

    Originally posted by: HendrikEduard

    Failed to load resource: the server responded with a status of 404 (Not Found)
    LTE.css Failed to load resource: the server responded with a status of 404 (Not Found)
    ionicons.min.css Failed to load resource: the server responded with a status of 404 (Not Found)
    skin-anvil-light.css Failed to load resource: the server responded with a status of 404 (Not Found)
    jquery.min.js Failed to load resource: the server responded with a status of 404 (Not Found)
    bootstrap.min.css Failed to load resource: the server responded with a status of 404 (Not Found)
    jquery.flot.js Failed to load resource: the server responded with a status of 404 (Not Found)
    jquery.flot.resize.js Failed to load resource: the server responded with a status of 404 (Not Found)
    jquery.flot.time.js Failed to load resource: the server responded with a status of 404 (Not Found)
    jquery-ui.min.js Failed to load resource: the server responded with a status of 404 (Not Found)
    bootstrap.min.js Failed to load resource: the server responded with a status of 404 (Not Found)
    app.js Failed to load resource: the server responded with a status of 404 (Not Found)
    fi-logo.jpg Failed to load resource: the server responded with a status of 404 (Not Found)
    forgeigniter-logo.jpg Failed to load resource: the server responded with a status of 404 (Not Found)
    avatar.png Failed to load resource: the server responded with a status of 404 (Not Found)
    jquery-migrate-3.0.0.js:540 Uncaught ReferenceError: jQuery is not defined
    at jquery-migrate-3.0.0.js:540
    avatar.png Failed to load resource: the server responded with a status of 404 (Not Found)
    jquery.flot.js Failed to load resource: the server responded with a status of 404 (Not Found)
    jquery.flot.resize.js Failed to load resource: the server responded with a status of 404 (Not Found)
    jquery.flot.time.js Failed to load resource: the server responded with a status of 404 (Not Found)
    jquery.flot.init.js:1 Uncaught ReferenceError: $ is not defined
    at jquery.flot.init.js:1
    (index):333 Uncaught ReferenceError: $ is not defined
    at (index):333
    jquery-ui.min.js Failed to load resource: the server responded with a status of 404 (Not Found)
    bootstrap.min.js Failed to load resource: the server responded with a status of 404 (Not Found)
    app.js Failed to load resource: the server responded with a status of 404 (Not Found)
    default.js:16 Uncaught ReferenceError: jQuery is not defined
    at default.js:16
    admin.js:2 Uncaught ReferenceError: $ is not defined
    at admin.js:2
    at admin.js:29
    (index):723 Uncaught ReferenceError: $ is not defined
    at (index):723
    bootstrap.min.css Failed to load resource: the server responded with a status of 404 (Not Found)
    font-awesome.min.css Failed to load resource: the server responded with a status of 404 (Not Found)
    LTE.css Failed to load resource: the server responded with a status of 404 (Not Found)
    ionicons.min.css Failed to load resource: the server responded with a status of 404 (Not Found)
    skin-anvil-light.css Failed to load resource: the server responded with a status of 404 (Not Found)

     

  • Anonymous

    Anonymous - 2018-02-10

    Originally posted by: HendrikEduard

    screen shot 2018-02-10 at 3 23 38 pm

     

  • Anonymous

    Anonymous - 2018-02-10

    Originally posted by: Reconix

    If that doesn't fix it then I believe it's a case of playing around with the regex.

     

  • John

    John - 2018-07-06
    • Description has changed:

    Diff:
    • status: open --> closed
    • Milestone: --> v2.1
     

Log in to post a comment.