search

INTABiotechMJ / phenobook-server

An open source software for phenotypic data collection - Server
http://getphenobook.com/
2 stars 3 forks source link

Troubles with installing and app #1

Open petervandepol opened 5 years ago

petervandepol commented 5 years ago

Hi,

I just managed to get Phenobook running on my server. Turned out that the admin@admin.com mentioned in the manual was user@user.com. Besides that I hacked the config.php to get rid of all dev stuff. The server is running now.

However: I can not use it with the app: nothing is synced. How to solve this?

Many thanks,

Peter

juancresc commented 5 years ago

hi! is the URL in the app set up? what is showing in the log details?

petervandepol commented 5 years ago

Thank you for your reply, Juan. The URL is set up. I had some troubles there: in "settings" under the Application URL it says "ends with trailing slash". If I end with a trailing slash I get an authentication error. Without trailing slash and "update" I get "Uploading 0 record/'s"

Phenobook runs on a shared server at a ISP, Unfortuanately I have no access to the log files.

petervandepol commented 5 years ago

There are some more issues I guess. When deleting the "John Doe" user I get:

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'isSuperAdmin' in 'field list'' in /home/overberg/domains/pro-overberg.nl/public_html/killer/phenobook/files/php/class/Entity.php:150 Stack trace: #0 /home/overberg/domains/pro-overberg.nl/public_html/killer/phenobook/files/php/class/Entity.php(150): PDOStatement->execute(Array) #1 /home/overberg/domains/pro-overberg.nl/public_html/killer/phenobook/logic/users/delete.php(9): Entity::update(Object(User)) #2 {main} thrown in /PATH TO WWW/public_html/killer/phenobook/files/php/class/Entity.php on line 150

The user is not deleted then. In the database the table "user" has a field isAdmin, not isSuperAdmin. Could this be the issue?

When changing a user's details I get:

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'isSuperAdmin' in 'field list'' in /PATH/public_html/killer/phenobook/files/php/class/Entity.php:150 Stack trace: #0 /PATH/public_html/killer/phenobook/files/php/class/Entity.php(150): PDOStatement->execute(Array) #1 /PATH/public_html/killer/phenobook/logic/users/edit.php(34): Entity::update(Object(User)) #2 {main} thrown in /PATH/public_html/killer/phenobook/files/php/class/Entity.php on line 150

The user is not changed then.

Seems to me that there are a few "beauty-issues" with this software. This is a pity because it is exactly what am looking for as rose breeder.....

juancresc commented 5 years ago

Peter so I've fixed the provided .SQL with this new field. Do you have access to the database? you can add it to the User table as isSuperAdmin TINYINT DEFAULT 1.

Regarding to the connection issue, you can write my privately and we can both check how to debug it (juan.crescente at gmail). Maybe I can help you setting up a small VPS which is far more convenient.

petervandepol commented 5 years ago

Exellent, Juan! The SQL problems are gone and I can add, edit and delete users. Thank you. Lets solve the app issue now.