Ii have a couple of webofrms that I used MySQL views to create new table to use in views, however these tables would not import to my live site. Now I can't uncheck the webform names at content/webform/mysql to rebuild the table, because the tables don't exist. Any help would be great!

Thanks
Sharon

Comments

bpopp’s picture

bpopp commented

I am having the same issue. Sharon, did you figure out how to resolve it?

SharonD214@aol.com’s picture

SharonD214@aol.com commented

Yes, I deleted the entry in the views_view table using phpmyadmin that was associated with the missing data table and then was able to uncheck and rebuild the table over again.

Sharon

bpopp’s picture

bpopp commented

Thanks Sharon! I don't use phpmyadmin but I was able to delete it in the variable editor that is part of the devel module: https://drupal.org/project/devel.

ThePixelMines’s picture

ThePixelMines commented

I'm having the same issue, but am not versed much on MySQL or PHP. I don't have access to phpmyadmin. Bpopp, can you tell me your process?

baram204’s picture

baram204 commented

This way you can update webform view with new webform items.

but your previous views removed. so export previous view's display setting.

Delete some variable

goto phpmyadmin, find your drupal's dbname. then delete table like 'webform view __number'.

Rebuild Webform Views schema.

1. Go to admin/structure/data

2. Drop table you want to rebuild
(It's O.K. real webform submission data will not be delete.)

3. Go to admin/content/webform/mysql

4. check WebFormname you want to make a view then, click the button below.

5. Go to admin_menu/flush-cache (flush cache... will make drupal notice new webform view we made previous steb)

6. Go to admin/structure/data/adopt then, apopt your new webformview's schema.

7. Go to admin/structure/data then, click edit.

5. Go to admin_menu/flush-cache (for view can access new webform data)

8. Almost done. make left join "sid to weform_submission.sid" and "uid to users.uid".

9. Then Go to your webform view... and make relasionship with sid.

10. Then Click add new field.

10. Finally, we could see new items added in the webform view section.