Way long story, too many agonizing details to relate. Trying to repair a site (charlotterc.com) that was at an older 6.x version after my lovely hosing provider went belly up. Following published guidelines, I updated my 6.x to the latest 6.37, and tried to also update webform, but ran into many issues most likey due to being stuck at PHP4 on that machine. No option to go backwards now. Given that this site only had a single form I decided to just nuke it move to latest 7.x series. After migrating my site to a more modern hosting solution, and updating to 7.39 and the latest corresponding webform, I of course ran into database incompatibilities. So I though I could just 1) disable webforms, 2) drop all references to it in my database (drop all webform_* tables which, don't forget were the original 6.x entries) and reinstall, and that the webform module would reinitialize my database. However, that didn't seem to work. I still end up with errors indicating that the required database entries are not present (PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table '.webform' doesn't exist:) when running update.php after webform module install.

Is there a procedure I could follow to basically "reset" webforms and have it reinitialize the database?

Thanks.

Comments

challinan created an issue. See original summary.

DanChadwick’s picture

DanChadwick CreditAttribution: DanChadwick as a volunteer commented
Status: Active » Fixed

Unfortunately, there is more to manually uninstalling a module than deleting its tables. If you don't have a backup, then your only option will be to press on.

  1. Find the webform entry in the system table. This contains a record of the last updated schema. Delete that row from the table.
  2. Then find all variables in the variables table that start with webform and delete them.
  3. Assuming your site still runs, delete the webform content type using the UI.
  4. Flush all your caches.
  5. Install the latest version of webform, currently 7.x-4.10.
  6. Enable webform and then deal with whatever issues you may have.
challinan’s picture

challinan CreditAttribution: challinan commented

Thanks a million, Dan. That very scary procedure for somebody who doesn't go much deeper than mysqldump worked!!! A couple forms to rebuild and we're on our way.

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.