ghmercado Posted May 13 Share Posted May 13 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 0 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.