[osCmax V2.0.25] wish list infobox error message

[QDblue2000]

When you login as a customer to our shopping cart you receive the following error message where the wishlist info box should be displayed

1054 - Unknown column 'products_name' in 'order clause'

select * from customers_wishlist WHERE customers_id = 2 order by products_name

[TEP STOP]

I am stumped on why this is being displayed. Does anyone have any pointers on what could be wrong or where?

[pgmarshall]

More info needed ...

Version? 2.0.25 or v2.5 Beta2?

Have you recently installed?

Do you have an url?

This looks like an install issue ... are you installing on a Windows machine ... if so search for MyISAM on this board for a similar thread.

Regards,

[QDblue2000]

We are using version 2.0.25. When it was 1st installed the error wasn't there. But now its displaying. We changed the main page from showing monthly new products to just products in general. But I do not know if this started occurring right after that or not. I hadn't logged in by the customer view in a while so I am just not sure.

The URL is thomsartisland.com and I setup a test account test@test.com/abc123 so you can see the error message

[pgmarshall]

Can you check the table structure of customers_wishlist in your phpMyAdmin or similar.

Just check it is there and has the products_name column in it.

Not sure how you could have just dropped one table though.

Regards,

[michael_s]

We are using version 2.0.25.

For future reference, when you create a new thread, please select the version of the software you are running from the prefix dropdown list. There are two "Prefix" options - v2.5 or v2.0.25. Pick one. That way we don't have to ask you what version. It saves everyone a lot of time. If you don't pick one, we will assume pre 2.0.25 or waste time asking you what version instead of getting to the point.

[QDblue2000]

Can you check the table structure of customers_wishlist in your phpMyAdmin or similar.

Just check it is there and has the products_name column in it.

Not sure how you could have just dropped one table though.

Regards,

I checked customers_wishlist and it has both columns in it with the proper data, I checkedproducts_description and it has products_name in it like its suppose to, an dI checked products and it all seems correct and calling all of the right fields. Am I missing a table.

Anyone else have any other thoughts?