osCommerce Community Support Forums

Jikaku

Jun 5 2007, 09:00 PM

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... if any one can tell me what I'm doing wrong I'll be terribly thankful.

Jikaku

Jun 5 2007, 11:08 PM

QUOTE (Jikaku @ Jun 5 2007, 05:00 PM)

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... if any one can tell me what I'm doing wrong I'll be terribly thankful.

No help?

spax

Jun 5 2007, 11:27 PM

Templates are notorious for out of date files, which is your problem here. They also use their own file sets as well I guess, as I've never heard of inner.php. Not unless that is from the MS1 days? Check in your includes/application_top.php and see which version you are using.

To update MS2 files, download the latest update from here. You'll have to do a manual update but the updates are listed in the package. The one that is causing you grief at the moment is MySql 5 Compatibility.

Jikaku

Jun 5 2007, 11:33 PM

QUOTE (spax @ Jun 5 2007, 07:27 PM)

Templates are notorious for out of date files, which is your problem here. They also use their own file sets as well I guess, as I've never heard of inner.php. Not unless that is from the MS1 days? Check in your includes/application_top.php and see which version you are using.

To update MS2 files, download the latest update from here. You'll have to do a manual update but the updates are listed in the package. The one that is causing you grief at the moment is MySql 5 Compatibility.

Thanks - application_top says:

CODE

// define the project version
define('PROJECT_VERSION', 'osCommerce 2.2-MS2');

Jikaku

Jun 5 2007, 11:41 PM

QUOTE (spax @ Jun 5 2007, 07:27 PM)

Templates are notorious for out of date files, which is your problem here. They also use their own file sets as well I guess, as I've never heard of inner.php. Not unless that is from the MS1 days? Check in your includes/application_top.php and see which version you are using.

To update MS2 files, download the latest update from here. You'll have to do a manual update but the updates are listed in the package. The one that is causing you grief at the moment is MySql 5 Compatibility.

Well, I really am in a pickle. Downloaded the latest update, but couldn't make heads or tails of what to do to update the MySql compatibility.

spax

Jun 6 2007, 12:09 AM

I don't really know how to advise you on this one. Your inner.php is doing what index.php does in a standard install so maybe start by comparing the 2 files.
I would stick with you but it is 1am here and I need my bed. I'll check back tomorrow to see how you are doing.

One thing you could consider and don't take this the wrong way. That template isn't anything special, wouldn't it be best to start with a fresh install - the one you just downloaded - and skin it how you need?

Something to ponder anyhow.

Jikaku

Jun 6 2007, 12:22 AM

Getting desperate, and no good at php...

Happy to paypal $50 USD to the helpful soul that can tell me excatly what I need to do to get this working! :-)

avatech

Jun 6 2007, 03:03 AM

QUOTE (Jikaku @ Jun 5 2007, 07:22 PM)

Getting desperate, and no good at php...

Happy to paypal $50 USD to the helpful soul that can tell me excatly what I need to do to get this working! :-)

We shouldn't have to pay to get help we are all new together and for those who were new and now beyond an amatuer. Both os us would be greatful to have a true oscommerce friend.

OSCOMMERCE SUPPORT CALL 702-453-3332