Veiws not created but stuck in webforms-mysql views [#1990400]

Hi There my view were never created. I am guessing because me table name are too long but now I can not get rid of them in the module menu. When I unchecked the boxes and submit I get errors like:

DOException: SQLSTATE[42000]: Syntax error or access violation: 1103 Incorrect table name 'webform_views_clone_of_roots_of__empathy_instructor_application_mb_57': DROP VIEW {webform_views_clone_of_roots_of__empathy_instructor_application_mb_57}; Array ( ) in webform_mysql_views_admin_form_submit() (line 267 of /var/www/vhosts/roe-vti.org/resource/sites/all/modules/webform_mysql_views/webform_mysql_views.module).

I checked the database and the tables are not there. I have uninstalled and deleted the module and reinstalled and they are still there...

How do i get them to go away????

Drupal 7.22

Thanks in advance

Comments

Comment #1

loopy1492 commented 16 May 2013 at 13:37

Category:

support

» bug

I'm getting the same thing.

There was a huge error when I tried to generate the view which included the entire insert statement. The problem is, now the module won't let me create any new views and the view it tried to create for the above form seems like it exists for the Webform View module, but not the Views module. When I go into the Views list, it's not there.

messagePDOException: SQLSTATE[42000]: Syntax error or access violation: 1103 Incorrect table name 'webform_views_eo_38_application_for_waiver_from_executive_compensation_and_administrative_expenses_l': DROP VIEW {webform_views_eo_38_application_for_waiver_from_executive_compensation_and_administrative_expenses_limitations_9}; Array ( ) in webform_mysql_views_admin_form_submit() (line 268 of ............../sites/all/modules/webform_mysql_views

I have no real access to the database, unfortunately, so this is going to be a real problem.