Jump to content

abz786

Members
  • Content count

    30
  • Joined

  • Last visited

Everything posted by abz786

  1. Hi there, We've had the featured products contribution V 1.5 installed on our store since Oct 2004 and it's been running fine. We recently upgraded our test server from MySQL 3.23.58 to MySQL 5 and PHP 5. We now get the following error message when you click on a Category with Sub-Categories: 1054 - Unknown column 'p.products_id' in 'on clause' select distinct p.products_id, p.products_image, p.products_tax_class_id, s.status as specstat, s.specials_new_products_price, p.products_price from products p left join specials s on p.products_id = s.products_id, products_to_categories p2c, categories c left join featured f on p.products_id = f.products_id where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '75' and p.products_status = '1' and f.status = '1' order by rand() DESC limit 9 The above code is from the featured.php file under catalog/includes/modules/featured.php. This is a specific MySQL 5 issue as MySQL 5 introduces Server SQL modes as part of its SQL 2003 standards support, and uses a more stricter approach to executing SQL queries We have already applied the general patches for MySQL 5 compliance as stipulated in the latest oscommerce-2.2ms2-051113 update. Any help would be appreciated. Thanks Abz
  2. Hi Chris, Great contibition. I've been looking to add an extra text box field to the to the product.info.php page? Do you think this can be adapted for that?
  3. Hi Jason, Search for the featured products contribution under contributions. There should be a fix there, I remember seeing it last week. I hope it helps Abz
  4. abz786

    Protx Form Problem

    Hi Mark, I've exactly the same problem. What version of MySQL and PHP are you using? I've just encountered this problem after migrating from MySQL 3.23 & PHP 4.3.10 to MySQL 5.0.18 and PHP 5. No problems encountered for over two years until now. The other thing I've noticed, I only get this problem when the amount involved is ?100 or over. It's happened to two of our customers in the last 24 hours and both had order values over ?100. I then tested this on our test server and it happened again. I'm convinced it has something to do with order values and MYSQL 5. If I find out, I'll let you. Abz
  5. Brilliant!!! It worked first time, a great result. Hopefully this will help many others as Hosting Companies migrate to MYSQL 5. Many thanks for the solution. Abz
  6. Thanks for the reply Chris. I'm not technical, so I don't know how you did it but here is the code: $featured_products_query = tep_db_query("select distinct p.products_id, p.products_image, p.products_tax_class_id, s.status as specstat, s.specials_new_products_price, p.products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c left join " . TABLE_FEATURED . " f on p.products_id = f.products_id where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '" . $featured_products_category_id . "' and p.products_status = '1' and f.status = '1' order by rand() DESC limit " . MAX_DISPLAY_FEATURED_PRODUCTS); } So how does writing joins using INNER/LEFT JOIN statements with corresponding ON clauses, and removing the WHERE predicates, apply here?? Abz
  7. Hi, I've installed this fantastic contribution (Categories Box Bullet and Line only) and it looks great . However, ever so often I'm getting the following error in the categories box which disappears once you refresh the page: Warning: in_array(): Wrong datatype for second argument in /home/public_html/includes/boxes/categories.php on line 57 Warning: in_array(): Wrong datatype for second argument. Line 57 refers to the following section of my /boxes/categories.php file if ($foo[$counter]['parent'] == 0) { $categories_string .= tep_href_link(FILENAME_DEFAULT, $cPath_new); $categories_string .= '">' . tep_image(DIR_WS_IMAGES . 'arrow_right_nav.gif', '') . ' '; } else { $categories_string .= tep_href_link(FILENAME_DEFAULT, $cPath_new); $categories_string .= '">' . tep_image(DIR_WS_IMAGES . 'arrow_bullet_square.gif', '') . ' '; } //ACTUAL LINE 57 - SEE BELOW if ( ($id) && (in_array($counter, $id)) ) { $categories_string .= "<b><font color='#CC0000'>"; } Any ideas why this is happening??
  8. abz786

    [Contribution] Product Sort Order

    Hi, I've just installed this contribution on MS2.2. No problems everything working EXCEPT when you go back into a product admin page the number in the sort order box is missing. I often change quantities and If I don't remember to re-input a value in the sort order box it changes to 0 by default and messes everything up. It's a real pain? Any ideas? Anyone???
  9. abz786

    [Contribution] Product Sort Order

    Hi, I've just installed this contribution on MS2.2. No problems everything working EXCEPT when you go back into a product admin page the number in the sort order box is missing. I often change quantities and If I don't remember to re-input a value in the sort order box it changes to 0 by default and messes everything up. It's a real pain? Any ideas?
  10. I'm upgrading too and I get exactly the same message! Please advise. Thanks
  11. Quick question Bobby. Installed your Ultimate SEO URLs v1.4 last week, works great!. I also have the configuration cache contribution installed since last Oct (faster page loads less DB queries). No problems with this too. Should I be considering upgrading to your Ultimate SEO URLs v2.0? If yes, do I need to remove the configuration cache contribution. Please advise. Thanks
  12. abz786

    Faster Page Loads

    Hi, I installed the latest version of Configuration Cache 1.32, back in last October. It's been running smoothly. However, I've discovered that when you uninstall say a shipping or a payment module you cannot reinstall it again. When the install button is clicked nothing happens. I've had to replace the modified catalog/admin/module.php file with the orginal to then be able to install a shipping module. I don't know if this is a bug but does anyone have a solution?
  13. OK, I fixed the problem of errors when I select the rewrite method and this in turn fixed the problem of my 'product extra fields' disappearing. My .htaccess file was incorrect. I should have selected the bit of code if your store is in the root directory but I selected the code for the 'folder' option (from the installation instructions). All fixed and working brilliantly. Thanks
  14. Hi Bobby, I've just installed this contribution, worked first time. Excellent work, thanks. I also have 'product extra fields v1.3c' contribution installed on my system and there appears to be a conflict with your Ultimate SEO URLS contribution. Basically, when I enable your contribution via the admin screen, my product extra fields disappear. When I disable it, they're visible again. I'm using the Cname method. This leads me to my second question. When I select the rewrite method, i get an error message 'this URL cannot be found on this server. I'm using apache. Any thoughts?
  15. abz786

    EZier New Fields

    Thanks for the reply, I really appreciate it. Yes, I am displaying prices with a strike out. Your absolutely right, the strike out line would make the 8 look like a 0 - duh, It didn't even occur to me. I'll change the font to address the problem. Thanks for your help. Abdul
  16. abz786

    EZier New Fields

    I've successfully installed Ezier fields 5 contribution (which is an excellent contribution by the way). It's working perfectly except for one thing which is VERY bizarre. If the retail price has a number ' 8 ' in it, it gets replaced with a ' 0 '. So if the retail price is ?88.88, then it gets replaced by ?00.00, or if its ?98.98 you see ?90.90. Apart from number '8' all other numbers from 0 - 9 are fine. Any ideas what it could be? The problem only appears to be with this contribution. Any help will be appreciated. Thanks
  17. Thanks Jack. I think I've got a similiar issue with product_info.php. Have a look at this, I'm using both Dynamic Meta Tags and Header Controller Tags: ?> <!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN"> <html <?php echo HTML_PARAMS; ?>> <head> <?php //begin dynamic meta tags query --> ?> <title><?php echo $the_product_name; ?>: <?php echo TITLE ?></title> <meta name="keywords" content="<?php echo TITLE ?>, <?php echo $the_product_name; ?>, <?php echo $the_product_model; ?>, <?php echo $the_manufacturers['manufacturers_name']; ?>"> <meta name="description" content="<?php echo $the_product_description . "," . $the_product_name; ?>"> <?php //end dynamic meta tags query --> ?> <?php // BOF: WebMakers.com Changed: Header Tag Controller v1.0 // Replaced by header_tags.php if ( file_exists(DIR_WS_INCLUDES . 'header_tags.php') ) { require(DIR_WS_INCLUDES . 'header_tags.php'); } else { ?> <title><?php echo TITLE; ?></title> <?php } // EOF: WebMakers.com Changed: Header Tag Controller v1.0 ?> <base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>"> <link rel="stylesheet" type="text/css" href="stylesheet.css"> <script language="javascript"><!-- function popupWindow(url) { window.open(url,'popupWindow','toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=no,res izable=yes,copyhistory=no,width=330,height=270,screenX=150,screenY=150,top=150,le ft=150') } //--></script> Do you think this will be considered as spamming? Should I be using both? This is important to get right as it is the product info page. (By the way the Dynamic Meta Tags have been working very well, the site is being indexed by Google) Please advise. Thanks
  18. Hi, I've just successfully installed the Header Tags Controller contribution V2.3.7, great contribution, thank you. However, I wasn't sure what to do when it came to the index.php file within catalog as I've already installed the meta tags contribution. My existing code is as follows: > <!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN"> <html <?php echo HTML_PARAMS; ?>> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <title><?php // RJW Begin Meta Tags Code if (file_exists(DIR_WS_INCLUDES . 'meta_tags.php')) { require(DIR_WS_INCLUDES . 'meta_tags.php'); } else { ?> <title><?php echo TITLE ?></title> <?php } // RJW End Meta Tags Code ?> The instructions in the ReadMe to operate.txt state the following: ----------------------------------------------------------------------------------------------- In each file of /catalog/ you will need to make the following modification: Replace the existing two lines in all files that you want to use the Header Tags Controller: Old Lines: <meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>"> <title><?php echo TITLE ?></title> New Lines: <?php // BOF: WebMakers.com Changed: Header Tag Controller v1.0 // Replaced by header_tags.php if ( file_exists(DIR_WS_INCLUDES . 'header_tags.php') ) { require(DIR_WS_INCLUDES . 'header_tags.php'); } else { ?> <title><?php echo TITLE; ?></title> <?php } // EOF: WebMakers.com Changed: Header Tag Controller v1.0 ?> ----------------------------------------------------------------------------------------- I'm not sure what to do in this instance. Please advise. Thanks
×