News:

Rule #1 - Be Patient - Rule #2 - Don't ask when, if you don't contribute - Rule #3 - You have coding skills - LinuxMCE's small brother is available: http://www.agocontrol.com

Main Menu
Menu

Show posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Show posts Menu

Messages - legolas

#1
Developers / Create phonelines scripts issues
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:

/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



/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


/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
Quote from: bulek on November 13, 2007, 04:49:18 PM
But I have a problem :

- when I try to add MEdia scnearios for it, it's painted in red and beside text appears :
QuoteDevices 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:
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:
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):
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
Quote from: rictec on April 06, 2007, 03:31:22 AM
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):
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
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).