Skip to content
This repository has been archived by the owner on May 3, 2021. It is now read-only.

Cannot log in because users cannot be created in Lychee #324

Open
sin-tokyo opened this issue Dec 23, 2019 · 2 comments
Open

Cannot log in because users cannot be created in Lychee #324

sin-tokyo opened this issue Dec 23, 2019 · 2 comments

Comments

@sin-tokyo
Copy link

Enter your username and password during Lychee installation and press Create Login. You will see "Function not found! Please check the spelling of the called function."
The user has not been created and login has not been successful.

If you check lychee_settings, "password" and "username" are blank.

Installation is performed according to the procedure, and permissions and .htaccess are also set.

What is the cause?
Help me.

-I am Japanese. Sorry for not good at English.

Lychee_01

Lychee_02

Diagnostics

Warning: Dropbox import not working. No property for dropboxKey.
Warning: Pictures that are rotated lose their metadata! Please install Imagick to avoid that.
Error: Username empty or not set in database
Error: Password empty or not set in database

System Information

You have to be logged in to see more information.

lychee_settings

"checkForUpdates","1"
"default_license","none"
"deleteImported","1"
"dropboxKey",""
"full_photo","1"
"hide_version_number","1"
"identifier","fc7a7d254c3f20d40139503523d8dd07"
"image_overlay","0"
"image_overlay_type","exif"
"imagick","1"
"lang","en"
"layout","0"
"medium_max_height","1080"
"medium_max_width","1920"
"password",""
"php_script_limit","0"
"plugins",""
"public_search","0"
"skipDuplicates","0"
"small_max_height","360"
"small_max_width","0"
"sortingAlbums","ORDER BY id DESC"
"sortingPhotos","ORDER BY id DESC"
"useExiftool","0"
"username",""
"version","update_030216"

lychee_log

"1","1577061595","error","Lychee\Modules\Database::createTables","169","Table 'lychee.lychee_settings' doesn't exist"
"2","1577061595","error","Lychee\Modules\Database::createTables","214","Table 'lychee.lychee_albums' doesn't exist"
"3","1577061595","error","Lychee\Modules\Database::createTables","237","Table 'lychee.lychee_photos' doesn't exist"
"4","1577061595","error","update_030203","12","Unknown column 'small' in 'field list'"
"5","1577061595","error","update_030204","12","Unknown column 'lens' in 'field list'"
"6","1577061595","error","update_030205","12","Unknown column 'license' in 'field list'"
"7","1577061595","error","update_030207","12","Unknown column 'license' in 'field list'

System Information

Lychee Version (json): 3.2.16
System: CentOS Linux 7.4.1708
PHP Version: 7.2.26
MySQL Version: 5.7.28

Browser and system

Chrome 78.0.3904.108
Windows 10

@d7415
Copy link
Contributor

d7415 commented Jan 1, 2020

It looks like your MySQL user doesn't have sufficient access.

@sin-tokyo
Copy link
Author

Thank you for the advice.

But unfortunately the MySQL user is granted GRANT ALL privileges.

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants