Comments (7)
Had absolutely no problems with it when I last tested it. Cant test it anymore since I traded my raspberrypi for a wandboard. The raspberrypi was just too slow to enjoy supysonic.
from supysonic.
I face this issue on a cubieboard running archlinux, here is the bt
$ python2 main.py
Traceback (most recent call last):
File "main.py", line 17, in <module>
db.init_db()
File "/var/supysonic/db.py", line 395, in init_db
Base.metadata.create_all(bind = engine)
File "/usr/lib/python2.7/site-packages/sqlalchemy/sql/schema.py", line 3308, in create_all
tables=tables)
File "/usr/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1516, in _run_visitor
conn._run_visitor(visitorcallable, element, **kwargs)
File "/usr/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1164, in _run_visitor
**kwargs).traverse_single(element)
File "/usr/lib/python2.7/site-packages/sqlalchemy/sql/visitors.py", line 119, in traverse_single
return meth(obj, **kw)
File "/usr/lib/python2.7/site-packages/sqlalchemy/sql/ddl.py", line 709, in visit_metadata
self.traverse_single(table, create_ok=True)
File "/usr/lib/python2.7/site-packages/sqlalchemy/sql/visitors.py", line 119, in traverse_single
return meth(obj, **kw)
File "/usr/lib/python2.7/site-packages/sqlalchemy/sql/ddl.py", line 728, in visit_table
self.connection.execute(CreateTable(table))
File "/usr/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 717, in execute
return meth(self, multiparams, params)
File "/usr/lib/python2.7/site-packages/sqlalchemy/sql/ddl.py", line 67, in _execute_on_connection
return connection._execute_ddl(self, multiparams, params)
File "/usr/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 771, in _execute_ddl
compiled
File "/usr/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 927, in _execute_context
context)
File "/usr/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1076, in _handle_dbapi_exception
exc_info
File "/usr/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 185, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb)
File "/usr/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 920, in _execute_context
context)
File "/usr/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 425, in do_execute
cursor.execute(statement, parameters)
File "/usr/lib/python2.7/site-packages/MySQLdb/cursors.py", line 205, in execute
self.errorhandler(self, exc, value)
File "/usr/lib/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorclass, errorvalue
sqlalchemy.exc.OperationalError: (OperationalError) (1071, 'Specified key was too long; max key length is 767 bytes') '\nCREATE TABLE artist (\n\tid BINARY(16) NOT NULL, \n\tname VARCHAR(256), \n\tPRIMARY KEY (id), \n\tUNIQUE (name)\n)\n\n' ()
from supysonic.
I was using ezpuzz's fork fine, but using spl0k's master brings up this error.
from supysonic.
That's (I guess) an unrelated problem. They talk about SQLite and you're using MySQL.
Anyway, your problem should be fixed with commit e84af9d
from supysonic.
Thanks, that did fix my problem
from supysonic.
The schema here works without issue on a Pi running the 2014-09-09 Wheezy image.
from supysonic.
Forgot to close this.
It's not valid anymore: it was created when supysonic was using SQLAlchemy, now we're using Storm.
from supysonic.
Related Issues (20)
- Testsuite failure using ponyorm v0.7.15rc1 (py3.9 and py3.10) HOT 2
- Pip failure on Windows HOT 3
- Running in PyCharm HOT 1
- Cyrillic letters in tags fail the playback / disable lyrics function? HOT 7
- jukebox mode skipping over songs HOT 2
- FR: Reach API level 1.11.0 HOT 6
- supysonic-server command not available HOT 2
- Testsuite failure with Python 3.11 HOT 9
- supysonic-daemon as normal user HOT 2
- supysonic-daemon settings HOT 5
- PostgreSQL error HOT 8
- Ongoing work to extend subsonic API HOT 7
- Error during migration with 7.4 HOT 2
- Intermittent '500 Internal Server Error' (possibly due to postgres query syntax) HOT 3
- Server error when accessing starred albums
- [Enchancement] Gunicorn request size limit HOT 3
- peewee.OperationalError: Server has gone away HOT 3
- Multiple artist albums have only 1 track HOT 4
- ValueError: badly formed hexadecimal UUID string in getAlbum.view HOT 2
- Error message should be logged on login failure
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from supysonic.