FWIW, here's the output of that command on my Debian 9 machine (running
Rivendell 2.17.0):
+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+
| Engine | Support | Comment
| Transactions | XA | Savepoints |
+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+
| MRG_MYISAM | YES | Collection of identical MyISAM tables
| NO | NO | NO |
| CSV | YES | CSV storage engine
| NO | NO | NO |
| MyISAM | YES | MyISAM storage engine
| NO | NO | NO |
| BLACKHOLE | YES | /dev/null storage engine (anything you
write to it disappears) | NO | NO | NO |
| MEMORY | YES | Hash based, stored in memory, useful for
temporary tables | NO | NO | NO |
| FEDERATED | NO | Federated MySQL storage engine
| NULL | NULL | NULL |
| ARCHIVE | YES | Archive storage engine
| NO | NO | NO |
| InnoDB | DEFAULT | Supports transactions, row-level locking,
and foreign keys | YES | YES | YES |
| PERFORMANCE_SCHEMA | YES | Performance Schema
| NO | NO | NO |
+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+
9 rows in set (0.00 sec)
I have 2.17.0 running successfully on this machine. I believe Marius's
problem is peculiar to 2.18.0.
Rob
--
Слышу голос из прекрасного далёка,
Он зовёт меня в чудесные края,
Слышу голос, голос спрашивает строго -
А сегодня что для завтра сделал я.
On Thu, 21 Dec 2017, Marius Wikstøl wrote:
It uses InndoDB by default, but I've tried setting the default engine to
MyISAM and restarting, with the same results.
Marius
On 12/21/2017 07:50 PM, Fred Gleason wrote:
On Dec 21, 2017, at 13:44, Marius Wikstøl
<[email protected]> wrote:
This is the error:
invalid SQL or failed DB connection[You have an error in
your SQL syntax; check the manual that corresponds to your
MariaDB server version for the right syntax to use near
'/dev/cdrom,PARANOIA_LEVEL int default 0,RIPPER_LEVEL int
default -1300,CDDB_SERV' at line 1 QMYSQL3: Unable to
execute query]: create table if not exists RDLIBRARY (ID
int
Thanks.
Please post the output of this shell command:
echo show\ engines\; | mysql -u root -p
(you’ll need to enter the root p/w for MySQL).
Cheers!
|----------------------------------------------------------------------|
| Frederick F. Gleason, Jr. | Chief Developer
|
| | Paravel Systems
|
|----------------------------------------------------------------------|
| A room without books is like a body without a soul.
|
| -- Cicero
|
|----------------------------------------------------------------------|
_______________________________________________
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
