Jump to content

carolannjo

Members
  • Content count

    42
  • Joined

  • Last visited

Posts 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. 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

    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. Look in the products edit page in admin. If the header tags title is still there, then look in Text Control to make if the HTTA box for products is set (try unchecking it). The last thing would be that the code in the products_info.php file somehow changed.

     

    Jack

    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. The title description and keywords uses an input field while the description uses a textarea. The code in admin/categories.php (neat the bottom) would have to be edited to make the keywords use a text area.That is usuallu because a mistake was made with the changes for the categories file. Try using the included one to see if the problem goes away.

     

    Jack

    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. It would depend on which one you want to change. The files to edit would be admin/categories.php and admin/header_tags_english.php.

     

    Jack

    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. Looking at the discussion Matt pointed to earlier I found that I could make one simple change to get the same results you're trying for (to have searches from the left column to default to searching descriptions and names). Below is what I changed [note: the only change I did was to add the tep_draw_hidden_field('search_in_description', '1') at the end of the line]:

     

    Original:

    'text' => tep_draw_input_field('keywords', '', 'size="10" maxlength="30" style="width: ' . (BOX_WIDTH-30) . 'px"') . ' ' . tep_hide_session_id() . tep_image_submit('button_quick_find.gif', BOX_HEADING_SEARCH) . '<br>' . BOX_SEARCH_TEXT . '<br><a href="' . tep_href_link(FILENAME_ADVANCED_SEARCH) . '"><b>' . BOX_SEARCH_ADVANCED_SEARCH . '</b></a>');

     

    New:

    'text' => tep_draw_input_field('keywords', '', 'size="10" maxlength="30" style="width: ' . (BOX_WIDTH-30) . 'px"') . ' ' . tep_hide_session_id() . tep_image_submit('button_quick_find.gif', BOX_HEADING_SEARCH) . '<br>' . BOX_SEARCH_TEXT . '<br><a href="' . tep_href_link(FILENAME_ADVANCED_SEARCH) . '"><b>' . BOX_SEARCH_ADVANCED_SEARCH . tep_draw_hidden_field('search_in_description', '1') . '</b></a>');

    Just found this and it works perfectly. Thanks!


  13. I installed the last version and some files that were either not used or have somehow been broken from 1.3. So here is an extremely easy Featured replacement for you front page only. It also has an sql install that will give you admin control to turn it on or off. You can also designate the amount of products you wish to display from admin. Very easy and quick install. Simple to read instructions thanks to a previous contributor who gets named in the file.

     

    http://www.oscommerce.com/community/contributions,651

     

    any questions feel free to post them here for me to see

    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


  14. Hmm, I don't have an answer for you then. I've installed it into a shop using mysql 5 so I don't that is the issue. It may be php 5 related but it will be a while before I test that. The only thing I can think to suggest is to be sure the search engine friendly option in admin->configuration is turned off. If can cause some strange problems.

     

    Jack

    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


  15. 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:


  16. 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


  17. 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


  18. 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


  19. 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


  20. Just started this thread to have a page that I can link to in the updated readme.

     

    If you want to ask questions or have suggestions for 'On The Fly' Auto Thumbnailer using GD Library, then please do it here.

     

    If you are looking for a previous support thread, you can look here. Another thread, which is actually located in the contribution anouncements, you can find here.

     

    Cheers,

    Martijn.

    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. :(


  21. I had the same problem and while surfing this thread (all 100 pages of it)... i saw many more had the same problem..

     

    I found a solution(worked for me)..

     

    I forced the use of cookies...

     

    Admin -> Session -> Force Cookie Use True

    This made sure that the oscid did not show up in the URL, which meant that Ultimate SEO (big thanks Chemo) did it's thing perfectly... even the first time..

    If it does work for anybody else.. do post here...

    Cheers..

    Jack

    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


  22. 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.

×