doctrine/archived-orm
1
0
Fork 0
mirror of https://github.com/doctrine/orm.git synced 2026-03-24 06:52:09 +01:00
Code Issues 5.3k Packages Projects Releases 100 Wiki Activity

MariaDB : Column not found: 1054 Unknown column 'x.TABLE_NAME' in 'on clause' #7231

New Issue
Closed
opened 2026-01-22 15:47:34 +01:00 by admin · 5 comments
admin commented 2026-01-22 15:47:34 +01:00
Owner
Copy Link

Originally created by @jeremyrncp on GitHub (Oct 16, 2023).

Bug Report

MariaDB : Column not found: 1054 Unknown column 'x.TABLE_NAME' in 'on clause'

Q A
doctrine/ORM 2.16.2

Summary

When running bin/console doctrine:schema:validate, i have an error SQLSTATE[42S22]: Column not found: 1054 Unknown column 'x.TABLE_NAME' in 'on claus e'

Current behavior

How to reproduce

bin/console doctrine:schema:validate

Mapping
-------

                                                                                                                       
[OK] The mapping files are correct.                                                                                    
                                                                                                                       

Database
--------

[critical] Error thrown while running command "doctrine:schema:validate". Message: "An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'x.TABLE_NAME' in 'on clause'"

In ExceptionConverter.php line 67:
                                                                                                                                    
 An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'x.TABLE_NAME' in 'on claus  
 e'                                                                                                                                 
                                                                                                                                    

In Exception.php line 28:
                                                                                       
 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'x.TABLE_NAME' in 'on clause'  
                                                                                       

In Statement.php line 130:
                                                                                       
 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'x.TABLE_NAME' in 'on clause'  
                                                                                       
doctrine:schema:validate [--em EM] [--skip-mapping] [--skip-sync]

Expected behavior

Originally created by @jeremyrncp on GitHub (Oct 16, 2023). ### Bug Report MariaDB : Column not found: 1054 Unknown column 'x.TABLE_NAME' in 'on clause' | Q | A |------------ | ------ | doctrine/ORM | 2.16.2 #### Summary When running bin/console doctrine:schema:validate, i have an error SQLSTATE[42S22]: Column not found: 1054 Unknown column 'x.TABLE_NAME' in 'on claus e' #### Current behavior <!-- What is the current (buggy) behavior? --> #### How to reproduce ``` bin/console doctrine:schema:validate Mapping ------- [OK] The mapping files are correct. Database -------- [critical] Error thrown while running command "doctrine:schema:validate". Message: "An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'x.TABLE_NAME' in 'on clause'" In ExceptionConverter.php line 67: An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'x.TABLE_NAME' in 'on claus e' In Exception.php line 28: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'x.TABLE_NAME' in 'on clause' In Statement.php line 130: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'x.TABLE_NAME' in 'on clause' doctrine:schema:validate [--em EM] [--skip-mapping] [--skip-sync] ``` #### Expected behavior <!-- What was the expected (correct) behavior? -->
admin closed this issue 2026-01-22 15:47:35 +01:00
admin commented 2026-01-22 15:47:36 +01:00
Author
Owner
Copy Link

@jeremyrncp commented on GitHub (Oct 17, 2023):

Bug fixed with modify key serverVersion of DATABASE_URL in .env

@jeremyrncp commented on GitHub (Oct 17, 2023): Bug fixed with modify key serverVersion of DATABASE_URL in .env
admin commented 2026-01-22 15:47:36 +01:00
Author
Owner
Copy Link

@NetworkDevHead commented on GitHub (Mar 18, 2024):

To elaborate on @jeremyrncp you can just completely remove the version .e.g ?serverVersion=mariadb-10.4.11 from the DATABASE_URL to solve

@NetworkDevHead commented on GitHub (Mar 18, 2024): To elaborate on @jeremyrncp you can just completely remove the version .e.g ?serverVersion=mariadb-10.4.11 from the DATABASE_URL to solve
admin commented 2026-01-22 15:47:36 +01:00
Author
Owner
Copy Link

@ErickGabrielLira commented on GitHub (Jun 5, 2024):

Thank you all, friends!

@ErickGabrielLira commented on GitHub (Jun 5, 2024): Thank you all, friends!
admin commented 2026-01-22 15:47:36 +01:00
Author
Owner
Copy Link

@kusman28 commented on GitHub (Sep 8, 2024):

To elaborate on @jeremyrncp you can just completely remove the version .e.g ?serverVersion=mariadb-10.4.11 from the DATABASE_URL to solve

This one works for me!

@kusman28 commented on GitHub (Sep 8, 2024): > To elaborate on @jeremyrncp you can just completely remove the version .e.g ?serverVersion=mariadb-10.4.11 from the DATABASE_URL to solve This one works for me!
admin commented 2026-01-22 15:47:36 +01:00
Author
Owner
Copy Link

@mahmutaydin1 commented on GitHub (Jan 17, 2025):

To elaborate on @jeremyrncp you can just completely remove the version .e.g ?serverVersion=mariadb-10.4.11 from the DATABASE_URL to solve

thank you

@mahmutaydin1 commented on GitHub (Jan 17, 2025): > To elaborate on [@jeremyrncp](https://github.com/jeremyrncp) you can just completely remove the version .e.g ?serverVersion=mariadb-10.4.11 from the DATABASE_URL to solve thank you
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
BC Break
Bug
Can't Fix
Deprecation
Documentation
DQL
Duplicate
Failing Test
Hacktoberfest
Improvement
Improvement
Incomplete
Invalid
Missing Tests
New Feature
PR Created
pull-request
Mirrored from GitHub Pull Request
 Question
Regression
Status: Waiting feedback
Waiting feedback
WIP
Won't Fix
No Label
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
admin
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: doctrine/archived-orm#7231
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?