Jump to content

Oscommerce/wishlist Errors


MoonFaery
 Share

Recommended Posts

I installed everything and when I go to test it.. I click on Add To Wishlist and I get this:

 

My Wish List contains:

 

 

Image Product Name Price Select

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

 

select pd.products_id, pd.products_name, pd.products_description, p.products_image, p.products_status, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from products p, products_description pd left join specials s on p.products_id = s.products_id where pd.products_id = '106' and p.products_id = pd.products_id and pd.language_id = '1' order by products_name

 

[TEP STOP]

 

---and when I log in as a customer I get:

 

1146 - Table 'mysticd2_osc2.customers_wishlist' doesn't exist

 

select products_id from customers_wishlist where customers_id = '5' and products_id = '106{1}7{2}39'

 

[TEP STOP]

 

:tchrocks:

Link to comment
Share on other sites

Ok, I did that.. but the errors from my previous post are still there.

 

Correction, the first one in the first post is still there (not the 2nd):

 

My Wish List contains:

 

 

Image Product Name Price Select

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

 

select pd.products_id, pd.products_name, pd.products_description, p.products_image, p.products_status, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from products p, products_description pd left join specials s on p.products_id = s.products_id where pd.products_id = '42' and p.products_id = pd.products_id and pd.language_id = '1' order by products_name

 

[TEP STOP]

Edited by MoonFaery
Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

×
×
  • Create New...