I Have a simular problem that I was actually just about to post.
When attempting to add a new clock in rdlogmanager, I get sql-errors
that says that the <clockname>_RULES table doesn't exist.
In the database, <clockname>_RULES doesn't exist but
<clockname>_CLK_RULES does exist. After I delete the clock, the
<clockname>_CLK_RULES is still there. So it creates
<clockname>_CLK_RULES but looks for <clockname>_RULES I guess?
Her are the errors that I'm getting:
invalid SQL or failed DB connection[Table 'Rivendell.DA1_RULES'
doesn't exist QMYSQL3: Unable to execute query]: select
MAX_ROW,MIN_WAIT,NOT_AFTER,OR_AFTER,OR_AFTER_II from DA1_RULES where
CODE="00s"
invalid SQL or failed DB connection[Table 'Rivendell.DA1_RULES'
doesn't exist QMYSQL3: Unable to execute query]: select
MAX_ROW,MIN_WAIT,NOT_AFTER,OR_AFTER,OR_AFTER_II from DA1_RULES where
CODE=""
invalid SQL or failed DB connection[Table 'Rivendell.DA1_RULES'
doesn't exist QMYSQL3: Unable to execute query]: select
MAX_ROW,MIN_WAIT,NOT_AFTER,OR_AFTER,OR_AFTER_II from DA1_RULES where
CODE=""
invalid SQL or failed DB connection[Table 'Rivendell.DA1_RULES'
doesn't exist QMYSQL3: Unable to execute query]: select
MAX_ROW,MIN_WAIT,NOT_AFTER,OR_AFTER,OR_AFTER_II from DA1_RULES where
CODE=""
invalid SQL or failed DB connection[Table 'Rivendell.DA1_RULES'
doesn't exist QMYSQL3: Unable to execute query]: select
MAX_ROW,MIN_WAIT,NOT_AFTER,OR_AFTER,OR_AFTER_II from DA1_RULES where
CODE=""
invalid SQL or failed DB connection[Table 'Rivendell.DA1_RULES'
doesn't exist QMYSQL3: Unable to execute query]: select
MAX_ROW,MIN_WAIT,NOT_AFTER,OR_AFTER,OR_AFTER_II from DA1_RULES where
CODE=""
invalid SQL or failed DB connection[Table 'Rivendell.DA1_RULES'
doesn't exist QMYSQL3: Unable to execute query]: select
MAX_ROW,MIN_WAIT,NOT_AFTER,OR_AFTER,OR_AFTER_II from DA1_RULES where
CODE=""
invalid SQL or failed DB connection[Table 'Rivendell.DA1_RULES'
doesn't exist QMYSQL3: Unable to execute query]: select
MAX_ROW,MIN_WAIT,NOT_AFTER,OR_AFTER,OR_AFTER_II from DA1_RULES where
CODE=""
invalid SQL or failed DB connection[Table 'Rivendell.DA1_RULES'
doesn't exist QMYSQL3: Unable to execute query]: select
MAX_ROW,MIN_WAIT,NOT_AFTER,OR_AFTER,OR_AFTER_II from DA1_RULES where
CODE=""
invalid SQL or failed DB connection[Table 'Rivendell.DA1_RULES'
doesn't exist QMYSQL3: Unable to execute query]: select
MAX_ROW,MIN_WAIT,NOT_AFTER,OR_AFTER,OR_AFTER_II from DA1_RULES where
CODE=""
invalid SQL or failed DB connection[Table 'Rivendell.DA1_RULES'
doesn't exist QMYSQL3: Unable to execute query]: select
MAX_ROW,MIN_WAIT,NOT_AFTER,OR_AFTER,OR_AFTER_II from DA1_RULES where
CODE=""
I'm running v2.18.1 compiled from source on Debian 9.
Marius
On 12/28/2017 03:59 AM, Robert Jeffares wrote:
Appliance Install 2.0.18.1
we have a service up and running which is not having any problems.
We want to install a second service.
Populating a clock with events works as expected
BUT
when I create a log Only the first event in the hour [time sync] and
the first music event get scheduled.
I can put other non music events in at the top of the list and they
work but nothing works AFTER the first music event which selects from
a GROUP which exists and is populated with audio that works.
/var/log/messages
Dec 28 14:35:33 rdhost rdlogmanager: invalid SQL or failed DB
connection[Table 'Rivendell.Hindiwi_NewsFirst_RULES' doesn't exist
QMYSQL3: Unable to execute query]: select
CODE,MAX_ROW,MIN_WAIT,NOT_AFTER, OR_AFTER,OR_AFTER_II from
Hindiwi_NewsFirst_RULES
rddbcheck
Table Hindiwi_NewsFirst_CLK_RULES is orphaned -- delete (y/N)?
Ferreting around in mysql the table is there but nothing in it.
Tables created prior to updating to 2.17 & 2.18.1 do have content.
At this point I am looking into the great abyss!
any suggestions
regards
Robert Jeffares
Auckland New Zealand
_______________________________________________
Rivendell-dev mailing list
Rivendell-dev@lists.rivendellaudio.org
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
_______________________________________________
Rivendell-dev mailing list
Rivendell-dev@lists.rivendellaudio.org
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
