PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'drupal7.taxonomy_vocabulary_node_type' doesn't exist: SELECT v.name, v.vid FROM {taxonomy_vocabulary} v LEFT JOIN {taxonomy_vocabulary_node_type} t ON t.vid=v.vid WHERE t.type=':type'; Array ( [0] => article ) in indexpage_page_index() (line 223 of C:\www\webapps\drupal7\sites\all\modules\indexpage\indexpage.module).
I just did a fresh CVS update and rebuilt my site.
Comments
Comment #1
nancydruTaxonomy.install does not include a schema definition for "taxonomy_vocabulary_node_type."
Comment #2
bojanz commentedAs far as I know, taxonomy_vocabulary_node_type was removed during the move to Field API (I'm looking at this)
Comment #3
nancydruSo how in the heck do you find which vocabularies are used by a specified content type? Several contribs are going to have to know how to do this.
Comment #4
aaronbaumanVocabularies are now handled as fields.
Content types are associated with vocabularies via Fields API.
Comment #5
nancydruThanks for the response, but it doesn't answer the question. For example, in D6, one can write
taxonomy_get_vocabularies('story')to find all the vocabularies that are used by the "story" content type. How does one do that in D7?Comment #6
aaronbaumanCheck field_info_fields():
Comment #7
nancydruThanks, I will give it a try.
Comment #8
berdirI guess it would make sense to add the above code snippet to http://drupal.org/node/224333#taxonomy_node?
Comment #9
nancydruIt is "allowed_values". In case someone else who needs it, here is what I changed it to that gives basically the same result as the D6
taxonomy_get_vocabularies('article')Comment #10
aaronbaumanI added the snippet from #6 to http://drupal.org/node/224333#taxonomy_node
Please feel free to update!
Comment #11
nancydruI corrected the allowed_values typo.
Comment #13
inti2010 commentedJust installed v7 on my local machine using Wamp v2.1
PHP 5.3.5
MySQL 5.5.8
There is no table?
Is there a patch? Let me rephrase.
Where do I put this patch?
PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '* taxonomy_vocabulary' at line 1: SELECT name, machine_name, vid FROM * {taxonomy_vocabulary}; Array ( ) in taxonomy_vocabulary_get_names() (line 791 of C:\wamp21\www\drupal7\modules\taxonomy\taxonomy.module).
Comment #14
inti2010 commentedJust installed v7 on my local machine using Wamp v2.1
PHP 5.3.5
MySQL 5.5.8
There is no table?
Is there a patch? Let me rephrase.
Where do I put this patch?
Comment #15
bojanz commentedThere is no patch and there isn't anything to put anywhere. Things just work differently now, see #9.
It looks like you're having a different problem, so open a new issue.
Comment #16
inti2010 commentedThanks!
I just did a total re-install (this just took 4 hours) but I now have Taxonomy on localhost!
And I swear I did nothing different except install the minimal version then add stuff.
Drupal will try the patients of a saint.
Comment #17
cyberranger commentedDo we make the change in #9 to indexpage.module around line 225? I've tried
that but now I'm getting -