julia

Hi.. I just installed the Column Product Listing 2.3 Contribution and I am getting this error. I have version 2.2 installed. Thanks for any help! Julie 1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'select p.products_image, pd.products_name, p.products_id, p.ma select count(select p.products_image, pd.products_name, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price 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 = \'2\' order by pd.products_name) as total

thanks Aaron..I spent some time on this last night, and figured its just as easy to manually move things around myself. It wasn't the nightmare I thought it would be...but I'm not done yet..ha ha.. I still wanted those variables on the page, they just weren't showing up for some reason, and they were showing up in the default oscommerce locations. I'm glad it worked well for you. Julie

Well The main things are: Insted of the info box, have those items on the top menu. A border around the left column. Create account, shopping cart, a measurement guide (basically the same page as create account) all in the left column. Visually and functionally you can see what I want at http://www.olivialitton.com/home.htm I also want to add an additional page (this is a separate issue from the STS) to the create account function. Do you know if this requires a major change..or can I just add the page, and define it. Thanks for your help. Julie

It seems like I would have to go in and change the index page and take out the left column and screw with the tables anyway...so I'm thinking I would just change the tables etc... it just gets so complicated...sigh.. Julie

Okay.. I tried that..and basically I get the same thing. The Category menu comes up on the left where I want it (Although I don't want a drop down...but I'll attack that later I guess) But the rest of the things..infobox etc show up in the main body I think I'm missing something REALLY basic http://www.threei.org/Store Julie

I just installed the Simple template system. Certain parts of it seem to work, but others...no.. Perhaps I'm not understanding exactly how it works. I made a plain HTML page, and then put the variables where I wanted them to go. Mostly the whole oscommerce default page shows up in the place where $content is. For instance in the left hand column box I put $catmenu $categorybox $searchbox but these are showing up in the body where I expected the $content to show up. The $breadcrumb, $checkout etc... are showing up where I put them. Also, where do I put the images where they show up. Any help greatly appreciated.. You can see this mess at http://www.threei.org/Store And one more thing... If there is a better place to post this question..could you let me know where? Julie

I have the Categories Box Images contribution on my site. If there is no image, it is supposed to display the text. However, when I don't add a picture, no text is displayed. Here is the code for the includes/boxes/categories.php page. Any help appreciated! <?php /* $Id: categories.php,v 1.25 2003/07/09 01:13:58 hpdl Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright © 2003 osCommerce Released under the GNU General Public License */ function tep_show_category($counter) { global $tree, $categories_string, $cPath_array; for ($i=0; $i<$tree[$counter]['level']; $i++) { $categories_string .= " "; } $categories_string .= '<a href="'; if ($tree[$counter]['parent'] == 0) { $cPath_new = 'cPath=' . $counter; } else { $cPath_new = 'cPath=' . $tree[$counter]['path']; } $categories_string .= tep_href_link(FILENAME_DEFAULT, $cPath_new) . '">'; if (isset($cPath_array) && in_array($counter, $cPath_array)) { $categories_string .= '<b>'; } // display category name if (tep_not_null($tree[$counter] ['image'])) { $categories_string .=tep_image(DIR_WS_IMAGES . $tree[$counter] ['image'], '240',' 30'); }else{ $categories_sting .= $tree[$counter] ['name']; } if (isset($cPath_array) && in_array($counter, $cPath_array)) { $categories_string .= '</b>'; } // if (tep_has_category_subcategories($counter)) { // $categories_string .= '->'; // } $categories_string .= '</a>'; if (SHOW_COUNTS == 'true') { $products_in_category = tep_count_products_in_category($counter); if ($products_in_category > 0) { $categories_string .= ' (' . $products_in_category . ')'; } } $categories_string .= '<br>'; if ($tree[$counter]['next_id'] != false) { tep_show_category($tree[$counter]['next_id']); } } ?> <!-- categories //--> <tr> <td> <?php $info_box_contents = array(); $info_box_contents[] = array('text' => BOX_HEADING_CATEGORIES); new infoBoxHeadingCategories($info_box_contents, true, false); $categories_string = ''; $tree = array(); $categories_query = tep_db_query("select c.categories_id, c.categories_image, cd.categories_name, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id='" . (int)$languages_id ."' order by sort_order, cd.categories_name"); while ($categories = tep_db_fetch_array($categories_query)) { $tree[$categories['categories_id']] = array('name' => $categories['categories_name'], 'image' => $categories['categories_image'], 'parent' => $categories['parent_id'], 'level' => 0, 'path' => $categories['categories_id'], 'next_id' => false); if (isset($parent_id)) { $tree[$parent_id]['next_id'] = $categories['categories_id']; } $parent_id = $categories['categories_id']; if (!isset($first_element)) { $first_element = $categories['categories_id']; } } //------------------------ if (tep_not_null($cPath)) { $new_path = ''; reset($cPath_array); while (list($key, $value) = each($cPath_array)) { unset($parent_id); unset($first_id); $categories_query = tep_db_query("select c.categories_id, c.categories_image, cd.categories_name, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '" . (int)$value . "' and c.categories_id = cd.categories_id and cd.language_id='" . (int)$languages_id ."' order by sort_order, cd.categories_name"); if (tep_db_num_rows($categories_query)) { $new_path .= $value; while ($row = tep_db_fetch_array($categories_query)) { $tree[$row['categories_id']] = array('name' => $row['categories_name'], 'image' => $row['categories_image'], 'parent' => $row['parent_id'], 'level' => $key+1, 'path' => $new_path . '_' . $row['categories_id'], 'next_id' => false); if (isset($parent_id)) { $tree[$parent_id]['next_id'] = $row['categories_id']; } $parent_id = $row['categories_id']; if (!isset($first_id)) { $first_id = $row['categories_id']; } $last_id = $row['categories_id']; } $tree[$last_id]['next_id'] = $tree[$value]['next_id']; $tree[$value]['next_id'] = $first_id; $new_path .= '_'; } else { break; } } } tep_show_category($first_element); $info_box_contents = array(); $info_box_contents[] = array('text' => $categories_string); new infoBox($info_box_contents); ?> </td> </tr> <!-- categories_eof //--> Thanks! Julie

Thanks Zeme. I am actually not getting an error. It appears to work fine, but just doesn't sort the attributes. The good thing is that when I add products the attributes are in the same order as the product before. I am going to go over your merge of the options type and the attributes sorter, and make sure I did that correctly. Just waiting till Mon... Will post my results! Julie

Any other information I can supply...let me know. Julie..Thanks! <{POST_SNAPBACK}> It is the options type feature that I merged with the sorter. I will take a close look at zeme's merge..and see if i have any errors there. I seem to remember one...questionable section! Thanks Julie

I did check the database, and the columns are there. I also added a contribution that added radio buttons and check boxes and text area's etc.. So..maybe that is screwing things up. Robin suggested that some of my products had attributes already, but I deleted everyting before I added these and specified a sort order for eatch of the options, so that is not it...at least ...I'm pretty sure that it is not. So..not sure what you mean by "(post the results of the SQL "describe products_attributes" and we'll find a solution for you) " Here are the colums in th products-attributes table products_attributes_id products_id attributes_id options_values_id options_values_price price_prefix products_options_sort_order Any other information I can supply...let me know. Julie..Thanks!

Thank You so much and especially for the feedback on the site. I was thinking I would have to have a separate product for the envelopes, but didn't think about having the quantity as a text option. Thanks Julie

Is it possible to add an option, where the cost is added only once per item regardless of the quantity of items bought. In other words, for ordering invitations, if someone wants to pre-order envelopes its an extra $8.99. If they order a quantity of 20 or 200, its still $8.99. Are there any contribs that do this? Thanks! Julie http://www.noteworthyinkonline.com/shop/catalog

I would like to set up my shipping so that say..0-25 items X$ amount 50-100 items Y$ amount and then have different price options for ground 2day, etc. I have never set up shipping before. What module do I use and where do I even begin???? Thanks for any and all advice. Julie http://www.noteworthyinkonline.com

Okay..newbie to this. How do I go about setting up the shipping modules. I would like to base shipping price on dollar amount. Then have ground, 2 day and overnight pricing. Can you suggest a good place to start. Thanks Julie

Hey there.. I installed your contribution, and it seems like it would be great for my needs, but I am having trouble getting to actually work. It appears to, ie. no errors, but the attributes basically show up how they want. I finally got one product the way I want it, but when I use the Attributes copier, the order in which some of the attributes shows up in the wrong order. Obviously this contribution works, so where do you think I'm going wrong. Here is my URL I only have products in the baby category. http://www.noteworthyinkonline.com/shop/catalog THanks..and I hope you are still monitoring this Thread. Julie