Opened 14 years ago

Closed 14 years ago

#2444 closed defect (fixed)

Can't use revamp with multiple frontends

Reported by: Mickey Chandler <micklc@…> Owned by: ldunning
Priority: minor Milestone: unknown
Component: mythweather Version: 0.20
Severity: medium Keywords:
Cc: Ticket locked: no

Description

You can't set up MythWeather? on multiple frontends.

I think what is happening here is that the insert statement is deleting "old" information from the weatherscreens table.

Currently, that table looks like this:

mysql> select * from weatherscreens; +-----------+-----------+-----------------------+------------------------+-------+ | screen_id | draworder | container | hostname | units | +-----------+-----------+-----------------------+------------------------+-------+ | 58 | 0 | Severe Weather Alerts | gopher.whizardries.com | 1 | | 59 | 1 | Animated Map | gopher.whizardries.com | 1 | | 60 | 2 | 18 Hour Forecast | gopher.whizardries.com | 1 | | 61 | 3 | Three Day Forecast | gopher.whizardries.com | 1 | | 62 | 4 | Six Day Forecast | gopher.whizardries.com | 1 | +-----------+-----------+-----------------------+------------------------+-------+ 5 rows in set (0.00 sec)

Screen_id is incrementing, but there should be an identical set here for my other host. So, I'm thinking that it's deleting everything that was in the table and adding in the new defintion.

The result of this, of course, is that moving between frontends is causing me to have to define my screens multiple times.

Attachments (1)

weatherSetup.diff (573 bytes) - added by ldunning 14 years ago.

Download all attachments as: .zip

Change History (5)

comment:1 Changed 14 years ago by ldunning

Status: newassigned

Changed 14 years ago by ldunning

Attachment: weatherSetup.diff added

comment:2 Changed 14 years ago by ldunning

I don't have a setup that I can easily verify this on, but its looks to be a simple fix. If your willing to give the attached patch a try that'd be appreciated. Thanks.

comment:3 Changed 14 years ago by Mickey Chandler <micklc@…>

That appears to have worked. The 2nd frontend is set up and I wasn't prompted to setup the 1st frontend again after doing that.

Thanks for the patch and all of you hard work on this plugin!

comment:4 Changed 14 years ago by ldunning

Resolution: fixed
Status: assignedclosed

(In [11280]) Was accidentally blowing out entire table, instead of rows associated with particular host.

Closes #2444

Note: See TracTickets for help on using tickets.