Just wanted to say I love all the hard work everyone has done with this project. Kudos to you all. Uncle Ward is a hero.
the BUG:
On line 397 of cnam.pl (in /var/www/perl/) the SQL statement fails.
This is for the Asteridesk CLID lookup sub-routine (which I should say, rocks.)
Currently the line reads:
MySql doesn't like it. Tailing /var/log/httpd/error_log gives:
It should read (aka the fix):
Hope this helps. 
Cheers,
tel0p
the BUG:
On line 397 of cnam.pl (in /var/www/perl/) the SQL statement fails.
This is for the Asteridesk CLID lookup sub-routine (which I should say, rocks.)
Currently the line reads:
Code:
$dbh->prepare("select * from user1 where out = '$npa$nxx$station'")MySql doesn't like it. Tailing /var/log/httpd/error_log gives:
Code:
DBD::mysql::st execute failed: 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 'out FROM user1 WHERE out = '206XXXXXXX''It should read (aka the fix):
Code:
$dbh->prepare("select * from user1 where user1.out = '$npa$nxx$station'")Cheers,
tel0p
Phone System 