templating tutorials

**inversechi** · 04-26-2006, 03:50 AM

anyone got any templating tips or tutorials, i am a begginer, ive only made a simple theme in STS for OSc but not BTS...

**inversechi** · 04-26-2006, 05:46 AM

i am getting problems when i add products

Code:

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

select count&#40;p.products_id&#41; 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_retail_prices 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 = '1'

&#91;TEP STOP&#93;

any idea?

**inversechi** · 04-28-2006, 11:43 AM

anyone know what could cause this?

**inversechi** · 04-28-2006, 11:49 AM

okeys i'll give a better description of the situation, i have created a catergory, and then i've placed a product inside this... all goes fine, no errors, then i browse the category from the menu on the side, and that error occurs.

**michael_s** · 04-28-2006, 01:18 PM

Your database is not set up correctly. You are missing the products_id field. Re-create your database.

**inversechi** · 04-30-2006, 03:18 AM

here are some screenshots of the errors

i am running on xampp if that makes any difference

**inversechi** · 04-30-2006, 03:27 AM

i ran the installer to install and then added a sample cat and sample product inside the cat...

**paulM** · 05-01-2006, 03:42 PM

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_retail_prices 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 = '1'

[TEP STOP]

I think you're using MySQL5, and osC is not ready for it. But I might be wrong.

**inversechi** · 05-02-2006, 03:14 PM

mysql
MySQL Support enabled
Active Persistent Links 0
Active Links 0
Client API version 5.0.18

i got that from PHP INFO.

It works with Oscommerce, just Osmax seems to come up with Errors =(... i'll try installing on my remote web server to see if that changes it.

**inversechi** · 05-03-2006, 08:49 AM

okeys i installed using mysql 4 database live and it's working... however two products are being displayed in each cat, like one on top of the other.. same as the screenshot shows, is this menna happen?