There is a content type named "book" and it hase on field name "ad_type".
So in each corn run the following error is generated.

Table 'sample.content_type_book' doesn't exist query: UPDATE content_type_book SET field_ad_type_value = 1 WHERE field_ad_type_degrade = 1 AND field_ad_type_degrade_on <= 1288519502 in /public_html/sites/all/modules/content_levels/content_levels.module on line 388.

Actually table name should be "drupal_content_type_book".

So to fix it : line 387 should be changed from

$sql = "UPDATE {$table} SET $column_value = %d WHERE $column_degrade = 1 AND $column_degrade_on <= %d";

to

$sql = "UPDATE {{$table}} SET $column_value = %d WHERE $column_degrade = 1 AND $column_degrade_on <= %d";

basicly change " {$table}" to "{{$table}}".

PS: Idon't think it needs me to submit a patch.

Comments

Monzer Emam’s picture

Also same changes to "content_levels.module" line 437

"{$table}" should change to "{{$table}}".

jamsilver’s picture

Status: Needs review » Fixed

Yes, silly mistake really. I have made the changes and made a new minor release - 1.1. This should have fixed the issue.

jamsilver’s picture

Title: Error "Table &#039;sample.content_type_book&#039; doesn&#039;t exist" in each corn run. » Error "Table &#039;sample.content_type_book&#039; doesn&#039;t exist" in each cron run.

Help people find this page

Status: Fixed » Closed (fixed)

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