user warning: Unknown column 'Array' in 'where clause' query...
gregsumi - April 25, 2008 - 00:40
| Project: | Taxonomy Timer |
| Version: | 5.x-1.7 |
| Component: | Code |
| Category: | bug report |
| Priority: | critical |
| Assigned: | Unassigned |
| Status: | active |
Description
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.
#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?