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.

Comments

brunodbo’s picture

Version: 5.x-3.x-dev » 5.x-3.0-alpha5

Same error here with 5.x-3.0-alpha5. Watchdog keeps filling up with this error.

philbar’s picture

I also receive this error.

jeremy’s picture

Assigned: Unassigned » jeremy
Status: Active » Fixed

Looks like I never checked in bayesian.install, resulting in this error. Committed.

Anonymous’s picture

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.

aerodog’s picture

Title: Missing Table: Bayesion filter » Missing Table: Bayesian filter
Version: 5.x-3.0-alpha5 » 5.x-3.0-alpha6

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.

Thomasr976’s picture

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.

Rhino’s picture

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.

jeremy’s picture

Status: Closed (fixed) » Active

Re-opening for re-review.

jeremy’s picture

Status: Active » Fixed

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.

Rhino’s picture

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."

jeremy’s picture

Note for posterity, the division by zero issue was resolved here.

Anonymous’s picture

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.