Jump to content


  • Content count

  • Joined

  • Last visited

Profile Information

  1. yodergraphics

    Automatically send data feed to Froogle

    My osCommerce Admin/error_log states... [09-Aug-2007 07:03:15] PHP Warning: ftp_put() [<a href='function.ftp-put'>function.ftp-put</a>]: base_products.txt: Permission denied on server. (Overwrite) in /home/stitchpi/public_html/catalog/admin/googlefeeder.php on line 364 More later if I fix....
  2. yodergraphics

    Automatically send data feed to Froogle

    Running: Google Base / Froogle Data Feeder v1.20 Date: February 25, 2006 PHP version 5.1.4 MySQL version 5.0.27-standard Hello, and thanks for the contrib. Problem: The script says it has uploaded... File completed: base_products.txt Connected to uploads.google.com, for user *** Uploaded ../feeds/base_products.txt to uploads.google.com as base_products.txt ...but the file never shows up on the Google Base website under "Bulk upload files>My Items" or at uploads.google.com when I ftp manually. No error messages are generated either. I've tried to both comment & uncomment the following line 362 in admin/googlefeeder.php, and this has not made anything appear on Google's end or on the ftp server: //ftp_pasv ( $conn_id, true ); What else can I try to get my server to relay the ftp file? Thanks in advance.
  3. yodergraphics

    JUST RELEASED! Printable Catalog

    The above fix works for Printable Catalog V 35 Sept 11-2005 when catalog_products_with_images.php and catalog_products_with_images_full.php are both getting the 1054 MySQL 5.0 error. In Catalog/catalog_products_with_images.php around line 344, replace with the above code posted by weerd. In Catalog/catalog_products_with_images_full.php around line 347, replace with the same code above. This should really be posted as an offical fix at the Contribution page
  4. NO - this error was not related to CCGV code. It turns out the offending code was a custom breadcrumb code in catalog/includes/application_top.php that removed the model number and replaced it with the product name instead.
  5. My version that worked with MySQL 4.0/PHP4 is heavily modified, but I will say my order_total.php doesn't have any of this ###CGV JONYO ### code. May try to roll back away from that if that's an update or go back to to 5.13d
  6. Hi, I'm getting the below error and I'm wondering if it's related to any code found in catalog/includes/add_ccgvdc_application_top.php. We upgraded to MySQL 4.1.21-standard and php 5.0.4 Error at top of any product page (only product detail pages): Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/stitchpi/public_html/catalog/includes/functions/database.php on line 103 Suspect code from catalog/includes/add_ccgvdc_application_top.php: //// // Create a Coupon Code. length may be between 1 and 16 Characters // $salt needs some thought. function create_coupon_code($salt="secret", $length = SECURITY_CODE_LENGTH) { $ccid = md5(uniqid("","salt")); $ccid .= md5(uniqid("","salt")); $ccid .= md5(uniqid("","salt")); $ccid .= md5(uniqid("","salt")); srand((double)microtime()*1000000); // seed the random number generator $random_start = @rand(0, (128-$length)); $good_result = 0; while ($good_result == 0) { $id1=substr($ccid, $random_start,$length); $query = tep_db_query("select coupon_code from " . TABLE_COUPONS . " where coupon_code = '" . $id1 . "'"); if (tep_db_num_rows($query) == 0) $good_result = 1; } return $id1; } //// // Update the Customers GV account function tep_gv_account_update($customer_id, $gv_id) { $customer_gv_query = tep_db_query("select amount from " . TABLE_COUPON_GV_CUSTOMER . " where customer_id = '" . $customer_id . "'"); $coupon_gv_query = tep_db_query("select coupon_amount from " . TABLE_COUPONS . " where coupon_id = '" . $gv_id . "'"); $coupon_gv = tep_db_fetch_array($coupon_gv_query); if (tep_db_num_rows($customer_gv_query) > 0) { $customer_gv = tep_db_fetch_array($customer_gv_query); $new_gv_amount = $customer_gv['amount'] + $coupon_gv['coupon_amount']; // new code bugfix $gv_query = tep_db_query("update " . TABLE_COUPON_GV_CUSTOMER . " set amount = '" . $new_gv_amount . "' where customer_id = '" . $customer_id . "'"); // original code $gv_query = tep_db_query("update " . TABLE_COUPON_GV_CUSTOMER . " set amount = '" . $new_gv_amount . "'"); } else { $gv_query = tep_db_query("insert into " . TABLE_COUPON_GV_CUSTOMER . " (customer_id, amount) values ('" . $customer_id . "', '" . $coupon_gv['coupon_amount'] . "')"); } } //// My catalog/includes/functions/database.php line 103 area function tep_db_num_rows($db_query) { return mysql_num_rows($db_query); } Any clues or help is appreciated!
  7. I seem to have this exact error msg "mysql_num_rows():...database.php on line 103" I am also running the CC/GV contribution. If anyone can post how they fixed this, it would be very helpful.
  8. yodergraphics


    Only in Mac Netscape 7.2, the Categories box is wider than it should be. (It's not shrinking to the size of the overlayed menu) Unlike some of the code posted around here, I have this code controlling the height of my Categories box: catalog/includes/boxes/coolmenu.php: <?php // get height of menu $height_query = tep_db_query("select count(*) as count from " . TABLE_CATEGORIES . " where parent_id = '0'"); $heightarray = tep_db_fetch_array($height_query); $height =($heightarray['count'] * 29.75); Like what you see above, is there a similar code to control the width for Netscape? (Like a $width=) Again, the width of the category box is working fine in Mac I.E. 5.2 and Safari If you are using Mac Net. 7.2, you can see the problem here: http://www.stitchpiecenpurl.com/catalog/ Thanks for your help!
  9. Wow, HeaderTags 2.5.5 version solved all of my previous bugs all at once that I had with the previous version.
  10. I had this same problem, caused by deleting any meta-content using the admin drop down menu. Something is causing that feature to truncating the top off of english/header_tags.php, spilling code all over the pages. I've started another post on this, next page.
  11. Bug 3: the edited catalog/product_info.php does not allow the product pages to appear. I do have a heavily modified product_info.php, but it's just a little snippet of code to add?? Here's what I have that crashes the product pages with the Header Tags Controller snippet added: <?php /* $Id: product_info.php,v 1.97 2003/07/01 14:34:54 hpdl Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2003 osCommerce Released under the GNU General Public License */ require('includes/application_top.php'); require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_PRODUCT_INFO); $product_check_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'"); $product_check = tep_db_fetch_array($product_check_query); ?> <!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN"> <html <?php echo HTML_PARAMS; ?>> <head> <?php // BOF: WebMakers.com Changed: Header Tag Controller v2.5.2 // Replaced by header_tags.php if ( file_exists(DIR_WS_INCLUDES . 'header_tags.php') ) { require(DIR_WS_INCLUDES . 'header_tags.php'); } else { ?> <title><?php echo TITLE; ?></title> <?php } // EOF: WebMakers.com Changed: Header Tag Controller v2.5.2 ?> <base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>"> <link rel="stylesheet" type="text/css" href="stylesheet.css"> <script language="javascript"><!-- function popupWindow(url) { window.open(url,'popupWindow','toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=no,res izable=yes,copyhistory=no,width=100,height=100,screenX=150,screenY=150,top=150,le ft=150') } //--></script> Jack_mcs, thanks for the advice on Bug 1 & 2
  12. Bug 1: When you delete meta content pages, it does not translate the code correctly in the process and resaves english/header_tags.php with a truncated start, and displays PHP code all over the pages. Everything above "WebMakers.com" in the below header_tags.php file is deleted. This is what is being deleted automatically: <?php // /catalog/includes/languages/english/header_tags.php // (catalog/includes/languages/english/header_tags.php error) Bug 2: When creating a new meta-content page (in this case, for shipping.php), the page will not appear. The correct code seems to be writing to catalog/includes/header_tags.php. Here's the code it doesn't like: // shipping.php case (strstr($_SERVER['PHP_SELF'],FILENAME_SHIPPING) or strstr($PHP_SELF, FILENAME_SHIPPING) ): $tags_array = tep_header_tag_page(HTTA_SHIPPING, HEAD_TITLE_TAG_SHIPPING, HTDA_SHIPPING, HEAD_DESC_TAG_SHIPPING, HTKA_SHIPPING, HEAD_KEY_TAG_SHIPPING ); break; If I take the above code out of catalog/includes/header_tags.php, the page will reapper, but of course, will only draw from the Default meta content. Both of these files set to chmod 777. If these fixes have been posted, please provide the link! Thanks.
  13. yodergraphics

    [Support] Category Fields

    Would Category Fields work to specify a deep link URL for a single sub category, so that when you click on that specific category, you are forwarded out of the osCommerce invironment to a 3rd party link. I am looking for a solution to do this. Please let me know, and thanks.
  14. I believe it is designed to have those appearing in Configuration>My Store area, separate from the other functions. Roll back prior to 5.13d to get files that have english. Do a search in this topic for french or topics posted by MzBeanz because it has been talked about a lot.
  15. yodergraphics

    Skipjack Geotrust Teanas~ error fix?

    The Problem: The word Teanas~ is transferred to the Skipjack credit card processor instead of a list of what was ordered. The word Teanas is hardcoded into the script, and apparently shouldn't be. This is a common posted problem, but no answers yet. Here's the bad code from Orderstring area of catalog/includes/modules/payment/geotrust.php: $process_button_string = tep_draw_hidden_field('Month', $this->cc_expiry_month) . tep_draw_hidden_field('Year', substr($this->cc_expiry_year, -2)) . tep_draw_hidden_field('Accountnumber', $this->cc_card_number) . tep_draw_hidden_field('Serialnumber', MODULE_PAYMENT_GEOTRUST_MERCHANT_ID) . tep_draw_hidden_field('Ordernumber', STORE_NAME . date('YmdHis')) . tep_draw_hidden_field('Transactionamount', number_format($order->info['total'], 2, '', '')) . tep_draw_hidden_field('Orderstring', 'Teanas~' . date('YmdHis') . '~' . number_format($order->info['total'], 2, '', '') . '~1~Y||') . tep_draw_hidden_field('cvv2', $HTTP_POST_VARS['geotrust_cc_cvv2']) . tep_draw_hidden_field('sjname', $HTTP_POST_VARS['geotrust_cc_owner_firstname'] . ' ' . $HTTP_POST_VARS['geotrust_cc_owner_lastname']) . tep_draw_hidden_field('Streetaddress', $order->billing['street_address']) . tep_draw_hidden_field('Streetaddress2', $order->billing['suburb']) . tep_draw_hidden_field('City', $order->billing['city']) . tep_draw_hidden_field('State', $order->billing['state']) . tep_draw_hidden_field('Zipcode', $order->billing['postcode']) . tep_draw_hidden_field('Country', $order->billing['country']['title']) . tep_draw_hidden_field('Shiptophone', $order->customer['telephone']) . tep_draw_hidden_field('Email', $order->customer['email_address']) . tep_draw_hidden_field('Shiptoname', $order->delivery['firstname'] . ' ' . $order->delivery['lastname']) . tep_draw_hidden_field('Shiptostreetaddress', $order->delivery['street_address']) . tep_draw_hidden_field('Shiptostreetaddress2', $order->delivery['suburb']) . tep_draw_hidden_field('Shiptocity', $order->delivery['city']) . tep_draw_hidden_field('Shiptostate', $order->delivery['state']) . tep_draw_hidden_field('Shiptozipcode', $order->delivery['postcode']) . tep_draw_hidden_field('Shiptocountry', $order->delivery['country']['title']); return $process_button_string; } Here's some tips from Skipjack on Orderstring variables that might be to you: Skipjack Integration Guide link Thanks for your help!