user warning: Table 'vm.fb_social_preset' doesn't exist
query: SELECT * FROM fb_social_preset t__0 in .... /sites/all/modules/ctools/includes/export.inc on line 379.

Tried using .dev and final release of CTools. No help.

Comments

ferdi’s picture

Can you elaborate a bit? How did you install it ?

vidichannel’s picture

Sure, I was upgrading from 1.0 beta 9, which up until yesterday was stable for me. Then Facebook changed the HREF issue in their API to popup the yellow error message box. So I upgraded trying to fix the problem.

Deleted old module, added new one, ran database update, deleted cache.

This message pops up twice, right away when I activate module:

user warning: Table 'vm.fb_social_preset' doesn't exist
query: SELECT * FROM fb_social_preset t__0 in ......sites/all/modules/ctools/includes/export.inc on line 379.

Thereafter I get the error from my first post when trying to add a preset.

Tried XFBML, html5, remove and re-add app ID, adding base URL. All efforts seem futile because fb_social_preset table was not created.

Thank you for the great work on the module. It has really been valuable for keeping Drupal relevant.

ferdi’s picture

So the steps should be in this order
- Uninstall the version 1 modules
- Delete the existing fb_social module in your file system
- And replace with the new one
- Install the new fb_social module as usual

It looks like you missed the first step. Drupal thinks that the module is installed so it's not going to install the new one and fb_social_preset table never gets created.

thanks,!

vidichannel’s picture

Total uninstall. Total deletion and you are correct that it does not create the table.

In fact, no fb_social tables are created. There are none at all.

Trying to run it on a clean install next. Maybe it has something to do with Authcache or Boost?

vidichannel’s picture

Worked fine on clean install. Will work backward to find module preventing it from creating the database.

MPankau’s picture

I just ran into this same problem and resolved it by doing the following:

  1. Disable the fb_social module
  2. remove the fb_social module from your filesystem
  3. Run update.php
  4. Use the devel variable editor and delete all the fb_social_ variables
  5. Access the 'system' table via phpadmin or similar tool. Find the rows for the fb_social plugin and delete them.
  6. run update.php again
  7. Add the module to the filesystem again
  8. Enable the fb_social module
  9. run update.php

This will erase all your presets and settings, so either write them down first or figure out how to export them.

vidichannel’s picture

Wow. That was some real surgery you figured out there, but it finally fixed it for me. Great work MPankau.

peter.bod’s picture

Thanks for that MPankau!

raidcha’s picture

I had the same problem, but even if i did the Mpankau's recommandations, it didn't work.

The problem was the version of my Ctools module. I used the 1.6 version.
I upgrade it to 1.8 and it works !
Now i can access the presets menu

raidcha’s picture

Issue summary: View changes

removed my domain URL