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

Hi Anthony here, TEP stop 1054 - Unknown column 'p.products_id' in 'on clause' Hi Anthony here from Your Chance to Profit.com The mysql4 and mysql5 1054 Tep stop issue, I provide different skins for oscommerce sites I provide hosting and free installation too so I have come across a few things that have to be changed with the sites code and database. If you search for a fix to your TEP code error you often find the answer which is you have to change some php coding in the index.php and the advanced_search_result.php on some pages it says you need to make a few changes to other pages on the admin side. Now I have had to look at changing the 1054 error on a few sites and to the most the changes don’t often work and if you’re not into php or database you can get lost just looking to change these lines. Anyway I could not understand why you should have to make any changes to the scripts when as you know all the products you had were once there with the product details for them so why would I need to start to make the changes that don’t often work when clearly at the end of the day it’s a database problem. With this in mind I have looked at the problem and come up with a simple answer which given guidance works, all you have to do is to make a few simple changes to your database. If you should need help please feel free to contact me. Also please feel free to ask if you have any other issues you never know I could have the help on those issues too.