Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



MySQL Error 1054

Software Development


Reply
 
Thread Tools Search this Thread
  #1  
Old 03-09-2009
Member
 
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?

Reply With Quote
  #2  
Old 03-09-2009
Member
 
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.
Reply With Quote
  #3  
Old 03-09-2009
Member
 
Join Date: May 2008
Posts: 2,383
Re: MySQL Error 1054

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

Quote:
'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.
__________________
The FIFA Manager 2009 PC Game
Reply With Quote
  #4  
Old 03-09-2009
Member
 
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.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "MySQL Error 1054"
Thread Thread Starter Forum Replies Last Post
Mysql Error : Can't connect to local mysql server through socket ' var lib mysql mysql.sock' 2 roshan45 Software Development 3 07-11-2009 08:36 PM
URGENT! 1054, windows cannot obtain the domain controller name hatred Small Business Server 3 04-12-2007 02:29 PM
Error: Userenv 1054 on domain controller Vicious Active Directory 2 01-10-2007 08:54 PM
Eventid 1054 on DC's Meng R Active Directory 1 24-09-2007 09:19 PM
Domain Controller getting Event 1054 Source Userenv !Starr! Active Directory 3 26-07-2007 01:36 PM


All times are GMT +5.5. The time now is 06:19 PM.