When I setup a new infobox with pages.php I get this error message.

Error reported on page /index.php

MySQL error: 1054 - Unknown column 'ip.pages_id' in 'on clause'

select ip.pages_id, ipd.pages_title from pages ip, pages_description ipd left join pages_to_categories ip2c on ip2c.pages_id = ip.pages_id where ipd.pages_id = ip.pages_id and ip2c.categories_id = '0' and ipd.language_id = '1' and ip.pages_status = '1' order by ip.pages_sort_order, ipd.pages_title

anyone know whats going on here?

www.trailheadcampinggear.com

Replace the query in template >> your default template >> boxes >> pages.php with the following.


// pages outside categories
$pages_query = tep_db_query("select ip.pages_id, ipd.pages_title from " . TABLE_PAGES . " ip, " . TABLE_PAGES_DESCRIPTION . " ipd left join " . TABLE_PAGES_TO_CATEGORIES . " ip2c on ip2c.pages_id = ipd.pages_id where ipd.pages_id = ip.pages_id and ip2c.categories_id = '0' and ipd.language_id = '" . (int)$languages_id . "' and ip.pages_status = '1' order by ip.pages_sort_order, ipd.pages_title");

Yea!

Thank you Mahesh for that fix!

I looked at the query you said to replace and it looked the same in the original source code included in Cre Loaded's pages.php. Then a code compare tool showed where you had fixed it.

The query on pages.php in the original code had a syntax error, missing a "p" in that query so that it specified "ip.pages_id" and your revision specified "ipd.pages_id" midway through that query.

Whew, what a great thing to find, thank you again Mahesh

This latent problem only showed up for me on one website which has an extra infobox and that's the one that came up with the error "MySQL error: 1054 - Unknown column 'ip.pages_id' in 'on clause".

Note: this error ONLY occurred after an update on my hosting server from PHP 5.2.6 to PHP 5.2.9, also the OpenSSL compiled in to PHP went from 0.9.7a to 0.9.8e-fips-rhel5, and THAT's what triggered the error.

All is well now, so I am going to include this fix into all my Cre Loaded websites so that in the future when a PHP update and the addition of extra infoboxes won't break them.

i got the same problem. after i replace the code to my template/boxes/pages.php


the problem still the same..please help...


my template is 6.2 and installed cre loaded 6.3 b2b version

no problem previously but after i installed a new infobox..the problem arise..


my website is www.sunvastdigital.com