MedicOneSystems / MedicOneSystems/livewire-datatables

error SQLSTATE[42S22] - 1054 with export

Open
#484 8 comments 1 reaction 0 assignees View on GitHub

Nobody has claimed this yet.

Dominant language
PHP
Stars
1.2k
Forks
257
PR merge metrics
No merged PRs in 30d

Description

Hi

when I export some datatable I have this message:
SQLSTATE[42S22]: Column not found: 1054 Unknown column

The column is a relation like : post.name

My config

        "php": "^7.3|^8.0", ->php 7.4  
        "bonecms/laravel-captcha": "^2.2",  
        "fideloper/proxy": "^4.4",  
        "fruitcake/laravel-cors": "^2.0",  
        "guzzlehttp/guzzle": "^6.5",  
        "intervention/image": "^2.7",  
        "laravel-frontend-presets/tall": "^3.1",  
        "laravel-lang/lang": "~8.0",  
        "laravel/fortify": "^1.7",  
        "laravel/framework": "^8.12",  
        "laravel/horizon": "^5.9",  
        "laravel/tinker": "^2.5",  
        "livewire-ui/modal": "^1.0",  
        "livewire/livewire": "^2.4",  
        "mediconesystems/livewire-datatables": "^0.7.0",  
        "phpsa/laravel-yourls-plugin": "^1.2"  

someone to help me ? ;)

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start by reproducing a datatable export that includes the relation column post.name, then trace the export and query path in the repository. The issue does not name files or tests; done means the export completes without the SQLSTATE[42S22] unknown-column error for relation columns.

Written by the indexing model from the issue text.

Assessment

Tech stack
laravel, php
Domain
backend, databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.