Since 310 DB schema, I can't modify or even create a new complete database.
leon@rivendell:~$ sudo rddbmgr --create
DB connection re-established
invalid SQL or failed DB connection[Field 'STATION' doesn't have a
default value QMYSQL: Unable to execute query]: insert into
NEXUS_STATIONS set RD_SERVICE="Production"
rddbmgr: sql error: Field 'STATION' doesn't have a default value QMYSQL:
Unable to execute query query: insert into NEXUS_STATIONS set
RD_SERVICE="Production"
DB creation is halted on 309 DB schema
MariaDB [Rivendell]> select * from VERSION;
+-----+---------------------+----------------------+
| DB | LAST_MAINT_DATETIME | LAST_ISCI_XREFERENCE |
+-----+---------------------+----------------------+
| 309 | 1970-01-01 00:00:00 | 1970-01-01 00:00:00 |
+-----+---------------------+----------------------+
1 row in set (0.000 sec)
MariaDB [Rivendell]> desc NEXUS_STATIONS;
+---------------+---------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------+---------------+------+-----+---------+-------+
| STATION | varchar(255) | NO | | NULL | |
| CATEGORY | varchar(10) | NO | | NULL | |
| AUTO_MERGE | enum('N','Y') | YES | | N | |
| RD_SERVICE | varchar(10) | NO | | NULL | |
| RD_GROUP_NAME | varchar(10) | NO | | NULL | |
| RD_SCHED_CODE | varchar(11) | NO | | NULL | |
+---------------+---------------+------+-----+---------+-------+
6 rows in set (0.001 sec)
Nearly everything defaults to NULL and can't be NULL, but the values are
not specified in the INSERT query.
--
Léon.
_______________________________________________
Rivendell-dev mailing list
[email protected]
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
