Database Error

[csaba911]

Everything works so far but for the direct catalog access through the catalog buttons. I get the following Error Message:

 

I'm using :Apache 1.3, PHP 5, MYSQL 5 OSX 10.4

 

Error Message is :

 

Let's See What We Have Here

 

1054 - Unknown column 'p.products_id' in 'on clause'

 

select count(p.products_id) as total from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '17'

 

[TEP STOP]

 

is that the "join" command that needs the ( ) argument brackets? And what file is giving me this error?

 

Thanks

[MarcoZorro]

Hmm

 

MySQL 5 has been out less than a week.... I would be very surprised if oscommerce works out of the box with it without having to go through a fix a lot of sql incompatabilites.

 

is that the "join" command that needs the ( ) argument brackets?

 

Unlikely... the problem seems to be

 

join specials s on p.products_id = s.products_id

 

Try changing that to

 

join specials s on p2c.products_id = s.products_id

 

And what file is giving me this error?

 

Without knowing what page you were looking at its impossible to say which file gives a specific error :)

 

My advice is to ditch mysql 5 and revert to 4 or if you really want to use 5 then be prepared for some rewriting of oscommerce.

[csaba911]

Hmm

 

MySQL 5 has been out less than a week.... I would be very surprised if oscommerce works out of the box with it without having to go through a fix a lot of sql incompatabilites.

Unlikely... the problem seems to be

 

join specials s on p.products_id = s.products_id

 

Try changing that to

 

join specials s on p2c.products_id = s.products_id

Without knowing what page you were looking at its impossible to say which file gives a specific error :)

 

My advice is to ditch mysql 5 and revert to 4 or if you really want to use 5 then be prepared for some rewriting of oscommerce.

 

 

I clicked on "any" category Icon. It's just the Category Icons when you clich directly on the products it works.

just the Category and not even the main category just the Icons

Must be a very small thing. Is it in the database or php script ?

[MarcoZorro]

Must be a very small thing. Is it in the database or php script ?

 

The problem is the changes introduced in mysql 5. Its not likely to be that small a thing as many things that worked in MySQL 4 work differently in MySQL 5...

 

My advice is to ditch mysql 5 in preference to 4... if you choose not to then be prepared to come across many of these little problems :)

[csaba911]

The problem is the changes introduced in mysql 5. Its not likely to be that small a thing as many things that worked in MySQL 4 work differently in MySQL 5...

 

My advice is to ditch mysql 5 in preference to 4... if you choose not to then be prepared to come across many of these little problems :)

 

OK but how easily can I downrade MySql5 to MySql 4 if it even lets me do that after all I have Joomla and other stuff running with the database .

[kgt]

Downgrading will not kill you. Make sure you have .sql backups of your data. This will allow you to recreate your tables. Read over http://dev.mysql.com/doc/refman/5.0/en/downgrading.html for help and known issues.

 

I can tell you with a high degree of certainty that Joomla does not require MySQL 5. It's only just now become production-quality. I doubt they've made enough changes to even have it ready for 5, much less dependent on it. (I can't back that statement up because their site's super slow for me right now, but I'd be shocked if it were false.)

[csaba911]

Downgrading will not kill you. Make sure you have .sql backups of your data. This will allow you to recreate your tables. Read over http://dev.mysql.com/doc/refman/5.0/en/downgrading.html for help and known issues.

 

I can tell you with a high degree of certainty that Joomla does not require MySQL 5. It's only just now become production-quality. I doubt they've made enough changes to even have it ready for 5, much less dependent on it. (I can't back that statement up because their site's super slow for me right now, but I'd be shocked if it were false.)

 

I tried to unistall MySql5 by stopping the server removing /usr/local/mysql5.0.4..... folder but the Installation program for my MAC OSX won't let me instal a lower version . Somehow it still knows that the version 5 was installed.

I even downloaded the tar version and untared it to /usr/local/mysql4....... couldn't even start the server

 

Then I installed the MySql 5 everything works again ... a shame

What am I doing wrong ... I want MySQL 4 is this of topic here ???

[kgt]

You can remove MySQL 5 and install MySQL 4. If you get errors trying to do any of this, you should post them. No one can help you much unless you do that.

 

Not everything installed by MySQL will necessarily be in /usr/local/mysql. I'm not that familiar with Mac installs, but keep in mind binaries can be installed and run from anywhere. Do a system search for "mysql" and see if anything turns up elsewhere.