I love this module, and I'm glad you are working on it for 6. I've missed it!

I got this error, when going to the configuration page right after install. (My database is named: biolists_drpl4v2)

user warning: Table 'biolists_drpl4v2.taxonomy_dhtml' doesn't exist query: SELECT v.*, t.noi, t.expblock FROM vocabulary v LEFT JOIN taxonomy_dhtml t ON v.vid = t.vid ORDER BY v.weight, v.name in /home/biolists/public_html/sites/all/modules/taxonomy_dhtml/taxonomy_dhtml.module on line 130.

For some reason the install script didn't set the tables?

Comments

codeknitter’s picture

codeknitter commented

I set up the taxonomy_dhtml table by hand, and the module works beautifully!

THANKS!!!

So -- something stopped it from installing correctly, at least on my 5 sites. I wish I was a bit better at troubleshooting so I could save you some work.

Anonymous’s picture

Anonymous (not verified) commented
Assigned: Unassigned »

I'll have to do some testing / experimentation to figure out what caused it to fail.

Glad to hear that someone is using the D6 version at least. And since you are using it, please make sure to tell me if it is operating as expected or if I've missed features from the D5 version.

Thanks!

cpprof’s picture

cpprof commented

Check the permissions on the module files. I think you are just missing "execute."

robeano’s picture

robeano commented

I just installed the 6.x-1.0-rc1 version and it's working without error. This is a great module. Thanks!

Anonymous’s picture

Anonymous (not verified) commented
Status: Active » Closed (fixed)

I'm closing this for now as I've been unable to repeat the issue. If it happens again, please re-open the issue.

bwooster47’s picture

bwooster47 commented

How did you setup the table by hand?

I got this error too, going from 5.14 to 6.8

loko’s picture

loko commented

Hello
I have the same problem and the same question.
How did you setup the table by hand?

Melkor’s picture

Melkor commented
Version: 6.x-1.0-rc1 » 6.x-1.0-rc3
Category: support » bug
Status: Closed (fixed) » Active

Hello,

At first, thank you for great module and your work

I've got the same error on Drupal 6.0 (upgraded from 5.15)

Kind regards,
Melkor

Melkor’s picture

Melkor commented

The SQL code for the table is:

CREATE TABLE taxonomy_dhtml (
vid int(11) not null default 0,
noi int(11) not null default 0,
depth int(11) not null default 0,
expblock int(11) not null default 0
) ENGINE=MyISAM;

Hope this will help someone

Anonymous’s picture

Anonymous (not verified) commented

Please provide specific details, including:

Is this a clean install or an upgrade (I don't have any d5 sites so I am unable to test an upgrade path)?
Did you run update.php?

Again, I am unable to recreate this error.

bwooster47’s picture

bwooster47 commented

For me (comment #6) it was an upgrade. I ran update.php many times (when I installed other modules). I actually went from 4.7 to 5.14 in a matter of days, and then to 6.8. So at this time I can't recreate the bug too but it did happen!

Is there any way to use the "Select Versions" in the update path to force this table to be installed? That may be an ok workaround.

Melkor’s picture

Melkor commented

In my case it was the upgrade from 5.15 to 6.0. I saw these messages after running update.php and then on live pages.
I was unable to find a reason which causes drupal not to install this module properly.

Manual creation of the table fixes the issue.

Anonymous’s picture

Anonymous (not verified) commented

I haven't tested this but based on the comments provided and a quick inquiry, this is a confirmed bug. It will only happen on an upgrade from versions of Drupal prior to 6.

I'll be working on a fix but there is presently no ETA. To solve this problem, either create the table manually or uninstall / reinstall the module.

Melkor’s picture

Melkor commented

Thanks.

If you could provide me with brief technical information regarding the issue. I think I can fix it and upload a patch here.
I am pretty beginner with Drupal, so if you could guide me, it would be great

Anonymous’s picture

Anonymous (not verified) commented

I know what is required to fix it. It's a matter of fixing it without creating another bug in the process. I'll get it in soon, but it may be this weekend before I get a chance to.

Anonymous’s picture

Anonymous (not verified) commented
Status: Active » Closed (won't fix)

This module is no longer being actively developed as it duplicates functionality that can be obtained through the usage of taxonomy_menu ( http://drupal.org/project/taxonomy_menu ) and dhtml_menu ( http://drupal.org/project/dhtml_menu ).