Jump to content
dev osCommerce
Forum
  • Checkout
  • Login
  • Contact Us
  • Get in touch

osCommerce

The e-commerce.

New Demo
Our Partners

newtech

Pioneers
 View Profile  See their activity

  • Posts

    494

  • Joined

  • Last visited

 Content Type 

Posts posted by newtech

    Products Attributes Sort v1.0

    in General Add-Ons Support

    Posted

    I have 2.3.1 install. I am trying to get this contrib to work but have a problem.

    I am getting the following error:

    PHP Fatal error: Class 'splitPageResults' not found in html/shop/admin/products_attributes.php on line 280

                    <td colspan="3" class="smallText" align="right">
<?php
   $options = "select * from " . TABLE_PRODUCTS_OPTIONS . " where language_id = '" . (int)$languages_id . "' order by products_options_id";
   $options_split = new splitPageResults($option_page, MAX_ROW_LISTS_OPTIONS, $options, $options_query_numrows);

   echo $options_split->display_links($options_query_numrows, MAX_ROW_LISTS_OPTIONS, MAX_DISPLAY_PAGE_LINKS, $option_page, 'value_page=' . $value_page . '&attribute_page=' . $attribute_page, 'option_page');
?>

     

    Any idea of what the problem could be?

     

    BTW in the install instructions for this contrib it says the following:

    **********

    * Upload *

    **********

     

    If you have an unmodified store you may upload

    and overwrite your files with the included fileset

    and complete Steps 1 & 2 ONLY below.

     

    Otherwise, please follow the step by step instructions below.

     

    There is no fileset included in the contrib. It would be nice to have an edited products_attributes.php file.

    Donation feature or contribution

    in General Add-Ons Support

    Posted

    Paying is fine if affordable. I understand. So what is the cost?

     

    What is the cost if it is fine tuned (not sure if it is possible).

    I have three causes so I would like three causees they could donate to. They could choose to enter an amount to 1 or all 3 of the causes.

     

    BTW. Yes charities and non-profits make money. But some like ours, barely make it. I donate tons and tons of hours, personal finances, etc. to keep ours running because the people we reach out to have nothing. I do not get paid for what I do.

     

    We give out free books on our site with suggested donations. Almost everyone gets them for free when I know some could pay. So I do know what it is like to give and give and everyone takes.

    Donation feature or contribution

    in General Add-Ons Support

    Posted

    Burt: I watched the youtube, it is not exactly what I need but would be great for now. So, I am confused. Where is the link to the contrib?

    osCommerce is an ecommerce solution, not a mechanism for donating. So, actually, not many people need the ability to add a dollar amount instead of a product, hence why it's never been coded up?.

    I don't totally agree with that assessment. There are many organizations that use OsCommerce for an ecommerce solution, that also would like to take donations.

     

    There are many requests on this site. Most just give up since they are left hanging with no response. I am being more persistent. The reason I have posted at different locations is I am hoping that whoever posted in the past maybe found a solution and they are watching their post and will respond when I ask if they found a solution.

     

    Anyways I like what I saw on the youtube video. How do I get it?

     

    BTW I tried 6659. It messes up my shopping cart when other items are later added to the cart.

    HELP WITH CHARITY

    in Add-Ons Development

    Posted

    Ok,

     

    I am confused !

     

    Does nobody check the contribution area anymore ?????.

     

    Quick Add Donation on Checkout Confirmation

    This occurs at checkout time. It does not allow for the customer to donate specific dollar amounts for various donation items. i.e. donate $100 to organization and choose a specific amount for another organization (i.e. each donation option would be a seperate 'product').

     

    Donations

    This is making the store owner make the donation, not the customer. Not what has been asked for for years.

     

    Charity Round Up

    It is not applicable and is not what people have been asking for years now. This is not allowing the customer to enter a specific donation amount.

     

     

     

     

     

    Chris

    Donations with and without purchases

    in Other

    Posted

    Come on. If someone is asking how do a feature for their non-profit organization, give them the answer how to do it, not promote another non-profit. We need an answer also on how to make it so that people can enter a specific dollar amount. We would help pay for such a contrib.

    cross-sell wrong Buy URL

    in General Add-Ons Support

    Posted · Edited by Jan Zonjee

    I have a product that has some cross-sell items:

    www dot fairhavenhouse dot info / store / help-heal-book-p-177.html

     

    When you go down to the 'We Recommend', the links for the text image and text is correct. However, when you click on the 'Buy 1' link, the URL is for the exisitng product (p-177) instead of for the recommended cross-sell item.

    article manager 1.2b-1054-'a.authors_id'

    in General Add-Ons Support

    Posted · Edited by newtech

    I did the recommended articles.php edit that is suggested in the 7 Aug 2008 fix and now have both articles.php and articles_new.php working.

     

    However, I have another problem in regards to subtopics. I am getting a page not found:

    Topic-Addictions (http://www.mydomain.com/store/addictions-t-10.html)

    Subtopic-Alcohol.

     

    When clicking on Alcohol subtopic I am routed to the following URL that says URL not on server.

    http://www.mydomain.com/store/addictions-t-10_12.html

     

    EDIT-Fixed by adding these RewriteRule in .htaccess

    RewriteRule ^(.*)-t-([0-9]+).html$ articles.php?tPath=$2&%{QUERY_STRING}

    RewriteRule ^(.*)-t-([0-9]+_[0-9]+).html$ articles.php?tPath=$2&%{QUERY_STRING}

    RewriteRule ^(.*)-t-([0-9]+_[0-9]+_[0-9]+).html$ articles.php?tPath=$2&%{QUERY_STRING}

    article manager 1.2b-1054-'a.authors_id'

    in General Add-Ons Support

    Posted

    Look for the queries containing:

    from " . TABLE_ARTICLES . " a, " . TABLE_ARTICLES_TO_TOPICS . " a2t left join " . TABLE_TOPICS_DESCRIPTION . " td on

     

    and change them into:

    from (" . TABLE_ARTICLES . " a, " . TABLE_ARTICLES_TO_TOPICS . " a2t) left join " . TABLE_TOPICS_DESCRIPTION . " td on

     

    (putting parenthesis after "from" and before "left join" statements).

     

     

    MySQL 5.0.15 follows the syntax rules of SQL:2003:

     

    <from clause> ::= FROM <table reference list>

    <table reference list> ::=

    <table reference> [ { <comma> <table reference> }… ]

    <table reference> ::=

    <table factor>

    | <joined table>

    <joined table> ::=

    <cross join>

    | <qualified join>

    | <natural join>

    This works for the New Articles, but what needs to be done for the articles.php which is the All Articles?

     

    I find four references in the code for the above and changed them but still get the error message.

    articles database error

    in General Add-Ons Support

    Posted

    I am getting the following error when I click on 'New Articles' or 'All Articles':

    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' and a.articles_date_added > SUBDATE(now( ), INTERVAL '30' DAY)

     

    [TEP STOP]

    download immediately after payment

    in General Add-Ons Support

    Posted

    I have installed Download Controller v5.3. I am not using any c/c processing contribs, just default.

     

    I am offering audio files in CD or mp3(download) as atributes.

    I am also offering an attribute of either $0.00 retail or a person can choose various attributes to make a donation.

     

    Currently if the person orders the product and makes no donation or makes a donation via credit card, I must change the status of the dorder to 'Can Download'.

     

    I would like it that if they make a donation via credit card, that they can download the mp3 immediately. Is this feasible?

    If not, then I would like tht they can download the mp3 immediately regardless of how they make payment or even not make payment via 'free of charge'.

     

    Here is how I have my download configuration set up currently:

    Download Controller Update Status Value-5 (labeled Update)

    Downloads Controller Order Status Value-4 (labeled Can Download)

     

    (Order_status is 1=Pending 2=Processing 3=Shipped 4=Can Download 5=Update)

    Donation feature or contribution

    in General Add-Ons Support

    Posted

    I am needing the following. I do not see a contribution for this feature and do not see a way to do this.

     

    I am with a non-profit organization that would like visitors to our store have the ability to make donations to our organization for any amount. Currently we have created 'donation products'. All we do is create donation products for $10, $20, $50, etc. We would like to still have these because it can encourage individuals to click on a certain donation amount. However, it also brings limitations to donations. We would like to have a product that allows individuals to enter a dollar amount for the product themselves. Any ideas? I am surprised there is not something like this by now.

     

    I did notice a contrib where a customer can enter a dollar amount for a donation but it is not put in their total order (it is assumed that the store will make the donation). Wonder if anyone would know how to edit this contrib to make it work so that the dollar amount they enter is added to the order total. I can't remember if it is the Donations or Charity contrib.

×
×
  • Create New...