search

GustavePate / lycheesync

a command line interface tool to sync lychee with any directory containing photos
108 stars 37 forks source link

Datebase Error pymysql.err.ProgrammingError: (1146, "Table 'lychee.lychee_albums' doesn't exist") #74

Open Powerbock opened 7 years ago

Powerbock commented 7 years ago 
System Information
------------------
Lychee Version:  3.1.6
DB Version:      030102
System:          Linux
PHP Version:     7
MySQL Version:   50718
Imagick:         1
Imagick Active:  1
Imagick Version: 1673
GD Version:      2.1.1
Plugins:

File "/usr/local/lib/python3.5/dist-packages/PyMySQL-0.7.1-py3.5.egg/pymysql/err.py", line 112, in _check_mysql_exception raise errorclass(errno, errorvalue) pymysql.err.ProgrammingError: (1146, "Table 'lychee.lychee_albums' doesn't exist") ERROR;2017-05-12 20:03:24,650; main; =================== script ended with errors ================== `

gslavov commented 7 years ago

I realise that this is quite old so you may have solved it already but I had the same issue trying to setup lycheesync today and it was due to the tables having a prefix. The fix is to modify the source files by replacing the table names with the prefixed versions.

There are 5 files to modify and 4 table names to replace in them.

GustavePate commented 6 years ago

ok, will add a conf for this

praneet195 commented 5 years ago

Is this fixed?