#256 Error occured after logging

[Alexandre ATKINSON]

Hi,

First, sorry for my english, it's not my maternal tongue.
I work in a genomic facilities, and we need a lims which manage samples, projects...
I have tested your test version, you make a really good job !!

I was able to follow the installation guide.
I just needed to change some files permission and add a missing jar file (j4log), and I can now log me.
I can see a progress bar screen, and it's stop with message "There has been a system error, please try the request again".

A look to Catalina logs indicate this error is SQL related, about an unknown column 'librarypre0.codeRequestCategory' in 'field list'.

I re-read the installation guide, I searched a bit, but I can't find if I made a mistake.
I add catalina log file.

[Alexandre ATKINSON]

Sorry, I forget some (useful?) informations : I use Linux Mint, java8, tomcat8,mysql5 and Gnomex 5.36.
I have tried 5.36 from Git, but no change.

[Ivan]

I'm having the exact same SQL error with 5.35, haven't tried other versions yet. Please update if you find the solution. Thanks!

[Ivan]

Just went to the Github page and used this version of gnomex_db_ddl.sql (https://github.com/hci-gnomex/gnomex/blob/6e7cc4ce6fc0ce0be929df1f4657b3682806b962/sql/gnomex_db_ddl.sql) and I was able to get past the SQL error!

[Alexandre ATKINSON]

I have tested 5.36 release, and files are identical.

But the latest Git version has been updated a month ago, and files are (a bit) different.
Many thanks, I'll test it tomorrow.

[Ivan]

Hi Alexandre,

Did you log in to mysql as root and do "DROP DATABASE gnomex" first and
recreate the database again? I had to do that to get it to work.

Best,

Ivan

On Mon, Oct 31, 2016 at 2:32 PM, Alexandre ATKINSON <a-atkinson@users.sf.net

wrote:

I have tested 5.36 release, and files are identical.

But the latest Git version has been updated a month ago, and is different.
Many thanks, I'll test it tomorrow.

---

• [bugs:#256] https://sourceforge.net/p/gnomex/bugs/256/ Error occured
  after logging*

Status: open
Group: Unknown_release
Created: Fri Oct 28, 2016 03:46 PM UTC by Alexandre ATKINSON
Last Updated: Mon Oct 31, 2016 09:06 PM UTC
Owner: nobody
Attachments:

• catalina.out
  https://sourceforge.net/p/gnomex/bugs/256/attachment/catalina.out
  (31.0 kB; application/octet-stream)

Hi,

First, sorry for my english, it's not my maternal tongue.
I work in a genomic facilities, and we need a lims which manage samples,
projects...
I have tested your test version, you make a really good job !!

I was able to follow the installation guide.
I just needed to change some files permission and add a missing jar file
(j4log), and I can now log me.
I can see a progress bar screen, and it's stop with message "There has
been a system error, please try the request again".

A look to Catalina logs indicate this error is SQL related, about an unknown
column 'librarypre0.codeRequestCategory' in 'field list'.

I re-read the installation guide, I searched a bit, but I can't find if I
made a mistake.
I add catalina log file.

---

Sent from sourceforge.net because you indicated interest in
https://sourceforge.net/p/gnomex/bugs/256/

To unsubscribe from further messages, please visit
https://sourceforge.net/auth/subscriptions/

[Alexandre ATKINSON]

By now, it's work for you ?
Or you just fall on another bug/problem again ?

[Ivan]

Yes, it's been working fine for me since I found the updated
gnomex_db_ddl.sql and recreated the mysql database.

Best of luck!

Ivan

On Mon, Oct 31, 2016 at 2:36 PM, Alexandre ATKINSON <a-atkinson@users.sf.net

wrote:

By now, it's work for you ?
Or you fall n another bug/problem ?

---

• [bugs:#256] https://sourceforge.net/p/gnomex/bugs/256/ Error occured
  after logging*

Status: open
Group: Unknown_release
Created: Fri Oct 28, 2016 03:46 PM UTC by Alexandre ATKINSON
Last Updated: Mon Oct 31, 2016 09:32 PM UTC
Owner: nobody
Attachments:

• catalina.out
  https://sourceforge.net/p/gnomex/bugs/256/attachment/catalina.out
  (31.0 kB; application/octet-stream)

Hi,

First, sorry for my english, it's not my maternal tongue.
I work in a genomic facilities, and we need a lims which manage samples,
projects...
I have tested your test version, you make a really good job !!

I was able to follow the installation guide.
I just needed to change some files permission and add a missing jar file
(j4log), and I can now log me.
I can see a progress bar screen, and it's stop with message "There has
been a system error, please try the request again".

A look to Catalina logs indicate this error is SQL related, about an unknown
column 'librarypre0.codeRequestCategory' in 'field list'.

I re-read the installation guide, I searched a bit, but I can't find if I
made a mistake.
I add catalina log file.

---

Sent from sourceforge.net because you indicated interest in
https://sourceforge.net/p/gnomex/bugs/256/

To unsubscribe from further messages, please visit
https://sourceforge.net/auth/subscriptions/