Jump to content
Our Partners

jchasick

Members
 View Profile  See their activity

  • Content count

    1,473

  • Joined

  • Last visited

Posts posted by jchasick

  1. Posted

    You're missing it somehow. I just checked and the definition is in admin/includes/languages/english/sitemap.php.

     

    Jack

     

     

    ok, I see that the defines are there

     

    after spending some time and experimenting with various things, I found the problem

     

    this may or may not be a php 5.x thing, but, I had to go thru the files for this contrib and change all

     

    <?

     

    to

     

    <?php

     

    once that was done, things started working

  2. Posted

    You probably downloaded one of the partial uploads the lazy and inconsiderate people upload. You will need to go through the various packages and find a full version. That definition is in there.

     

    Jack

     

    I have gone thru all of them and cannot find the defines for these variables

     

    thanks

  3. Posted

    Hi,

     

    I am wondering if there is any alternative program to WinMerge that I can use with a Mac. I guess some of the people doing contributions simply assume everyone uses a PC, but I don't, so I am having big trouble trying to figure out the changes on certain files that have no comments to guide me through them.

     

    Any suggestions would be greatly appreciated!

     

    Thanks!

     

    jailaxmi

     

    BBedit will show you the diffs between files and allow you to update

  4. Posted · Edited by jchasick

    The TEXT_EXCLUDE_FOR_UNREG in the error indicates the definition has not been installed. Have you uploaded the files included in the contribution to the correct location?

     

    Jack

    yes I have

     

    there is no define for TEXT_EXCLUDE_FOR_UNREG or other TEXT_ variables in any of the readme files

  5. Posted

    '.TEXT_EXCLUDE_FOR_UNREG.tep_draw_radio_field('ex_type','unreg');?>

     

    '.TEXT_EXCLUDE_FOR_UNREG.tep_draw_radio_field('ex_type','unreg');?>

    '.$exclude['exclude_file'].' ('.( $exclude['exclude_type'] == 1 ? TEXT_ALL : TEXT_UNREG ).') '.TEXT_INCLUDE.'

    '; } ?>

     

    '.$exclude['exclude_file'].' ('.( $exclude['exclude_type'] == 1 ? TEXT_ALL : TEXT_UNREG ).') '.TEXT_INCLUDE.'

    '; } ?>

    And on the catalog page -

     

    # ', $parent_group_end_string = ' ', $child_start_string = '', $child_end_string = '

    ', $spacer_string = '', $spacer_multiplier = 1; function osC_CategoryTree($load_from_database = true) { global $languages_id; $categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "' order by c.parent_id, c.sort_order, cd.categories_name"); $this->data = array(); while ($categories = tep_db_fetch_array($categories_query)) { $this->data[$categories['parent_id']][$categories['categories_id']] = array('name' => $categories['categories_name'], 'count' => 0);} } //end class osC_CategoryTree function buildBranch($parent_id, $level = 0) { $result = $this->parent_group_start_string; //starts the

     

    * tag if (isset($this->data[$parent_id])) { foreach ($this->data[$parent_id] as $category_id => $category) { $category_link = $category_id; $result .= $this->child_start_string; // prints if (isset($this->data[$category_id])) {$result .= $this->parent_start_string;} //prints nothing if ($level == 0) {$result .= $this->root_start_string;} //prints nothing $result .= str_repeat($this->spacer_string, $this->spacer_multiplier * $level) . ''; $result .= $category['name']; $result .= ''; if ($level == 0) {$result .= $this->root_end_string;} //prints nothing if (isset($this->data[$category_id])) {$result .= $this->parent_end_string;} //prints

     

    if (isset($this->data[$category_id]) && (($this->max_level == '0') || ($this->max_level > $level+1))) { $result .= $this->buildBranch($category_id, $level+1);} $result .= $this->child_end_string; //prints }// end foreach } // end if (isset $result .= $this->parent_group_end_string; // return $result; } //end function function buildTree() { return $this->buildBranch($this->root_category_id);}} ?>

     

    I am getting these same errors

     

    have installed, reinstalled the mod multiple times

     

    osCommerce 2.2-MS2

    PHP Version 5.1.6

    Database: MySQL 5.0.26-standard

     

     

    TIA

  6. Posted · Edited by jchasick

    to help narrow down where the error is occuring I added some echo statements and the error is being generated from the following code:

     

    catalog/articles.php

     

     

    <?php

    $articles_all_array = array();

     

    $articles_all_query_raw = "select a.articles_id, a.articles_date_added, ad.articles_name, ad.articles_head_desc_tag, au.authors_id, au.authors_name, td.topics_id, td.topics_name from " . TABLE_ARTICLES . " a, " . TABLE_ARTICLES_TO_TOPICS . " a2t left join " . TABLE_TOPICS_DESCRIPTION . " td on a2t.topics_id = td.topics_id left join " . TABLE_AUTHORS . " au on a.authors_id = au.authors_id, " . TABLE_ARTICLES_DESCRIPTION . " ad where (a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.articles_id = a2t.articles_id and a.articles_status = '1' and a.articles_id = ad.articles_id and ad.language_id = '" . (int)$languages_id . "' and td.language_id = '" . (int)$languages_id . "' order by a.articles_date_added desc, ad.articles_name";

     

     

     

     

    1054 - Unknown column 'a.authors_id' in 'on clause'

     

    select count(*) as total from articles a, articles_to_topics a2t left join topics_description td on a2t.topics_id = td.topics_id left join authors au on a.authors_id = au.authors_id, articles_description ad where (a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.articles_id = a2t.articles_id and a.articles_status = '1' and a.articles_id = ad.articles_id and ad.language_id = '1' and td.language_id = '1'

  7. Posted

    I used the patches in this thread and it fixed my problem with I click on NEW ARTICLES

     

    but... when I click on ALL ARTICLES, I am still getting the following error:

     

    1054 - Unknown column 'a.authors_id' in 'on clause'

     

    select count(*) as total from articles a, articles_to_topics a2t left join topics_description td on a2t.topics_id = td.topics_id left join authors au on a.authors_id = au.authors_id, articles_description ad where (a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.articles_id = a2t.articles_id and a.articles_status = '1' and a.articles_id = ad.articles_id and ad.language_id = '1' and td.language_id = '1'

     

    [TEP STOP]

     

     

    all I know is that the problem is in articles.php

     

    anyone know the patch for this?

     

    TIA

  8. Posted

    i just installed the latest contribution of the FedEx1 shipping module

     

    after installing i started testing and it is calculating rates corrently, but when i get to the checkout confirmation page, the shipping amount is not being added to the total, and i placed a test order, and the shipping amount was not on the order....

     

    any ideas?

     

    using ms2.2

  10. Posted

    thank you for finally re-writing this beast

     

    the install seemed to go fairly smoothly, but now i am testing and when i get to the shipping page i am receiving the following error:

     

    Rating and Service 1.0001 0 MODULE_SHIPPING_UPSXML_RATES_TEXT_COMM_UNKNWON_ERROR : Rating and Service 1.0001 0 MODULE_SHIPPING_UPSXML_RATES_TEXT_COMM_UNKNWON_ERROR

     

    I do have a valid access key

  12. Posted

    your response was basically "well it doesnt fit my requirement so what good is it?"

     

    that certainly makes people that write contributions feel good about trying to help others and is the reason why many people don't write them any more

     

    it would be more useful to say, "well, your contribution adds something but is also missing a piece that i could use and is there a way to add that to the contribution?"

     

    i write mods when people ask for a solution, and this particular solution was what everyone wanted - to add a list of products ordered to the standard paypal email so if the customer did not complete the order process and return to the site, then at least they could see what the person ordered without having to hunt down the customer and ask them what they ordered - this was also part of the reason the paypal ipn contribution was written

     

    we get 100's of requests to do things, and we try to fulfill requests as we can

     

    i do not feel 'obligated' to do anything, i do what i do because i want to give to the OSC group, but you can't please everyone, and so we do what we do, and then try to fill in any blank spaces as they arise

     

    asking nicely works wonderful

  16. Posted

    the way i wrote the original modification is:

     

    function process_button() {

    global $order, $currencies, $currency;

     

    if (MODULE_PAYMENT_PAYPAL_CURRENCY == 'Selected Currency') {

    $my_currency = $currency;

    } else {

    $my_currency = substr(MODULE_PAYMENT_PAYPAL_CURRENCY, 5);

    }

    if (!in_array($my_currency, array('CAD', 'EUR', 'GBP', 'JPY', 'USD'))) {

    $my_currency = 'USD';

    }

    $xx = '';

    for ($i=0; $i<sizeof($order->products); $i++) {

    $xx .= $order->products[$i]['qty'] . '-' . ($order->products[$i]['name']) . '**';

    }

    $process_button_string = tep_draw_hidden_field('cmd', '_xclick') . tep_draw_hidden_field('business', MODULE_PAYMENT_PAYPAL_ID) . tep_draw_hidden_field('item_name', STORE_NAME . ' ' . $xx) .tep_draw_hidden_field('amount', number_format(($order->info['total'] - $order->info['shipping_cost']) * $currencies->get_value($my_currency), $currencies->get_decimal_places($my_currency))) . tep_draw_hidden_field('shipping', number_format($order->info['shipping_cost'] * $currencies->get_value($my_currency), $currencies->get_decimal_places($my_currency))) . tep_draw_hidden_field('currency_code', $my_currency) . tep_draw_hidden_field('return', tep_href_link(FILENAME_CHECKOUT_PROCESS, '', 'SSL')) . tep_draw_hidden_field('cancel_return', tep_href_link(FILENAME_CHECKOUT_PAYMENT, '', 'SSL'));

     

    return $process_button_string;

    }

     

    this works with the standard paypal module but will not work with paypal ipn as the structure of the data that gets passed is different

     

    the $xx variable is used to parse the order and collect the information and then pass it to the paypal module so that when you receive a payment notification you will receive a list of the product(s) ordered in case the customer does not complete the paypal process and return to your site (so no invoice is generated by OSC)

     

    here is the original thread:

     

    http://forums.oscommerce.com/viewtopic.php...ighlight=paypal

  17. Posted

    you may have had the blank line in the SID contribution - that is normally the cause of that particular error msg and tracking it down can be daunting since it can be in any file in the stream of files being called up to the point where the error is finally flagged

     

    glad to hear that you have it working

     

    i would go thru the installation process for the SID killer - there is a SID killer built into the current version of OSC

  21. Posted

    i suppose you could do what you are talking about with the hidden products

     

    i am not familiar with the other contribution so i really couldnt speak about whether that would work or not, but one of the beauties of this cart if that since it is open source,you can modify awy to your hearts delight

     

    you should check out some of Linda's contributions as she is always doing things like that, and her SEC contribution has some of those types of features in it, but you have to use a specific CVS version

     

    with the impending release of MS2 I have a feeling she has been locked away working on an MS2 version....

  22. Posted

    it allows you to hide a product (or products), and in the admin you can go into user accounts and give them the ability to see the product

     

    we use it to offer special deals to various companies. we have people create an account, then email us their account email, go in and activate the hidden product function on their account, and thats it - then they can see the hidden products :wink:

×