Jump to content
Latest News: (loading..)

rednme

Members
  • Content count

    21
  • Joined

  • Last visited

Profile Information

  • Real Name
    Jeff Genno
  1. rednme

    Header Tags SEO

    hi, I think I explained it little confusing. at line 273 else //generic option was used tep_db_query("update " . TABLE_PRODUCTS_DESCRIPTION . $set . " where.... this $set variable has value from manufactures information above. so I added in line #235 inside products info update area to make it to be just ' set ' when no more content to be added to $set... hope this explains little more. thanks genesis
  2. rednme

    Header Tags SEO

    thanks for the reply. if you look at the error code carefully, this 'manufacturers_htc_title_tag' is being called in products_description update query. 1054 - Unknown column 'manufacturers_htc_title_tag' in 'field list' update products_description set manufacturers_htc_title_tag="Jones New York is a great product", manufacturers_htc_desc_tag="We sell Jones New York in an quantity", manufacturers_htc_keywords_tag="Jones New York, Jones New York computer, Jones New York dresses", manufacturers_htc_description="JONES NEW YORK is one of our best categories. There are many types of Jones New York\\\'s in the Jones New York category. " where products_id = '369' and language_id='1'[TEP STOP] by seeing all other update situation is working fine, i think my db tables are ok... Please help here. thanks. genesis
  3. rednme

    Header Tags SEO

    hi, thanks for your contribution. I installed and tested. When testing with "fill tags", with all check marks are clicked for categories, manufacturers, products and Generic override checked, with Fill products meta description with Products Description? checked, with fill tags area with "Fill only empty tags" radios check all. I got the following error : 1054 - Unknown column 'manufacturers_htc_title_tag' in 'field list' update products_description set manufacturers_htc_title_tag="Jones New York is a great product", manufacturers_htc_desc_tag="We sell Jones New York in an quantity", manufacturers_htc_keywords_tag="Jones New York, Jones New York computer, Jones New York dresses", manufacturers_htc_description="JONES NEW YORK is one of our best categories. There are many types of Jones New York\\\'s in the Jones New York category. " where products_id = '369' and language_id='1' [TEP STOP] looks like $set variable value in the code is being carried over from manufacturers to products.(header_tags_fill_tags.php) one thing I tried was to add one more line at line # 235 if ($updateDB) { /************************ FILL THE DESCRIPTION **********************/ if ($productsMetaDesc == 'fillMetaDesc_yes') //fill the description with all or part of the { //product description if (! empty($products_tags['products_description'])) { if (isset($productsMetaDescLength) && (int)$productsMetaDescLength > 3 && (int)$productsMetaDescLength < strlen($products_tags['products_description'])) $desc = substr($products_tags['products_description'], 0, (int)$productsMetaDescLength); else //length not entered or too small $desc = $products_tags['products_description']; //so use the whole description } else $desc = $products_tags['products_name']; [color="#FF0000"]// $set = ' set '; // this line added to debug error ************** this is line 235[/color] } else if (isset($_POST['generic_enabled']) && $_POST['generic_enabled'] == 'on') { can someone guide me to the permanent solution ? thanks genesis
  4. rednme

    Seperate Pricing Per Customer v3.5

    got, it. actually, there was Webmakers contribution for attributes, which commented out the portion that I edited. I didn't realize that portion was commented out from above about 3 line and about 20 lines down. I uncommented and it works fine. Great Contributions. thanks, and deep appreciation to you, and you all. genesis.
  5. rednme

    Seperate Pricing Per Customer v3.5

    :huh: hi, all. I have installed, QPBPP 1.3.5 for SPPC 4.2.2 in my store , 2.2Rc2a, with a few adons installed. with customer groups of retail and wholesale setup. price break levels of 2 only for test. when I try to add or edit a product with price breaks, it shows the following error. (with some test values)----------------------------------------- ...$_POST[products_price_break]... Array... ...pbb_cg_id... 0... ... price_break_array ... Array... ... price_break_array value... 0... Warning: Invalid argument supplied for foreach() in /home/catalog/admin/categories.php on line 484 ...pbb_cg_id... 1... ... price_break_array ... Array... ... price_break_array value... 0... Warning: Invalid argument supplied for foreach() in /home/catalog/admin/categories.php on line 484 ( then it showed /admin/function/general.php line 22, header already sent .... ( now, it doesn't show, so I couldn't copy here)) ---------------------------------------------------------------------------------- first I installed, SPPC 4.2.2 and checked working fine. then installed QPBPP 1.3.5 for SPPC 4.2.2 from JanZ & Zappo 2008/11/23 version. as you can see, I tested the values for foreach call, can someone have answers for it? this is the portion of the code in /admin/categories.php near that lines. // BOF entries in products_price_break // TEST ************* echo '... $_POST[products_price_break] ... ' . $_POST['products_price_break'][0] . '...<br><br>'; foreach ($_POST['products_price_break'] as $pbb_cg_id => $price_break_array) { // TEST ************* echo '...pbb_cg_id... ' . $pbb_cg_id . '...<br><br>'; echo '... price_break_array ... ' . $price_break_array . '...<br><br>'; echo '... price_break_array value... ' . (int)$_POST['products_qty'][$pbb_cg_id][$price_break_array] . '...<br><br>'; foreach ($price_break_array as $key1 => $products_price) { // TEST ************* echo '...key1 ... ' . $key1 . '...<br><br>'; echo '... products_price ... ' . $products_price . '...<br><br>'; $pb_action = 'insert'; // re-set default to insert $where_clause = ''; if (isset($_POST['products_delete'][$pbb_cg_id][$key1]) && $_POST['products_delete'][$pbb_cg_id][$key1] == 'y' && isset($_POST['products_price_break_id'][$pbb_cg_id][$key1])) { $delete_from_ppb_array[] = (int)$_POST['products_price_break_id'][$pbb_cg_id][$key1]; continue; } if (!tep_not_null($products_price)) { continue; // if price is empty this price break is unused } elseif (!tep_not_null($_POST['products_qty'][$pbb_cg_id][$key1])) { continue; // if qty is not entered we will not update or insert this in the table } else { $sql_price_break_data_array = array( 'products_id' => (int)$products_id, 'products_price' => (float)$products_price, 'products_qty' => (int)$_POST['products_qty'][$pbb_cg_id][$key1], 'customers_group_id' => $pbb_cg_id ); if (isset($_POST['products_price_break_id'][$pbb_cg_id][$key1]) && (int)$_POST['products_price_break_id'][$pbb_cg_id][$key1] > 0) { $pb_action = 'update'; $where_clause = " products_price_break_id = '" . (int)$_POST['products_price_break_id'][$pbb_cg_id][$key1] . "'"; } tep_db_perform(TABLE_PRODUCTS_PRICE_BREAK, $sql_price_break_data_array, $pb_action, $where_clause); } // end if/else (!tep_not_null($products_price)) } // end foreach ($price_break_array as $key1 => $products_price) } // end foreach ($_POST['products_price_break'] as $pbb_cg_id => $price_break_array) // delete the unwanted price breaks using their products_price_break_id's if (isset($delete_from_ppb_array) && sizeof($delete_from_ppb_array > 0) && tep_not_null($delete_from_ppb_array[0])) { tep_db_query("delete from " . TABLE_PRODUCTS_PRICE_BREAK . " where products_price_break_id in (" . implode(',', $delete_from_ppb_array) . ")"); } // EOF entries in products_price_break // EOF QPBPP for SPPC //////////////////////////////////////// thank you all. genesis
  6. hello, what version of curl and openssl do I need to run Authorizenet AIM ? I currently have curl 7.9.2 and openssl 0.9.6b. Will it be a problem ? tia. Jeff
×