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

[pepsishot]

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

I am getting this message on my website when trying to look at any product. All my categories are there but when you click on any of them to see product it's not there anymore.

I'm new and freaking out.

Everything was fine an hour ago!!!

What did I do??????

Someone PLEASE help me!!!

Amber

[kuroi]

Is the full SQL statement also being output with the error message?

[pepsishot]

Is the full SQL statement also being output with the error message?

I am very new here... I have no idea what you are asking... sorry.

The "1054 Unknown column 'p.products_id' in 'on clause'" message is the only thing you see when you click on a sub-category to see list of items.

I have found out that my host has upgraded to some 5.0 MySQL thing. (I think that is what it was called.)

I don't know if that has anything to do with this problem. I contacted them and they said they'd get back to me in 24-48 hours. In the meantime I am without a business. Not good for me.

Amber

[pepsishot]

kuroi,

I took my site off "down for maintenance" for the moment.

You can see what it does...

www.ambersscrapattic.com

That is if it even loads for you. That is another problem I'm working on.

Thank you, Amber

[DrByte]

What version of Zen Cart are you using ?
What addons/contributions are installed?

[pepsishot]

Zen Cart 1.2.7

Old, I know. I have someone who is going to teach me to upgrade. I just don't understand it all yet. I need it broke down better for me.

But my server/host people just did something this morning I found out. I was hopeing they'd help but so far they haven't done much.

Thanks!!

Amber

[DrByte]

The following *might* provide some relief until you can get around to doing the upgrade (which should still be done as soon as possible if you're on MySQL5 now):

/includes/classes/db/mysql/query_factory.php
around line 41 you'll find:

    if ($this->link) {
      if (@mysql_select_db($zf_database, $this->link)) {
        $this->db_connected = true;
        return true;
      } else {

Insert an extra line as shown:

    if ($this->link) {
      if (@mysql_select_db($zf_database, $this->link)) {
        @mysql_query("SET SESSION sql_mode = ''", $this->link);
        $this->db_connected = true;
        return true;
      } else {

Doing this *might* be enough to tell MySQL 5 to ignore some of the strictness it normally enforces.

[pepsishot]

Well... that did not work for me.

Thank you anyway. It was a good try.

Maybe once I learn to upgrade my cart things will get better.

Thanks, Amber

[ocsand]

is your site hosted by powweb? they just upgraded their mySQL database to version 5 and it screwed up my cart with the same error message you are getting.

...joe
seaside stampin' ink
seasidestampin.com

[pepsishot]

Yes, I am with PowWeb. It would seem the cart I am using is to old to work with this MySQL 5.0 thing.

Sorry I don't really know what MySQL is, but we need to upgrade our Zen Cart.

This I now know.

Problem is I don't really understand how to upgrade my cart.

I need less computer words to explain it to me.

Amber