Missing Table: Bayesian filter
rkdesantos - June 22, 2008 - 02:45
| Project: | Spam |
| Version: | 5.x-3.0-alpha6 |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Jeremy |
| Status: | closed |
Jump to:
Description
Hi,
Just installed the new release and I get this php error in my logs:
Table 'afana_drupal5.bayesian_tokens' doesn't exist query: SELECT probability FROM bayesian_tokens WHERE class = 'spam' AND token = 'vxxxxxx@yahoxxxxx.com' in /home/afana/public_html/drupal5/includes/database.mysql.inc on line 172.
What's missing is a table that didn't get created on install, I assume.
#1
Same error here with 5.x-3.0-alpha5. Watchdog keeps filling up with this error.
#2
I also receive this error.
#3
Looks like I never checked in bayesian.install, resulting in this error. Committed.
#4
Automatically closed -- issue fixed for two weeks with no activity.
#5
I don't see why you closed this issue. I get the same exact error still with the latest alpha6 version, and yes bayesian.install is there.
#6
Also getting similar error:
Table 'millenni_drupal.bayesian_tokens' doesn't exist query: SELECT probability, yes_count, no_count FROM bayesian_tokens WHERE class = 'spam' AND token = 'did' in ...............
Looked in DB but it'a not there. Error produced when anonymous users enter comment.
Please advise how to proceed. Thanks.
#7
I'm getting the same exact error i 5.x-3.0-alpha6
What should the table/bayesian schema look like? I could always insert it manually in MYSQL as a fix for now.
#8
Re-opening for re-review.
#9
Confirmed with clean install, the bayesian_tokens module does get installed fine. If you're still having the problem, I suggest you run the following command directly in your MySQL database and then re-install the bayesian module:
DELETE FROM system WHERE name = 'bayesian';You will need to do this if you already installed the Bayesian module with an earlier alpha release, before the bayesian.install file was checked in. You will know you need to do this if you are getting the errors reported above.
#10
Did the " DELETE FROM system WHERE name = 'bayesian';" after uninstalling all Spam module bits, and then re-installed the spam module. It cleared up the table doesn't exist problem.
Now I get this warning every time a comment is posted instead;
"warning: Division by zero in /drup/sites/default/modules/spam/spam.module on line 181."
#11
Note for posterity, the division by zero issue was resolved here.
#12
Automatically closed -- issue fixed for two weeks with no activity.