osCommerce Community Support Forums

Jikaku

Jun 6 2007, 12:59 AM

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.

CODE

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...

Jikaku

Jun 6 2007, 02:30 AM

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

QUOTE (Jikaku @ Jun 5 2007, 08:59 PM)

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.

CODE

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

Jun 6 2007, 02:48 AM

QUOTE (Jikaku @ Jun 5 2007, 08:30 PM)

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

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

Jikaku

Jun 6 2007, 03:01 AM

QUOTE (bkellum @ Jun 5 2007, 10:48 PM)

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:

CODE

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

to

CODE

$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

Jun 6 2007, 05:48 AM

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.

OSCOMMERCE SUPPORT CALL 702-453-3332