search

FriendUPCloud / friendup

FriendOS is a free web based platform that runs in your browser. It allows you to work and play, collaboratively, across devices.
https://friendos.com/
Other
347 stars 87 forks source link

Database issues on login #128

Closed ApertureDevelopment closed 3 years ago

ApertureDevelopment commented 4 years ago

Hello, I am experiencing some issues with commit https://github.com/FriendUPCloud/friendup/commit/c37b059ae9a08b009bd7c452dab0e55ea26b9d19 it seems that uppon user login it asks for a 'ModifyTime' field in the FUser table, which apperently does not exist. I followed the manual installation instructions, which is why I belive that this is a issue on your side.

Error message:

friendup-app   |   (mysqllibrary.c:136) 140205700851456 Cannot run query: 'SELECT `ID`,`Name`,`Password`,`Fullname`,`Email`,`SessionID`,`LoggedTime`,`CreatedTime`,`ModifyTime`,`LoginTime`,`MaxStoredBytes`,`MaxReadedBytes`,`Status`,`UniqueID` FROM FUser WHERE  `Name`='fadmin''
friendup-app   |   (mysqllibrary.c:138) 140205700851456 [MYSQLLibrary]  Unknown column 'ModifyTime' in 'field list'
titlestad commented 4 years ago

Ok, I see you are on master. Needs to be looked into for sure.

titlestad commented 4 years ago

Can you test this in Friend OS 1.2.4?

We've done updates - and you may have to look in the numbered update scripts in the db/ folder. Perhaps some of them didn't go through for some reason?