[p2pu-dev] Problem with installing lernanta

zuzel.vp zuzel.vp at gmail.com
Wed Sep 21 20:48:07 UTC 2011


Remember that the regular expression you used to filter page views is
tracking * after the page slug. The longer ones we currently have on
db are:

mysql> select request_url, length(request_url) from tracker_pageview
order by length(request_url) desc limit 3;
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------+
| request_url

                                              | length(request_url) |
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------+
| /en/groups/getting-started-with-scilab/content/session-5-ranges-sub-matrix-extraction-and-replacement/'&source=mobileproducts'&ved=0CBEQFjAEOLYC'&usg=AFQjCNEaHFOXL6Yt6N4lAWjXGu65Hy3rqw'
|                 185 |
| /en/groups/introduction-to-the-field-of-computer-supported-co/content/wk-7-cases-knowledge-forum-wise-math-forum-compendium-embedded-phenomena-immersive-enviros/comment/2350/
           |                 174 |
| /en/groups/introduction-to-the-field-of-computer-supported-co/content/wk-7-cases-knowledge-forum-wise-math-forum-compendium-embedded-phenomena-immersive-enviros/comment/2374/
           |                 174 |
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------+

and wouldn't the referrer url have the same problem?

However this error seams to be specific to migrations because the last
tie I tried 'python manage.py syncdb --all --noinput' worked. Paul
does that last command works for you or do you get the same error
while creating the db without using the migrations.

-- 
Thanks,
    Zuzel

On Wed, Sep 21, 2011 at 12:16 PM, Jessica Ledbetter
<jessica at jessicaledbetter.com> wrote:
> 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#L21
> to 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
>
>
> _______________________________________________
> p2pu-dev mailing list
> p2pu-dev at lists.p2pu.org
> http://lists.p2pu.org/mailman/listinfo/p2pu-dev
>
>


More information about the p2pu-dev mailing list