Opened 16 years ago

Closed 16 years ago

#7373 closed defect (invalid)

Table 'mythconverg.weatherdatalayout' doesn't exist

Reported by: fayoeu@… Owned by: Isaac Richards
Priority: minor Milestone: unknown
Component: MythTV - General Version: unknown
Severity: medium Keywords:
Cc: Ticket locked: no

Description

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

Attachments (2)

frontend.log​ (7.9 KB ) - added by fayoeu@… 16 years ago.
Frontend log.
show.engines.txt​ (1.3 KB ) - added by fayoeu@… 16 years ago.
Output of show engines.

Download all attachments as: .zip

Change History (5)

by fayoeu@…, 16 years ago

Attachment: frontend.log​ added

Frontend log.

comment:1 by sphery, 16 years ago

Status: new → infoneeded_new

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'

comment:2 by fayoeu@…, 16 years ago 

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

by fayoeu@…, 16 years ago

Attachment: show.engines.txt​ added

Output of show engines.

comment:3 by sphery, 16 years ago

Resolution: → invalid
Status: infoneeded_new → closed

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.

Note: See TracTickets for help on using tickets.