Hi everyone, I want to work with sara plugin, after station table has been populated and the archive scanned, I use the command "msnoise config --set plugins=msnoise_sara" then Successfully updated parameter plugins = msnoise_sara. Afterwards I use the command "msnoise p sara install" and I face with the Error "No such command "sara"" could you please help me Thanks a lot Navid Return-Path: &lt;vanessa.gaelle3(a)gmail.com&gt; X-Original-To: msnoise(a)mailman-as.oma.be Delivered-To: msnoise(a)mailman-as.oma.be Received: from mail-oi1-f174.google.com (mail-oi1-f174.google.com [209.85.167.174]) by mailman-as.oma.be (Postfix) with ESMTP id 2398E2075B for &lt;msnoise(a)mailman-as.oma.be&gt;be>; Mon, 15 Jul 2019 18:32:37 +0000 (UTC) Received: by mail-oi1-f174.google.com with SMTP id s184so13433018oie.9 for &lt;msnoise(a)mailman-as.oma.be&gt;be>; Mon, 15 Jul 2019 11:32:37 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:references:in-reply-to:from:date:message-id:subject:to; bh=8FQlI/B22THz1BlxuVRG+2J33NYLtL+fFfOln5d+gTg=; b=rdQJjPdyG2V0iwseZEDwm/R+/uhm3c6piUoUbWwl9wtnXWCkVsSXjt4X0d79wc7QZ5 H3wYCOo/bhJBagqoz0MitiaPwsVg9x4Py212TvLiXulFX2wqJ5+rxl9JlXj89o+qQ2/D 2u7UusYKOIp5jTvN4aT51yqYw9c1xN4qkvwlX5Ph9zCRn2r9PhTpOVJBOm4hmZggBmhX 5dsBallB4vJwQ21uEYGaCqCjeSMWNmgxs0NKLKqeUwNqp2qDqp//zNcz0Yv0Gp1F6+cC XM7ZgpiNYvkRqJTseykUvDMvGfaPCn55PYfdviuc1dpb/r0SkKMuPo2VwMEcUXOkELLA K1/A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to; bh=8FQlI/B22THz1BlxuVRG+2J33NYLtL+fFfOln5d+gTg=; b=oghE5kmS7XAaMs7Arz4LaN0uuJ1f+bnLaRu2ok9IuAaYk2mEgFME0eYQORC/h7ePOo CWLayVKFgFaHzDfgupFEiPNOeN5QomZfnRemC9oJkqlHfgWieDw2lpT36g86+XbUVAbr iXdrYi6HmP9rLNGtPk5WM+b7zFgz+2c0A3lFLPkZ07frCf/wGQG7RdCzjd2wdjWybG6u S3fS8ch85NayEVv0IINBHrs9FADIBCZijtaScdQqfVWCnIdLCfMqu4lDwzTuN8qdNtN8 6/tdyzMwucKfQtn2wNu7CSx8hQyaqV8kOJ2DGCtg01kVu3QcSP4HZrpKgFYGyI0Ry4r2 501Q== X-Gm-Message-State: APjAAAW0Eb+SEVW//I4DKSyMF448W3ULSstrwwZT8kB2CbeR8osT74gJ /JGfRQab1Fz/eKMUa4BL4qyyuVDoEopKPj2+pTRPCbz6 X-Google-Smtp-Source: APXvYqyp24AjB8Nx92UQPmRtNnc1SX+RvtDptMYfdGLrWpaMxS9/8caetjMCFDIdHC/etcCqTMtmSu+wjFF5SD5O0/I= X-Received: by 2002:aca:544b:: with SMTP id i72mr14663197oib.174.1563215555809; Mon, 15 Jul 2019 11:32:35 -0700 (PDT) MIME-Version: 1.0 References: &lt;CAMKH5-=4HkuTgBU6SqH6A=BZuCCgJSLku4AnCa4i=og0DqO_qA(a)mail.gmail.com&gt; &lt;778217f9-4cec-ce15-530f-5e318838c820(a)seismology.be&gt; In-Reply-To: &lt;778217f9-4cec-ce15-530f-5e318838c820(a)seismology.be&gt; From: gaelle vanessa Nana &lt;vanessa.gaelle3(a)gmail.com&gt; Date: Mon, 15 Jul 2019 19:32:15 +0100 Message-ID: &lt;CAMKH5-=sG8+7SkKu2DCPd5gnwmFMUvXJf8YGZ+B3L+x_w6N8SA(a)mail.gmail.com&gt; To: Python Package for Monitoring Seismic Velocity Changes using Ambient Seismic Noise &lt;msnoise(a)mailman-as.oma.be&gt; Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable X-Content-Filtered-By: Mailman/MimeDel 2.1.12 Subject: Re: [MSNoise] help X-BeenThere: msnoise(a)mailman-as.oma.be X-Mailman-Version: 2.1.12 Precedence: list List-Id: Python Package for Monitoring Seismic Velocity Changes using Ambient Seismic Noise <msnoise.mailman-as.oma.be> List-Unsubscribe: <http://mailman-as.oma.be/mailman/options/msnoise>, <mailto:msnoise-request@mailman-as.oma.be?subject=unsubscribe> List-Archive: <http://mailman-as.oma.be/pipermail/msnoise/> List-Post: <mailto:msnoise@mailman-as.oma.be> List-Help: <mailto:msnoise-request@mailman-as.oma.be?subject=help> List-Subscribe: <http://mailman-as.oma.be/mailman/listinfo/msnoise>, <mailto:msnoise-request@mailman-as.oma.be?subject=subscribe> X-List-Received-Date: Mon, 15 Jul 2019 18:32:37 -0000 Hello group, i have Problem with the STACK. I did the CC, but when i start the STACK processus, some PB appear, i don't know what to do exactly. You can see below the error who appear on the terminal, after running the STACK. thank you for your help base) vanessa@NANA:~/noise1$ msnoise stack -r -m -i 10 Lets STACK ! 2019-07-15 19:23:45 [DEBUG] Starting the ref stack [] 2019-07-15 19:23:45 [DEBUG] Processing XB_CM01:XB_CM02-ZZ-1 Traceback (most recent call last): File "/home/vanessa/anaconda3/lib/python3.7/site-packages/sqlalchemy/engine/base= .py", line 1244, in _execute_context cursor, statement, parameters, context File "/home/vanessa/anaconda3/lib/python3.7/site-packages/sqlalchemy/engine/defa= ult.py ", line 550, in do_execute cursor.execute(statement, parameters) File "/home/vanessa/anaconda3/lib/python3.7/site-packages/pymysql/cursors.py", line 17 0, in execute result =3D self._query(query) File "/home/vanessa/anaconda3/lib/python3.7/site-packages/pymysql/cursors.py", line 32 8, in _query conn.query(q) File "/home/vanessa/anaconda3/lib/python3.7/site-packages/pymysql/connections.py= ", lin e 517, in query self._affected_rows =3D self._read_query_result(unbuffered=3Dunbuffered) File "/home/vanessa/anaconda3/lib/python3.7/site-packages/pymysql/connections.py= ", lin e 732, in _read_query_result result.read() File "/home/vanessa/anaconda3/lib/python3.7/site-packages/pymysql/connections.py= ", lin e 1075, in read first_packet =3D self.connection._read_packet() File "/home/vanessa/anaconda3/lib/python3.7/site-packages/pymysql/connections.py= ", lin e 684, in _read_packet packet.check_error() File "/home/vanessa/anaconda3/lib/python3.7/site-packages/pymysql/protocol.py", line 2 20, in check_error err.raise_mysql_exception(self._data) File "/home/vanessa/anaconda3/lib/python3.7/site-packages/pymysql/err.py", line 109, i n raise_mysql_exception raise errorclass(errno, errval) pymysql.err.InternalError: (1055, "Expression #1 of SELECT list is not in GROUP BY claus e and contains nonaggregated column 'msnoise.jobs.ref' which is not functionally depende nt on columns in GROUP BY clause; this is incompatible with sql_mode=3Donly_full_group_by" ) The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/home/vanessa/anaconda3/bin/msnoise", line 10, in <module> sys.exit(run()) File "/home/vanessa/anaconda3/lib/python3.7/site-packages/msnoise/scripts/msnois= e.py", line 717, in run cli(obj=3D{}) File "/home/vanessa/anaconda3/lib/python3.7/site-packages/click/core.py", line 764, in __call__ return self.main(*args, **kwargs) File "/home/vanessa/anaconda3/lib/python3.7/site-packages/click/core.py", line 717, in main rv =3D self.invoke(ctx) File "/home/vanessa/anaconda3/lib/python3.7/site-packages/click/core.py", line 1137, i n invoke return _process_result(sub_ctx.command.invoke(sub_ctx)) File "/home/vanessa/anaconda3/lib/python3.7/site-packages/click/core.py", line 956, in invoke return ctx.invoke(self.callback, **ctx.params) File "/home/vanessa/anaconda3/lib/python3.7/site-packages/click/core.py", line 555, in invoke return callback(*args, **kwargs) File "/home/vanessa/anaconda3/lib/python3.7/site-packages/msnoise/scripts/msnois= e.py", line 375, in stack main('ref', interval) File "/home/vanessa/anaconda3/lib/python3.7/site-packages/msnoise/s04stack.py", line 1 97, in main updated_days =3D updated_days_for_dates(db, start, end, pair.replace('_'= , '.'), jobtyp e=3D'CC', interval=3Ddatetime.timedelta(days=3Dinterval),returndays=3DTrue) File "/home/vanessa/anaconda3/lib/python3.7/site-packages/msnoise/api.py", line 1255, in updated_days_for_dates group_by(Job.day).order_by(Job.day).all() File "/home/vanessa/anaconda3/lib/python3.7/site-packages/sqlalchemy/orm/query.p= y", li ne 3168, in all return list(self) File "/home/vanessa/anaconda3/lib/python3.7/site-packages/sqlalchemy/orm/query.p= y", li ne 3324, in __iter__ return self._execute_and_instances(context) File "/home/vanessa/anaconda3/lib/python3.7/site-packages/sqlalchemy/orm/query.p= y", li ne 3349, in _execute_and_instances result =3D conn.execute(querycontext.statement, self._params) File "/home/vanessa/anaconda3/lib/python3.7/site-packages/sqlalchemy/engine/base= .py", line 988, in execute return meth(self, multiparams, params) File "/home/vanessa/anaconda3/lib/python3.7/site-packages/sqlalchemy/sql/element= s.py", line 287, in _execute_on_connection return connection._execute_clauseelement(self, multiparams, params) File "/home/vanessa/anaconda3/lib/python3.7/site-packages/sqlalchemy/engine/base= .py", line 1107, in _execute_clauseelement distilled_params, File "/home/vanessa/anaconda3/lib/python3.7/site-packages/sqlalchemy/engine/base= .py", line 1248, in _execute_context e, statement, parameters, cursor, context File "/home/vanessa/anaconda3/lib/python3.7/site-packages/sqlalchemy/engine/base= .py", line 1466, in _handle_dbapi_exception util.raise_from_cause(sqlalchemy_exception, exc_info) File "/home/vanessa/anaconda3/lib/python3.7/site-packages/sqlalchemy/util/compat= .py", line 399, in raise_from_cause reraise(type(exception), exception, tb=3Dexc_tb, cause=3Dcause) File "/home/vanessa/anaconda3/lib/python3.7/site-packages/sqlalchemy/util/compat= .py", line 153, in reraise raise value.with_traceback(tb) File "/home/vanessa/anaconda3/lib/python3.7/site-packages/sqlalchemy/engine/base= .py", line 1244, in _execute_context cursor, statement, parameters, context File "/home/vanessa/anaconda3/lib/python3.7/site-packages/sqlalchemy/engine/defa= ult.py ", line 550, in do_execute cursor.execute(statement, parameters) File "/home/vanessa/anaconda3/lib/python3.7/site-packages/pymysql/cursors.py", line 17 0, in execute result =3D self._query(query) File "/home/vanessa/anaconda3/lib/python3.7/site-packages/pymysql/cursors.py", line 32 8, in _query conn.query(q) File "/home/vanessa/anaconda3/lib/python3.7/site-packages/pymysql/connections.py= ", lin e 517, in query self._affected_rows =3D self._read_query_result(unbuffered=3Dunbuffered) File "/home/vanessa/anaconda3/lib/python3.7/site-packages/pymysql/connections.py= ", lin e 732, in _read_query_result result.read() File "/home/vanessa/anaconda3/lib/python3.7/site-packages/pymysql/connections.py= ", lin e 1075, in read first_packet =3D self.connection._read_packet() File "/home/vanessa/anaconda3/lib/python3.7/site-packages/pymysql/connections.py= ", lin e 684, in _read_packet packet.check_error() File "/home/vanessa/anaconda3/lib/python3.7/site-packages/pymysql/protocol.py", line 2 20, in check_error err.raise_mysql_exception(self._data) File "/home/vanessa/anaconda3/lib/python3.7/site-packages/pymysql/err.py", line 109, i n raise_mysql_exception raise errorclass(errno, errval) sqlalchemy.exc.InternalError: (pymysql.err.InternalError) (1055, "Expression #1 of SELEC T list is not in GROUP BY clause and contains nonaggregated column 'msnoise.jobs.ref' wh ich is not functionally dependent on columns in GROUP BY clause; this is incompatible wi th sql_mode=3Donly_full_group_by") [SQL: SELECT jobs.ref AS jobs_ref, jobs.day AS jobs_day, jobs.pair AS jobs_pair, jobs.jo btype AS jobs_jobtype, jobs.flag AS jobs_flag, jobs.lastmod AS jobs_lastmod FROM jobs WHERE jobs.pair =3D %(pair_1)s AND jobs.day >=3D %(day_1)s AND jobs.day <= =3D %(day_2)s AND job s.jobtype =3D %(jobtype_1)s AND jobs.lastmod >=3D %(lastmod_1)s GROUP BY jobs.day ORDER BY j obs.day] [parameters: {'pair_1': 'XB.CM01:XB.CM02', 'day_1': datetime.date(2006, 1, 1), 'day_2': datetime.date(2007, 1, 1), 'jobtype_1': 'CC', 'lastmod_1': datetime.datetime(2019, 7, 5, 19, 23, 45, 798518)}] (Background on this error at: http://sqlalche.me/e/2j85) Le mer. 3 juil. 2019 =C3=A0 08:07, Thomas Lecocq &lt;Thomas.Lecocq(a)seismology.= be> a =C3=A9crit :