paq1200

Thanks for all your help JanZ. The only products that are showing up twice is the ones that are in more than one category. I did what you said and reverted to backup and products are only shown once. I inserted the code in products_new as instructed and products are shown twice. reverted back and only inserted the $products_new_query_raw line and products are shown twice. I am thinking the problem is in this line: $products_new_query_raw = "select p.products_id, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id, p.products_date_added, m.manufacturers_name from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on (p.manufacturers_id = m.manufacturers_id), " . TABLE_PRODUCTS_DESCRIPTION . " pd left join " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c using(products_id) left join " . TABLE_CATEGORIES . " c using(categories_id) where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and find_in_set('".$customer_group_id."', products_hide_from_groups) = 0 and find_in_set('" . $customer_group_id . "', categories_hide_from_groups) = 0 order by p.products_date_added DESC, pd.products_name"; can someone tell me how to go about breaking this line down to find out what is causing the products to show up twice. Mike

Sorry about the way the question was asked. What I was refering to when I said "this has been asked several times with no answer" was that in the contributions forum that question was asked several times and no one answered it in the forum. That is why I put it as a new topic. I am still learning php and I do not know what I should do here. you can see what I am talking about HERE. signon:[email protected] password:trial when you go to All Products then change the sort by and you will be logged off. and the session will not be in the address bar. Thanks Mike

This has been asked several times with no answer. how do I keep the session from one page to the next? I have added a contribution which allows you to sort the products by dropdown but when you go to the next page the session is dropped. this is the code on the index.php: echo '<td align="center" class="dynamicMain">' . tep_draw_form('sort', FILENAME_DEFAULT, 'get') . '<b>Sort by:</b> '; if (isset($HTTP_GET_VARS['manufacturers_id'])) { echo tep_draw_hidden_field('manufacturers_id', $HTTP_GET_VARS['manufacturers_id']); } else { echo tep_draw_hidden_field('cPath', $cPath); } $sort_list = array('6d' => 'Best Sellers', '2a' => 'Products Name A to Z', '2d' => 'Products Name Z to A', '3a' => 'Price Low to High', '3d' => 'Price High to Low'); foreach($sort_list as $id=>$text) { $sort_range[] = array('id' => $id, 'text' => $text); } echo tep_draw_pull_down_menu('sort', $sort_range, (isset($HTTP_GET_VARS['sort']) ? $HTTP_GET_VARS['sort'] : ''), 'onchange="this.form.submit()"'); echo tep_draw_hidden_field('filter_id', (isset($HTTP_GET_VARS['filter_id']) ? $HTTP_GET_VARS['filter_id'] : '')); echo '</form></td>' . "\n"; // End Additional Products Sort Any help is appreciated Mike

Did anyone get this problem fixed. I have the same problem. Mike

When I installed the sppc hide contribution now the new products are showing up twice. I am not sure where to start looking to fix this. Thanks Mike

I thought I had seen this question before but I can not find it after several searches. How do I make it so when a customer creates an account they are automaticly set up in a different customer group. Thanks

I am having the same problem. Can you tell me if you got it fixed and if so can you tell me how you did it? Mike

I am getting this on the new products page Text_Price_Instead Text_Price_Savings Text_Price_Now I did not see where to add this anywhere Can someone help Mike

I have just added SPPC to my site and now I am getting this error during checkout and I am not sure how to fix it: PHP Fatal error: Call to undefined method: shoppingcart->count_contents_virtual() in /usr/home/mickna/www/htdocs/checkout_payment.php on line 75 Here is what is on line 75: $total_count = $cart->count_contents_virtual(); // CCGV I have looked at checkout_payment.php but I am not sure what I should be looking for. When I reverted back to site without sppc, everything works fine. Can someone tell me where I should be looking? Thanks

can someone tell me how to change the font color on the margin_report.php. I want the header font to be white. Thanks

everything works great except i had the ot_modules setup to show the discounts with a minus sign and the font in red. since the install the font is black again and there is no minus sign. It looks right in the checkout process but in the order history info and in admin/edit_orders it is not red anymore. can you point me in the direction on where to look. Thanks Mike

I found the problem had to add: function checkout_initialization_method() { $initialize_array = array(); if (is_array($this->modules)) { reset($this->modules); while (list(, $value) = each($this->modules)) { $class = substr($value, 0, strrpos($value, '.')); if ($GLOBALS[$class]->enabled && method_exists($GLOBALS[$class], 'checkout_initialization_method')) { $initialize_array[] = $GLOBALS[$class]->checkout_initialization_method(); } } } return $initialize_array; } to catalog/includes/classes/payment all is working now.....at least on the coupon side

I just installed the latest version of ccgv(trad) and now I get this error: Fatal error: Call to undefined function: checkout_initialization_method() in c:\apache\htdocs\shopping_cart.php on line 210 I noticed earlier that someone else was getting this error but no solution was given on how to correct it. any help is apprecitated Mike

I have installed the easy discount and easy coupon contributions but I am getting the error: Fatal error: Call to undefined function: clear() in c:\apache\htdocs\includes\modules\easy_coupons_code.php on line 72 Not sure where to look. Can anyone help me Thanks Mike