Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2009
    Location
    North Bendigo, VIC, Australia
    Posts
    158
    Plugin Contributions
    0

    Default Buy One Get One Free Module - Help Please

    I installed the module which can be found here


    I went to install the SQL however I got the following error in my admin:

    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 'Go to tools--->Install sql patches in the admin panel and run the following afte' at line 1
    in:
    [Go to tools--->Install sql patches in the admin panel and run the following after uploading all files to your site. make sure you back up your files first. BACK UP BACK UP BACK UP You have been warned. ///alternatively, you may change the file extension to .sql and upload it via phpmyadmin or through your zen_cart admin. Just delete everythng from here up and rename the text file to intstall.sql///// ALTER TABLE products ADD products_sell_quantity INT( 255 ) NOT NULL , ADD products_less_quantity INT( 255 ) NOT NULL , ADD products_coupon INT( 11 ) NOT NULL ;]
    If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
    Can anyone please shed some light as to why this is happening?

    I have a fresh install of ZenCart.
    Using Ashley Pink template


    Thanks in advance
    Kind Regards Casey

  2. #2
    Join Date
    Apr 2006
    Location
    London, UK
    Posts
    10,569
    Plugin Contributions
    25

    Default Re: Buy One Get One Free Module - Help Please

    The SQL is:

    ALTER TABLE products ADD products_sell_quantity INT( 255 ) NOT NULL , ADD products_less_quantity INT( 255 ) NOT NULL , ADD products_coupon INT( 11 ) NOT NULL ;

    It looks as though you tried to execute the instructions that go with it.
    Kuroi Web Design and Development | Twitter

    (Questions answered in the forum only - so that any forum member can benefit - not by personal message)

  3. #3
    Join Date
    Nov 2009
    Location
    North Bendigo, VIC, Australia
    Posts
    158
    Plugin Contributions
    0

    Default Re: Buy One Get One Free Module - Help Please

    Quote Originally Posted by kuroi View Post
    The SQL is:

    ALTER TABLE products ADD products_sell_quantity INT( 255 ) NOT NULL , ADD products_less_quantity INT( 255 ) NOT NULL , ADD products_coupon INT( 11 ) NOT NULL ;

    It looks as though you tried to execute the instructions that go with it.


    Thanks. I copied all that was in the notepad file and didn't take any notice until you have just mentioned it.
    Thanks .

    Kind Regards Casey

 

 

Similar Threads

  1. v151 % off on a whole order at checkout and buy one get one free option
    By webmiss in forum General Questions
    Replies: 3
    Last Post: 18 Sep 2013, 05:43 PM
  2. v139h Please help me do Buy One Get One Free
    By justwonder2 in forum Setting Up Categories, Products, Attributes
    Replies: 2
    Last Post: 13 Oct 2012, 12:31 AM
  3. Buy One Get One Free Module
    By Rexxo1 in forum All Other Contributions/Addons
    Replies: 7
    Last Post: 13 Aug 2011, 03:19 AM
  4. Is It Possible To Offer Buy One Get One Free On Zen Cart
    By UrbanGod in forum Managing Customers and Orders
    Replies: 6
    Last Post: 5 Sep 2009, 02:27 PM
  5. Big chooser Buy one Get one Free help
    By Andy_GS in forum Setting Up Categories, Products, Attributes
    Replies: 1
    Last Post: 13 Jan 2009, 12:40 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
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR