Opened 10 years ago

Closed 10 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@… 10 years ago.
Frontend log.
show.engines.txt (1.3 KB) - added by fayoeu@… 10 years ago.
Output of show engines.

Download all attachments as: .zip

Change History (5)

Changed 10 years ago by fayoeu@…

Attachment: frontend.log added

Frontend log.

comment:1 Changed 10 years ago by sphery

Status: newinfoneeded_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 Changed 10 years ago by fayoeu@…

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

Changed 10 years ago by fayoeu@…

Attachment: show.engines.txt added

Output of show engines.

comment:3 Changed 10 years ago by sphery

Resolution: invalid
Status: infoneeded_newclosed

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.