ERROR 1052 in MySQL 4 !!!!! please help

web_designer_iq

Hi
I'm using PHP 4.4.1 and MySQL 5.0.16 in localhost (Windows XP SP2).
Now i sent the database to web server, And the SQL statements not correctly on web server.
Note: (Web Server) using MySQL 4.xx

for example i can't use the (inner):

SELECT
posts.post_id,

IF(posts.user_id != -1, users.full_name, posts.poster_name) AS name,
DATE_FORMAT(posts.post_time + INTERVAL 3 HOUR, '%d/%m/%Y %H:%i:%s') AS post_time,
posts.title,
cats.title AS cat_title,
posts.head,

IF(posts.img != NULL && posts.img != '', NULL, posts.img ) AS img,
posts.img_width_thumb,
posts.img_height_thumb,
posts.sum_read,
posts.how_see,
users.user_id

FROM

portal_posts AS posts NATURAL LEFT JOIN portal_users AS users
INNER JOIN portal_categories AS cats USING(cat_id)

WHERE

posts.visibility = 1 && posts.is_accept = 1
&& (lang = 'all' || lang = 'arabic')

ERROR is:
ERROR 1052 (23000): Column 'lang' in where clause is ambiguous

I deleted the lang from where clause but the following error show:

ERROR 1054 (42S22): Unknown column 'portal_portal.users.cat_id' in 'on clause'

I don't know why! The error from MySQL version or from what??

Please help..

Note: It's working in localhost + windows OS + MySQL 5.xx without any error

Thanks

ClarkF1

Have you tried putting a table name before the lang e.g. posts.lang

web_designer_iq

Thank you very much sir 🙂
It's fixed.
But i have a problem:
ERROR 1054 (42S22): Unknown column 'portal_portal.users.cat_id' in 'on clause'

What's the error please? it's from "inner" or what ?
Thank you 🙂

leatherback

Just a little note: You probably want to install the same versions on your localhost as you have on the online server, as these problems could probably all be traced back to version issues..

web_designer_iq

Thank you sir 🙂
But i can't upgrade MySQL now!
I can replace the (inner) but i don't want do it. It's easy & right way to use the (inner) betwen tables.
Any idea please?

bpat1434

Try specifying the inner join, rather than using "USING()".

INNER JOIN portal_categories AS cats ON posts.cat_id = cats.cat_id

The issue here is that you've got a left join just before the inner join. I think (though I can't be certain) that mySQL in 4.0 processes it in a left to right fashion. So if you have your original table, then join an arbitrary table, then join a third, the third will join to the arbitrary table unless you specify what to join it on.

mySQL Documentation wrote:
Note that several changes in join processing were made in MySQL 5.0.12 to make MySQL more compliant with standard SQL. These changes include the ability to handle nested joins (including outer joins) according to the standard. If a nested join returns results that are not what you expect, please consider upgrading to MySQL 5.0. Further details about the changes in join processing can be found at http://dev.mysql.com/doc/refman/5.0/en/join.html.

web_designer_iq

Thank you very much sir 🙂
It's fixed 🙂