Results 1 to 4 of 4

Thread: MySQL Error 1054

  1. #1
    Join Date
    Jun 2009
    Posts
    105

    MySQL Error 1054

    I have a small site developed in vBulletin and MySQL. I am having problem with this site. I am getting the error message as "MySQL error: 1054 - Unknown column 'languagesId' in 'field list'". I recently upgraded my database to MySQL 5.0. How can I get rid of MySQL error 1054?

  2. #2
    Join Date
    Nov 2008
    Posts
    1,054

    Re: MySQL Error 1054

    This is a small bug in MySQL 5. It occurs if you are using LEFT JOIN in your query. If you want to get rid of this error message then temporarily don't use LEFT JOIN in your query. I hope developer of MYSQL will sooner come up with some patches or something that will fix this problem.

  3. #3
    Join Date
    May 2008
    Posts
    2,393

    Re: MySQL Error 1054

    Check your config.php file and make sure it is similar to as given below:

    'dbconfig' =>
    array (
    'db_host_name' => 'localhost',
    'db_host_instance' => '',
    'db_user_name' => 'opaper',
    'db_password' => 'opaper',
    'db_name' => 'opaper',
    'db_type' => 'mysql', ),
    Here replace "opaper" with your user name, password and database name respectively.

  4. #4
    Join Date
    Nov 2008
    Posts
    996

    Re: MySQL Error 1054

    Simply change your query to one below (for example):

    Code:
    SELECT id, field1, field2, field3
    FROM ( table1, table2 )
    LEFT OUTER JOIN condition1
    ON condition2
    WHERE condition3;
    So the most important changes that you should implement is use parenthesis in your FROM clause.

Similar Threads

  1. Replies: 3
    Last Post: 07-11-2009, 08:36 PM
  2. URGENT! 1054, windows cannot obtain the domain controller name
    By hatred in forum Small Business Server
    Replies: 3
    Last Post: 04-12-2007, 02:29 PM
  3. Error: Userenv 1054 on domain controller
    By Vicious in forum Active Directory
    Replies: 2
    Last Post: 01-10-2007, 08:54 PM
  4. Eventid 1054 on DC's
    By Meng R in forum Active Directory
    Replies: 1
    Last Post: 24-09-2007, 09:19 PM
  5. Domain Controller getting Event 1054 Source Userenv
    By !Starr! in forum Active Directory
    Replies: 3
    Last Post: 26-07-2007, 01:36 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •