SQL error Column not found

[kintaro1981]

Invoiceplane 1.5.4
I'm getting this:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ip_payment_methods.invoice_id' in 'where clause' (SQL: select * from ip_payment_methods where ip_payment_methods.invoice_id in (2, 8, 9, 10, 12, 13, 14, 15, 16, 17, 18, 19, 22, 23, 24, 25, 28, 29, 30, 31, 32, 34, 35, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 60, 64, 65, 66, 67, 68, 69, 70, 71))

in ip_payment_methods there's no invoice_id column.

[turbo124]

Are you getting any other error messages, such as a line number where this is being produced?

I am not sure why this is happening for you as we don't call anything at all from ip_payment_methods

[kintaro1981]

here's the complete error:

(2/2) QueryExceptionSQLSTATE[42S22]: Column not found: 1054 Unknown column 'ip_payment_methods.invoice_id' in 'where clause' (SQL: select * from `ip_payment_methods` where `ip_payment_methods`.`invoice_id` in (2, 8, 9, 10, 12, 13, 14, 15, 16, 17, 18, 19, 22, 23, 24, 25, 28, 29, 30, 31, 32, 34, 35, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 60, 64, 65, 66, 67, 68, 69, 70, 71))
--
in Connection.php (line 647)
at Connection->runQueryCallback('select * from `ip_payment_methods` where `ip_payment_methods`.`invoice_id` in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)', array(2, 8, 9, 10, 12, 13, 14, 15, 16, 17, 18, 19, 22, 23, 24, 25, 28, 29, 30, 31, 32, 34, 35, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 60, 64, 65, 66, 67, 68, 69, 70, 71), object(Closure))in Connection.php (line 607)
at Connection->run('select * from `ip_payment_methods` where `ip_payment_methods`.`invoice_id` in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)', array(2, 8, 9, 10, 12, 13, 14, 15, 16, 17, 18, 19, 22, 23, 24, 25, 28, 29, 30, 31, 32, 34, 35, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 60, 64, 65, 66, 67, 68, 69, 70, 71), object(Closure))in Connection.php (line 326)
at Connection->select('select * from `ip_payment_methods` where `ip_payment_methods`.`invoice_id` in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)', array(2, 8, 9, 10, 12, 13, 14, 15, 16, 17, 18, 19, 22, 23, 24, 25, 28, 29, 30, 31, 32, 34, 35, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 60, 64, 65, 66, 67, 68, 69, 70, 71), true)in Builder.php (line 1706)
at Builder->runSelect()in Builder.php (line 1690)
at Builder->get(array('*'))in Builder.php (line 462)
at Builder->getModels(array('*'))in Builder.php (line 446)
at Builder->get()
at call_user_func_array(array(object(Builder), 'get'), array())in Relation.php (line 356)
at Relation->__call('get', array())in Relation.php (line 143)
at HasMany->get()in Relation.php (line 143)
at Relation->getEager()in Builder.php (line 510)
at Builder->eagerLoadRelation(array(object(Invoice), object(Invoice), object(Invoice), object(Invoice), object(Invoice), object(Invoice), object(Invoice),object(Invoice), object(Invoice), object(Invoice), object(Invoice), object(Invoice), object(Invoice), object(Invoice), object(Invoice), object(Invoice), object(Invoice),object(Invoice), object(Invoice), object(Invoice), object(Invoice), object(Invoice), object(Invoice), object(Invoice), object(Invoice), object(Invoice), object(Invoice),object(Invoice), object(Invoice), object(Invoice), object(Invoice), object(Invoice), object(Invoice), object(Invoice), object(Invoice), object(Invoice), object(Invoice),object(Invoice), object(Invoice), object(Invoice), object(Invoice), object(Invoice), object(Invoice), object(Invoice), object(Invoice), object(Invoice), object(Invoice)), 'payments', object(Closure))in Builder.php (line 479)
at Builder->eagerLoadRelations(array(object(Invoice), object(Invoice), object(Invoice), object(Invoice), object(Invoice), object(Invoice), object(Invoice),object(Invoice), object(Invoice), object(Invoice), object(Invoice), object(Invoice), object(Invoice), object(Invoice), object(Invoice), object(Invoice), object(Invoice),object(Invoice), object(Invoice), object(Invoice), object(Invoice), object(Invoice), object(Invoice), object(Invoice), object(Invoice), object(Invoice), object(Invoice),object(Invoice), object(Invoice), object(Invoice), object(Invoice), object(Invoice), object(Invoice), object(Invoice), object(Invoice), object(Invoice), object(Invoice),object(Invoice), object(Invoice), object(Invoice), object(Invoice), object(Invoice), object(Invoice), object(Invoice), object(Invoice), object(Invoice), object(Invoice)))in Builder.php (line 447)
at Builder->get()
at call_user_func_array(array(object(Builder), 'get'), array())in Relation.php (line 356)
at Relation->__call('get', array())in Relation.php (line 143)
at HasMany->get()in Relation.php (line 143)
at Relation->getEager()in Builder.php (line 510)
at Builder->eagerLoadRelation(array(object(Client), object(Client), object(Client), object(Client), object(Client), object(Client), object(Client), object(Client),object(Client), object(Client), object(Client)), 'invoices', object(Closure))in Builder.php (line 479)
at Builder->eagerLoadRelations(array(object(Client), object(Client), object(Client), object(Client), object(Client), object(Client), object(Client), object(Client),object(Client), object(Client), object(Client)))in Builder.php (line 447)
at Builder->get()in ImportController.php (line 42)
at ImportController->crunch('clients')
at call_user_func_array(array(object(ImportController), 'crunch'), array('class_name' => 'clients'))in Controller.php (line 55)
at Controller->callAction('crunch', array('class_name' => 'clients'))in ControllerDispatcher.php (line 44)
at ControllerDispatcher->dispatch(object(Route), object(ImportController), 'crunch')in Route.php (line 204)
at Route->runController()in Route.php (line 160)
at Route->run()in Router.php (line 572)
at Router->Illuminate\Routing\{closure}(object(Request))in Pipeline.php (line 30)
at Pipeline->Illuminate\Routing\{closure}(object(Request))in SubstituteBindings.php (line 41)
at SubstituteBindings->handle(object(Request), object(Closure))in Pipeline.php (line 148)
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing\{closure}(object(Request))in VerifyCsrfToken.php (line 65)
at VerifyCsrfToken->handle(object(Request), object(Closure))in Pipeline.php (line 148)
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing\{closure}(object(Request))in ShareErrorsFromSession.php (line 49)
at ShareErrorsFromSession->handle(object(Request), object(Closure))in Pipeline.php (line 148)
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing\{closure}(object(Request))in StartSession.php (line 64)
at StartSession->handle(object(Request), object(Closure))in Pipeline.php (line 148)
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing\{closure}(object(Request))in AddQueuedCookiesToResponse.php (line 37)
at AddQueuedCookiesToResponse->handle(object(Request), object(Closure))in Pipeline.php (line 148)
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing\{closure}(object(Request))in EncryptCookies.php (line 59)
at EncryptCookies->handle(object(Request), object(Closure))in Pipeline.php (line 148)
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing\{closure}(object(Request))in Pipeline.php (line 102)
at Pipeline->then(object(Closure))in Router.php (line 574)
at Router->runRouteWithinStack(object(Route), object(Request))in Router.php (line 533)
at Router->dispatchToRoute(object(Request))in Router.php (line 511)
at Router->dispatch(object(Request))in Kernel.php (line 176)
at Kernel->Illuminate\Foundation\Http\{closure}(object(Request))in Pipeline.php (line 30)
at Pipeline->Illuminate\Routing\{closure}(object(Request))in TransformsRequest.php (line 30)
at TransformsRequest->handle(object(Request), object(Closure))in Pipeline.php (line 148)
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing\{closure}(object(Request))in TransformsRequest.php (line 30)
at TransformsRequest->handle(object(Request), object(Closure))in Pipeline.php (line 148)
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing\{closure}(object(Request))in ValidatePostSize.php (line 27)
at ValidatePostSize->handle(object(Request), object(Closure))in Pipeline.php (line 148)
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing\{closure}(object(Request))in CheckForMaintenanceMode.php (line 46)
at CheckForMaintenanceMode->handle(object(Request), object(Closure))in Pipeline.php (line 148)
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing\{closure}(object(Request))in Pipeline.php (line 102)
at Pipeline->then(object(Closure))in Kernel.php (line 151)
at Kernel->sendRequestThroughRouter(object(Request))in Kernel.php (line 116)
at Kernel->handle(object(Request))in index.php (line 54)

[turbo124]

6e76b7b

should resolve this issue, let me know if it persists.