Cloudron makes it easy to run web apps like WordPress, Nextcloud, GitLab on your server. Find out more or install now.


  • Categories
  • Recent
  • Tags
  • Popular
  • Bookmarks
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse

Cloudron Forum

Apps | Demo | Docs | Install

SQL error

Scheduled Pinned Locked Moved Ampache
10 Posts 3 Posters 393 Views
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • rmdesR Offline
    rmdesR Offline
    rmdes
    wrote on last edited by
    #1

    There is this looping SQL error that I want to figure out the root cause

    this is the loop it's doing every few seconds : https://paste.armada.digital/acurocoyoz.coffeescript

    I searched sql_mode=only_full_group_by" and specifically about : this is incompatible with sql_mode=only_full_group_by" bit in the error, thinking without this constraint this could be fixed ?
    https://stackoverflow.com/questions/23921117/disable-only-full-group-by

    so if I try to set this global I obviously can't :
    ded2a7c4-5430-4d13-8129-44c9b556728a-image.png

    but I'm wondering @girish if this cannot be fixed at the packaging level ?

    ps: I searched for whatever options I enabled might be causing this but I could not find it, from the logs it seems this started since the last upgrade, previous days logs, before the upgrade don't have this loop error

    murgeroM 1 Reply Last reply
    0
  • murgeroM Offline
    murgeroM Offline
    murgero App Dev
    replied to rmdes on last edited by murgero
    #2

    @rmdes This is by design I'd imagine - You cannot change global SQL variables because it affects ALL apps that use the mysql addon.

    Apps that use the mysql addon allows an app to connect to Cloudron's SQL server (ran in the mysql container). Changing a Global variable could mess up another app.

    Edit: Looks like I only answered part of the post - sorry about that.

    --
    https://urgero.org
    ~ Professional Nerd. Freelance Programmer. ~
    Matrix: @murgero:urgero.org

    1 Reply Last reply
    1
  • girishG Offline
    girishG Offline
    girish Staff
    wrote on last edited by
    #3

    When/where do you his this error in ampache? This needs to fixed in the app itself (it's hopefully quite easy to fix). If you can tell me how to reproduce this, we can create a proper bug report upstream.

    rmdesR 1 Reply Last reply
    0
  • rmdesR Offline
    rmdesR Offline
    rmdes
    replied to girish on last edited by rmdes
    #4

    @girish I started to see this error only with the last app package update. (logs from previous days do not show this error at all)
    this error can be seen in the Ampache log file, you need to specify it in the ampache cfg file
    mine is being collected at /app/data/log/ampache/daily-generated.txt file.

    I think I'm going to make a clean install, use my library on this new install and see if the error is there, I want to be sure this is not an option that I enabled causing this, and if it is, which one!

    rmdesR 1 Reply Last reply
    0
  • rmdesR Offline
    rmdesR Offline
    rmdes
    replied to rmdes on last edited by
    #5

    After a clean install the sql errors keep coming in the ampache log configured on the ampache.cfg config file.

    rmdesR 1 Reply Last reply
    0
  • rmdesR Offline
    rmdesR Offline
    rmdes
    replied to rmdes on last edited by
    #6

    It seems this thread is related to this old issue : https://github.com/ampache/ampache/issues/1078 but I'm still unsure about the origin of this error or what I can do to stop it

    rmdesR 1 Reply Last reply
    0
  • rmdesR Offline
    rmdesR Offline
    rmdes
    replied to rmdes on last edited by
    #7

    Found the cause at last :

    Basically if you turn the site public you get the SQL error
    https://forum.cloudron.io/topic/3663/how-to-turn-ampache-public-for-guests/1

    girishG 1 Reply Last reply
    0
  • girishG Offline
    girishG Offline
    girish Staff
    replied to rmdes on last edited by
    #8

    @rmdes Can you report this upstream? Thanks.

    rmdesR 1 Reply Last reply
    0
  • rmdesR Offline
    rmdesR Offline
    rmdes
    replied to girish on last edited by rmdes
    #9

    @girish Yes and found the option causing this : Enable URL Rewriting
    if you turn this off and then put auth"false" to have public site, all is fine.
    it's really this particular option turned True for role guest (default is user or off) that is causing the error, i'll create an issue upstream 🙂

    girishG 1 Reply Last reply
    1
  • girishG Offline
    girishG Offline
    girish Staff
    replied to rmdes on last edited by
    #10

    @rmdes Nice! Good detective work 🙂

    1 Reply Last reply
    1

  • Login

  • Don't have an account? Register

  • Login or register to search.
  • First post
    Last post
0
  • Categories
  • Recent
  • Tags
  • Popular
  • Bookmarks
  • Login

  • Don't have an account? Register

  • Login or register to search.