Posted by gregsumi on April 25, 2008 at 12:40am
| Project: | Taxonomy Timer |
| Version: | 5.x-1.7 |
| Component: | Code |
| Category: | bug report |
| Priority: | critical |
| Assigned: | Unassigned |
| Status: | active |
Issue Summary
Neat idea. I'm having problems though. After installing and setting up the timer defaults, I get the following user warnings. I'm novice, so any advice would be helpful.
On node update, change to "Schedule Immediate":
user warning: Unknown column 'Array' in 'where clause' query: SELECT * FROM mywab5_hstaxonomy_timer_defaults WHERE tid = Array in /Sites/beta.wab.edu/drupal/includes/database.mysqli.inc on line 151.
On Cron job:
user warning: Unknown column 'notified' in 'where clause' query: SELECT * FROM mywab5_hstaxonomy_timer_nodes WHERE tt_expiration <= 1209256299 AND tt_expiration >= 1209083499 AND completed = 0 AND notified=0 in /Sites/beta.wab.edu/drupal/includes/database.mysqli.inc on line 151.
Comments
#1
+1
Same problem
Ben
#2
I put it in critical priority because the module is not usable.
B.
#3
Hi,
This is the solution.
Goto, http://example.com/admin/build/modules
In that click update.php which will lead you to this page http://example.com/update.php
Click run the database upgrade script. In select version, for taxonomy_timer select 2.It will run update script.
Go back to administartor page.
You are done! I am using 5.x1.8
Thanks,
Nehal Mehta.
#4
Good start, you're right, I don't have errors anymore exepte in the following situation :
In fact, I use content taxonomy in order to assign a term to a node.
In a fresh drupal installation, I create a category (ex:"question"), I add to terms (ex : "yes" and "no") than I modify the node content type by adding the category "question" as a cck taxonomy field. I create a node and I assign the term "no". When I edit this node, I change term "no" to "yes", I submit, I have this error : see picture "error1". Content taxonomy can assign a term, but there is no data entry in the table "taxonomy_timer_nodes ". (this can be reproduced even with no term changing: just edit and than submit)
If I do the same node but without using cck field, but the regular method to assign a term. It's ok.
In a more complex website, a node composed with lot of CCK fields ( 4 of theme are ckk taxonomy field), when I edit and than submit, I have 4 message errors (see picture "error2".
Its seems that taxonomy timer module cannot "understand" term data provided by the cck content taxonomy field.
Any idea ?
Thanks for your help
Benjamin
#5
I have the same problem. I would love to have this module work, as it is EXACTLY what I need for my client. Does anyone maintain this module? Is it dead? Has it ever worked?
#6
I maintain it, sporadically. :)
It may not work with CCK taxonomy (though I'm not sure why).
Seems that the CCK taxonomy must hook_form_alter the taxonomy form object for selecting terms.
One solution would be to edit the weight of this module so that it runs before CCK.
Not sure if that's the right thing to do or not though. I've never tried it with CCK taxonomy .