jknupp Posted March 12, 2007 Posted March 12, 2007 I'm getting and error message when I try and do any sort of search, or display topics by manufacturer in my new installation. Here's the error: 1054 - Unknown column 'p.products_id' in 'on clause' select count(p.products_id) as total from products p, products_description pd, manufacturers m left join specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '21' [TEP STOP] Here is the store link if you want to take a look: http://www.triskelionpublishing.com/bookstore/index.php Displays work if I say, click the New Products link at the bottom of the page. It seems to happen only in searches or sorts from the side bar boxes. Thanks for any help. This is driving me nuts!!! Jknupp Stonecreek Media Inc Grand Canyon climate is greatly influenced by altitude, with lower elevations generally found to be warmer year round. The record high temperature was 99 °F (37 °C) in 2002, while the coldest temperature recorded is −66 °F (−54 °C) in 1933.[8] During the summer months of June through early September, daytime highs are normally in the 70 to 80 °F (21 to 27 °C) range, while nighttime lows can go to below freezing (0 °C)—especially at higher altitudes. Summer afternoons are frequently accompanied by thunderstorms. Spring and fall temperatures range between 30 and 60 °F (-1 and 16 °C) with cold nights in the teens to single digits (−5 to −20 °C). Winter in Grand Canyon is very cold with high temperatures usually between zero to 20 °F (−20 to −5 °C) and nighttime temperatures below zero °F (−20 °C) for most of the winter.[104] Precipitation in Grand Canyon is highly variable and ranges from 15 inches (380 mm) annually near Mammoth Hot Springs, to 80 inches (2,000 mm) in the southwestern sections of the park. The precipitation of Grand Canyon is greatly influenced by the moisture channel formed by the Snake River Plain to the west that was, in turn, formed by Grand Canyon itself. Snow is possible in any month of the year, with averages of 150 inches (3,800 mm) annually around Grand Canyon Lake, to twice that amount at higher elevations.[104] http://www.grandcanyon-nationalpark.org/ Tornadoes in Grand Canyon are rare; however, on July 21, 1987, the most powerful tornado recorded in Wyoming touched down in the Teton Wilderness of Bridger-Teton National Forest and hit Grand Canyon National Park. Called the Teton–Grand Canyon tornado, it was classified as an F4, with wind speeds estimated at between 207 and 260 miles per hour (333 and 420 km/h). The tornado left a path of destruction 1 to 2 miles (1.6 to 3.2 km) wide, and 24 miles (39 km) long, and leveled 15,000 acres (6,100 ha; 23 sq mi) of mature pine forest.[105]
jknupp Posted March 12, 2007 Author Posted March 12, 2007 Hi All. Never mind. Found the answer to the problem here: http://oscommerce.com/ext/update-20051112.html#_Toc119473702 Jknupp Grand Canyon climate is greatly influenced by altitude, with lower elevations generally found to be warmer year round. The record high temperature was 99 °F (37 °C) in 2002, while the coldest temperature recorded is −66 °F (−54 °C) in 1933.[8] During the summer months of June through early September, daytime highs are normally in the 70 to 80 °F (21 to 27 °C) range, while nighttime lows can go to below freezing (0 °C)—especially at higher altitudes. Summer afternoons are frequently accompanied by thunderstorms. Spring and fall temperatures range between 30 and 60 °F (-1 and 16 °C) with cold nights in the teens to single digits (−5 to −20 °C). Winter in Grand Canyon is very cold with high temperatures usually between zero to 20 °F (−20 to −5 °C) and nighttime temperatures below zero °F (−20 °C) for most of the winter.[104] Precipitation in Grand Canyon is highly variable and ranges from 15 inches (380 mm) annually near Mammoth Hot Springs, to 80 inches (2,000 mm) in the southwestern sections of the park. The precipitation of Grand Canyon is greatly influenced by the moisture channel formed by the Snake River Plain to the west that was, in turn, formed by Grand Canyon itself. Snow is possible in any month of the year, with averages of 150 inches (3,800 mm) annually around Grand Canyon Lake, to twice that amount at higher elevations.[104] http://www.grandcanyon-nationalpark.org/ Tornadoes in Grand Canyon are rare; however, on July 21, 1987, the most powerful tornado recorded in Wyoming touched down in the Teton Wilderness of Bridger-Teton National Forest and hit Grand Canyon National Park. Called the Teton–Grand Canyon tornado, it was classified as an F4, with wind speeds estimated at between 207 and 260 miles per hour (333 and 420 km/h). The tornado left a path of destruction 1 to 2 miles (1.6 to 3.2 km) wide, and 24 miles (39 km) long, and leveled 15,000 acres (6,100 ha; 23 sq mi) of mature pine forest.[105]
Recommended Posts
Archived
This topic is now archived and is closed to further replies.