Hello all,
Today I upgraded my WHMCS installation to the latest version v8.2.0 but after the upgrade I cannot create new tickets anymore. From the admin backend and from the frontend the following error shows up:
PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ipaddress' in 'field list' in /var/www/stuxhost/public/vendor/illuminate/database/Connection.php:458Stack trace:#0 /var/www/stuxhost/public/vendor/illuminate/database/Connection.php(458): PDO->prepare()#1 /var/www/stuxhost/public/vendor/illuminate/database/Connection.php(664): Illuminate\Database\Connection->Illuminate\Database\{closure}()#2 /var/www/stuxhost/public/vendor/illuminate/database/Connection.php(631): Illuminate\Database\Connection->runQueryCallback()#3 /var/www/stuxhost/public/vendor/illuminate/database/Connection.php(465): Illuminate\Database\Connection->run()#4 /var/www/stuxhost/public/vendor/illuminate/database/Connection.php(417): Illuminate\Database\Connection->statement()#5 /var/www/stuxhost/public/vendor/illuminate/database/Query/Processors/Processor.php(32): Illuminate\Database\Connection->insert()#6 /var/www/stuxhost/public/vendor/illuminate/database/Query/Builder.php(2771): Illuminate\Database\Query\Processors\Processor->processInsertGetId()#7 /var/www/stuxhost/public/vendor/illuminate/database/Eloquent/Builder.php(1403): Illuminate\Database\Query\Builder->insertGetId()#8 /var/www/stuxhost/public/vendor/illuminate/database/Eloquent/Model.php(900): Illuminate\Database\Eloquent\Builder->__call()#9 /var/www/stuxhost/public/vendor/illuminate/database/Eloquent/Model.php(865): Illuminate\Database\Eloquent\Model->insertAndSetId()#10 /var/www/stuxhost/public/vendor/illuminate/database/Eloquent/Model.php(728): Illuminate\Database\Eloquent\Model->performInsert()#11 /var/www/stuxhost/public/includes/ticketfunctions.php(0): Illuminate\Database\Eloquent\Model->save()#12 /var/www/stuxhost/public/submitticket.php(0): openNewTicket()#13 {main}Next Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ipaddress' in 'field list' (SQL: insert into `tbltickets` (`tid`, `userid`, `contactid`, `requestor_id`, `did`, `date`, `title`, `message`, `urgency`, `status`, `attachment`, `lastreply`, `name`, `email`, `c`, `ipaddress`, `clientunread`, `adminunread`, `service`, `cc`, `editor`, `admin`, `updated_at`) values (834063, 2, , 2, 1, 2021-08-17 16:38:35, Test, test, Medium, Open, , 2021-08-17 16:38:35, , , hAE41EEH, 2a02:a448:a22e:1:944c:8125:24bb:6576, 1, , , , markdown, , 2021-08-17 16:38:35)) in /var/www/stuxhost/public/vendor/illuminate/database/Connection.php:671Stack trace:#0 /var/www/stuxhost/public/vendor/illuminate/database/Connection.php(631): Illuminate\Database\Connection->runQueryCallback()#1 /var/www/stuxhost/public/vendor/illuminate/database/Connection.php(465): Illuminate\Database\Connection->run()#2 /var/www/stuxhost/public/vendor/illuminate/database/Connection.php(417): Illuminate\Database\Connection->statement()#3 /var/www/stuxhost/public/vendor/illuminate/database/Query/Processors/Processor.php(32): Illuminate\Database\Connection->insert()#4 /var/www/stuxhost/public/vendor/illuminate/database/Query/Builder.php(2771): Illuminate\Database\Query\Processors\Processor->processInsertGetId()#5 /var/www/stuxhost/public/vendor/illuminate/database/Eloquent/Builder.php(1403): Illuminate\Database\Query\Builder->insertGetId()#6 /var/www/stuxhost/public/vendor/illuminate/database/Eloquent/Model.php(900): Illuminate\Database\Eloquent\Builder->__call()#7 /var/www/stuxhost/public/vendor/illuminate/database/Eloquent/Model.php(865): Illuminate\Database\Eloquent\Model->insertAndSetId()#8 /var/www/stuxhost/public/vendor/illuminate/database/Eloquent/Model.php(728): Illuminate\Database\Eloquent\Model->performInsert()#9 /var/www/stuxhost/public/includes/ticketfunctions.php(0): Illuminate\Database\Eloquent\Model->save()#10 /var/www/stuxhost/public/submitticket.php(0): openNewTicket()#11 {main}
This indicates there's a column missing but I have no clue why..
Is there someone who could help with this?
Thank you.