Page 1 of 2 12 LastLast
Results 1 to 10 of 13

Thread: Buy Now buttons from catagories list is not working,

  1. #1
    Redeye_Joe
    Guest


    Default Buy Now buttons from catagories list is not working,

    Hi, the buy it now button for any of my items after you click on one of the catagories list doesnt work, it only works if you open the item then buy it now, not if you try to buy direct from the catagories page. Here is error that comes up;
    1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

    delete from customers_wishlist WHERE customers_id=1 AND products_id=

    [TEP STOP]


    Anyone else having this problem?
    Any ideas on how I can fix this? Thanks,

    Doug

  2. #2
    Redeye_Joe
    Guest


    Default RE: Buy Now buttons from catagories list is not working,

    If logged it this happens, but if you are not logged in, it acts like it adds it to the cart but shows nothing, and $0.00 for total.

    think it my have something to do with visitors cart.
    Please help!!
    Doug

  3. #3
    ganast
    Guest


    Default RE: Buy Now buttons from catagories list is not working,

    Apply patch for bug 11.

    http://bugtrack.oscmax.com/view.php?id=11

    --gabe

  4. #4
    cleangroove
    Guest


    Default RE: Buy Now buttons from catagories list is not working,

    Hello all... and props to all, especially Michael and Gabe for wonderful work and knowledge. I wasn't sure if I should open a new thread on this? I am also experiencing a Buy Now button issue for V2 from the Categories area. I have applied the ID=11 patch. I have tried my own homework on this, but now turned to the forum.

    Problem: The link that is offered when rolling over (and of course clicking) the Buy Now button - which excludes the .php file extension from the link.

    From this link
    http://partsoplenty.com/catalog/index.php?cPath=4

    Rolling over the Buy It Now button gives you this link
    http://partsoplenty.com/catalog/inde...;products_id=1

    Notice the .php is missing after index.

    OK, I'm not the PHP expert here but my problem is not PHP, but where to find where this link is generated.

    I'm not sure if I broke something applying bug fixes or not. Fix 11 is confirmed correct. I didn't just turn to the forum here. Please just point me in the right direction, if you can. The site is not live yet. This is not priority 1 for you, just for me. Thanks - Cleangroove

  5. #5
    sarahjessica
    Guest


    Default

    The fix for product_listing_col.php does not fix the SQL error because the problem is actually coming from includes/application_top.php - the database query is wrong. To fix it, change this:

    Code:
    // performed by the 'buy now' button in product listings and review page
          case 'buy_now' :        if (isset($HTTP_GET_VARS['products_id'])) {
    // BOF: MOD - Wish List 2.3
                if (tep_session_is_registered('customer_id')) {
                  tep_db_query("delete from " . TABLE_WISHLIST . " WHERE customers_id=$customer_id AND products_id=$products_id");
                  tep_db_query("delete from " . TABLE_WISHLIST_ATTRIBUTES . " WHERE customers_id=$customer_id AND products_id=$products_id");
                }
    // EOF: MOD - Wish List 2.3
    to this:

    Code:
     case 'buy_now' :        if (isset($HTTP_GET_VARS['products_id'])) {
    // BOF: MOD - Wish List 2.3
              if (tep_session_is_registered('customer_id')) {
              tep_db_query("delete from " . TABLE_WISHLIST . " where products_id = '" . $HTTP_GET_VARS['pid'] . "' and customers_id = '" . $customer_id . "'");
                                   // Begin Wish List Code w/Attributes
                                   tep_db_query("delete from " . TABLE_WISHLIST_ATTRIBUTES . " WHERE customers_id=$customer_id AND products_id='" . $HTTP_GET_VARS['pid']."'");
              }
    // EOF: MOD - Wish List 2.3
    Hope that helps!!

  6. #6
    macfionn
    Guest


    Default

    Thank you, sarahjessica, this has indeed squelched the error.

    Mac

  7. #7
    danhosts
    Guest


    Default

    OK, this is an easy fix but why is it not corrected in the download?

  8. #8
    osCMax Developer


    Buy Now buttons from catagories list is not working,

    michael_s's Avatar
    Join Date
    Jul 2002
    Location
    Phoenix, AZ
    Posts
    23,012
    Total Contributions For

    michael_s     $ 10.00
    Rep Power
    594


    Default

    This is fixed in the download. I just downloaded and installed RC3 and the issue is not present.
    Michael Sasek

    osCmax 2.5.4 is now available via auto-installation using Softaculous!

    Stay Up To Date with everything osCMax:
    osCmax on Twitter - Up to the minute info as it happens. Know it first.

    osCmax Documentation

  9. #9
    go2pub
    Guest


    Default

    Quote Originally Posted by michael_s View Post
    This is fixed in the download. I just downloaded and installed RC3 and the issue is not present.
    I downloaded RC3 about 2 weeks ago and had to apply this fix, not sure why but I did and it worked a treat.

    Oscmax is a great piece of work BTW, I'm in the process of switching from a standard osc install and so far oscmax is super.

  10. #10
    Pivkhan
    Guest


    Default Re: Buy Now buttons from catagories list is not working,

    I'm having a simular problem. The Buy now button doesn't do anything in IE but works fine in Firefox. The fixes mentioned above are all there and the adress it points to looks right. I have several other buttons not working in IE as well so I'm thinking that some global file is the problem here. any ideas anyone?

Page 1 of 2 12 LastLast

Similar Threads

  1. catagories & products HELP!!!
    By krystaleyes in forum osCmax v2 Installation issues
    Replies: 0
    Last Post: 11-11-2005, 11:44 AM
  2. Cart Buttons and check out not working
    By misersmith in forum osCommerce 2.2 Installation Help
    Replies: 2
    Last Post: 06-18-2005, 10:12 AM
  3. Change the number of Catagories
    By Milmod in forum osCommerce 2.2 Modification Help
    Replies: 4
    Last Post: 03-15-2005, 12:19 PM
  4. Listing of Catagories
    By Milmod in forum osCommerce 2.2 Modification Help
    Replies: 5
    Last Post: 02-28-2005, 05:44 PM
  5. Help - Catagories Menu Box Using Different Colors
    By smf in forum osCommerce 2.2 Modification Help
    Replies: 0
    Last Post: 05-14-2003, 04:07 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •