Jump to content

allaboutwicker

Members
  • Content count

    455
  • Joined

  • Last visited

  • Days Won

    1

Everything posted by allaboutwicker

  1. Hi, Thank you for a wonderful contrib! I am wondering if I did something wrong or if I have a setting off somewhere. I have the Additional Images contrib installed as well and if I use the setting "thumbnail" it pulls the first additional image that I have added for the product and displays that instead of the main image for the product. If I have it set to listing view it is fine. Any ideas??? Thanks!
  2. allaboutwicker

    Links Manager II

    My main error message is as follows: Warning: mysql_query() [function.mysql-query]: Unable to save result set in /homepages/12/d188340574/htdocs/store/includes/functions/database.php on line 44 2008 - MySQL client ran out of memory I have looked at database.php which is mentioned in the error message around line 44 and see this coding: if (defined('STORE_DB_TRANSACTIONS') && (STORE_DB_TRANSACTIONS == 'true')) { error_log('QUERY ' . $query . "\n", 3, STORE_PAGE_PARSE_TIME_LOG); } $result = mysql_query($query, $$link) or tep_db_error($query, mysql_errno(), mysql_error()); if (defined('STORE_DB_TRANSACTIONS') && (STORE_DB_TRANSACTIONS == 'true')) { $result_error = mysql_error(); error_log('RESULT ' . $result . ' ' . $result_error . "\n", 3, STORE_PAGE_PARSE_TIME_LOG); } return $result; } I am not a programmer so I do not understand much of this php coding stuff. I have a feeling though that there may be something in here which is causing my error. I do hope someone can help me on this one as I am losing back links since their links do not come up on my website right now, just the error message. Thanks again for any help!!!
  3. allaboutwicker

    Links Manager II

    Hi Jack, I got this response from my host, 1 and 1: This is an update regarding the conversation we had about the mysql error on your website. The reason why your website is showing the said error right now has to do with a the limitation allowed for your mysql database. The thing is the Max_used_connections allowed within our shared hosting package for mysql is only up to 60. You have already exceeded this limit since you have a Max_used_connections of 65. Do you have any idea what he means by this or does this give you any incite as to what may be triggering this error message as it is only happening on my links.php page??? Thanks!
  4. allaboutwicker

    Links Manager II

    Thanks Jack, I was pulling my hair out trying to figure out what I had done wrong. I will contact them as you suggested.
  5. 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!
  6. 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!
  7. 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.
  8. 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!
  9. 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!
  10. 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!
  11. 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!
  12. 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.
  13. 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.
  14. 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!
  15. 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!
  16. 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!
  17. allaboutwicker

    [Contribution] Additional Images Module

    Check to see if "define('FILENAME_LOGIN', 'login.php');" is in the INCLUDES/FILENAMES.PHP file.
  18. 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!
  19. 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!
  20. allaboutwicker

    [Contribution] Discount Coupon Codes

    I found this thread: http://forums.oscommerce.com/index.php?showtopic=70852 Hope that helps!
  21. 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!
  22. 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.
  23. 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!
  24. 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!
  25. 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.
×