Jump to content

v8.2.0 MySQL error with new tickets


Recommended Posts

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:458
Stack 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:671
Stack 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. 

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use & Guidelines and understand your posts will initially be pre-moderated