Hello,

When I'm trying to enable facebook autopost types module I'm getting error on page.

In logs I see:

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'dbname.field_data_field_facebook_end_time' doesn't exist: SELECT COUNT(*) AS expression FROM (SELECT 1 AS expression FROM {field_data_field_facebook_end_time} field_data_field_facebook_end_time0 WHERE (field_data_field_facebook_end_time0.deleted = :db_condition_placeholder_0) LIMIT 1 OFFSET 0) subquery; Array ( [:db_condition_placeholder_0] => 0 ) în field_sql_storage_field_storage_query() (linia 585 din /siteroot/modules/field/modules/field_sql_storage/field_sql_storage.module).

How can I solve this problem?
Thank you!!!

Comments

Loter’s picture

Completely removed module, reinstalled, now the problem is with another database field. Looks like it's not a component problem. Trying to debug.

SocialNicheGuru’s picture

any update?
I was having problems and ran "drush rr --debug "and this showed in my logs:

WD php: PDOException: SQLSTATE[42S02]: Base table or view not found: 1146
Table 'testgallery2devs.cache_entity_facebook_publication' doesn't exist:
TRUNCATE {cache_entity_facebook_publication} ; Array
(
)
 in cache_clear_all() (line 165 of drupal7/includes/cache.inc).
[195.69 sec, 381.17 MB]

I have entitycache enabled
I enabled both fb_autopost_entity and fb_autopost_types at the same time.
I then disabled and uninstalled them.

I notice that in fb_autopost_entity.install both facebook_publication and facebook_publication_type are created in the database.

I enabled just fb_autopost_entity first.
The database table, facebook_publication, was created and cache_entity_facebook_publication was also.
The database table, facebook_publication_type, was also created but not its accompanying cache table.

Would adding something like this help? Is the cache table needed?

  // sng what happened to facebook_publication_type?
  // Support entity cache module.
  if (module_exists('entitycache')) {
    $return['facebook_publication_type']['field cache'] = FALSE;
    $return['facebook_publication_type']['entity cache'] = TRUE;
  }
tsmulugeta’s picture

Any update? I also have a problem with Facebook autopost types

e0ipso’s picture

Status: Active » Closed (outdated)

#2909088: Looking for sponsors to fix the breaks from Facebook's side

I'm sorry, but this module is no longer maintained. I don't have the time or energy to chase this since I don't have it running in any of my projects any longer.

I'm looking for co-maintainters and/or funding to do this.