Jump to content


  • Content count

  • Joined

  • Last visited

About tdhs

  • Birthday 01/20/1979

Profile Information

  1. tdhs

    Automatically send data feed to Froogle

    Hey all I've tried searching for the answer to this but I've either missed it or it's not out their. Just set up my googlefeeder.php and pointed my server to it and I get this : SQL error The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay| sql = SELECT concat( 'product_info.php' ,products.products_id) AS product_url, products_model AS prodModel, products_weight, manufacturers.manufacturers_name AS mfgName, manufacturers.manufacturers_id, products.products_id AS id, products_description.products_name AS name, products_description.products_description AS description, products.products_quantity AS quantity, products.products_status AS prodStatus, FORMAT( IFNULL(specials.specials_new_products_price, products.products_price) * 1,2) AS price, CONCAT( 'http://www.desiretotouch.co.uk/retail/images/' ,products.products_image) AS image_url, products_to_categories.categories_id AS prodCatID, categories.parent_id AS catParentID, categories_description.categories_name AS catName FROM (categories, categories_description, products, products_description, products_to_categories) left join manufacturers on ( manufacturers.manufacturers_id = products.manufacturers_id ) left join specials on ( specials.products_id = products.products_id AND ( ( (specials.expires_date > CURRENT_DATE) OR (specials.expires_date is NULL) ) AND ( specials.status = 1 ) ) ) WHERE products.products_id=products_description.products_id AND products.products_id=products_to_categories.products_id AND products_to_categories.categories_id=categories.categories_id AND categories.categories_id=categories_description.categories_id ORDER BY products.products_id ASC my knowledge of databases and php is not great although I do try - so please any advice please speak in plain english!!! Thanks Rob
  2. tdhs

    Free Shipping over a certain amount

    An old thread I know but does anyone know why when I install this it does not save my settings in admin. I want to change from free shiiping at 50 to free shipping at 30 - every time I update it reverts back to 50. Cheers Rob
  3. OK all working now and great. I have 1 last problem though - in admin if I go to add or modify a product it no longer displays the product name, if I update the product the name is not displayed (appart from in the page name). I think the bit of code should be in admin/categories.php and I have checked but I can't see what is wrong. I'm no PHP expert though! Can anyone advise? Also - not a problem but was wondering - can this mod be made to display categories and sub categories as well as the product name in the keywords? Cheers Rob
  4. Cheers Jack I knew I'd done something wrong!! Boy I had - I forgot to upload admin/includes/filenames I wanan kill myself it only took 12 hours to discover! Hopefully I'll be fault free and can enjoy a great contrib Cheers Rob
  5. Hi all Tried reading through this thread but couldnt find my answers. Just installed this mod but few problems. 1. No Header Tag option is available in admin. 2. When I go to add or edit a product I get: Fatal error: Call to undefined function: tep_get_products_head_title_tag() in /home/sites/mydomain.co.uk/public_html/catalog/admin/categories.php on line 587 3. If I type in mydomain.co.uk/catalog/admin/header_tags_controller.php (or english.php) I get: Warning: main(includes/languages/english/FILENAME_HEADER_TAGS_CONTROLLER) [function.main]: failed to open stream: No such file or directory in /home/sites/mydomain.co.uk/public_html/catalog/admin/header_tags_controller.php on line 15 x3 and Fatal error: main() [function.require]: Failed opening required 'includes/languages/english/FILENAME_HEADER_TAGS_CONTROLLER' (include_path='.:/usr/share/pear') in /home/sites/mydomain.co.uk/public_html/catalog/admin/header_tags_controller.php on line 15 x1. I'm guessing I've done something wrong but I've tried 4 times at installing this only to get the same problems - any help much appreciated. Thanks Rob
  6. tdhs

    Specials valid from

    Hi there Did you ever get these 2 contribs working together. I haven't installed yet but I will be installing the category specials soon and could really do with this contrib as well. Cheers Rob
  7. Hi all Sounds like a great contrib - few probs tho! Like Noutje I'm using 2.6a 1. The products I use as gifts are also products in my catalog therefore have a value - when selected as a gift it is added to the cart and the customer charged the full amount. 2. In the free gifts box how do you enable it to display a random free gift? I know the code I need to edit but I'm not great with PHP - I tried but couldn't get it to work. 3. What code would I need to make a Free Gift page - one that will display like the specials page but without add to cart. Thanks in advance for any help!! Noutje - on my site when a gift has options there is an add to cart button.
  8. Hi all Apologies if these questions have been asked and answered somewhere but I can't find them!! I love this mod but I have 2 problems: 1. When checking out it deducts the reward points from the customers total but not the value of the reward points from the cutomers cart. 2. In 'my points information page' under the comments header it displays 'shopping points name' this works fine until that customer referes someone, then the name displayed is that of the person they refered. The actual points remain the original customers points. I'm using version ## POINTS AND REWARDS MODULE V2.0d ## CORRECTED with minor bug fix (11 Aug 06) and Referral Points Once insatalled. Thanks everyone.
  9. Quite new to os and this is the first time I've used a contibution like this. Looks great and its unfortunate that bobby can't offer his support on os anymore. I'm going to post a problem several people have posted before and I'm aware they have, I have read all 46 pages in this forum and tried every solution offered to others for my problem, none have worked :( When I click a product or catergry i get a 404 - page not found. My .htaccess file has been ammended (using notepad) and the directory changed to catalog as my store runs from there. the code now reads # $Id: .htaccess,v 1.3 2003/06/12 10:53:20 hpdl Exp $ # # This is used with Apache WebServers # # For this to work, you must include the parameter 'Options' to # the AllowOverride configuration # # Example: # # <Directory "/usr/local/apache/htdocs"> # AllowOverride Options # </Directory> # # 'All' with also work. (This configuration is in the # apache/conf/httpd.conf file) # The following makes adjustments to the SSL protocol for Internet # Explorer browsers <IfModule mod_setenvif.c> <IfDefine SSL> SetEnvIf User-Agent ".*MSIE.*" \ nokeepalive ssl-unclean-shutdown \ downgrade-1.0 force-response-1.0 </IfDefine> </IfModule> # If Search Engine Friendly URLs do not work, try enabling the # following Apache configuration parameter # # AcceptPathInfo On # Fix certain PHP values # (commented out by default to prevent errors occuring on certain # servers) # #<IfModule mod_php4.c> # php_value session.use_trans_sid 0 # php_value register_globals 1 #</IfModule> Options +FollowSymLinks RewriteEngine On RewriteBase /catalog/ RewriteRule ^(.*)-p-(.*).html$ product_info.php?products_id=$2&%{QUERY_STRING} RewriteRule ^(.*)-c-(.*).html$ index.php?cPath=$2&%{QUERY_STRING} RewriteRule ^(.*)-m-(.*).html$ index.php?manufacturers_id=$2&%{QUERY_STRING} RewriteRule ^(.*)-pi-(.*).html$ popup_image.php?pID=$2&%{QUERY_STRING} RewriteRule ^(.*)-t-(.*).html$ articles.php?tPath=$2&%{QUERY_STRING} RewriteRule ^(.*)-a-(.*).html$ article_info.php?articles_id=$2&%{QUERY_STRING} RewriteRule ^(.*)-pr-(.*).html$ product_reviews.php?products_id=$2&%{QUERY_STRING} RewriteRule ^(.*)-pri-(.*).html$ product_reviews_info.php?products_id=$2&%{QUERY_STRING} RewriteRule ^(.*)-i-(.*).html$ information.php?info_id=$2&%{QUERY_STRING} I also checked for spaces in my html_output.php as someone suggested but didn't see any difference to bobbys code. Any ideas much appreciated. :blink: