Offering Money!

[Guest]

I'm in a pickle, and I'm desperate -

 

I'll be happy to paypal $50 to whomever can walk me through exactly what I need to do, and get this thing working!

 

http://www.bluelotusassembly.org/skhquest/shop/

 

I have the category links showing up fine on the main page, and on the secondary (inner.php) pages the bread crumbs know what category to display, but it's puking on actually displaying the category items.

 

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 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 = '3'

[TEP STOP]

 

 

I barely know what I'm doing, and as you can see I'm modifying a template...

[Guest]

Okay, used this contribution:

 

http://www.oscommerce.com/community/contributions,4654

 

and now it appears to work, but only 4 of 17 items show? (books category)

 

still offering the money to the person who finally helps me sort it out :blush:

 

I'm in a pickle, and I'm desperate -

 

I'll be happy to paypal $50 to whomever can walk me through exactly what I need to do, and get this thing working!

 

http://www.bluelotusassembly.org/skhquest/shop/

 

I have the category links showing up fine on the main page, and on the secondary (inner.php) pages the bread crumbs know what category to display, but it's puking on actually displaying the category items.

 

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 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 = '3'

[TEP STOP]

I barely know what I'm doing, and as you can see I'm modifying a template...

[bkellum]

Okay, used this contribution:

 

http://www.oscommerce.com/community/contributions,4654

 

and now it appears to work, but only 4 of 17 items show? (books category)

 

still offering the money to the person who finally helps me sort it out :blush:

Check the admin setting for your product listing. Go to Admin | Configuration | Search Results.

[Guest]

Check the admin setting for your product listing. Go to Admin | Configuration | Search Results.

 

You know, I tried that, and got nothing - so I fiddled with product_listing.php

 

changed:

 

  $listing_split = new splitPageResults($listing_sql, 4, 'p.products_id');

 

to

 

  $listing_split = new splitPageResults($listing_sql, 5, 'p.products_id');

 

And now I'm getting the "next page" etc. results link.

 

Odd... but appears to be fixed for now.

[oschellas]

If you are using php5 / mysql5 you have to put the join queries between brackets, have a look at this contribution how to do so.