Jump to content

db missing column error when activating sitebuilder addon


Recommended Posts

I wanted to try Site Builder on one of my domains.

on whmcs, i went to my domain > products/services > + new addon >

i chose the correct domain,

i click Predefined Addon > Site Builder Free Trial
Custom name: sitebuilder
Status: active
I get this:


Oops!
Something went wrong and we couldn't process your request.

Please go back to the previous page and try again.

If the problem persists, please contact us.

« Back to Homepage

For additional assistance, please reference the WHMCS TroubleShooting Guide »

PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'subscriptionid' in 'field list' in /home/wpghm/public_html/clients/vendor/illuminate/database/Connection.php:458
Stack trace:
#0 /home/wpghm/public_html/clients/vendor/illuminate/database/Connection.php(458): PDO->prepare('insert into `tb...')
#1 /home/wpghm/public_html/clients/vendor/illuminate/database/Connection.php(664): Illuminate\Database\Connection->Illuminate\Database\{closure}('insert into `tb...', Array)
#2 /home/wpghm/public_html/clients/vendor/illuminate/database/Connection.php(631): Illuminate\Database\Connection->runQueryCallback('insert into `tb...', Array, Object(Closure))
#3 /home/wpghm/public_html/clients/vendor/illuminate/database/Connection.php(465): Illuminate\Database\Connection->run('insert into `tb...', Array, Object(Closure))
#4 /home/wpghm/public_html/clients/vendor/illuminate/database/Connection.php(417): Illuminate\Database\Connection->statement('insert into `tb...', Array)
#5 /home/wpghm/public_html/clients/vendor/illuminate/database/Query/Processors/Processor.php(32): Illuminate\Database\Connection->insert('insert into `tb...', Array)
#6 /home/wpghm/public_html/clients/vendor/illuminate/database/Query/Builder.php(2771): Illuminate\Database\Query\Processors\Processor->processInsertGetId(Object(Illuminate\Database\Query\Builder), 'insert into `tb...', Array, 'id')
#7 /home/wpghm/public_html/clients/vendor/illuminate/database/Eloquent/Builder.php(1403): Illuminate\Database\Query\Builder->insertGetId(Array, 'id')
#8 /home/wpghm/public_html/clients/vendor/illuminate/database/Eloquent/Model.php(900): Illuminate\Database\Eloquent\Builder->__call('insertGetId', Array)
#9 /home/wpghm/public_html/clients/vendor/illuminate/database/Eloquent/Model.php(865): Illuminate\Database\Eloquent\Model->insertAndSetId(Object(Illuminate\Database\Eloquent\Builder), Array)
#10 /home/wpghm/public_html/clients/vendor/illuminate/database/Eloquent/Model.php(728): Illuminate\Database\Eloquent\Model->performInsert(Object(Illuminate\Database\Eloquent\Builder))
#11 /home/wpghm/public_html/clients/x/clientsservices.php(0): Illuminate\Database\Eloquent\Model->save()
#12 {main}
Next Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'subscriptionid' in 'field list' (SQL: insert into `tblhostingaddons` (`hostingid`, `addonid`, `userid`, `name`, `setupfee`, `qty`, `firstpaymentamount`, `recurring`, `billingcycle`, `status`, `regdate`, `nextduedate`, `nextinvoicedate`, `termination_date`, `paymentmethod`, `tax`, `notes`, `subscriptionid`, `updated_at`, `created_at`) values (72, 38, 40, , 0, 1, 0, 0, Free Account, Pending, 2024-05-13, 0000-00-00, 0000-00-00, 0000-00-00, banktransfer, 1, , , 2024-05-13 09:06:25, 2024-05-13 09:06:25)) in /home/wpghm/public_html/clients/vendor/illuminate/database/Connection.php:671
Stack trace:
#0 /home/wpghm/public_html/clients/vendor/illuminate/database/Connection.php(631): Illuminate\Database\Connection->runQueryCallback('insert into `tb...', Array, Object(Closure))
#1 /home/wpghm/public_html/clients/vendor/illuminate/database/Connection.php(465): Illuminate\Database\Connection->run('insert into `tb...', Array, Object(Closure))
#2 /home/wpghm/public_html/clients/vendor/illuminate/database/Connection.php(417): Illuminate\Database\Connection->statement('insert into `tb...', Array)
#3 /home/wpghm/public_html/clients/vendor/illuminate/database/Query/Processors/Processor.php(32): Illuminate\Database\Connection->insert('insert into `tb...', Array)
#4 /home/wpghm/public_html/clients/vendor/illuminate/database/Query/Builder.php(2771): Illuminate\Database\Query\Processors\Processor->processInsertGetId(Object(Illuminate\Database\Query\Builder), 'insert into `tb...', Array, 'id')
#5 /home/wpghm/public_html/clients/vendor/illuminate/database/Eloquent/Builder.php(1403): Illuminate\Database\Query\Builder->insertGetId(Array, 'id')
#6 /home/wpghm/public_html/clients/vendor/illuminate/database/Eloquent/Model.php(900): Illuminate\Database\Eloquent\Builder->__call('insertGetId', Array)
#7 /home/wpghm/public_html/clients/vendor/illuminate/database/Eloquent/Model.php(865): Illuminate\Database\Eloquent\Model->insertAndSetId(Object(Illuminate\Database\Eloquent\Builder), Array)
#8 /home/wpghm/public_html/clients/vendor/illuminate/database/Eloquent/Model.php(728): Illuminate\Database\Eloquent\Model->performInsert(Object(Illuminate\Database\Eloquent\Builder))
#9 /home/wpghm/public_html/clients/x/clientsservices.php(0): Illuminate\Database\Eloquent\Model->save()
#10 {main}

I figure the install didnt push through and missed a column?

id appreciate phpmyadmin command to add missing column please

many many thanks in advance i just want to try site builder
 

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.

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • 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