[p2pu-dev] Problem with installing lernanta

[Jessica Ledbetter]

I couldn't replicate it on my other vm but I'm thinking we have our MySQL
setup differently. If it won't lose any data, we can limit down the
https://github.com/p2pu/lernanta/blob/master/lernanta/apps/tracker/models.py#L21to
200? URLField's default is 200.

Zuzel, do we have any that are more than 200? Can we? I think group slug and
task slug are limiting so don't think we would go over 200 but can't check
right now.

On Wed, Sep 21, 2011 at 12:02 PM, zuzel.vp <zuzel.vp at gmail.com> wrote:

> Jessica, that is the error I mentioned about the setup on mysql. Paul,
> I recommend you to try setting things up with sqlite until the
> migrations are fixed for mysql.
>
> --
> Thanks,
>    Zuzel
>
> On Wed, Sep 21, 2011 at 10:11 AM, i at paulbooker.co.uk <i at paulbooker.co.uk>
> wrote:
> > Hello,
> >
> > Just got this error, i'll investigate some more this evening.
> >
> > // Paul Booker
> >
> > (lernanta)Paul-Bookers-Mac-mini:lernanta paul$ ./sh/syncdb
> > ..
> > ..
> >
> > Running migrations for tracker:
> >  - Migrating forwards to 0005_auto__add_pageviewmetrics.
> >> tracker:0001_initial
> >  ! Error found during real run of migration! Aborting.
> >
> >  ! Since you have a database that does not support running
> >  ! schema-altering statements in transactions, we have had
> >  ! to leave it in an interim state between migrations.
> >
> > ! You *might* be able to recover with:   = DROP TABLE `tracker_pageview`
> > CASCADE; []
> >
> >  ! The South developers regret this has happened, and would
> >  ! like to gently persuade you to consider a slightly
> >  ! easier-to-deal-with DBMS.
> >  ! NOTE: The error which caused the migration to fail is further up.
> > Traceback (most recent call last):
> >  File "manage.py", line 26, in <module>
> >    execute_manager(settings)
> >  File
> > "/Library/Python/2.6/site-packages/django/core/management/__init__.py",
> line
> > 438, in execute_manager
> >    utility.execute()
> >  File
> > "/Library/Python/2.6/site-packages/django/core/management/__init__.py",
> line
> > 379, in execute
> >    self.fetch_command(subcommand).run_from_argv(self.argv)
> >  File "/Library/Python/2.6/site-packages/django/core/management/base.py",
> > line 191, in run_from_argv
> >    self.execute(*args, **options.__dict__)
> >  File "/Library/Python/2.6/site-packages/django/core/management/base.py",
> > line 220, in execute
> >    output = self.handle(*args, **options)
> >  File
> >
> "/Users/paul/.virtualenvs/lernanta/lib/python2.6/site-packages/south/management/commands/migrate.py",
> > line 105, in handle
> >    ignore_ghosts = ignore_ghosts,
> >  File
> >
> "/Users/paul/.virtualenvs/lernanta/lib/python2.6/site-packages/south/migration/__init__.py",
> > line 191, in migrate_app
> >    success = migrator.migrate_many(target, workplan, database)
> >  File
> >
> "/Users/paul/.virtualenvs/lernanta/lib/python2.6/site-packages/south/migration/migrators.py",
> > line 221, in migrate_many
> >    result = migrator.__class__.migrate_many(migrator, target, migrations,
> > database)
> >  File
> >
> "/Users/paul/.virtualenvs/lernanta/lib/python2.6/site-packages/south/migration/migrators.py",
> > line 292, in migrate_many
> >    result = self.migrate(migration, database)
> >  File
> >
> "/Users/paul/.virtualenvs/lernanta/lib/python2.6/site-packages/south/migration/migrators.py",
> > line 125, in migrate
> >    result = self.run(migration)
> >  File
> >
> "/Users/paul/.virtualenvs/lernanta/lib/python2.6/site-packages/south/migration/migrators.py",
> > line 99, in run
> >    return self.run_migration(migration)
> >  File
> >
> "/Users/paul/.virtualenvs/lernanta/lib/python2.6/site-packages/south/migration/migrators.py",
> > line 82, in run_migration
> >    south.db.db.execute_deferred_sql()
> >  File
> >
> "/Users/paul/.virtualenvs/lernanta/lib/python2.6/site-packages/south/db/generic.py",
> > line 184, in execute_deferred_sql
> >    self.execute(sql)
> >  File
> >
> "/Users/paul/.virtualenvs/lernanta/lib/python2.6/site-packages/south/db/generic.py",
> > line 150, in execute
> >    cursor.execute(sql, params)
> >  File "/Library/Python/2.6/site-packages/django/db/backends/util.py",
> line
> > 15, in execute
> >    return self.cursor.execute(sql, params)
> >  File
> "/Library/Python/2.6/site-packages/django/db/backends/mysql/base.py",
> > line 86, in execute
> >    return self.cursor.execute(query, args)
> >  File
> >
> "/Users/paul/.virtualenvs/lernanta/lib/python2.6/site-packages/MySQLdb/cursors.py",
> > line 175, in execute
> >    if not self._defer_warnings: self._warning_check()
> >  File
> >
> "/Users/paul/.virtualenvs/lernanta/lib/python2.6/site-packages/MySQLdb/cursors.py",
> > line 89, in _warning_check
> >    warn(w[-1], self.Warning, 3)
> > _mysql_exceptions.Warning: Specified key was too long; max key length is
> 767
> > bytes
> >
> > _______________________________________________
> > p2pu-dev mailing list
> > p2pu-dev at lists.p2pu.org
> > http://lists.p2pu.org/mailman/listinfo/p2pu-dev
> >
> _______________________________________________
> p2pu-dev mailing list
> p2pu-dev at lists.p2pu.org
> http://lists.p2pu.org/mailman/listinfo/p2pu-dev
>



-- 
Jessica Ledbetter
http://jessicaledbetter.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.p2pu.org/pipermail/p2pu-dev/attachments/20110921/f335cc85/attachment.html>