Community Forums

1. 

   dmferrari
   Member
   Posted 14 years ago

   After trying to make work MediaCore without success (see here http://getmediacore.com/community/topic/thumbnail-problem), we decided to install the latest version from git. Everything goes well until we get an error with the mediacore.categories table not found.

   This is what apache error log says:

   [Mon Apr 05 19:17:49 2010] [error] [client 200.117.xxx.xxx] Error - <class 'sqlalchemy.exc.ProgrammingError'>: (ProgrammingError) (1146, "Table 'mediacore.categories' doesn't exist") u'SELECT categories.id AS categories_id, categories.name AS categories_name, categories.slug AS categories_slug, categories.parent_id AS categories_parent_id, (SELECT coalesce(count(*), 0) AS coalesce_1 \\nFROM media, media_categories \\nWHERE media.id = media_categories.media_id AND categories.id = media_categories.category_id AND media.publishable AND media.publish_on <= %s AND (media.publish_until IS NULL OR media.publish_until >= %s)) AS media_count_published \\nFROM categories \\nHAVING media_count_published >= 1 ORDER BY categories.name' [datetime.datetime(2010, 4, 5, 19, 17, 47, 647184), datetime.datetime(2010, 4, 5, 19, 17, 47, 647184)]

   I've been looking in the previous database and inside setup.sql, but I cannot find a table with this name.

   Can you help me please?

   --
   Martin
2. 

   Nathan Wright
   Maintainer
   Posted 14 years ago

   The setup.sql file is a little behind our latest changes to the database. I'll be getting it all up to date this week, along with a number of other major improvements.

   If you don't want to wait, open ./database/changes/ — in there you'll find a bunch of dated .sql files that we've created during development — and import all the scripts dated 2010-02-09 and on. This can be done in the same way as the initial setup.sql script:
   

   # Import initial data into an existing database named mediacore:
   mysql -u mediacore_user -p mediacore < setup.sql

   Cheers, Nathan
3. 

   dmferrari
   Member
   Posted 14 years ago

   Nathan,
   Thanks for the reply.
   We have found a workaround for this.
   Now we have another problem:
   Error - <class 'sqlalchemy.exc.OperationalError'>: (OperationalError) (1054, "Unknown column 'categories' in 'field list'") u'INSERT INTO media_categories (media_id, category_id) VALUES (%s, %s)' [36L, 1L]

   Now, I am stuck with this.

   --
   Martin
4. 

   Nathan Wright
   Maintainer
   Posted 14 years ago

   What was your workaround exactly? Is that an SQL script you're trying to run or are you trying to load a page?
5. 

   dmferrari
   Member
   Posted 14 years ago

   Nathan,
   This was solved using your's sql scripts.
   This problems happens when we try to save a media selecting a category. If not category is selected, everything works fine.

   --
   Martin
6. 

   dmferrari
   Member
   Posted 14 years ago

   That error message is from Apache´s error log.
   Mediacore says: Error 500.
7. 

   dmferrari
   Member
   Posted 14 years ago

   Still I can not solve this:

   Error - <class 'sqlalchemy.exc.OperationalError'>: (OperationalError) (1054, "Unknown column 'categories' in 'field list'") u'INSERT INTO media_categories (media_id, category_id) VALUES (%s, %s)' [36L, 1L]
8. 

   Nathan Wright
   Maintainer
   Posted 14 years ago

   Ah, can you check that the media_fulltext table has a categories column? I'm guessing that table still needs to be updated. If that is the problem, this query will update it.
   

   ALTER TABLE media_fulltext
   CHANGE COLUMN topics categories TEXT
   CHARACTER SET utf8 COLLATE utf8_general_ci
   DEFAULT NULL;

   This error message was confusing me because obviously there's no categories column in media_categories, it's just a join table with a media_id and a category_id. The error is occurring when the trigger tries to update the row in media_fulltext to append the new category to the categories column.

   Hope that helps! Cheers, Nathan
9. 

   dmferrari
   Member
   Posted 14 years ago

   Nathan,
   It works!!! Very much thanks!

   --
   Martin
10. 

    dmferrari
    Member
    Posted 14 years ago

    Nathan,
    This was solved, but the ´Topics Index´ button does not appear? Do you think that it is related?
    Thanks for your help!

    --
    Martin
11. 

    Jeremy
    Community Manager
    Posted 14 years ago

    Martin,

    Nate may have a quick fix for this, but we've stopped including the topic index in the general release as it has a couple of UI issues. With the upcoming 0.8 release we'll be introducing n-tiered categories in a major way, and the old topic index will be no more.
12. 

    dmferrari
    Member
    Posted 14 years ago

    Nathan, Stuart,
    I'll really apreciate the topic index button fix.
    Thanks!
13. 

    dmferrari
    Member
    Posted 13 years ago

    Nathan, Stuart,
    Nothing about the topic index button?
    Thanks!
14. 

    Nathan Wright
    Maintainer
    Posted 13 years ago

    Have you tried the latest release yet? We've completely revamped the frontend UI: there's no topic index button anymore. Instead we have a much more useful Categories tab.

RSS feed for this topic

Reply

You must log in to post.