Solved mysql reading problem
#1
Hi all,

I'm kinda here and having some troubles using one shared database. Hope somebody can help me.

At the moment I use 3 Raspberry Pi's to view movies and series stored on my NAS in different rooms. The use of one database would be awsome so you can see what episodes or movies you have whatched.

I set up a mysql 5.1.36 server (newer isn't available) on my QNAP and created a user for access. Added the advancedsettings.xml on one RPi and made new connections to my movies. I can see them being added to the database (via phpmyadmin) but when I look at movies there are non shown. When I go to movies/files I see the share and can access the files.

At first I thought it was a performance issue so I ran these commands in mysql:

ALTER TABLE movie ADD INDEX idMovie(idMovie);
ALTER TABLE movie ADD INDEX idFile(idFile)


Although the writing to the database went much quicker, there was stil not one movie shown.

If needed I can supply a error log but see no option here to add files.

Thanks for who want's to help me.
Reply


Messages In This Thread
mysql reading problem - by Edwinus - 2014-02-15, 01:25
RE: mysql reading problem - by Kib - 2014-02-15, 10:58
RE: mysql reading problem - by Edwinus - 2014-02-15, 12:20
RE: mysql reading problem - by Edwinus - 2014-02-16, 23:34
RE: mysql reading problem - by nickr - 2014-02-16, 23:39
RE: mysql reading problem - by Edwinus - 2014-02-17, 06:06
RE: mysql reading problem - by nickr - 2014-02-17, 07:25
RE: mysql reading problem - by Kib - 2014-02-17, 12:44
RE: mysql reading problem - by Edwinus - 2014-02-18, 01:18
RE: mysql reading problem - by nickr - 2014-02-18, 02:51
RE: mysql reading problem - by Edwinus - 2014-02-18, 12:09
RE: mysql reading problem - by nickr - 2014-02-18, 21:07
RE: mysql reading problem - by Edwinus - 2014-02-18, 21:31
RE: mysql reading problem - by nickr - 2014-02-18, 21:41
Re: mysql reading problem - by Milhouse - 2014-02-19, 12:58
RE: mysql reading problem - by Edwinus - 2014-02-19, 13:27
RE: mysql reading problem - by Milhouse - 2014-02-19, 14:14
RE: mysql reading problem - by Edwinus - 2014-02-19, 18:53
RE: mysql reading problem - by Milhouse - 2014-02-19, 19:12
RE: mysql reading problem - by Edwinus - 2014-02-20, 00:01
RE: mysql reading problem - by Milhouse - 2014-02-20, 00:30
RE: mysql reading problem - by Edwinus - 2014-02-20, 19:21
RE: mysql reading problem - by danomac - 2015-03-18, 03:57
RE: mysql reading problem - by unrequited - 2017-12-01, 08:21
RE: mysql reading problem - by fizze - 2016-07-15, 19:31
RE: mysql reading problem - by bigwang - 2017-01-19, 07:19
RE: mysql reading problem - by danomac - 2017-01-19, 08:11
RE: mysql reading problem - by killbilly - 2020-01-16, 05:26
RE: mysql reading problem - by killbilly - 2020-01-17, 04:10
RE: mysql reading problem - by black_eagle - 2020-01-17, 21:26
RE: mysql reading problem - by pkscout - 2020-01-18, 00:21
Logout Mark Read Team Forum Stats Members Help
mysql reading problem0