call history + odbc_cdr

[nicolas]

Try to edit calldetailrecords.php and set $datefield to the value corresponding to your schema (start), instead of the default 'calldate'.

You can set that around line 18 of such script.

Best regards,

[AlexRS]

I will try tomorrow, thank you!
What aboute odbc schema and asternic cdr report? Will it work?

[nicolas]

In Asternic CDR Standalone, in config.php you can configure the $DATEFIELD to be 'start' , so it should work.

[AlexRS]

Its works, but 'View record' page is still empty (In mysql schema it was empty too)..

[AlexRS]

Its printscreen

[nicolas]

You can enable debug in config.php and see if you get some errors. It is not possible for me to test locally.

[AlexRS]

I get this:

notice
/var/www/html/fop2/lib/dblib.php (line 59)

mysqli::mysqli(): Headers and client library minor version mismatch. Headers:50550 Library:50635
notice
/var/www/html/fop2/calldetailrecords.php (line 241)

Undefined index: filterdir
notice
/var/www/html/fop2/calldetailrecords.php (line 260)

Undefined index: filterdispo
View Record
notice
/var/www/html/fop2/lib/dblib.php (line 356)

mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given

[nicolas]

hmmm, this:

Headers and client library minor version mismatch. Headers:50550 Library:50635

seems to indicate that you have conflicting packages/versions installed for mysql and libaries.... maybe the problem is a result of that mismatch. You will have to be sure you have same version of mysql-xx everything installed.

[AlexRS]

I think, the problem is here
/var/www/html/fop2/lib/dblib.php (line 356)

mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given

i.e. mysqli_num_rows(this->result), this->result doesnt contain mysqli_result data. Plese show, where its colled in detail record.
PS. When I comment this function and return 1 instead, I see "cancel" button on detail record page. The problem is here.

[AlexRS]

The problem was solved by

diff tmp/dbgrid.php lib/dbgrid.php
2618c2618
<         $res = $this->link->consulta("SELECT $this->fields FROM %s %s WHERE %s = %s %s",$this->table,$joinstring,$this->table.".".$this->pk,$id, $this->groupby);
---
>         $res = $this->link->consulta("SELECT $this->fields FROM %s %s WHERE %s = '%s' %s",$this->table,$joinstring,$this->table.".".$this->pk,$id, $this->groupby);

[nicolas]

thanks,