lycheesync icon indicating copy to clipboard operation
lycheesync copied to clipboard

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

Open Powerbock opened this issue 7 years ago • 3 comments

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 ================== `

Powerbock avatar May 12 '17 18:05 Powerbock

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.

gslavov avatar Sep 28 '17 07:09 gslavov

ok, will add a conf for this

GustavePate avatar Feb 17 '18 14:02 GustavePate

Is this fixed?

praneet195 avatar Mar 05 '19 12:03 praneet195