Code Monkey home page Code Monkey logo

Comments (7)

andrenam avatar andrenam commented on August 17, 2024

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.

hdhoang avatar hdhoang commented on August 17, 2024

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.

hdhoang avatar hdhoang commented on August 17, 2024

I was using ezpuzz's fork fine, but using spl0k's master brings up this error.

from supysonic.

spl0k avatar spl0k commented on August 17, 2024

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.

hdhoang avatar hdhoang commented on August 17, 2024

Thanks, that did fix my problem

from supysonic.

ddd999 avatar ddd999 commented on August 17, 2024

The schema here works without issue on a Pi running the 2014-09-09 Wheezy image.

from supysonic.

spl0k avatar spl0k commented on August 17, 2024

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)

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo 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.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.