[PROMOÇÃO] Assine com + 30% de desconto ANUAL MENSAL (últimas horas)
Jean Silva
Criador Jean Silva 02/08/2022

Boa tarde!

Por algum motivo meu telescope não retorna os detalhes das informações como em seu exemplo, mesmo seguindo a risca a documentação, ele aparece a seguinte informação no momento que tento visualizar os detalhes No entry found.

Poderia me ajudar, por favor?.

 

Manager Carlos Ferreira 02/08/2022

Olá, Jean!
Tudo bem?

Ajudo sim, claro.

Tem o projeto no GitHub?

Qual o seu setup? Docker?

Carlos Ferreira
Criador Jean Silva 02/08/2022

Olá Professor, bom dia!

Segue o repositorio, esse projeto é profissional, então deixei privado para o seu acesso carlosfgti, se puder me ajudar, agradeço.

Front (Vuejs, Ts) : https://github.com/jeanasilva/job_pro_front.git

Back: (Laravel, Docker) : https://github.com/jeanasilva/job_pro.git

Grato.

Jean Silva
Manager Carlos Ferreira 02/08/2022

Olá, Jean!
Tudo bem?

Olhei agora o seu backend, aparentemente está tudo certo.

Experimenta limpar os arquivos em cache, segue os comandos:
php artisan cache:clear
php artisan route:clear
php artisan config:clear
php artisan view:clear

Carlos Ferreira
Criador Jean Silva 02/08/2022

Olá professor, bom dia!

Não funcionou com as informações, eu verifiquei que existe um arquivo de log do laravel, e está informando os seguintes erros abaixo no log.

[previous exception] [object] (Yajra\\Pdo\\Oci8\\Exceptions\\Oci8Exception(code: 942): Error Code    : 942

Error Message : ORA-00942: table or view does not exist

Position      : 12

Statement     : insert into \"TELESCOPE_ENTRIES_TAGS\" (\"ENTRY_UUID\", \"TAG\") select :p0, :p1 from dual union all select :p2, :p3 from dual union all select :p4, :p5 from dual union all select :p6, :p7 from dual union all select :p8, :p9 from dual union all select :p10, :p11 from dual union all select :p12, :p13 from dual union all select :p14, :p15 from dual 

Bindings      : [96f310d2-ba4c-42af-8c5b-cab353573768,Laravel\\Sanctum\\PersonalAccessToken,96f310d2-c730-440d-bbff-8447f170dd1d,App\\Models\\User,96f310d2-c79c-4170-bb3f-f08d0e70b12b,Laravel\\Sanctum\\PersonalAccessToken:921,96f310d2-cecb-4727-9079-27e68f687e92,Laravel\\Sanctum\\PersonalAccessToken:921,96f310d2-d0e8-4ff4-9522-6b15ff83fc3a,Auth:361910e3-c173-c061-e053-20fb96965d02,96f310d2-e3a2-44e4-9e2b-14b890336746,Auth:361910e3-c173-c061-e053-20fb96965d02,96f310d2-fd2e-4b6c-9516-8219bd49ab15,Auth:361910e3-c173-c061-e053-20fb96965d02,96f310d3-3c76-438e-bb94-589f69ebace9,Auth:361910e3-c173-c061-e053-20fb96965d02]

 at C:\\laragon\\www\\Back-end\\isos-backend\\vendor\\yajra\\laravel-pdo-via-oci8\\src\\Pdo\\Oci8\\Statement.php:753)

[stacktrace]

#0 C:\\laragon\\www\\Back-end\\isos-backend\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(544): Yajra\\Pdo\\Oci8\\Statement->execute()

#1 C:\\laragon\\www\\Back-end\\isos-backend\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(752): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}('insert into \"TE...', Array)

#2 C:\\laragon\\www\\Back-end\\isos-backend\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(719): Illuminate\\Database\\Connection->runQueryCallback('insert into \"TE...', Array, Object(Closure))

#3 C:\\laragon\\www\\Back-end\\isos-backend\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(545): Illuminate\\Database\\Connection->run('insert into \"TE...', Array, Object(Closure))

#4 C:\\laragon\\www\\Back-end\\isos-backend\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(497): Illuminate\\Database\\Connection->statement('insert into \"TE...', Array)

#5 C:\\laragon\\www\\Back-end\\isos-backend\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Query\\Builder.php(3198): Illuminate\\Database\\Connection->insert('insert into \"TE...', Array)

#6 C:\\laragon\\www\\Back-end\\isos-backend\\vendor\\laravel\\telescope\\src\\Storage\\DatabaseEntriesRepository.php(199): Illuminate\\Database\\Query\\Builder->insert(Array)

#7 C:\\laragon\\www\\Back-end\\isos-backend\\vendor\\laravel\\framework\\src\\Illuminate\\Collections\\Traits\\EnumeratesValues.php(264): Laravel\\Telescope\\Storage\\DatabaseEntriesRepository->Laravel\\Telescope\\Storage\\{closure}(Object(Illuminate\\Support\\Collection), 0)

#8 C:\\laragon\\www\\Back-end\\isos-backend\\vendor\\laravel\\telescope\\src\\Storage\\DatabaseEntriesRepository.php(200): Illuminate\\Support\\Collection->each(Object(Closure))

#9 C:\\laragon\\www\\Back-end\\isos-backend\\vendor\\laravel\\telescope\\src\\Storage\\DatabaseEntriesRepository.php(151): Laravel\\Telescope\\Storage\\DatabaseEntriesRepository->storeTags(Object(Illuminate\\Support\\Collection))

#10 C:\\laragon\\www\\Back-end\\isos-backend\\vendor\\laravel\\telescope\\src\\Telescope.php(663): Laravel\\Telescope\\Storage\\DatabaseEntriesRepository->store(Object(Illuminate\\Support\\Collection))

#11 [internal function]: Laravel\\Telescope\\Telescope::Laravel\\Telescope\\{closure}()

#12 C:\\laragon\\www\\Back-end\\isos-backend\\vendor\\laravel\\telescope\\src\\Telescope.php(284): call_user_func(Object(Closure))

#13 C:\\laragon\\www\\Back-end\\isos-backend\\vendor\\laravel\\telescope\\src\\Telescope.php(674): Laravel\\Telescope\\Telescope::withoutRecording(Object(Closure))

#14 C:\\laragon\\www\\Back-end\\isos-backend\\vendor\\laravel\\telescope\\src\\ListensForStorageOpportunities.php(65): Laravel\\Telescope\\Telescope::store(Object(Laravel\\Telescope\\Storage\\DatabaseEntriesRepository))

#15 C:\\laragon\\www\\Back-end\\isos-backend\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\BoundMethod.php(36): Laravel\\Telescope\\Telescope::Laravel\\Telescope\\{closure}()

#16 C:\\laragon\\www\\Back-end\\isos-backend\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\Util.php(41): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()

#17 C:\\laragon\\www\\Back-end\\isos-backend\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\BoundMethod.php(81): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))

#18 C:\\laragon\\www\\Back-end\\isos-backend\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\BoundMethod.php(37): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Illuminate\\Foundation\\Application), Object(Closure), Object(Closure))

#19 C:\\laragon\\www\\Back-end\\isos-backend\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\Container.php(651): Illuminate\\Container\\BoundMethod::call(Object(Illuminate\\Foundation\\Application), Object(Closure), Array, NULL)

#20 C:\\laragon\\www\\Back-end\\isos-backend\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Application.php(1172): Illuminate\\Container\\Container->call(Object(Closure))

#21 C:\\laragon\\www\\Back-end\\isos-backend\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(182): Illuminate\\Foundation\\Application->terminate()

#22 C:\\laragon\\www\\Back-end\\isos-backend\\public\\index.php(55): Illuminate\\Foundation\\Http\\Kernel->terminate(Object(Illuminate\\Http\\Request), Object(Illuminate\\Http\\JsonResponse))

#23 C:\\laragon\\www\\Back-end\\isos-backend\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\

esources\\server.php(16): require_once('C:\\\\laragon\\\\www\\\\...')

 

Jean Silva
Manager Carlos Ferreira 02/08/2022

Está faltando uma tabela no banco.

Quando rodou o migration do telescope, gerou algum erro? Qual?
php artisan migrate

Carlos Ferreira
Criador Jean Silva 02/08/2022

Olá professor, bom dia!

Aqui estou usando Oracle, e então a única forma que achei para conectar com o db oracle foi usar essa lib da Yajra, fiz o migrate:fresh.

 

 C:\laragon\www\Back-end\isos-backend\vendor\yajra\laravel-pdo-via-oci8\src\Pdo\Oci8\Statement.php:753

      Yajra\Pdo\Oci8\Exceptions\Oci8Exception::("Error Code    : 2270

Error Message : ORA-02270: no matching unique or primary key for this column-list

Position      : 192

Statement     : create table telescope_entries_tags ( entry_uuid char(36) not null, tag varchar2(255) not null, constraint telesco_entri_ta_ent_uu_fk foreign key ( entry_uuid ) references telescope_entries ( uuid ) on delete cascade )

Bindings      : []

")

 

  2   C:\laragon\www\Back-end\isos-backend\vendor\laravel\framework\src\Illuminate\Database\Connection.php:544

      Yajra\Pdo\Oci8\Statement::execute()

Jean Silva
Manager Carlos Ferreira 02/08/2022

O banco de dados Oracle necessita que a primary key da tabela relacionada exista.

O telescope relaciona com uma coluna "uuid", por isso o "erro": https://github.com/especializati/curso-laravel-api-cache/blob/main/database/migrations/2018_08_08_100000_create_telescope_entries_table.php#L62

Mude o seu arquivo de migration, para atender aos requisitos do Oracle.

php artisan vendor:publish --tag=telescope-migrations

Carlos Ferreira
Criador Jean Silva 02/08/2022

Vlwww, obrigadoo.

Jean Silva
Sabe a Solução? Ajude a resolver!

Precisa estar logado para conseguir responder a este ticket!

Clique Aqui Para Entrar!