When appletv or iOS mrmc creates the databases, it doesn’t seem to create the views.
I am using a qnap running MariaDB
Is there a sql script to drop/create the views?
Thanks.
1. No user installed addons are supported, python or otherwise.
2. No, they really are not supported.
3. They are not coming back
4. Read from 1. again
Any mention of illegal streaming sites, addons or any pirated material will not be tolerated. This is not democracy and any offenders will be banned and posts deleted immediately without warning.
Other than that, we hope you enjoy MrMC so far and we welcome any input and feedback you might have.
Team MrMC.
2. No, they really are not supported.
3. They are not coming back
4. Read from 1. again
Any mention of illegal streaming sites, addons or any pirated material will not be tolerated. This is not democracy and any offenders will be banned and posts deleted immediately without warning.
Other than that, we hope you enjoy MrMC so far and we welcome any input and feedback you might have.
Team MrMC.
MySQL databases not creating views [SOLVED]
- koying
- Team MrMC
- Posts: 443
- Joined: 20 Mar 2016, 17:49
Re: MySQL databases not creating views
Debuglog would be nice to know why they are not created in the first place.
Probably some mariadb tweaks to be applied.
Probably some mariadb tweaks to be applied.
-
- Posts: 4
- Joined: 12 Jul 2018, 12:55
Re: MySQL databases not creating views
Will recreate the dbs with logging enabled, and can provide the sql logs as well if helpful
Will be away for the weekend but will look at it afterwards.
Cheers
Will be away for the weekend but will look at it afterwards.
Cheers
-
- Posts: 4
- Joined: 12 Jul 2018, 12:55
Re: MySQL databases not creating views
LOGS:
Last SQL command (from DB)
CREATE INDEX ix_country_link_3 ON country_link (media_type(20))
Code: Select all
<i>
</i>18:44:40 T:6174748672 NOTICE: Running database version TV29
18:44:40 T:6174748672 NOTICE: Running database version Epg11
18:45:48 T:6170734592 NOTICE: Running database version Addons20
18:45:48 T:6170734592 NOTICE: Running database version ViewModes6
18:45:48 T:6170734592 NOTICE: Running database version Textures13
18:45:48 T:6170734592 NOTICE: Running database version mrmc_MyMusic60
18:45:48 T:6170734592 ERROR: Unable to open database: mrmc_MyVideosBUG107 [1049](Unknown database 'mrmc_MyVideosBUG107')
18:45:48 T:6170734592 ERROR: Unable to open database: mrmc_MyVideosBUG106 [1049](Unknown database 'mrmc_MyVideosBUG106')
18:45:48 T:6170734592 ERROR: Unable to open database: mrmc_MyVideosBUG105 [1049](Unknown database 'mrmc_MyVideosBUG105')
18:45:48 T:6170734592 ERROR: Unable to open database: mrmc_MyVideosBUG104 [1049](Unknown database 'mrmc_MyVideosBUG104')
18:45:48 T:6170734592 ERROR: Unable to open database: mrmc_MyVideosBUG103 [1049](Unknown database 'mrmc_MyVideosBUG103')
18:45:48 T:6170734592 ERROR: Unable to open database: mrmc_MyVideosBUG102 [1049](Unknown database 'mrmc_MyVideosBUG102')
18:45:48 T:6170734592 ERROR: Unable to open database: mrmc_MyVideosBUG101 [1049](Unknown database 'mrmc_MyVideosBUG101')
18:45:48 T:6170734592 ERROR: Unable to open database: mrmc_MyVideosBUG100 [1049](Unknown database 'mrmc_MyVideosBUG100')
18:45:48 T:6170734592 ERROR: Unable to open database: mrmc_MyVideosBUG99 [1049](Unknown database 'mrmc_MyVideosBUG99')
18:45:49 T:6170734592 ERROR: Unable to open database: mrmc_MyVideosBUG98 [1049](Unknown database 'mrmc_MyVideosBUG98')
18:45:49 T:6170734592 ERROR: Unable to open database: mrmc_MyVideosBUG97 [1049](Unknown database 'mrmc_MyVideosBUG97')
18:45:49 T:6170734592 ERROR: Unable to open database: mrmc_MyVideosBUG96 [1049](Unknown database 'mrmc_MyVideosBUG96')
18:45:49 T:6170734592 ERROR: Unable to open database: mrmc_MyVideosBUG95 [1049](Unknown database 'mrmc_MyVideosBUG95')
18:45:49 T:6170734592 ERROR: Unable to open database: mrmc_MyVideosBUG94 [1049](Unknown database 'mrmc_MyVideosBUG94')
18:45:49 T:6170734592 ERROR: Unable to open database: mrmc_MyVideosBUG93 [1049](Unknown database 'mrmc_MyVideosBUG93')
18:45:49 T:6170734592 ERROR: Unable to open database: mrmc_MyVideosBUG92 [1049](Unknown database 'mrmc_MyVideosBUG92')
18:45:49 T:6170734592 ERROR: Unable to open database: mrmc_MyVideosBUG91 [1049](Unknown database 'mrmc_MyVideosBUG91')
18:45:49 T:6170734592 ERROR: Unable to open database: mrmc_MyVideosBUG90 [1049](Unknown database 'mrmc_MyVideosBUG90')
18:45:49 T:6170734592 ERROR: Unable to open database: mrmc_MyVideosBUG89 [1049](Unknown database 'mrmc_MyVideosBUG89')
18:45:49 T:6170734592 ERROR: Unable to open database: mrmc_MyVideosBUG88 [1049](Unknown database 'mrmc_MyVideosBUG88')
18:45:49 T:6170734592 ERROR: Unable to open database: mrmc_MyVideosBUG87 [1049](Unknown database 'mrmc_MyVideosBUG87')
18:45:49 T:6170734592 ERROR: Unable to open database: mrmc_MyVideosBUG86 [1049](Unknown database 'mrmc_MyVideosBUG86')
18:45:49 T:6170734592 ERROR: Unable to open database: mrmc_MyVideosBUG85 [1049](Unknown database 'mrmc_MyVideosBUG85')
18:45:49 T:6170734592 ERROR: Unable to open database: mrmc_MyVideosBUG84 [1049](Unknown database 'mrmc_MyVideosBUG84')
18:45:49 T:6170734592 ERROR: Unable to open database: mrmc_MyVideosBUG83 [1049](Unknown database 'mrmc_MyVideosBUG83')
18:45:49 T:6170734592 ERROR: Unable to open database: mrmc_MyVideosBUG82 [1049](Unknown database 'mrmc_MyVideosBUG82')
18:45:49 T:6170734592 ERROR: Unable to open database: mrmc_MyVideosBUG81 [1049](Unknown database 'mrmc_MyVideosBUG81')
18:45:49 T:6170734592 ERROR: Unable to open database: mrmc_MyVideosBUG80 [1049](Unknown database 'mrmc_MyVideosBUG80')
18:45:49 T:6170734592 ERROR: Unable to open database: mrmc_MyVideosBUG79 [1049](Unknown database 'mrmc_MyVideosBUG79')
18:45:49 T:6170734592 ERROR: Unable to open database: mrmc_MyVideosBUG78 [1049](Unknown database 'mrmc_MyVideosBUG78')
18:45:49 T:6170734592 ERROR: Unable to open database: mrmc_MyVideosBUG77 [1049](Unknown database 'mrmc_MyVideosBUG77')
18:45:49 T:6170734592 ERROR: Unable to open database: mrmc_MyVideosBUG76 [1049](Unknown database 'mrmc_MyVideosBUG76')
18:45:49 T:6170734592 ERROR: Unable to open database: mrmc_MyVideosBUG75 [1049](Unknown database 'mrmc_MyVideosBUG75')
18:45:56 T:6170734592 ERROR: SQL: [mrmc_MyVideosBUG107] Undefined MySQL error: Code (1419)
Query: CREATE TRIGGER delete_movie AFTER DELETE ON movie FOR EACH ROW BEGIN DELETE FROM genre_link WHERE media_id=old.idMovie AND media_type='movie'; DELETE FROM actor_link WHERE media_id=old.idMovie AND media_type='movie'; DELETE FROM director_link WHERE media_id=old.idMovie AND media_type='movie'; DELETE FROM studio_link WHERE media_id=old.idMovie AND media_type='movie'; DELETE FROM country_link WHERE media_id=old.idMovie AND media_type='movie'; DELETE FROM writer_link WHERE media_id=old.idMovie AND media_type='movie'; DELETE FROM movielinktvshow WHERE idMovie=old.idMovie; DELETE FROM art WHERE media_id=old.idMovie AND media_type='movie'; DELETE FROM tag_link WHERE media_id=old.idMovie AND media_type='movie'; DELETE FROM rating WHERE media_id=old.idMovie AND media_type='movie'; DELETE FROM uniqueid WHERE media_id=old.idMovie AND media_type='movie'; END
18:45:56 T:6170734592 ERROR: CreateDatabase unable to create database:0
18:45:56 T:6170734592 NOTICE: Running database version TV29
18:45:56 T:6170734592 NOTICE: Running database version Epg11<e>
Last SQL command (from DB)
CREATE INDEX ix_country_link_3 ON country_link (media_type(20))
-
- Posts: 4
- Joined: 12 Jul 2018, 12:55
Re: MySQL databases not creating views
I have added GRANT SUPER to the user and this seems to have resolved the issue.
https://bugs.mysql.com/bug.php?id=39489
https://bugs.mysql.com/bug.php?id=39489
- koying
- Team MrMC
- Posts: 443
- Joined: 20 Mar 2016, 17:49
Re: MySQL databases not creating views [SOLVED]
See the alternative ways by tweaking binary logging: http://wiki.ispirer.com/sqlways/trouble ... ry-logging
Not sure if you actually need to do replication on your db.
Not sure if you actually need to do replication on your db.