Messages

1

Developers / Create phonelines scripts issues

« on: February 26, 2008, 04:10:07 pm »

I tested phone lines for all available providers (including those provided by comunity) and looks like a couple of them are messed:

Code: [Select]

/usr/pluto/bin/create_amp_phoneline.sh 1und1 1 2 3 4
Argument "" isn't numeric in numeric gt (>) at
        /usr/pluto/bin/create_amp_1und1.pl line 174 (#1)
    (W numeric) The indicated string was fed as an argument to an operator
    that expected a numeric value instead.  If you're fortunate the message
    will identify which operator was so unfortunate.

Can't use string ("4") as an ARRAY ref while "strict refs" in use at
        /usr/pluto/bin/create_amp_1und1.pl line 95 (#2)
    (F) Only hard references are allowed by "strict refs".  Symbolic
    references are disallowed.  See perlref.

Uncaught exception from user code:
        Can't use string ("4") as an ARRAY ref while "strict refs" in use at /usr/pluto/bin/create_amp_1und1.pl line 95.
 at /usr/pluto/bin/create_amp_1und1.pl line 95


Code: [Select]

/usr/pluto/bin/create_amp_phoneline.sh sipgradwell qq aa zz xx
Argument "" isn't numeric in numeric gt (>) at
        /usr/pluto/bin/create_amp_sipgradwell.pl line 176 (#1)
    (W numeric) The indicated string was fed as an argument to an operator
    that expected a numeric value instead.  If you're fortunate the message
    will identify which operator was so unfortunate.


curl: (1) Unsupported protocol:  http

curl: (1) Unsupported protocol:  http


Code: [Select]

/usr/pluto/bin/create_amp_phoneline.sh viatalk_us-central rrr ttt ggg fff
Argument "" isn't numeric in numeric gt (>) at
        /usr/pluto/bin/create_amp_viatalk_us-central.pl line 174 (#1)
    (W numeric) The indicated string was fed as an argument to an operator
    that expected a numeric value instead.  If you're fortunate the message
    will identify which operator was so unfortunate.

Can't use string ("fff") as an ARRAY ref while "strict refs" in use at
        /usr/pluto/bin/create_amp_viatalk_us-central.pl line 95 (#2)
    (F) Only hard references are allowed by "strict refs".  Symbolic
    references are disallowed.  See perlref.

Uncaught exception from user code:
        Can't use string ("fff") as an ARRAY ref while "strict refs" in use at /usr/pluto/bin/create_amp_viatalk_us-central.pl line 95.
 at /usr/pluto/bin/create_amp_viatalk_us-central.pl line 95
It will be nice if someone can take a look at them, to be able to include them in the beta 4 scheduled next week.
Thanks.

2

Developers / Re: Complete rewrite of template for Marantz Audio receivers

« on: November 15, 2007, 12:25:28 pm »

But I have a problem :

- when I try to add MEdia scnearios for it, it's painted in red and beside text appears :

Devices in red do not have any media types set on the A/V Properties page or they are not assigned to this entertain area.

and I cannot add any media scenario for that device. It has assigned room and EA, so I really have no clue what is wrong...

Your device template doesn't have any media type, that's why is displayed in red.
You can check this by running in a mysql console this:

Code: [Select]

select PK_DeviceTemplate_MediaType,FK_MediaType from DeviceTemplate_MediaType WHERE FK_DeviceTemplate=[device template ID];
Web admin doesn't allow changing that for a device template after it is created, so you have to do it in a mysql console:

Code: [Select]

select PK_MediaType,Description from MediaType;This will display all media types available.

Then run this (you can do it multiple times, for different media types):

Code: [Select]

insert into DeviceTemplate_MediaType (FK_DeviceTemplate,FK_MediaType) values ([device template PK],[media type PK]);
Then you should be able to use your device in media scenarios.

3

Users / Re: i got this selecting cover art on pluto admin

« on: April 19, 2007, 12:34:22 pm »

Fatal error: mysql error: [1054: Unknown column 'FK_AttributeType' in 'on clause'] in EXECUTE("SELECT * FROM File_Attribute INNER JOIN AttributeType ON FK_AttributeType=PK_AttributeType INNER JOIN Attribute ON FK_Attribute=PK_Attribute WHERE FK_AttributeType IN (2,3) AND FK_File IN (157,156,1)") in /var/www/pluto-admin/include/adodb/adodb-errorhandler.inc.php on line 77

a ref to adodb? maybe or a bad install?

It's a SQL error (at least in mySQL 5.0, in 4.x it's working):

Code: [Select]

SELECT * FROM File_Attribute INNER JOIN AttributeType ON FK_AttributeType=PK_AttributeType INNER JOIN Attribute ON FK_Attribute=PK_Attribute WHERE FK_AttributeType IN ... shold be

Code: [Select]

SELECT * FROM File_Attribute INNER JOIN Attribute ON FK_Attribute=PK_Attribute INNER JOIN AttributeType ON FK_AttributeType=PK_AttributeType WHERE FK_AttributeType IN ...(first join with Attribute table, then with AttributeType).