[MSNoise] Web interface internal server error

[Thomas Lecocq]

Hi Emily,

Strange... could you try doing:

msnoise upgrade_db

and retry ?

Tom


On 06/09/2017 13:37, Crowder, Emily wrote:
> Hello,
>
>
> I have just installed and setup MSNoise (and MySQL and MySQL Workbench) on my new Mac. I have successfully done scan_archive but my problem is that when I try to use the web interface to view "Data Availability" I get the following error message:
>
>
> "Internal Server Error - The server encountered an internal error and was unable to complete your request. Either the server is overloaded or there is an error in the application."
>
>
> In the terminal, the message is:
>
>
> "InternalError: (pymysql.err.InternalError) (1412, u'Table definition has changed, please retry transaction') [SQL: u'SELECT count(%(count_2)s) AS count_1 \nFROM data_availability'] [parameters: {u'count_2': '*'}]
>
>
> 2017-09-06 12:36:04 [INFO] 127.0.0.1 - - [06/Sep/2017 12:36:04] "GET /admin/data_availability/ HTTP/1.1" 500 -"
>
>
> Is there something I have done in MySQL Workbench? Any ideas on how I can view Data Availability and Jobs? Everything else appears to be working, I have all my data in the MySQL database.
>
>
> Kind regards,
>
> Emily
>
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~
>
> Emily Crowder MSc BSc
> PhD Student
> School of Geosciences
> University of Aberdeen
> Aberdeen AB24 3UE
> Scotland
> Em: emily.crowder at abdn.ac.uk
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~
>
>
> The University of Aberdeen is a charity registered in Scotland, No SC013683.
> Tha Oilthigh Obar Dheathain na charthannas clàraichte ann an Alba, Àir. SC013683.
> _______________________________________________
> MSNoise mailing list
> MSNoise at mailman-as.oma.be
> http://mailman-as.oma.be/mailman/listinfo/msnoise

-- 
Dr. Thomas Lecocq
Geologist - Seismologist

Seismology - Gravimetry
Royal Observatory of Belgium

            *
        * * * * *
         * * * *
        ---------
http://www.seismology.be
http://msnoise.org
http://twitter.com/#!/Seismologie_be
https://www.facebook.com/seismologie.be