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