Table 'mythconverg.weatherdatalayout' doesn't exist

[fayoeu@…]

Upgrading from 0.21 to 0.22 trunk and I received the following error while running mythfrontend:

2009-10-19 22:42:29.538 Upgrading to MythWeather schema version 1002
2009-10-19 22:42:29.539 DB Error (Performing database upgrade):
Query was: ALTER TABLE weatherdatalayout  MODIFY location varbinary(64) NOT NULL,  MODIFY dataitem varbinary(64) NOT NULL;
Error was: Driver error was [2/1146]:
QMYSQL3: Unable to execute statement
Database error was:
Table 'mythconverg.weatherdatalayout' doesn't exist

new version: 1002

[fayoeu@…]

Frontend log.

[sphery]

The MythWeather? tables use InnoDB storage engine. Do you have InnoDB disabled on your MySQL server? You can find out with:

mysql -umythtv -p mythconverg -e 'SHOW ENGINES\G'

[fayoeu@…]

*************************** 5. row ***************************
      Engine: InnoDB
     Support: YES
     Comment: Supports transactions, row-level locking, and foreign keys
Transactions: YES
          XA: YES
  Savepoints: YES

[fayoeu@…]

Output of show engines.

[sphery]

The reporter had dropped tables to work around an issue on a previous install, as explained at ​http://mythtv.org/pipermail/mythtv-dev/2009-October/066451.html.