After upgrading from 4.x to 5.3.x if a customer reports an error where Fax->Sent pages cannot be opened and are throwing an MYSQL error, just execute the attached script.
New updated script:
#!/bin/bash
read -p "Check tenant numbers before proceeding!! Proceed? " -n 1 -r
echo
if [[ $REPLY =~ ^[Yy]$ ]]
then
for tcode in {200..999}
do
/opt/pbxware/sh/mysql -e "DROP TABLE pbxware_$tcode.sent_faxes"
/opt/pbxware/sh/mysql -e "CREATE TABLE pbxware_$tcode.sent_faxes (faxid varchar(100) PRIMARY KEY, faxsource varchar(100), faxdestination varchar(100), faxsentpages int(11), faxtotalpages int(11), faxstatus varchar(20), faxdate varchar(100), faxfile varchar(200))"
done
fi