Dear Sirs,
after updating to version 1.4 block crashes with error message

Error message
PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'htd.vocabulary' doesn't exist: SELECT vid, name from {vocabulary} order by name; Array ( ) in taxonomy_block_admin_settings() (line 24 of /var/www/sites/all/modules/taxonomy_block/taxonomy_block.settings.inc).
The website encountered an unexpected error. Please try again later.

please advice

Support from Acquia helps fund testing for Drupal Acquia logo

Comments

InternetDevels’s picture

Status: Active » Needs review
FileSize
701 bytes

Here is a patch which fixes the issue above.

npetronikolos’s picture

Thank you but when apply patch i receive the foll error

../Downloads/taxonomy.patch
warning: taxonomy_block.settings.inc has type 100755, expected 100644

the taxonomy block did not appear in blocks i had to install taxonomy block 1.3 to return everything back to normal.

please correct possible errors. taxonomy block is very nice and useful module

Thank you

GemVinny’s picture

I have installed this module and get this error as well. I can't apply the patch either.

Thanks
Gemma

InternetDevels’s picture

../Downloads/taxonomy.patch
warning: taxonomy_block.settings.inc has type 100755, expected 100644

To fix this error please look http://drupal.org/patch/apply#comment-6945422
or you can apply patch with new permissions

Also I've found that version 7.14 contains functions from D6 so other issues are possible.

inventlogic’s picture

Got this and unbelievable that this patch has not been committed as version 1.4 cannot be configured without it.

Also even after applying the patch the Taxonomy Block is nowhere to be found.

This module should be avoided until these issues get fixed by a serious developer.

jsibley’s picture

Are there plans to update the module? I am also not seeing a block after installing 1.4.

npetronikolos’s picture

i know that everything is done on spare time and i respect that . But really men if you do not want to continue to develop the module just close it on the main page. declare it as abandoned or something. Do not issue crappy updates.
Thank you.

irutz’s picture

Issue summary: View changes

Hi, I installed this module as well and got the same error. I fixed it by changing the following lines in the file taxonomy_block.settings.inc

-  $vocabs = db_query("SELECT vid, name from {vocabulary} order by name");
-  $vocab_array = array();
-  while ($term_parent = db_fetch_object($vocabs)) {
-    $vocab_array[$term_parent->vid] = $term_parent->name;
-  }
-
+  $vocab_array = db_query("SELECT vid, name FROM {taxonomy_vocabulary} ORDER BY name ASC")->fetchAllKeyed();
PMorris’s picture

I applied the patch to fix the error but where is the block that I can use to see the taxonomy?

There is nothing new in admin/structure/block and I don't see a way to add a block in /admin/settings/taxonomy_block

I tried clearing cache and nothing!

irutz’s picture

FileSize
5.08 KB

Hi, the patch i applied was just to fix the error what that issue is about. after applying the patch I've also realized that the block is still not visible. i hade a view on the code and realized that the code is more or less still the one from D6. I attached the file which should make it work for D7.

mitkompm’s picture

irutz, after patching from #8, Taxonomy block setting link/ and page/, getting to work. And after changing the code in taxonomy_block.module with that from taxonomy_block.module.txt, Taxonomy block appeared in Block setting page. But trying to activate this block broke the site /maybe template/.
Tested in Drupal 7.29 and Taxonomy block 7x-1.4 with applyed patches.

irutz’s picture

mitkompm, i tried it out with Drupal 7.29 and Taxonomy block 7x-1.4 and on my side it is working well. Can you try the DEV version 7.x-1.x-dev. That would be a similar version to the fixes i made here.

illmatix’s picture

Looks like the D6 version of the module was pushed to the D7 branch of the module on drupal.org. It would be nice if the 7.x branch actually was compatible with D7.

Is there any chance this 7.x branch can be pushed again by the maintainer?

thomscode’s picture

This is still an issue. Version 7.x-1.3 is the actual latest D7 release.

James Marks’s picture

According to the current maintainer, 7.x-1.3 will result in a WSOD. That said, I'm running 7.x-1.3 on a Drupal 7.59 site and not getting a WSOD. (YMMV)

7.x-1.4 contains two hooks from Drupal 6 — 'hook_perm()' and 'hook_block()' — and appears to either be a D6 version or an incomplete port to D7. It will not function properly on a D7 site and should not be used on one.

TLWatson’s picture

Still seeing this issue... is the maintainer inactive?