Troubleshooting of MySQL errors: Difference between revisions

Jump to navigation Jump to search

Troubleshooting of MySQL errors (edit)

Revision as of 19:13, 12 May 2024

882 bytes removed ,  12 May 2024
m
→‎ERROR 1054 - Unknown column in 'where clause'
Line 41: Line 41:
References
References
* [https://mysqldump.guru/mysqldump-got-errno-32-on-write.html mysqldump: Got errno 32 on write | mysqldump.guru]
* [https://mysqldump.guru/mysqldump-got-errno-32-on-write.html mysqldump: Got errno 32 on write | mysqldump.guru]
== ERROR 1054 - Unknown column in 'where clause' ==
Message: [Err] 1054 - Unknown column 'xxx' in 'where clause'
Solution:
# check the column name 'xxx' if exists
# if the column name 'xxx' was computed by the [http://dev.mysql.com/doc/refman/5.7/en/example-user-variables.html User-Defined Variables]. Enclosed the whole query into another parent derived query.
<pre>
-- The query which met the error message: [Err] 1054 - Unknown column 'rank' in 'where clause'
SELECT semi.*, IF(semi.id = semi.prev, @rank := @rank +1, @rank := 1 ) AS `rank` 
FROM
(
        ...
) semi
WHERE semi.rank <= 10
</pre>
Enclosed the whole query into another parent derived query.
<pre>
SELECT final.*
FROM
(
        SELECT semi.*, IF(semi.id = semi.prev, @rank := @rank +1, @rank := 1 ) AS `rank` 
        FROM
        (
                ...
        ) semi
) final
WHERE final.rank <= 10
</pre>


== ERROR 1114 (HY000): The table `TABLE_NAME` is full ==
== ERROR 1114 (HY000): The table `TABLE_NAME` is full ==
Retrieved from "https://wiki.planetoid.info/index.php/Special:MobileDiff/24735"

Navigation menu