Jump to content

allaboutwicker

Members
  • Content count

    455
  • Joined

  • Last visited

  • Days Won

    1

Everything posted by allaboutwicker

  1. allaboutwicker

    Links Manager II

    Hello, I have tried to find a solution to the error message I now get when you go to my links page, but have not been able to find one. It used to work and I don't remember changing anything in my links files recently, but I just discovered that when you click to go to my links.php page it looks like it will go then you get this at the top of the page: Warning: mysql_query() [function.mysql-query]: Unable to save result set in bla..bla...bla.../includes/functions/database.php on line 44 2008 - MySQL client ran out of memory select l.links_status from links l LEFT JOIN ( links_description ld, links_to_link_categories l2c, link_categories lc ) on (l.links_status = 2 and ld.language_id = '1' and l2c.links_id = l.links_id and lc.parent_id = '0') [TEP STOP] 2013 - Lost connection to MySQL server during query select count(*) as total from sessions where sesskey = '85a7f0f6b20152ef64d270b92831f404' [TEP STOP] Does anyone have any clue how to fix this??? I only get this error message in links and only on the store side, admin appears to be working fine. Thanks in advance!
  2. allaboutwicker

    [Contribution] Additional Images Module

    Hi Patrick, I am not sure if this will help you to locate where the add image button can be found, but I thought why not. I took a screenshot of my admin/catalog for you: Click Here Do you see it on the bottom right corner below the main product image? hope that helps!
  3. allaboutwicker

    [Contribution] Discount Coupon Codes

    Hi, I am not sure on your checkout page being changed, but I think you missed adding the following to your includes/database_tables.php file: //kgt - discount coupons define('TABLE_DISCOUNT_COUPONS', 'discount_coupons'); define('TABLE_DISCOUNT_COUPONS_TO_ORDERS', 'discount_coupons_to_orders'); //end kgt - discount coupons I believe this may be giving you the error message.
  4. allaboutwicker

    [Contribution] Additional Images Module

    Hi, I had the same thing happen and I had read somewhere that if the file name is too long it can't accept it. Try when you are in a product and click to add image to delete all info except leave the file as "products/" in the upload location box and see if it will take it then. I hope that helps!
  5. allaboutwicker

    [Contribution] Discount Coupon Codes

    Hi, I am not sure on this, but it is an easy thing to try. Go into your Admin->Modules->Order Total and check to see how you have the order of the choices there. I remember I had to play around with mine when I had installed this contrib. I have mine as: Sub Total - 1, Tax - 2, Shipping - 3, Discount Coupon - 4 and Total - 5 Hope this helps!
  6. allaboutwicker

    [Contribution] Discount Coupon Codes

    Hi, I am not sure if I installed the same exact contrib, but mine has this in the instructions: The module will automatically create the database tables needed, there is no SQL script you need to run, unless the script encountered an error creating the tables (this can happen if the user osCommerce connects with does not have CREATE TABLE permissions). See the common problems section if you need to manually run the create table statements. Then down in the problem section it has: # Creating the database tables failed, and I need the SQL statements. Here you go: CREATE TABLE IF NOT EXISTS discount_coupons ( coupons_id VARCHAR(32) NOT NULL DEFAULT '', coupons_description VARCHAR(64) NOT NULL DEFAULT '', coupons_discount_amount DECIMAL(15,12) NOT NULL DEFAULT '0.0000', coupons_discount_type ENUM ('fixed','percent','shipping') NOT NULL DEFAULT 'percent', coupons_date_start DATETIME DEFAULT NULL, coupons_date_end DATETIME DEFAULT NULL, coupons_max_use INT(3) NOT NULL DEFAULT 0, coupons_min_order DECIMAL(15,4) NOT NULL DEFAULT '0.0000', coupons_min_order_type ENUM('price','quantity') DEFAULT 'price', coupons_number_available INT(3) NOT NULL DEFAULT 0, PRIMARY KEY (coupons_id) ); CREATE TABLE IF NOT EXISTS discount_coupons_to_orders ( coupons_id VARCHAR(32) NOT NULL DEFAULT '', orders_id INT(11) DEFAULT '0', PRIMARY KEY (coupons_id,orders_id) ); CREATE TABLE IF NOT EXISTS discount_coupons_to_categories ( coupons_id VARCHAR(32) NOT NULL DEFAULT '', categories_id INT(11) NOT NULL DEFAULT '0', PRIMARY KEY (coupons_id,categories_id) ); CREATE TABLE IF NOT EXISTS discount_coupons_to_products ( coupons_id VARCHAR(32) NOT NULL DEFAULT '', products_id INT(11) NOT NULL DEFAULT '0', PRIMARY KEY (coupons_id,products_id) ); CREATE TABLE IF NOT EXISTS discount_coupons_to_manufacturers ( coupons_id VARCHAR(32) NOT NULL DEFAULT '', manufacturers_id INT(11) NOT NULL DEFAULT '0', PRIMARY KEY (coupons_id,manufacturers_id) ); CREATE TABLE IF NOT EXISTS discount_coupons_to_customers ( coupons_id VARCHAR(32) NOT NULL DEFAULT '', customers_id INT(11) NOT NULL DEFAULT '0', PRIMARY KEY (coupons_id,customers_id) ); CREATE TABLE IF NOT EXISTS discount_coupons_to_zones ( coupons_id VARCHAR(32) NOT NULL DEFAULT '', geo_zone_id INT(11) NOT NULL DEFAULT '0', PRIMARY KEY (coupons_id,geo_zone_id) ); Hope that helps!
  7. allaboutwicker

    [Contribution] Additional Images Module

    Update on my situation: I think I got it!!! I needed to incorporate the quantity coding properly. Of course it was just a matter of this php code stuff which I have to guess at unless directly told what to put in. Anyway, I wanted to say I think I am there before I waisted anyone's time trying to help me any more. Now to go and hopefully see how this contrib actually works!
  8. allaboutwicker

    [Contribution] Additional Images Module

    I thought I would add that when I upload the product_info.php file that comes with the contrib, it appears to work as in the pop up image is big again and the product page has all the information, but then when you click to add to cart, it goes to the shopping cart yet the item has not actually been entered into the cart. I am going over the product_info.php file again comparing my old version which works as far as functioning through the shopping cart, but not the extra image updates in place and the file from the contrib. If anyone has any suggestions they would be much appreciated.
  9. allaboutwicker

    [Contribution] Discount Coupon Codes

    Hi Ifan, I was wondering what other contribs you have installed which might be effecting this one? Also, I think I saw a while back that someone was having an issue with the coupon reducing the taxed amount besides taking the fixed amount off, but I can't seem to find it now. I could have sworn that this working properly for me and now it is definitely not. If anyone has any clue for me please let me know.
  10. allaboutwicker

    [Contribution] Additional Images Module

    Thanks surfalot, you have been a big help. I could have sworn that I had changed that one out. Anyway, I have the options now available in my product edit page. My last obstacle is the product_info.php file. I have so many contributions installed before this one, I am having quite a time even using the file compare program to get them to meld. I think I am close, but yet so far. I am not real good with this php coding stuff, so I feel like a hacker. When I upload the product_info.php file I have modified with your coding with my previous file, I lose the image and the price goes to $0.00. It is probably some little dot or semi colon thing somewhere. I haven't been able to figure it out yet. I am so anxious to see this contrib in action! Anyway, any further ideas for me would be Oh so appreciated or if you could take a look at my file and tell if you see what is wrong, that would be awesome. Thanks again for all your help!
  11. allaboutwicker

    [Contribution] Additional Images Module

    Hi, I am still trying to install this one. Getting there, but still need help. I do not see anywhere on the product edit page where you add the images. This screen does not seem to be changed at all. I believe I have changed and added all files, but obviously have missed something here. Can you tell me what I should be checking? Thanks!
  12. allaboutwicker

    [Contribution] Additional Images Module

    Also: check in your admin/includes/languages/english.php there should be a line there that says CODE define('BOX_CONFIGURATION_ADMINISTRATORS', 'Administrators'); If it is not there, add it in around about line 59, and under the line that says CODE define('BOX_HEADING_CONFIGURATION', 'Configuration'); Just a note: I found this info by doing a google search of the errors you posted. Of course I had to take out any parts that were specific to your site, but sometimes you get lucky by doing that and get your answers. Hope this helps!
  13. allaboutwicker

    [Contribution] Additional Images Module

    Check to see if "define('FILENAME_LOGIN', 'login.php');" is in the INCLUDES/FILENAMES.PHP file.
  14. allaboutwicker

    UPSXML sql

    The way I run sql files is to use a program one of which is called phpMyAdmin. You probably have this somewhere in your cpanel (control panel) for your website. On one of mine I have to first go into MySQLAdministration then the phpMyAdmin is in there. Search in your cpanel and you might find it. It was already available in both of the sites I have with different companies. Anyway, hopefully its there, if not maybe you can download it. Assuming its there, what you do is make sure you have made a backup of your database! Just in case. Then go into phpmyadmin and make sure you are in the correct database if you have more then one on your site. You will see several tabs on the top of a box and one will be Import or if that isn't there then click on the one that shows SQL. You should get a Browse button feature. Just browse for where the SQL file is on your computer for the contribution installation and click GO or possibly RUN and that is all! it should do what the file commanded it to do. You may also manually cut and paste the SQL file into the box, but I would prefer to browse for it. Hope this helps!
  15. allaboutwicker

    Running an SQL on my database

    Hi, The way I run my sql files is to use a program which is called phpMyAdmin. You probably have this somewhere in your cpanel (control panel) for your website. On one of mine I have to first go into MySQLAdministration then the phpMyAdmin is in there. Search in your cpanel and you might find it. It was already available in both of the sites I have with different companies. Anyway, hopefully its there, if not maybe you can download it. Assuming its there, what you do is make sure you have made a backup of your database! Just in case. Then go into phpmyadmin and make sure you are in the correct database if you have more then one on your site. You will see several tabs on the top of a box and one will be Import or if that isn't there then click on the one that shows SQL. You should get a Browse button feature. Just browse for where the SQL file is on your computer for the contribution installation and click GO or possibly RUN and that is all! it should do what the file commanded it to do. You may also manually cut and paste the SQL file into the box, but I would prefer to browse for it. Hope this helps!
  16. allaboutwicker

    [Contribution] Discount Coupon Codes

    I found this thread: http://forums.oscommerce.com/index.php?showtopic=70852 Hope that helps!
  17. allaboutwicker

    [Contribution] Additional Images Module

    I still can't figure out this error after installing this contrib: Fatal error: Cannot instantiate non-existent class: displayimages in //store/product_info.php on line 147 Does anyone have a clue for me??? Thanks!
  18. allaboutwicker

    [Contribution] Discount Coupon Codes

    Hi Simon, Sorry I am not one of those oscommerce Gurus. More like a learnin from doin, but I am trying to help. Anyway, I am posting another screen shot of my admin page with the settings shown as this might have something to do with it: Screen Shot Not sure but compare mine to yours and see if they are the same. Notice that I have Display subtotal with applied discount: false and Display tax in discount line: None and then I have them set up in a certain order to come up on the customer screen. I do not have a good memory and it has been a while since I installed this, but I seem to recall that I had to play around with these settings a bit until it worked out correctly. Hope this helps or if not that one of those Gurus will find it and come up with a solution.
  19. allaboutwicker

    [Contribution] Additional Images Module

    Hi, I installed this contrib and am getting this error message: Fatal error: Cannot instantiate non-existent class: displayimages in //store/product_info.php on line 147 From what I have read and can figure, it is telling me that it can't find displayimages.php in the includes/classes folder, but I did put it there and verified that it is there. Does anyone know what else I need to do? Thanks!
  20. allaboutwicker

    [Contribution] Discount Coupon Codes

    I tried on my site and it worked as it should. I am not sure what is causing your problems, but it may be your settings in the total order module. Here is a screen shot of how mine are set: Screen Shot Hope this helps!
  21. allaboutwicker

    [Contribution] Discount Coupon Codes

    It looks like your 10% is coming off of the tax as well as the subtotal. 72.03 + 11.15 = 83.18 x 10% = 8.32 off Is that how you wanted it? I will have to check how mine is set up and get back to you. It has been a while since I set mine up.
  22. allaboutwicker

    [Contribution] Discount Coupon Codes

    I see from your contribution list that you use the STS template contrib. I have not tried that one yet and for the main reason that it seems to cause a lot of hard times getting other contribs to work from what I have read. I may be wrong, but that is my hunch as to what is giving you grief. Have you checked that thread for answers to some of your problems?
  23. allaboutwicker

    PayPal IPN v2.3.3 error!

    Hi, I am not 100% sure on this, but I plugged your error message in google search and found this: http://discussionboard.prostores.com/showp...amp;postcount=6 Worth taking a look.
  24. allaboutwicker

    Trying to find a module. I saw in the past....

    Hi, I just wanted to let you know that I went to your site to take a peek and noticed that when you click on the Specials link at the top you get the following error: 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 '-9, 9' at line 1 select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from products p, products_description pd, specials s where p.products_status = '1' and s.products_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and s.status = '1' order by s.specials_date_added DESC limit -9, 9 I am not sure how to fix it, but did find this thread with not exact, but similar error thru a google search: http://forums.oscommerce.com/index.php?sho...144095&st=0 Also, I noticed that you have not changed your title of your site from showing osCommerce.
  25. allaboutwicker

    Trying to find a module. I saw in the past....

    Hi, I found this one: http://addons.oscommerce.com/info/367 You might also check this one as it looks quite interesting and more recent: http://addons.oscommerce.com/info/1333 How I found them was I went to the Community --> Contributions and searched "weight shipping" to see what came up. I looked thru and picked out these, but there may be more there you may want to use instead. I have not used any myself to give an opinion as to how well they work. Hope this helps!
×