Sqlstate 22p02 invalid text representation 7 error invalid input syntax for integer

SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for type integer: «» #30701

Description:

I have the following error while entering data in Store HELP ME PLZ:

SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for type integer: «» (SQL: insert into «pmieducar».»servidor_alocacao» («ref_usuario_cad», «ref_usuario_exc», «data_cadastro», «ano», «ref_cod_escola», «periodo», «data_admissao», «ref_cod_servidor_funcao», «ref_cod_funcionario_vinculo», «hora_inicial», «hora_final», «carga_horaria», «hora_atividade», «horas_excedentes») values (1, 1, 2019-11-27 10:34:05, 2019, 39, 1, 2018-10-26, , , 16:54:06, , 12:38:00, , ) returning «cod_servidor_alocacao»)

Controller
` shere(‘rota’ , ‘alocacao.’); view()->share(‘titulo’, $this->titulo); view()->share(‘instituicao’, Instituicao::orderBy(‘nm_instituicao’, ‘asc’)->get()); view()->share(‘vinculo’, FuncionarioVinculo::orderBy(‘cod_funcionario_vinculo’ , ‘asc’)->get()); view()->share(‘funcao’, TipoFuncao::orderBy(‘cod_funcao’ , ‘asc’)->get()); > /** * Display a listing of the resource. * * @return IlluminateHttpResponse */ public function index($cod_servidor) < $servidor = Servidor::find($cod_servidor); return view(‘Admin.servidor.servidor.alocacao.index’ , compact(‘servidor’)); >/** * Show the form for creating a new resource. * * @return IlluminateHttpResponse */ public function create($cod_servidor ) < $servidor = Servidor::find($cod_servidor); // return $servidor; $escola = Escola::where(‘ref_cod_instituicao’, $servidor->ref_cod_instituicao)->OrderBy(‘ref_cod_instituicao’)->get(); return view(‘Admin.servidor.servidor.alocacao.create’ , compact(‘servidor’ , ‘escola’)); // > /** * Store a newly created resource in storage. * * @param IlluminateHttpRequest $request * @return IlluminateHttpResponse */ public function store(Request $request , ServidorAlocacao $data) < $data->carga_horaria = $request->carga_horaria; $data->periodo = $request->periodo; $data->ref_cod_servidor_funcao = $request->ref_cod_servidor_funcao; $data->ref_cod_funcionario_vinculo = $request->ref_cod_funcionario_vinculo; $data->ano = $request->ano; $data->data_admissao = $request->data_admissao; $data->hora_inicial = $request->hora_inicial; $data->hora_final = $request->hora_final; $data->hora_atividade = $request->hora_atividade; $data->horas_excedentes = $request->horas_excedentes; // dd($data) ; $data->save(); if($data->fill($request->all())->save() != null)< return redirect(‘Admin/servidor/servidor/alocacao/cod_servidor>‘)->with([‘success’ => ‘Servidor alocado com sucesso.’]); >else< return redirect(‘Admin/servidor/servidor/alocacao/‘)->with([‘error’ => ‘Ocorreu um erro. Tente novamente mais tarde.’]); > > /** * Display the specified resource. * * @param int $id * @return IlluminateHttpResponse */ public function show($id) < // >/** * Show the form for editing the specified resource. * * @param int $id * @return IlluminateHttpResponse */ public function edit($id) < // >/** * Update the specified resource in storage. * * @param IlluminateHttpRequest $request * @param int $id * @return IlluminateHttpResponse */ public function update(Request $request, $id) < // >/** * Remove the specified resource from storage. * * @param int $id * @return IlluminateHttpResponse */ public function destroy($id) < // >«>

>
Model belongsTo(Escola::class, ‘ref_cod_escola’, ‘cod_escola’); > public function funcao()< return $this->belongsTo(ServidorFuncao::class, ‘ref_cod_servidor_funcao’, ‘cod_servidor_funcao’); > public function vinculo()< return $this->belongsTo(FuncionarioVinculo::class, ‘ref_cod_funcionario_vinculo’, ‘cod_funcionario_vinculo’); >»>

@section(‘contentheader_icon’)
fa-graduation-cap
@endsection

Источник

Invalid text representation with Postgresql #22

I have an error :

SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for integer: «»

SQL: SELECT «resultats».»id» FROM «resultats» WHERE «id» = ? LIMIT 1

Bindings: array (
0 => false,
)

it works with an ugly hack on ModelHelper.php :

The text was updated successfully, but these errors were encountered:

Hey @guiguidoc, can you tell me where you’re getting this error? What action are you performing?

When I access to the index page of a model

I’m looking into this at the moment. To give you an idea of where I’m coming from. I only ever tested this in MySQL! I’m actually really happy that you posted this here because I was curious to see what happens in postgresql. I’m going to try to set up a postgresql database today and isolate the issue.

Hey @guiguidoc. I’ve come up with a fix for this that should account for all possible scenarios. I couldn’t cast the $id as an integer because sometimes people use non-integer values for ids. Instead, I changed the default $id value from boolean false (which PostgreSQL has an issue with) to integer 0. This should solve your issue, but please let me know if it hasn’t. You can either grab the 2.3.0 source or make the changes from that commit directly (it’s really simple. just a single line).

Hey janhartigan,
Thanks for the fix, Am now running your example app fine on pages Admin, Actors and Box office .
However i now get an error when viewing ‘Films’ and ‘Theatre’

SQLSTATE[42883]: Undefined function: 7 ERROR: function format(numeric, integer) does not exist
LINE 1: . films.film_id) AS num_actors, (SELECT CONCAT(‘$’, FORMAT(SUM.
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.

SQL: SELECT DISTINCT films.id, films.*, (SELECT CONCAT(directors.first_name, ‘ ‘, directors.last_name) FROM directors WHERE films.director_id = directors.id) AS director_name, (SELECT COUNT(actors_films.id) FROM actors_films WHERE films.id = actors_films.film_id) AS num_actors, (SELECT CONCAT(‘$’, FORMAT(SUM(box_office.revenue), 2)) FROM box_office WHERE films.id = box_office.film_id) AS box_office FROM «films» GROUP BY «films».»id» ORDER BY «films».»id» DESC LIMIT 20 OFFSET 0

Let me know if you want a stack trace.

And, Thanks for your work on this bundle. Looks good.

Hey @kentvv. The examples use some MySQL functions (such as FORMAT) in the selects. If you’re using PostgreSQL, you should give this a look: http://stackoverflow.com/questions/5419199/how-to-format-money-in-postgresql. So, for example, replace FORMAT on this line with to_char.

Perfect. Thanks for that.

Great. I’m glad that it worked. So now I sort of know that it works in PostgreSQL! Woot. You guys have really helped me out on this one 🙂

© 2023 GitHub, Inc.

You can’t perform that action at this time.

You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session.

Источник

PostGresql error: PDOException: SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for integer: «70.json» #196

Getting this error when running GET /log/70.json to get log ID 70.
Get this error for all logs, but not for assets or users, or terms.
«70.json» is being passed to the SELECT by id query, instead of just the number

The text was updated successfully, but these errors were encountered:

I’m able to replicate this in my local pgsql environment. Investigating.

Related issue that was fixed in Drupal core (a long time ago, but might provide clues for this issue): https://www.drupal.org/project/drupal/issues/1003788

Notably, in that issue, the restws module maintainer suggests:

Using the format extension like «.json» or «.xml» is not recommended anyway — use the accept headers when possible.

So instead of making a request to /log/X.json , make a request to /log/X with a Accept: application/json header.

Can you give that a try @Skipper-is ?

Maybe we should update the API docs to recommend that instead of tacking .json to the end.

I would prefer to find a solution than change the recommendations, personally.

Well, it doesn’t crash.

But that isn’t what I needed

Forgot the header.
But this works:
/log.json?id=23

Confirming that /log/23 with Accept: application/json Header also works

I found the fix.

Basically, the same fix that was applied to Drupal core’s entity controller needs to be applied to the Entity module’s controller.

So this is actually a bug in the Entity module. I’ll prepare a patch.

I submitted a patch upstream to the Entity API module: https://www.drupal.org/project/entity/issues/3076175

Try patching your Entity API module in [webroot]/profiles/farm/modules/contrib/entity/includes/entity.controller.inc and adding the lines from this patch: https://www.drupal.org/files/issues/2019-08-20/entity_postgresql_cleanids-3076175-2.patch

That should allow you to access /log/23.json without the Accept header.

I added the patch to farmOS’s Drush make file, so it will be automatically included in farmOS’s Entity API module moving forward.

Reopening this — the patch caused issues elsewhere in farmOS, so I rolled it back.

OK, I think I have it worked out pretty well. There is a new patch posted to this comment: https://www.drupal.org/project/entity/issues/3076175#comment-13231819

I’d like to test it a bit more myself in farmOS before merging it into farmOS, as it does have the potential to break things.

I’d love to hear back from the maintainers of the Entity API module about that patch as well, in case they have any insights about other potential issues. But I don’t think that module is actively maintained since it is part of Drupal 8 core now. So we may just have to patch it in farmOS as a crutch until we can upgrade to D8.

The same error is also triggered when deleting custom log types in admin/config/log/types:
PDOException: SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for integer: «survey» LINE 1: . tity WHERE entity_type = ‘log_type’ AND entity_id = ‘survey’ ^: DELETE FROM WHERE entity_type = :entity_type AND entity_id = :entity_id; Array ( [:entity_type] => log_type [:entity_id] => survey ) in farm_quick_entity_delete() (line 252 of /var/www/html/farmOS/profiles/farm/modules/farm/farm_quick/farm_quick.module).
Actually, that looks different, looks like it is passing the name of the log type to the DB, rather than the ID

That makes sense — the core issue lies in the way the Entity API module deals with entities that have a name-based ID in addition to a numerical ID, which is what custom entity types have.

My patch in that issue cover both cases that you came across. I do feel more confident with it now, if you want to test it out. Make sure you get the most recent patch from that thread.

Источник

Sqlstate 22p02 invalid text representation 7 error

Jobfieldofstudy::where(«id», $value)->delete();n n

Its for reference part- n

I am getting this error everywhere I use the ‘where’ clause. n

SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for integer: «HelloCareer» (SQL: select * from «access_tokens» where «access_tokens».»id» = HelloCareer limit 1) n

Here’s the full stacktrace. n

in Connection.php line 729nat Connection->runQueryCallback(‘select * from «access_tokens» where «access_tokens».»id» = ? limit 1’, array(‘HelloCareer’), object(Closure)) in Connection.php line 685nat Connection->run(‘select * from «access_tokens» where «access_tokens».»id» = ? limit 1’, array(‘HelloCareer’), object(Closure)) in Connection.php line 349nat Connection->select(‘select * from «access_tokens» where «access_tokens».»id» = ? limit 1’, array(‘HelloCareer’), true) in Builder.php line 1610nat Builder->runSelect() in Builder.php line 1596nat Builder->get(array(‘‘)) in Builder.php line 625nat Builder->getModels(array(‘ ‘)) in Builder.php line 316nat Builder->get(array(‘‘)) in Builder.php line 286nat Builder->first(array(‘ ‘)) in Builder.php line 167nat Builder->find(‘HelloCareer’)nat call_user_func_array(array(object(Builder), ‘find’), array(‘HelloCareer’)) in Model.php line 3526nat Model->__call(‘find’, array(‘HelloCareer’))nat call_user_func_array(array(object(Access_token), ‘find’), array(‘HelloCareer’)) in Model.php line 3540nat Model::__callStatic(‘find’, array(‘HelloCareer’)) in SMSOauth2Controller.php line 18nat SMSOauth2Controller->getAccessToken(‘HelloCareer’, ‘St85UchczVuSlVCtpUEl’, ‘5r3nZNbScW1aXW5Kx5xOd86’, ‘JXpd9NC8WFYbDLaEwJHfr4Xsy6X6szfqyuq’) in SMSOauth2Controller.php line 82nat SMSOauth2Controller->SendSms()nat call_user_func_array(array(object(SMSOauth2Controller), ‘SendSms’), array()) in Controller.php line 80nat Controller->callAction(‘SendSms’, array()) in ControllerDispatcher.php line 146nat ControllerDispatcher->call(object(SMSOauth2Controller), object(Route), ‘SendSms’) in ControllerDispatcher.php line 94nat ControllerDispatcher->Illuminate\Routing(object(Request))nat call_user_func(object(Closure), object(Request)) in Pipeline.php line 52nat Pipeline->Illuminate\Routing(object(Request))nat call_user_func(object(Closure), object(Request)) in Pipeline.php line 102nat Pipeline->then(object(Closure)) in ControllerDispatcher.php line 96nat ControllerDispatcher->callWithinStack(object(SMSOauth2Controller), object(Route), object(Request), ‘SendSms’) in ControllerDispatcher.php line 54nat ControllerDispatcher->dispatch(object(Route), object(Request), ‘App\Http\Controllers\SMSOauth2Controller’, ‘SendSms’) in Route.php line 174nat Route->runController(object(Request)) in Route.php line 140nat Route->run(object(Request)) in Router.php line 724nat Router->Illuminate\Routing(object(Request))nat call_user_func(object(Closure), object(Request)) in Pipeline.php line 52nat Pipeline->Illuminate\Routing(object(Request)) in Authenticate.php line 28nat Authenticate->handle(object(Request), object(Closure))nat call_user_func_array(array(object(Authenticate), ‘handle’), array(object(Request), object(Closure))) in Pipeline.php line 136nat Pipeline->Illuminate\Pipeline(object(Request))nat call_user_func(object(Closure), object(Request)) in Pipeline.php line 32nat Pipeline->Illuminate\Routing(object(Request)) in VerifyCsrfToken.php line 64nat VerifyCsrfToken->handle(object(Request), object(Closure))nat call_user_func_array(array(object(VerifyCsrfToken), ‘handle’), array(object(Request), object(Closure))) in Pipeline.php line 136nat Pipeline->Illuminate\Pipeline(object(Request))nat call_user_func(object(Closure), object(Request)) in Pipeline.php line 32nat Pipeline->Illuminate\Routing(object(Request)) in ShareErrorsFromSession.php line 49nat ShareErrorsFromSession->handle(object(Request), object(Closure))nat call_user_func_array(array(object(ShareErrorsFromSession), ‘handle’), array(object(Request), object(Closure))) in Pipeline.php line 136nat Pipeline->Illuminate\Pipeline(object(Request))nat call_user_func(object(Closure), object(Request)) in Pipeline.php line 32nat Pipeline->Illuminate\Routing(object(Request)) in StartSession.php line 64nat StartSession->handle(object(Request), object(Closure))nat call_user_func_array(array(object(StartSession), ‘handle’), array(object(Request), object(Closure))) in Pipeline.php line 136nat Pipeline->Illuminate\Pipeline(object(Request))nat call_user_func(object(Closure), object(Request)) in Pipeline.php line 32nat Pipeline->Illuminate\Routing(object(Request)) in AddQueuedCookiesToResponse.php line 37nat AddQueuedCookiesToResponse->handle(object(Request), object(Closure))nat call_user_func_array(array(object(AddQueuedCookiesToResponse), ‘handle’), array(object(Request), object(Closure))) in Pipeline.php line 136nat Pipeline->Illuminate\Pipeline(object(Request))nat call_user_func(object(Closure), object(Request)) in Pipeline.php line 32nat Pipeline->Illuminate\Routing(object(Request)) in EncryptCookies.php line 59nat EncryptCookies->handle(object(Request), object(Closure))nat call_user_func_array(array(object(EncryptCookies), ‘handle’), array(object(Request), object(Closure))) in Pipeline.php line 136nat Pipeline->Illuminate\Pipeline(object(Request))nat call_user_func(object(Closure), object(Request)) in Pipeline.php line 32nat Pipeline->Illuminate\Routing(object(Request))nat call_user_func(object(Closure), object(Request)) in Pipeline.php line 102nat Pipeline->then(object(Closure)) in Router.php line 726nat Router->runRouteWithinStack(object(Route), object(Request)) in Router.php line 699nat Router->dispatchToRoute(object(Request)) in Router.php line 675nat Router->dispatch(object(Request)) in Kernel.php line 246nat Kernel->Illuminate\Foundation\Http(object(Request))nat call_user_func(object(Closure), object(Request)) in Pipeline.php line 52nat Pipeline->Illuminate\Routing(object(Request)) in CheckForMaintenanceMode.php line 44nat CheckForMaintenanceMode->handle(object(Request), object(Closure))nat call_user_func_array(array(object(CheckForMaintenanceMode), ‘handle’), array(object(Request), object(Closure))) in Pipeline.php line 136nat Pipeline->Illuminate\Pipeline(object(Request))nat call_user_func(object(Closure), object(Request)) in Pipeline.php line 32nat Pipeline->Illuminate\Routing(object(Request))nat call_user_func(object(Closure), object(Request)) in Pipeline.php line 102nat Pipeline->then(object(Closure)) in Kernel.php line 132nat Kernel->sendRequestThroughRouter(object(Request)) in Kernel.php line 99nat Kernel->handle(object(Request)) in index.php line 53 n»,»bodyInMarkdown»:»I am getting this error everywhere I use the ‘where’ clause.rnrnex. rnrnSQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for integer: »HelloCareer» (SQL: select * from »access_tokens» where »access_tokens».»id» = HelloCareer limit 1)rnrnHere’s the full stacktrace.rnrnin Connection.php line 729rnat Connection->runQueryCallback(‘select * from »access_tokens» where »access_tokens».»id» = ? limit 1’, array(‘HelloCareer’), object(Closure)) in Connection.php line 685rnat Connection->run(‘select * from »access_tokens» where »access_tokens».»id» = ? limit 1’, array(‘HelloCareer’), object(Closure)) in Connection.php line 349rnat Connection->select(‘select * from »access_tokens» where »access_tokens».»id» = ? limit 1’, array(‘HelloCareer’), true) in Builder.php line 1610rnat Builder->runSelect() in Builder.php line 1596rnat Builder->get(array(‘*’)) in Builder.php line 625rnat Builder->getModels(array(‘*’)) in Builder.php line 316rnat Builder->get(array(‘*’)) in Builder.php line 286rnat Builder->first(array(‘*’)) in Builder.php line 167rnat Builder->find(‘HelloCareer’)rnat call_user_func_array(array(object(Builder), ‘find’), array(‘HelloCareer’)) in Model.php line 3526rnat Model->__call(‘find’, array(‘HelloCareer’))rnat call_user_func_array(array(object(Access_token), ‘find’), array(‘HelloCareer’)) in Model.php line 3540rnat Model::__callStatic(‘find’, array(‘HelloCareer’)) in SMSOauth2Controller.php line 18rnat SMSOauth2Controller->getAccessToken(‘HelloCareer’, ‘St85UchczVuSlVCtpUEl’, ‘5r3nZNbScW1aXW5Kx5xOd86’, ‘JXpd9NC8WFYbDLaEwJHfr4Xsy6X6szfqyuq’) in SMSOauth2Controller.php line 82rnat SMSOauth2Controller->SendSms()rnat call_user_func_array(array(object(SMSOauth2Controller), ‘SendSms’), array()) in Controller.php line 80rnat Controller->callAction(‘SendSms’, array()) in ControllerDispatcher.php line 146rnat ControllerDispatcher->call(object(SMSOauth2Controller), object(Route), ‘SendSms’) in ControllerDispatcher.php line 94rnat ControllerDispatcher->Illuminate\Routing\(object(Request))rnat call_user_func(object(Closure), object(Request)) in Pipeline.php line 52rnat Pipeline->Illuminate\Routing\(object(Request))rnat call_user_func(object(Closure), object(Request)) in Pipeline.php line 102rnat Pipeline->then(object(Closure)) in ControllerDispatcher.php line 96rnat ControllerDispatcher->callWithinStack(object(SMSOauth2Controller), object(Route), object(Request), ‘SendSms’) in ControllerDispatcher.php line 54rnat ControllerDispatcher->dispatch(object(Route), object(Request), ‘App\Http\Controllers\SMSOauth2Controller’, ‘SendSms’) in Route.php line 174rnat Route->runController(object(Request)) in Route.php line 140rnat Route->run(object(Request)) in Router.php line 724rnat Router->Illuminate\Routing\(object(Request))rnat call_user_func(object(Closure), object(Request)) in Pipeline.php line 52rnat Pipeline->Illuminate\Routing\(object(Request)) in Authenticate.php line 28rnat Authenticate->handle(object(Request), object(Closure))rnat call_user_func_array(array(object(Authenticate), ‘handle’), array(object(Request), object(Closure))) in Pipeline.php line 136rnat Pipeline->Illuminate\Pipeline\(object(Request))rnat call_user_func(object(Closure), object(Request)) in Pipeline.php line 32rnat Pipeline->Illuminate\Routing\(object(Request)) in VerifyCsrfToken.php line 64rnat VerifyCsrfToken->handle(object(Request), object(Closure))rnat call_user_func_array(array(object(VerifyCsrfToken), ‘handle’), array(object(Request), object(Closure))) in Pipeline.php line 136rnat Pipeline->Illuminate\Pipeline\(object(Request))rnat call_user_func(object(Closure), object(Request)) in Pipeline.php line 32rnat Pipeline->Illuminate\Routing\(object(Request)) in ShareErrorsFromSession.php line 49rnat ShareErrorsFromSession->handle(object(Request), object(Closure))rnat call_user_func_array(array(object(ShareErrorsFromSession), ‘handle’), array(object(Request), object(Closure))) in Pipeline.php line 136rnat Pipeline->Illuminate\Pipeline\(object(Request))rnat call_user_func(object(Closure), object(Request)) in Pipeline.php line 32rnat Pipeline->Illuminate\Routing\(object(Request)) in StartSession.php line 64rnat StartSession->handle(object(Request), object(Closure))rnat call_user_func_array(array(object(StartSession), ‘handle’), array(object(Request), object(Closure))) in Pipeline.php line 136rnat Pipeline->Illuminate\Pipeline\(object(Request))rnat call_user_func(object(Closure), object(Request)) in Pipeline.php line 32rnat Pipeline->Illuminate\Routing\(object(Request)) in AddQueuedCookiesToResponse.php line 37rnat AddQueuedCookiesToResponse->handle(object(Request), object(Closure))rnat call_user_func_array(array(object(AddQueuedCookiesToResponse), ‘handle’), array(object(Request), object(Closure))) in Pipeline.php line 136rnat Pipeline->Illuminate\Pipeline\(object(Request))rnat call_user_func(object(Closure), object(Request)) in Pipeline.php line 32rnat Pipeline->Illuminate\Routing\(object(Request)) in EncryptCookies.php line 59rnat EncryptCookies->handle(object(Request), object(Closure))rnat call_user_func_array(array(object(EncryptCookies), ‘handle’), array(object(Request), object(Closure))) in Pipeline.php line 136rnat Pipeline->Illuminate\Pipeline\(object(Request))rnat call_user_func(object(Closure), object(Request)) in Pipeline.php line 32rnat Pipeline->Illuminate\Routing\(object(Request))rnat call_user_func(object(Closure), object(Request)) in Pipeline.php line 102rnat Pipeline->then(object(Closure)) in Router.php line 726rnat Router->runRouteWithinStack(object(Route), object(Request)) in Router.php line 699rnat Router->dispatchToRoute(object(Request)) in Router.php line 675rnat Router->dispatch(object(Request)) in Kernel.php line 246rnat Kernel->Illuminate\Foundation\Http\(object(Request))rnat call_user_func(object(Closure), object(Request)) in Pipeline.php line 52rnat Pipeline->Illuminate\Routing\(object(Request)) in CheckForMaintenanceMode.php line 44rnat CheckForMaintenanceMode->handle(object(Request), object(Closure))rnat call_user_func_array(array(object(CheckForMaintenanceMode), ‘handle’), array(object(Request), object(Closure))) in Pipeline.php line 136rnat Pipeline->Illuminate\Pipeline\(object(Request))rnat call_user_func(object(Closure), object(Request)) in Pipeline.php line 32rnat Pipeline->Illuminate\Routing\(object(Request))rnat call_user_func(object(Closure), object(Request)) in Pipeline.php line 102rnat Pipeline->then(object(Closure)) in Kernel.php line 132rnat Kernel->sendRequestThroughRouter(object(Request)) in Kernel.php line 99rnat Kernel->handle(object(Request)) in index.php line 53″,»replies»:[],»user»:<«id»:100280,»username»:»asteway»,»avatar»:»//www.gravatar.com/avatar/366560ab03a429b7becd7c2598aa17d3?s=100&d=https%3A%2F%2Fs3.amazonaws.com%2Flaracasts%2Fimages%2Fforum%2Favatars%2Fdefault-avatar-24.png»,»experience»:<«award_count»:»0″,»level»:1,»points»:»180″,»pointsUntilNextLevel»:»4,820″>,»achievements»:[],»reported»:null,»staff»:false,»subscribed»:false,»profile»:<«full_name»:null,»bio»:null,»twitter»:»»,»github»:»»,»website»:»»,»employment»:»»,»job_title»:»Software Engineer»,»location»:»»,»flag»:null,»available_for_hire»:0>,»dateSegments»:<«created_diff»:»5 years ago»>,»settings»:<«show_profile»:true>,»links»:<«profile»:»https://laracasts.com/@asteway»>>,»likes»:[],»created_at»:»2017-12-10T08:16:45.000000Z»,»links»:<«delete»:»/discuss/replies/384116″,»like»:»/discuss/replies/384116/likes»,»best_answer»:»/discuss/conversations/76065/best»>,»best_answer»:false,»dateSegments»:<«createdDiff»:»5 years ago»>>,<«id»:384121,»conversation_id»:76065,»body»:»

• Laravel Version: 5.6.39
• PHP Version: 7.3.11
• Database Driver & Version:PostgreSQL 12

Description:

I have the following error while entering data in Store HELP ME PLZ:

SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for type integer: «» (SQL: insert into «pmieducar».»servidor_alocacao» («ref_usuario_cad», «ref_usuario_exc», «data_cadastro», «ano», «ref_cod_escola», «periodo», «data_admissao», «ref_cod_servidor_funcao», «ref_cod_funcionario_vinculo», «hora_inicial», «hora_final», «carga_horaria», «hora_atividade», «horas_excedentes») values (1, 1, 2019-11-27 10:34:05, 2019, 39, 1, 2018-10-26, , , 16:54:06, , 12:38:00, , ) returning «cod_servidor_alocacao»)

Controller
`<?php

namespace AppHttpControllersServidor;

use IlluminateHttpRequest;
use AppInstituicao;
use AppHttpControllersController;
use AppModelsServidorServidor;
use AppModelsServidorServidorAlocacao;
use AppModelsPmieducarEscola;
use AppModelsPortalFuncionarioVinculo;
use AppModelsServidorServidorFuncao;
use AppModelsServidorTipoFuncao;

class ServidorAlocacaoController extends Controller
{
private $rota = ‘Admin/servidor/servidor/alocao’;
// public $rotaAlocacao = ‘Admin/servidor/servidor/alocao’;
private $view = ‘admin.servidor.servidor.alocacao’;
private $titulo = ‘Alocação de Servidor’;

public function __construct(){
    view()->share('rota', 'alocacao.');
    // view()->shere('rota' , 'alocacao.');
    view()->share('titulo', $this->titulo);
    view()->share('instituicao', Instituicao::orderBy('nm_instituicao', 'asc')->get());
    view()->share('vinculo', FuncionarioVinculo::orderBy('cod_funcionario_vinculo' , 'asc')->get());
    view()->share('funcao', TipoFuncao::orderBy('cod_funcao' , 'asc')->get());

}


/**
 * Display a listing of the resource.
 *
 * @return IlluminateHttpResponse
 */
public function index($cod_servidor)
{
    
    $servidor = Servidor::find($cod_servidor);
    
    return view('Admin.servidor.servidor.alocacao.index' , compact('servidor'));

}

/**
 * Show the form for creating a new resource.
 *
 * @return IlluminateHttpResponse
 */
public function create($cod_servidor )
{
    
    


    $servidor = Servidor::find($cod_servidor);
    // return $servidor;        
    $escola = Escola::where('ref_cod_instituicao', $servidor->ref_cod_instituicao)->OrderBy('ref_cod_instituicao')->get();
    
    return view('Admin.servidor.servidor.alocacao.create' , compact('servidor' , 'escola'));


    //
}

/**
 * Store a newly created resource in storage.
 *
 * @param  IlluminateHttpRequest  $request
 * @return IlluminateHttpResponse
 */
public function store(Request $request , ServidorAlocacao $data)
{
    
    $data->carga_horaria               = $request->carga_horaria;
    $data->periodo                     = $request->periodo;
    $data->ref_cod_servidor_funcao     = $request->ref_cod_servidor_funcao;
    $data->ref_cod_funcionario_vinculo = $request->ref_cod_funcionario_vinculo;
    $data->ano                         = $request->ano;
    $data->data_admissao               = $request->data_admissao;
    $data->hora_inicial                = $request->hora_inicial;
    $data->hora_final                  = $request->hora_final;
    $data->hora_atividade              = $request->hora_atividade;
    $data->horas_excedentes            = $request->horas_excedentes;
// dd($data)        ;
    $data->save();

    if($data->fill($request->all())->save() != null){
        return redirect('Admin/servidor/servidor/alocacao/cod_servidor}')->with(['success' => 'Servidor alocado com sucesso.']);
    }else{
        return redirect('Admin/servidor/servidor/alocacao/{cod_servidor}')->with(['error' => 'Ocorreu um erro. Tente novamente mais tarde.']);
    }

}

/**
 * Display the specified resource.
 *
 * @param  int  $id
 * @return IlluminateHttpResponse
 */
public function show($id)
{
    //
}

/**
 * Show the form for editing the specified resource.
 *
 * @param  int  $id
 * @return IlluminateHttpResponse
 */
public function edit($id)
{
    //
}

/**
 * Update the specified resource in storage.
 *
 * @param  IlluminateHttpRequest  $request
 * @param  int  $id
 * @return IlluminateHttpResponse
 */
public function update(Request $request, $id)
{
    //
}

/**
 * Remove the specified resource from storage.
 *
 * @param  int  $id
 * @return IlluminateHttpResponse
 */
public function destroy($id)
{
    //
}

}
Model<?php

namespace AppModelsServidor;

use AppModelsPmieducarEscola;
use AppModelsPortalFuncionarioVinculo;
use IlluminateDatabaseEloquentModel;

class ServidorAlocacao extends Model
{
protected $table = ‘pmieducar.servidor_alocacao’;
protected $primaryKey = ‘cod_servidor_alocacao’;
protected $fillable = [‘cod_servidor_alocacao’, ‘ref_ref_cod_instituicao’, ‘ref_usuario_exc’,
‘ref_usuario_cad’, ‘ref_cod_escola’, ‘ref_cod_servidor’, ‘data_cadastro’, ‘data_exclusao’,
‘ativo’, ‘carga_horaria’, ‘periodo’, ‘ref_cod_servidor_funcao’, ‘ref_cod_funcionario_vinculo’,
‘ano’, ‘data_admissao’, ‘hora_inicial’, ‘hora_final’, ‘hora_atividade’, ‘horas_excedentes’,
];
public $timestamps = false;

public function servidor(){
    return $this->belongsTo(Servidor::class, 'ref_cod_servidor', 'cod_servidor');
}

public function escola(){
    return $this->belongsTo(Escola::class, 'ref_cod_escola', 'cod_escola');
}

public function funcao(){
    return $this->belongsTo(ServidorFuncao::class, 'ref_cod_servidor_funcao', 'cod_servidor_funcao');
}
public function vinculo(){
    return $this->belongsTo(FuncionarioVinculo::class, 'ref_cod_funcionario_vinculo', 'cod_funcionario_vinculo');
}

}
View@extends(‘dashboard.app’)

@section(‘htmlheader_title’)
— {{$titulo}}
@endsection

@section(‘contentheader_title’)
{{$titulo}}
@endsection

@section(‘contentheader_icon’)
fa-graduation-cap
@endsection

@section(‘main-content’)

                                </div><!-- /.form-group -->
                            </div><!-- /.col -->
                            <div class="col-md-6">
                                <div class="form-group">
                                    <label>Servidor:</label>
                                    <input class="form-control" type="text" disabled="disabled" name="" id="" 
                                    placeholder="{{$servidor->pessoa->nome}}">
                                </div><!-- /.form-group -->
                            </div><!-- /.col -->
                        </div><!-- /.row-->
                        <!-- row-->
                        <div class="row">
                            <div class="col-md-3">
                                <div class="form-group">
                                    <label>Carga Horária do Servidor:</label>
                                    <input class="form-control" type="text" disabled="disabled" name="" id="" 
                                    placeholder="{{$servidor->carga_horaria}} horas">                                    </div><!-- /.form-group -->
                                </div><!-- /.col -->
                                <div class="col-md-3">
                                    <div class="form-group">
                                        <label>Ano *:</label>
                                        <input class="form-control" type="text" name="ano" id="" required
                                        placeholder="Ano">                                    
                                    </div><!-- /.form-group -->
                                </div><!-- /.col -->
                                    <div class="col-md-6">
                                            <div class="form-group">
                                                <label>Escola *:</label>
                                                <select class="form-control" name="ref_cod_escola" id="" required>
                                                    <option value="ref_cod_escola">Selecione
                                                            
                                                    </option>
                                                    @if (isset($escola))
                                                        @foreach ($escola as $it)
                                                            <option value="{{$it->cod_escola}}"> {{$it->pessoa->nome}} </option>
                                                        @endforeach
                                                    @endif
                                                </select>                                   </div><!-- /.form-group -->
                                            </div><!-- /.col -->
                                    </div><!-- /.-->
                                    <div class="row">
                                            <div class="col-md-6">
                                                    <div class="form-group">
                                                        <label>Periodo *:</label>
                                                        <select required class="form-control" name="periodo" id="" required>
                                                            <option value="">Selecione</option>
                                                            <option value="1">Matutino</option>
                                                            <option value="2">Vespertino</option>
                                                            <option value="3">Noturno</option>
        
        
        
                                                        </select>
                                                    </div><!-- /.form-group -->
                                            </div><!-- /.col -->
                                            
                                            <div class="col-md-3">
                                                    <div class="form-group">
                                                        <label>Data de admissão :</label>
                                                        <input class="form-control" type="date" name="data_admissao" id="" 
                                                        placeholder="dd/mm/yyyy">                                    
                                                    </div><!-- /.form-group -->
                                            </div><!-- /.col -->
                                            
                                    </div><!-- /.row-->
                                    <div class="row">
                                            <div class="col-md-6">
                                                    <div class="form-group">
                                                        <label>Função *:</label>
                                                        <select required class="form-control" name="ref_cod_servidor_funcao" id="" >
                                                                <option value="">Selecione</option>
                                                            @if (isset($funcao))
                                                                @foreach ($funcao as $it)
                                                                    @if($it->cod_funcao !== null)
                                                                    <option value="{{$it->ref_cod_servidor_funcao}}"> {{$it->nm_funcao}} </option>
                                                                    @endif
                                                                @endforeach
                                                            @endif
            
            
            
                                                            </select>                        
                                                    </div><!-- /.form-group -->
                                            </div><!-- /.col -->  
                                            <div class="col-md-6">
                                                    <div class="form-group">
                                                        <label>Vunculo *:</label>
                                                        <select required class="form-control" name="ref_cod_funcionario_vinculo" id="" >
                                                                <option value="">Selecione</option>
                                                                
                                                            @if (isset($vinculo))
                                                                @foreach ($vinculo as $it)
                                                                    @if($it->cod_funcionario_vinculo !== null)
                                                                    <option value="{{$it->ref_cod_funcionario_vinculo}}"> {{$it->nm_vinculo}} </option>
                                                                    @endif
                                                                @endforeach
                                                            @endif
            
            
                                                            </select>                        
                                                    </div><!-- /.form-group -->
                                            </div><!-- /.col -->  
                                    </div>
                                </div><!-- /.-->
                                <div class="card-header">
                                        <h3 class="mb-0">Informações Sobre Carga Horaria</h3>
                                </div>
                                <div class="row">
                                    
                                    
                                    <div class="col-md-2">
                                            <div class="form-group">
                                                <label>Horario de Início:</label>
                                                <input class="form-control" type="time" step="2" name="hora_inicial" id="" 
                                                >                                    
                                            </div><!-- /.form-group -->
                                    </div><!-- /.col -->
                                    <div class="col-md-2">
                                            <div class="form-group">
                                                <label>Horario de termíno:</label>
                                                <input class="form-control" type="time" step="2" name="hora_final" id="" 
                                                >                                    
                                            </div><!-- /.form-group -->
                                    </div><!-- /.col -->  
                                    <div class="col-md-2">
                                        <div class="form-group">
                                            <label>Carga horária *:</label>
                                            <input class="form-control" type="time" step="2" name="carga_horaria" id="carga_horaria" 
                                            required>                                    
                                        </div><!-- /.form-group -->
                                </div><!-- /.col --> 
                                <div class="col-md-2">
                                    <div class="form-group">
                                        <label>Hora atividade:</label>
                                        <input class="form-control" type="time" step="2" name="hora_atividade" id="" 
                                        >                                    
                                    </div><!-- /.form-group -->
                            </div><!-- /.col --> 
                            <div class="col-md-2">
                                <div class="form-group">
                                    <label>Horas excedentes:</label>
                                    <input class="form-control" type="time" step="2" name="horas_excedentes" id="" 
                                    >                                    
                                </div><!-- /.form-group -->
                            </div><!-- /.col --> 
                            </div><!-- /.row-->
                            <div class="row">
                            </div>
                        
                        

                        <div style="width:100%;text-align:center">
                            <div class="form-group ">
                                <button class="btn btn-primary" type="submit">Salvar</button>
                                <a class="btn btn-danger" href="{{route($rota.'index' , $servidor->cod_servidor)}}"> Voltar </a>
                            </div>
                        </div>
                    </form>
                </div>
            </div>

        </div>
    </div>
</div>

PASSED: [[SimpleTest]]: [MySQL] 41,464 pass(es). View

PASSED: [[SimpleTest]]: [MySQL] 41,463 pass(es). View

PASSED: [[SimpleTest]]: [MySQL] 41,456 pass(es). View

FAILED: [[SimpleTest]]: [MySQL] Drupal installation failed. View

PASSED: [[SimpleTest]]: [MySQL] 41,137 pass(es). View

PASSED: [[SimpleTest]]: [PHP 5.4 MySQL] 79,483 pass(es). View

PASSED: [[SimpleTest]]: [PHP 5.4 MySQL] 79,029 pass(es). View

FAILED: [[SimpleTest]]: [PHP 5.4 MySQL] 78,913 pass(es), 14 fail(s), and 0 exception(s). View

FAILED: [[SimpleTest]]: [PHP 5.4 MySQL] 78,855 pass(es), 14 fail(s), and 0 exception(s). View

FAILED: [[SimpleTest]]: [PHP 5.4 MySQL] Unable to apply patch 1003788-172-drupal7_0.patch. Unable to apply patch. See the log in the details link for more information. View

PASSED: [[SimpleTest]]: [PHP 5.4 MySQL] 72,959 pass(es). View

PASSED: [[SimpleTest]]: [PHP 5.4 MySQL] 72,903 pass(es). View

PASSED: [[SimpleTest]]: [PHP 5.4 MySQL] 72,736 pass(es). View

PASSED: [[SimpleTest]]: [PHP 5.4 MySQL] 72,774 pass(es). View

PASSED: [[SimpleTest]]: [PHP 5.4 MySQL] 72,734 pass(es). View

FAILED: [[SimpleTest]]: [PHP 5.4 MySQL] Drupal installation failed. View

PASSED: [[SimpleTest]]: [MySQL] 41,155 pass(es). View

PASSED: [[SimpleTest]]: [PHP 5.4 MySQL] 72,572 pass(es). View

PASSED: [[SimpleTest]]: [PHP 5.4 MySQL] 72,551 pass(es). View

PASSED: [[SimpleTest]]: [PHP 5.4 MySQL] 72,555 pass(es). View

PASSED: [[SimpleTest]]: [PHP 5.4 MySQL] 72,553 pass(es). View

PASSED: [[SimpleTest]]: [PHP 5.4 MySQL] 72,551 pass(es). View

PASSED: [[SimpleTest]]: [PHP 5.4 MySQL] 72,547 pass(es). View

PASSED: [[SimpleTest]]: [PHP 5.4 MySQL] 72,510 pass(es). View

PASSED: [[SimpleTest]]: [PHP 5.4 MySQL] 67,817 pass(es). View

PASSED: [[SimpleTest]]: [PHP 5.4 MySQL] 67,883 pass(es). View

FAILED: [[SimpleTest]]: [PHP 5.4 MySQL] Drupal installation failed. View

PASSED: [[SimpleTest]]: [MySQL] 63,686 pass(es). View

FAILED: [[SimpleTest]]: [MySQL] Unable to apply patch 1003788-8.x-entity-id-datatype-support_0.patch. Unable to apply patch. See the log in the details link for more information. View

FAILED: [[SimpleTest]]: [MySQL] Drupal installation failed. View

PASSED: [[SimpleTest]]: [MySQL] 34,240 pass(es). View

FAILED: [[SimpleTest]]: [MySQL] Unable to apply patch 1003788-70-drupal7.patch. Unable to apply patch. See the log in the details link for more information. View

FAILED: [[SimpleTest]]: [MySQL] Unable to apply patch 1003788-57-drupal7.patch. Unable to apply patch. See the log in the details link for more information. View

FAILED: [[SimpleTest]]: [MySQL] Fetch test patch: failed to retrieve [1003788 drupal 7.9 with other changes.patch] from [drupal.org]. View

PASSED: [[SimpleTest]]: [MySQL] 33,148 pass(es). View

FAILED: [[SimpleTest]]: [MySQL] 33,151 pass(es), 1 fail(s), and 0 exception(es). View

FAILED: [[SimpleTest]]: [MySQL] 32,909 pass(es), 28 fail(s), and 31 exception(es). View

FAILED: [[SimpleTest]]: [MySQL] 29,462 pass(es), 1 fail(s), and 0 exception(es). View

FAILED: [[SimpleTest]]: [MySQL] 29,400 pass(es), 1 fail(s), and 0 exception(es). View

PASSED: [[SimpleTest]]: [MySQL] 29,879 pass(es). View

FAILED: [[SimpleTest]]: [MySQL] Unable to apply patch non-int-entity-ids.diff. View

FAILED: [[SimpleTest]]: [MySQL] 31,315 pass(es), 2 fail(s), and 5,699 exception(es). View

FAILED: [[SimpleTest]]: [MySQL] 31,236 pass(es), 2 fail(s), and 5,723 exception(es). View