templating tutorials

[inversechi]

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]

i am getting problems when i add products

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]

any idea?

[inversechi]

anyone know what could cause this?

[inversechi]

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]

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

[inversechi]

here are some screenshots of the errors





i am running on xampp if that makes any difference

[inversechi]

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

[paulM]

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]

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]

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?