MYSQL ERROR
Hello,
I (re) installed fop2 on a freepbx17 debian12 server (asterisk 21)
I get an MySQL error in the Call History popup.
I had to install asterisk and dahdi with phreakscript as I needed an old dahdi driver and had to more or less manually install freepbx17 (without asterisk) on top.
All seems to be working, the only error I get is this :
Fatal error: Uncaught mysqli_sql_exception: Unknown column 'direction' in 'having clause' in /var/www/html/fop2/lib/dblib.php:96 Stack trace: #0 /var/www/html/fop2/lib/dblib.php(96): mysqli_query() #1 /var/www/html/fop2/lib/dbgrid.php(826): dbcon->consulta() #2 /var/www/html/fop2/lib/dbgrid.php(1685): dbgrid->set_pagination() #3 /var/www/html/fop2/lib/dbgrid.php(1182): dbgrid->print_grid() #4 /var/www/html/fop2/calldetailrecords.php(600): dbgrid->show_grid() #5 {main} thrown in /var/www/html/fop2/lib/dblib.php on line 96
The asteriskcdrdb database is the old one I reimported from the old centos freepbx16 server .
The call history is working for both inbound and outbound calls .
Does anybody know where the column 'direction' is supposed to be ?
I guess there has been a change in the table structure which I missed by importing the old table
Thanks