I tried to create a view, but ran up against the long file name issue - namely the module has recorded the view but not created a table -

I am now not able to remove the views that the module attempted to create because they do not exist.

PDOException: SQLSTATE[42000]: Syntax error or access violation: 1103 Incorrect table name

I realise that this is an issue you have addressed with the dev version, but how do I recover from the issue now that I have it?

Somewhere I should be able to delete a data-entry that records that the view has been created - but where is it? I could recover if by manually deleting the entry from the database then the code wouldn't try to delete a non-existent data table.

I am stuck, not even able to uninstall the component and start again -

I have upgraded to the dev version but still have the problem.

Comments

joecorall’s picture

joecorall commented

Do you have access to your database? If so, try running the query:

DELETE FROM variable WHERE name = 'webform_mysql_views_views';

That will remove all the Webform MySQL View settings from your Drupal instance, and you should be able to create views.