hi all,
Same experiment as Tim here when I try to restore DB version 245
DB connection re-established
invalid SQL or failed DB connection[Incorrect date value: '0000-00-00'
for column 'YEAR' at row 1 QMYSQL: Unable to execute query]: alter table
`CART` add column `USE_WEIGHTING` enum('N','Y') default 'Y' after
`ENFORCE_LENGTH`
rddbmgr: sql error: Incorrect date value: '0000-00-00' for column 'YEAR'
at row 1 QMYSQL: Unable to execute query query: alter table `CART` add
column `USE_WEIGHTING` enum('N','Y') default 'Y' after `ENFORCE_LENGTH`
not the same version, not the same message
Ubuntu studio
Regards
JM
Le 04/08/2021 à 23:15, Tim Camp a écrit :
Greetings,
I am having dayshavoo
In the process of testing out Ver 4 Beta 2 and want to test it in the
same environment as
my production systems (with a dedicated mysql server and audio store)
So I'm setting up a client only machine using ubuntu studio.
I am at
sudo rddbmgr -- modify
which returns
DB connection re-established
invalid SQL or failed DB connection[Unknown column 'UDP_ADDR' in
'field list' QMYSQL: Unable to execute query]: insert into
`LOG_MACHINES` set
`STATION_NAME`='genews',`MACHINE`=0,`START_MODE`=0,`AUTO_RESTART`='N',`LOG_NAME`='',`CURRENT_LOG`='Homefest',`RUNNING`='N',`LOG_ID`=-1,`LOG_LINE`=1,`NOW_CART`=0,`NEXT_CART`=0,`UDP_ADDR`='0.0.0.0',`UDP_PORT`=5401,`UDP_STRING`='',`LOG_RML`=''
rddbmgr: sql error: Unknown column 'UDP_ADDR' in 'field list' QMYSQL:
Unable to execute query query: insert into `LOG_MACHINES` set
`STATION_NAME`='genews',`MACHINE`=0,`START_MODE`=0,`AUTO_RESTART`='N',`LOG_NAME`='',`CURRENT_LOG`='Homefest',`RUNNING`='N',`LOG_ID`=-1,`LOG_LINE`=1,`NOW_CART`=0,`NEXT_CART`=0,`UDP_ADDR`='0.0.0.0',`UDP_PORT`=5401,`UDP_STRING`='',`LOG_RML`=''
So I have been here before and cannot convert my existing database
(schema 272)
After this crash
sudo rddbmgr
returns 277 as the schema
I have tried numerous things that I have found searching on line and
notes I had from previous schema troubles and I'm stuck.
I have good backups so i can reload and get back to where we started.
Tim Camp
WZEW-FM
Mobile, Al.
_______________________________________________
Rivendell-dev mailing list
[email protected]
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
_______________________________________________
Rivendell-dev mailing list
[email protected]
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
