LinuxMCE Forums

Hi all,
I get a new tv sharp aquos with rs232c port try to connect it to my core/hybrid and it was not autodetected so I try to add it manually, but first I need to edit the A/V Properties of the template as posted on wiki  http://wiki.linuxmce.org/index.php/Alx9r%27s_Aquos_TV_Setup (http://wiki.linuxmce.org/index.php/Alx9r%27s_Aquos_TV_Setup) follow steps listed there but, when I try Edit Audio/Video Properties. I have an error telling
(http://C:%5CDocuments%20and%20Settings%5Ccesar%5CMy%20Documents%5CMy%20Pictures%5Cerror122.png)

    ERROR!
Cannot retrieve IR codes.

I'm Running a new installation, Unfortunately I don't have the old installation any more, to compare, but I found out that if I try to add an other av equipment it do the same thing, same error Cannot retrieve IR codes, bellow this it is a retry link when I click on it it give me an other error in the same frame saying "Device template # 0 was not found". I'm using LMCE 7.10 RC2 I386 I also tried the AMD64 same results.

thank you for any help you can give me on this.

any one please?
I'm clueless.
I do not know where to start to troubleshoot this.
Searched wiki searched forum no similar problem.
It seems that it is related with the sqlCVS?
could I start here. how do I rebuild it?

If some one please can tell me where to look for a log file to see a detail of the error
Thanks

I am now seeing the same issue on my system.
Did you modify your db by any chance.

I did reinitialize my pluto_media but even after restoring a backup the problem remains.


So I too am looking into this.   I thought it was just me.


Tim

Tim,
It is a clean installation I did not touch the DB.
its possible that during installation the system tries to download something from a repository that is broken or inaccessible?
where to look for some logs tho see what could be happening? I'm not a Linux expert but I know my way around.


Cesar

In the previous message is an attachment of the error screen.

He guys New installation different hawrdware new downloaded isos same problem I thinks somenthig is meessing on installation.

The Device Templates are installed locally with the cd or DVDs or they came from an other source like they are downloded at installation from some other source?

Thanks
Cesar

Serching the wiki I found that, as I though, the the device template's infrared or Ruby codes are fetched from the linuxmce.org website
with this script

Quote/usr/pluto/bin/WebDB_GetIR.sh [deviceID] [deviceTemplateID] [restriction flag]

I ran this scripts on linux shell and it response
linuxmce@dcerouter:/usr/pluto/bin$ /usr/pluto/bin/WebDB_GetIR.sh 1856
ERROR. Empty result
linuxmce@dcerouter:/usr/pluto/bin$
Is there an alternative url that I can use to test?
what should I see if I put the parameters of the script on a browser?
I get this
(http://error22.png)

An other update on this problem
I decided to take a look at the InfraredGroup_Command table on the pluto_main database. It is empty. Is this normal? from where can I download a sql file to import locally? It is possible to do this?

Thanks in advance


Cesar

good point, this script does not work any more after we've moved services. I'll fix it.

br Hari

Hari,
Thanks for your reply.
Are you going to fix the script or the service?
is something that i can do to help or test?

Thanks again

Cesar

the script is the service :-) I'm sure i will find time tonite or tomorrow.

br, Hari

Hari,
I sorry what I meant with service was something to fix on the linuxmce.org site, where the codes are fetched from, or something on the local script it self. if this last is the case is there some parameters o values that I have to change? or is a complete rewrite of the script?
I ask this again is something I can do to help. I think this is a very important feature of the system and is affecting all users that wants to add new devises. Is there is a walkaround for this problem?

thank you for your great job
Cesar

Hari,
I'm still unavailable to retrieve  GSD or IR codes for my AV devices.
Did you had a chance to look at it?
Again if there is something I can assist in this, let me know.
Thanks.
Cesar

Quote from: cesarscav on December 08, 2008, 09:48:23 PM
Hari,
I'm still unavailable to retrieve  GSD or IR codes for my AV devices.
Did you had a chance to look at it?
Again if there is something I can assist in this, let me know.
Thanks.
Cesar

Hi Cesar,

Hari's a busy guy right now so I expect he's a little 'snowed under' as they say. However if you want to have a quick check of where he is on this look for him on irc channel #linuxmce-devel

All the best

Andrew

Hi Andrew,
Thank you very much for you reply. I hate to be bother, I know how hard this guys are working on the new release and other stuff that in the long run will benefit all of us.
I'm not the kind of guy that whats somebody to solve My issues. I just want to know more abut this to try to troubleshoot, that eventually will also benefit all of us. (please feel free to correct me if I'm getting this wrong and the problem is just mine)
As I told before I'm not a linux or programmer expert but I know my way around. I Asked several questions before and had no answer  that's why I keep trying. I can understand what the script (/usr/pluto/bin/WebDB_GetIR.sh) does and why it doesn't do what is suppose to do, but I just not have the means to solve it. Meanwhile it is fun because I learning a lot of how the system works that other way, if every thing worked out of the box, I would not be able.
Please do not take this as an angry discharge. I'm Just trying to know this community until we can fix this.

Thanks.
Cesar

ok, i've installed adodb, pointed the script to the real db server and changed the username to builder. Dunno if that is enough, have to sleep now. Sorry for the delay.

best regards,
Hari

Hari,
Thanks for putting an eye on this.
Unfortunately I thinks is still not working.
Is something I have to change locally?
I tried to resynchronize ir codes and edit av properties and they didn't work, had same error as before.

Any advice?

Thanks Again.
Cesar

i had to revert as this was using the exact same config like the homepage. Tschak is just looking at that as I'm on a business trip in UK.

br, Hari

I'm just curious guys, I ran into a problem recently attempting to create a GSD, when I attempt to edit ruby codes I was receiving some error messages about ircodes, is this the same problem?

los93sol: yes, sorry for your inconvenience.

br, Hari

To clarify Hari...this is the error message I get:

Fatal error: mysql error: [1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1] in EXECUTE("SELECT FK_Command,PK_InfraredGroup_Command FROM InfraredGroup_Command WHERE FK_InfraredGroup= ") in /var/www/pluto-admin/include/adodb/adodb-errorhandler.inc.php on line 77

fixed and reported working by tkmedia.

br, Hari

Hari,

Great!
It worked!
Thanks you
Cesar

you're welcome!

br, Hari