Community Forums

1. 

   86me
   Member
   Posted 13 years ago

   Full error:
   

   File '/httpdocs/mediacore-0.8rc1/mediacore/lib/decorators.py', line 206 in validate
     return self.func(*args, **kwargs)
   File '/httpdocs/mediacore-0.8rc1/mediacore/controllers/admin/media.py', line 237 in save
     media.set_tags(tags)
   File '/httpdocs/mediacore-0.8rc1/mediacore/model/media.py', line 349 in set_tags
     tags = fetch_and_create_tags(tags)
   File '/httpdocs/mediacore-0.8rc1/mediacore/model/tags.py', line 123 in fetch_and_create_tags
     func.lower(Tag.name).in_(lower_case_tags)
   File '/lib/python2.5/site-packages/SQLAlchemy-0.5.8-py2.5.egg/sqlalchemy/orm/query.py', line 1267 in all
   File '/lib/python2.5/site-packages/SQLAlchemy-0.5.8-py2.5.egg/sqlalchemy/orm/query.py', line 1360 in __iter__
   File '/lib/python2.5/site-packages/SQLAlchemy-0.5.8-py2.5.egg/sqlalchemy/orm/session.py', line 897 in _autoflush
   File '/lib/python2.5/site-packages/SQLAlchemy-0.5.8-py2.5.egg/sqlalchemy/orm/session.py', line 1354 in flush
   File '/lib/python2.5/site-packages/SQLAlchemy-0.5.8-py2.5.egg/sqlalchemy/orm/session.py', line 1432 in _flush
   File '/lib/python2.5/site-packages/SQLAlchemy-0.5.8-py2.5.egg/sqlalchemy/orm/unitofwork.py', line 261 in execute
   File '/lib/python2.5/site-packages/SQLAlchemy-0.5.8-py2.5.egg/sqlalchemy/orm/unitofwork.py', line 753 in execute
   File '/lib/python2.5/site-packages/SQLAlchemy-0.5.8-py2.5.egg/sqlalchemy/orm/unitofwork.py', line 768 in execute_save_steps
   File '/lib/python2.5/site-packages/SQLAlchemy-0.5.8-py2.5.egg/sqlalchemy/orm/unitofwork.py', line 759 in save_objects
   File '/lib/python2.5/site-packages/SQLAlchemy-0.5.8-py2.5.egg/sqlalchemy/orm/mapper.py', line 1417 in _save_obj
   File '/lib/python2.5/site-packages/SQLAlchemy-0.5.8-py2.5.egg/sqlalchemy/engine/base.py', line 824 in execute
   File '/lib/python2.5/site-packages/SQLAlchemy-0.5.8-py2.5.egg/sqlalchemy/engine/base.py', line 874 in _execute_clauseelement
   File '/lib/python2.5/site-packages/SQLAlchemy-0.5.8-py2.5.egg/sqlalchemy/engine/base.py', line 896 in __execute_context
   File '/lib/python2.5/site-packages/SQLAlchemy-0.5.8-py2.5.egg/sqlalchemy/engine/base.py', line 950 in _cursor_execute
   File '/lib/python2.5/site-packages/SQLAlchemy-0.5.8-py2.5.egg/sqlalchemy/engine/base.py', line 931 in _handle_dbapi_exception
   OperationalError: (OperationalError) (1449, "There is no 'root'@'localhost' registered") u'UPDATE media SET modified_on=%s, description_plain=%s, notes=%s, duration=%s, author_name=%s, author_email=%s WHERE media.id = %s' [datetime.datetime(2010, 5, 4, 14, 38, 17, 854453), 'test text', None, None, 'Admin', 'email@address.com', 1L]

   my sqlalchemy.url does not refer to root user. Not sure where this is coming from.
2. 

   Nathan Wright
   Maintainer
   Posted 13 years ago

   That's interesting, the error you're seeing result from the media table triggers. It seems that mysqldump exports triggers in a way that works great on the machine that
   it originally ran on, but that's not guaranteed to work on all other machines. For some reason it explicitly references root@localhost when it creates them, but I see no need for it to.

   I've committed setup_triggers.sql to our Git repository. Please try running this script on your current database as a mysql superuser such as root. It will remove the broken triggers and recreate them using the same queries I wrote originally, rather than mysqldump output.

   Let me know if you have any further troubles on this! It's difficult for me to thoroughly test this myself since it seems to be a product of our mysql configurations being different.

   Cheers, Nathan

RSS feed for this topic

Reply

You must log in to post.