ictinnovations / ictfax

Open Source Fax Server Software supporting inbound and outbound faxing. ICTFAX can be used in following faxing scenarios Web to fax, Fax to Web or Online Fax Email to fax and fax to email ATA / Extensions to send and receive faxes via Fax machine using internet REST based Fax API’s to integrate with third party applications and automate business process G.711 based Fax Origination / Termination / Gateway T.38 based Fax Origination / Termination PSTN based Fax Origination / Termination / Gateway
http://www.ictfax.org
GNU General Public License v3.0
175 stars 60 forks source link

Cannot view the Receive Fax page #87

Open rw180800 opened 1 year ago

rw180800 commented 1 year ago

when I select the receive page it then tries then bounces back to the dashboard. All other pages are fine. .1m inbound and 3.5k out.

rw180800 commented 11 months ago

it seems if I set the value here too high I cant see any received faxes..it seems ~50,000 is about the max, is there a way to trim the database so that I can see recent records? It shows oldest only so at over 100,000 received faxes I cant see the latest ones. I don't really need much of a history of faxes in or out.

$query = "SELECT t.transmission_id, $owner_fields, $contact_fields, t.status, t.response, t.direction, t.last_run FROM " . $from_str . " LIMIT 100000";

rw180800 commented 6 months ago

I have been running the below in the ictfax DB. This seems to work ... as long as there is no issue doing it? delete from transmission where transmission_id<xxxxxxx;