Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

carolannjo

Archived
  • Posts

    42
  • Joined

  • Last visited

Everything posted by carolannjo

  1. I am getting the same error as Paul since installing the indvship module. When I go to checkout-shipping page, I get the error: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/creative/public_html/includes/classes/shipping.php on line 33 Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/creative/public_html/includes/classes/shipping.php on line 68 Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/creative/public_html/includes/classes/shipping.php on line 68 Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/creative/public_html/includes/classes/shipping.php on line 68 I have looked through the documentation and nothing speaks to this. However, I am puzzeled by an instruction to remove some code which has also been mentioned in the Forum. I don't have this code and am curious why or if it affects this module. The text follows: Remove the following code (unless you are using the ship method from another contibution) in: catalog / admin / categories.php //Product shipping $ship_method_array = array(array('id' => '', 'text' => TEXT_NONE)); $ship_method_query = tep_db_query("select methods_id, methods_name from " . TABLE_SHIPPING_METHODS); while ($ship_method = tep_db_fetch_array($ship_method_query)) { $ship_method_array[] = array('id' => $ship_method['methods_id'], 'text' => $ship_method['methods_name']); } //end Product shipping Is this just from another module and not needed for this module? Any help for the mysql error will be greatly appreciated. I am using osC 2.2.2 and have several other modules installed and wanted to try this because I can't get USPSMethods to work properly. Carol Ann I just wanted to add that line 33 (to follow) does not appear to have been changed from my previous shipping.php file. So I'm guessing the problem is with the SQL provided: $include_modules[] = array('class' => substr($module['id'], 0, strpos($module['id'], '_')), 'file' => substr($module['id'], 0, strpos($module['id'], '_')) . '.' . substr($PHP_SELF, (strrpos($PHP_SELF, '.')+1))); Any idea?
  2. I am also getting the error message: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/creative/public_html/includes/functions/database.php on line 103. I have installed Get 1 free 1.4 and I also installed Category Discount module today. I can't find a problem in either installation, but it appears to be something to do with Get 1 Free. Any solution for this yet? I am using osc 2.2 (not RC1). Thanks, Carol Ann
  3. I am using Header Tags 2.6.3 and I have osCommerce 2.2.2. I have default tags set up for general pages, but I can't get the information I set up in the products pages to show up. I think I have tried every combination in Text Control, but it always shows the default tags. I have unchecked all the HTXX boxes including HTPA, but this always remained checked. I know you can fill tags on the Fill Tags page, but this will overwrite the tags I have set up. Is this my only option to get my keywords and descriptions to show up in the source code? Thanks for your help, Carol Ann
  4. I am using Header Tags 2.6.3 and I have osCommerce 2.2.2. I have default tags set up for general pages, but I can't get the information I set up in the products pages to show up. I think I have tried every combination in Text Control, but it always shows the default tags. I have unchecked all the HTXX boxes including HTPA, but this always remained checked. I know you can fill tags on the Fill Tags page, but this will overwrite the tags I have set up. Is this my only option to get my keywords and descriptions to show up in the source code? Thanks for your help, Carol Ann
  5. Never mind. I uploaded the files again and this time it worked. Thought I had already done this. Thanks again for your support. Carol Ann
  6. Jack, I am having the same problem. I recently had to rebuild my entire website and install all modules fresh. My product tags and descriptions are all filled in but they all show up as the Default Title Tag and Description. I have tried each of your suggestions above. I also have tried using the fill all tags section (I asked it to limit the number of characters in the description and it did that, so I know this function works). However, the source still shows the default tags. The code in the products_info.php has not changed. I have tried checking and unchecking the boxes in Text Control page. What's next? Thanks, Carol Ann
  7. I am getting the same error that so many people have reported: Warning: move_uploaded_file(): Moved: '/var/tmp/phpje9kcZ' to '/home/creative/public_html/images/baby.jpg' in /home/creative/public_html/admin/includes/classes/upload.php on line 91 Warning: Cannot modify header information - headers already sent by (output started at /home/creative/public_html/admin/includes/classes/upload.php:91) in /home/creative/public_html/admin/includes/functions/general.php on line 22 However, the problem is definitely not whitespace. In fact I deleted whitespace from every file that could be remotely connected. Does this have anything to do with Ultimate SEO URL's. That and the CCGV were the last things I installed. I get the above error when I try to add new categories in Admin. Hope someone finds an answer for this. Please let me know ifyou have any suggestions. Carol Ann
  8. I installed the Country State Selector in anticipation of installing Florida County Based Tax Zones for OSC 2.2 MS2. I received one error in the admin/customers.php where there was an extra bracket: $processed = true; // +Country-State Selector } else if ($refresh == 'true') { $cInfo = new objectInfo($HTTP_POST_VARS); } // -Country-State Selector //} I commented out the extra bracket and the error went away. I also have this error which I have not been able to resove: "Cannot redeclare class order_total in /home/creative/public_html/includes/classes/order_total.php on line 13" I tried adding a new test customer to see if it had anything to do with your cautionary notes, but no change. I still get the error with a new customer. Can anyone help? I can't install my tax rates until this is resolved. Thanks so much, Carol Ann
  9. Thanks very much Jack. I was able to fix both problems. You're the man! Something I have found useful in finding problems is the WinMerge program which you can download at http://winmerge.org/ and two other programs for general editing are the HTML-Kit and the PHP Expert Editor both of which can be downloaded free. I also found FTP Voyager to replace FrontPage as an editor and I am very happy with this as well. Hopes this helps someone else. Carol Ann
  10. On this same subject, any idea why the contents of the HTC boxes in the Admin categories section are gone if you go back to edit them? So, whenever you try to change any keywords, titles, etc. you have to recreate everything instead of just being able to make a small chanage. Thanks, Carol Ann
  11. Hi Jack, Yes, I looked in those files and I'm sure it is there. This is what I want to do. When you edit a Category (in the Admin panel), there are a number of information boxes: Category Name, Category Image, etc. I want to change the size of the box to enter keywords (Header Tags Category Keywords). Only the Header Tags Category Description is large enought to enter keywords. Hope that clears it up. Thanks, Carol Ann
  12. Where can I change the size of the Keyword box in the Header Tags Controller mod? The Categories Description box is a nice size, but the Keyword box is so small it is difficult to edit or check the contents. Thanks, Carol Ann
  13. Where can I change the size of the Keyword box in the Header Tags Controller mod? The Categories Description box is a nice size, but the Keyword box is so small it is difficult to edit or check the contents. Thanks, Carol Ann
  14. Great contribution. I have one problem. The "New Products for (Month)" appears twice in the categories pages, but only in those that have subcategories. http://creativescrapbooksolutions.com/deluxe-pages-c-52.html Any idea where I can fix this? Everything else seems to work fine. Thanks, Carol Ann
  15. Does anyone know of a way to set the images in the printable catalog to be different than those in the website? My images are set to 200 x 200 because of the type of product that I sell, but I would like the catalog images to be smaller. http://creativescrapbooksolutions.com Thanks, Carol Ann
  16. Hi Jack, Did you ever come up with a solution for the email problem? This contirbution would be extremely helpful but not without the details in the email. It is not practical for me to turn off SEO URLS because other modules depend on it being set to true. Is there another solution yet? Thanks, Carol Ann
  17. Does anyone know of an up to date category discount module that comes with complete instructions? I have tried several and they either don't work or the instructions are so sketchy that I can't complete them. I really need something that allows you to discount products by category. I tried easy advanced specials admin: instructions don't see to be complete; Category discount: I had some conflicts (could have been the get_1_free module) I uninstalled it; Specials Admin: instructions not complete. I have installed several modules successfully, so I am competent to do so. Any suggestions? Thanks, Carol Ann :huh:
  18. I have the SEO_URL installed and had it working. I had some problems with another module, but I went back to a previous file. For some reason, I could no longer access any of the products pages. The images were fine, but clicking on them returned 404 page errors. I checked and rechecked all the files including both configure files. I finally discovered that if I disabled the SEO_URL's in the Admin section, everything is fine. HOWEVER, now I can't turn the SEO_URL's back on. If I Enable them, I get: Not Found The requested URL /company-bordeaux-wedding-scrapbook-album-p-84.html was not found on this server. Additionally, a 403 Forbidden error was encountered while trying to use an ErrorDocument to handle the request. -------------------------------------------------------------------------------- Apache/1.3.33 Server at creativescrapbooksolutions.com Port 80 I reset the cache both by inserting the reset code in categories.php and by doing it manually in Admin. Nothing seems to help. In addition to Ultimate SEO URLs (chemo's module) I also have Header Tags Controller, sid_killer and the googleSiteMap. Does anyone know how to get this working again? Thanks, Carol Ann
  19. Addendum to my previous question. I deleted the get_1_free table, but not the Quantity Price Breaks Per Product beacause I plan to reinstall when I resolve my problem. Is there anything in this table that would cause the product pages to be unaccessable? Quantity Price Breaks Per Product int(11) No auto_increment products_quantity int(4) No 0 products_model varchar(12) Yes NULL products_image varchar(64) Yes NULL products_price decimal(15,4) No 0.0000 products_date_added datetime No 0000-00-00 00:00:00 products_last_modified datetime Yes NULL products_date_available datetime Yes NULL products_weight decimal(5,2) No 0.00 products_status tinyint(1) No 0 products_tax_class_id int(11) No 0 manufacturers_id int(11) Yes NULL products_ordered int(11) No 0 products_price1 decimal(15,4) No 0.0000 products_price2 decimal(15,4) No 0.0000 products_price3 decimal(15,4) No 0.0000 products_price4 decimal(15,4) No 0.0000 products_price5 decimal(15,4) No 0.0000 products_price6 decimal(15,4) No 0.0000 products_price7 decimal(15,4) No 0.0000 products_price8 decimal(15,4) No 0.0000 products_price1_qty int(11) No 0 products_price2_qty int(11) No 0 products_price3_qty int(11) No 0 products_price4_qty int(11) No 0 products_price5_qty int(11) No 0 products_price6_qty int(11) No 0 products_price7_qty int(11) No 0 products_price8_qty int(11) No 0 products_qty_blocks int(11) No 1 Check All / Uncheck All With selected: -------------------------------------------------------------------------------- Print view Propose table structure Add field(s)At End of Table At Beginning of Table After products_id products_quantity products_model products_image products_price products_date_added products_last_modified products_date_available products_weight products_status products_tax_class_id manufacturers_id products_ordered products_price1 products_price2 products_price3 products_price4 products_price5 products_price6 products_price7 products_price8 products_price1_qty products_price2_qty products_price3_qty products_price4_qty products_price5_qty products_price6_qty products_price7_qty products_price8_qty products_qty_blocks -------------------------------------------------------------------------------- Browse Structure SQL Search Insert Export Import Operations Empty Drop Indexes: Keyname Type Cardinality Action Field PRIMARY PRIMARY 53 products_id idx_products_date_added INDEX None products_date_added Create an index on columns Space usage Type Usage Data 7,128 B Index 3,072 B Total 10,200 B Row Statistics Statements Value Format dynamic Rows 53 Row length ø 134 Row size ø 192 B Next Autoindex 87 Creation Nov 18, 2007 at 03:55 PM Last update Nov 22, 2007 at 06:12 AM
  20. I recently installed the Ultimate SEO_URL successfully. Then I tried to install a couple more modules (Quantity Price Breaks Per Product , Get_1_free, and category_discount_mc.) The first two worked but were not exactly what I needed. I never could get category_discount to work. I tried to install Thumbnailer on the fly, but it caused so many problems I had to go back to a previous version. So I should be back to the point of SEO_URL installation. HOWEVER, I am still having a problem that I had prior to going back to the previous installation. I don't have any errors in the Admin section and the index.php looks fine, but when you click on any image, it returns a 404 page. The urls look fine, but it can't find the product pages. I've checked and rechecked the configure.php pages. Does anyone have any idea where to look for the source of this problem? I also have Header Tags Controller installed and the googleSitemap files. My URL is http://creativescrapbooksolutions.com/index.php. Any clues would be apprectiated. Thanks so much, Carol Ann
  21. Hi, I installed Quantity Price Breaks v1.2.3 and found it very useful for certain items. Installation was very smooth. Kudos to the contributors. I have one issue and have not been able to find the answer in the thread. in fact, it says that it is supposed to check for quantity against stock, but I am finding that it doesn't. Most of my items are one of a kind and I enter 1 in the stock field. But when I test it, I find that it allows me to order more than is available in stock. Is there any way to fix this? Also, I would like to discount items by category (buy 2 items of one category get one free, or volumne discount, spend so much on certain category and get a discount). Most contribs don't do this and the one that does, Category Discount MC, isn't complete and there doesn't seem to be any support for it. Does anyone know of anything that will work with QPBPP? Thanks very much, Carol Ann Johnson
  22. Hello, I installed this contribution today (mb 2.3b) I had similar problems that others seem to have had, but could not find a solution that worked for me. I have that big ugly no_image.jpg in my categories box. It only appears in the index.php (you can even see in the code where it says : <td height="14" class="infoBoxHeading"><img src="images/no_image.jpg" width="200" height="200" border="0" alt=""></td> The image that normally would appear here, corner_right_left.gif, is right where it always is, but I can't find a way to fix this. I also commented out (/* // if no file exists display the 'no image' file if (!is_file($src)) { $src = "images/no_image.jpg"; } */ ) as suggested on the thread. this had not affect. Also, I am getting an error in the admin section. I thought if I changed the Thumbnail Path in Thumbnails, it might help. It just produced another error: Fatal error: Call to undefined function: tep_image_submit() in /home/creative/public_html/admin/configuration.php on line 133. This file doesn't seem to have changed but of course there is the change in the html_output.php files. I have removed the comments to see if this caused the second error, but it did not fix it. Hope you can help, Carol Ann Johnson http://creativescrapbooksolutions.com/index.php PS I have done nothing with the settings beyond the installation, but my pages are 10 times slower than before. I am assuming there is something yet to be done but of course do not want to proceed until the errors are gone. Thanks in advance. :(
  23. Jack, I was having the same problem and tried your solution. It works (removes the osCsid#) but when you try to add something to the shopping cart, you get this madate to set the cookie level to Medium. The instructions are very clear, but even after changing the setting to Medium, you continue be blocked by this warning. you are never taken to the cart even after setting the level to Medium. Did you ever figure this out? Carol Ann
  24. The developer of this contribution has declined to answer my question and I am hoping that someone else will be willing to try. The SEO_G installation says "The osC Admin configuration options are stored with configuration ID of 24. If this identifier is already in use you need to change the SQL file and the catalog\admin\seo_zones_config.php near the beginning $gID = .... " but it is not clear what I am supposed to change the $gID to. It is 24 in my configuration files as he states. When I run the "SELECT count(*) as total FROM configuration WHERE configuration_group_id=24" it returned 17 not 0, so I don't know what to modify in the .sql file. There is no mention of $gID in the .sql file. Can anyone help me with this so I can finish this installation? :( FULL TEXT of instruction in question: Database Changes Run the seo_g.sql file that came with this archive using phpmyadmin. This will create the necessary tables and configuration options. There is a good turorial how to use phpmyadmin here. The osC Admin configuration options are stored with configuration ID of 24. If this identifier is already in use you need to change the SQL file and the catalog\admin\seo_zones_config.php near the beginning $gID = .... You can identify if this ID is already in use by executing the following query in phpmyadmin SELECT count(*) as total FROM configuration WHERE configuration_group_id=24 Then check the total returned, if it's 0 it is not allocated and you can install the default .sql file, otherwise you need to modify it as explained above.
×
×
  • Create New...