boltje

Sometimes life is simple :-) tnx Jim Changed the /includes/functions/database.php for the SHP module (one space less) Regards Martin

Thanx Jim, Yes I have the SHP module, it has a modification in database.php. Getting late, try to find things out tomorow.

Sorry Jim, had to write it a bit more clear with the difference in my pages. As you say, there is no difference in de sql statement. However, i just replaced my file with the original file for example the fp_scroller.php and imidiatly the error is back. (if only fp_new_products is active I don't have the sql error and the results of new product items are on my page.) mysql version 5.5.31 This is the result for the fp_scroller.php: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where p.products_id not in(45, 82)' at line 18 select p.products_id, p.products_image, pd.products_name from products p join products_description pd on pd.products_id = p.products_id where p.products_status = '1' and pd.language_id = '4' order by rand() limit 20 where p.products_id not in(45, 82) [TEP STOP]

Having some problems with the modules in /includes/modules/frontpage The only one working was fp_new_products.php The fp_specials.php did not work, some sql error. Strange. Comparing these fp_new_products.php and fp_specials.php I changed this in fp_specials.php if ($PHP_SELF == 'index.php' && $cPath == '') { $specials_products_query_raw = " select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from " . TABLE_PRODUCTS . " p join " . TABLE_PRODUCTS_DESCRIPTION . " pd on pd.products_id = p.products_id join " . TABLE_SPECIALS . " s on s.products_id = p.products_id where p.products_status = '1' and pd.language_id = '" . ( int ) $languages_id . "' and s.status = '1' order by RAND() limit " . MODULE_FRONT_PAGE_SPECIALS_MAX_DISPLAY . " "; // print 'Specials Query: ' . $specials_products_query_raw . '<br />'; $specials_products_query = tep_db_query( $specials_products_query_raw ); into this: (which is similar to the fp_new_products.php) if ($PHP_SELF == 'index.php' && $cPath == '') { // print 'Specials Query: ' . $specials_products_query_raw . '<br />'; $specials_products_query = tep_db_query( "select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from " . TABLE_PRODUCTS . " p join " . TABLE_PRODUCTS_DESCRIPTION . " pd on pd.products_id = p.products_id join " . TABLE_SPECIALS . " s on s.products_id = p.products_id where p.products_status = '1' and pd.language_id = '" . ( int ) $languages_id . "' and s.status = '1' order by RAND() limit " . MODULE_FRONT_PAGE_SPECIALS_MAX_DISPLAY ); This worked for me. Now, on the other hand, is this a good solution? Or will it give other (hidden) problems after. I have osc2.3.3 and frontpage 1.4 (php 5.3.10)

Thnx Chris, but it seems there is a little problem with the latest Ideal 1.5A Module (dutch payment) In checkout_process.php a part of the IDEAL module (just before the discount coupon should be added) I found a problem. One of the If statements was not closed well. A few code was not executed because of this, part of it was the kgt discount module.

Just added coupon discount 334 to an almost clean OScommerce 2.3.3 (ideal , SHP and SEO ultimate) The strange thing is, when a client puts a discount code in the field at checkout_payment.php (valid or non valid code) it just goes to checkout_confirmation.php without the discount calculated. If however the customer enters something in the comments about the order (entry above discount) and then puts a code in the discount field, the discount will be taken to the checkout_confirmation.php. (And when filling in a non valid discount coupon, on top of the page there will be an error notification that the code is not valid.) So only if a comment is filled in it will accept the discount? Looks like the function the check coupon does not work here. (i removed everything and installed it twice to be sure, but no difference) Anyone else had this problem? and has a solution for this?

Just did a new install for a webshop, with oscommerce 2.3.3. And I can't find this code either. Also using SHP latest release ready for 2.3.3