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
Comment #1
Monzer Emam commentedAlso same changes to "content_levels.module" line 437
"{$table}" should change to "{{$table}}".
Comment #2
jamsilver commentedYes, silly mistake really. I have made the changes and made a new minor release - 1.1. This should have fixed the issue.
Comment #3
jamsilver commentedHelp people find this page