Jump to content

fernyburn

Members
  • Content count

    137
  • Joined

  • Last visited

Posts posted by fernyburn


  1. Just installed the new 1.3 module

     

    1) the amount in the shopping cart now shows the amount minus tax instead of with tax (as is set in store config)

     

    2) When selecting the default state - it doesnt show - just shows 'please select'

     

    3) moving the postcode to a new line doesnt work, it sticks it in the middle of the column

     

    4) constantly get this error

    There was an error refreshing the final products listing, please inform ShedsForLessDirect about this error.

     

    not sure what has been done to this contribution, but it looks really bad now !


  2. My Hero !!

     

    yes it does - thankyou so much....

     

    This is perfect for me as I can now lose our trade site, as we have different prices for them, and yet more different prices for overseas trade, and I can make certain customers only see certain prices

     

    Fab - Thanks Again !


  3. hey fernyburn,

     

    go into the file catalog/includes/functions/database.php and REPLACE:

     

    if(stristr($query, " where "))

     

    WITH:

     

    if(substr($query, 0, 8) == 'describe')
    {
       //do not modify query
    }
    else if(stristr($query, " where "))

     

    (2 times: near line 53 and near line 93)

     

    does it help ?


  4. hI

    Can any one help with the below error

     

    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 categories_id not in(36, 36)' at line 1

     

    describe categories status where categories_id not in(36, 36)

     

    I have done the split results code changes - but it doesn't make any difference.

    I have installed the Simply hide products contribution this is what gives the error .... but it only shows on /shop/index.php - the error doesnt show on any other page.

     

    Any help pleeeeeze


  5. hi fernyburn

     

    Can you post the complete query which fails please (you can do this by placing echo $query; at database.php before //START SHP

     

    ok

     

    on database.php

     

    I have showing at the very top of the page (up before the header)

     

    select configuration_key as cfgKey, configuration_value as cfgValue from configurationselect value from sessions where sesskey = 'a1487fd9968d54d2919d4ca98e768278' and expiry > '1271262053'

    Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/****/public_html/shop/includes/functions/database.php:43) in /home/****/public_html/shop/includes/functions/sessions.php on line 102

    select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currenciesSELECT unixtime FROM hidden_products WHERE unixtime > 1271259570delete from whos_online where time_last_click < '1271261153'select count(*) as count from whos_online where session_id = 'a1487fd9968d54d2919d4ca98e768278'insert into whos_online (customer_id, full_name, session_id, ip_address, hostname, time_entry, time_last_click, last_page_url, http_referer, user_agent) values ('0', 'Guest', 'a1487fd9968d54d2919d4ca98e768278', '79.64.167.75', '79-64-167-75.dynamic.dsl.as9105.com', '1271262053', '1271262053', '/shop/', 'http://www.****.co.uk/shop/', 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv:1.9.2.3) Gecko/20100401 Firefox/3.6.3 (.NET CLR 3.5.30729)')select banners_id, date_scheduled from banners where date_scheduled != ''select b.banners_id, b.expires_date, b.expires_impressions, sum(bh.banners_shown) as banners_shown from banners b, banners_history bh where b.status = '1' and b.banners_id = bh.banners_id group by b.banners_idselect specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0

     

    and then actually on the index page

     

    describe categories status1064 - 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 categories_id not in(39, 38, 21)' at line 1

     

    describe categories status where categories_id not in(39, 38, 21)

     

    [TEP STOP]

     

    select count(*) as total from sessions where sesskey = 'a1487fd9968d54d2919d4ca98e768278'update sessions set expiry = '1271276453', value = 'cart|O:12:\"shoppingCart\":7:{s:8:\"contents\";a:1:{i:65;a:1:{s:3:\"qty\";i:1;}}s:5:\"total\";d:40;s:6:\"weight\";d:2000;s:6:\"cartID\";s:5:\"95721\";s:12:\"content_type\";s:8:\"physical\";s:13:\"total_virtual\";d:40;s:14:\"weight_virtual\";d:979976;}language|s:7:\"english\";languages_id|s:1:\"1\";currency|s:3:\"GBP\";navigation|O:17:\"navigationHistory\":2:{s:4:\"path\";a:1:{i:0;a:4:{s:4:\"page\";s:9:\"index.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:0:{}s:4:\"post\";a:0:{}}}s:8:\"snapshot\";a:4:{s:4:\"page\";s:11:\"account.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:0:{}s:4:\"post\";a:0:{}}}hidden_products|s:62:\"28, 29, 39, 42, 47, 91, 74, 75, 76, 77, 83, 84, 87, 88, 89, 94\";hidden_categories|s:10:\"39, 38, 21\";hidden_products_timestamp|i:1271262153;referral_id|s:0:\"\";cartID|R:7;onepage|a:6:{s:4:\"info\";a:4:{s:14:\"payment_method\";s:0:\"\";s:15:\"shipping_method\";s:0:\"\";s:8:\"comments\";s:0:\"\";s:6:\"coupon\";s:0:\"\";}s:8:\"customer\";a:16:{s:9:\"firstname\";N;s:8:\"lastname\";N;s:7:\"company\";N;s:14:\"street_address\";N;s:6:\"suburb\";N;s:4:\"city\";N;s:8:\"postcode\";N;s:5:\"state\";N;s:7:\"zone_id\";N;s:7:\"country\";a:4:{s:2:\"id\";N;s:5:\"title\";N;s:10:\"iso_code_2\";N;s:10:\"iso_code_3\";N;}s:9:\"format_id\";N;s:9:\"telephone\";s:0:\"\";s:13:\"email_address\";s:0:\"\";s:8:\"password\";s:0:\"\";s:10:\"newsletter\";s:0:\"\";s:10:\"country_id\";N;}s:8:\"delivery\";a:12:{s:9:\"firstname\";N;s:8:\"lastname\";N;s:7:\"company\";N;s:14:\"street_address\";N;s:6:\"suburb\";N;s:4:\"city\";N;s:8:\"postcode\";N;s:5:\"state\";N;s:7:\"zone_id\";N;s:7:\"country\";a:4:{s:2:\"id\";N;s:5:\"title\";N;s:10:\"iso_code_2\";N;s:10:\"iso_code_3\";N;}s:10:\"country_id\";N;s:9:\"format_id\";N;}s:7:\"billing\";a:12:{s:9:\"firstname\";N;s:8:\"lastname\";N;s:7:\"company\";N;s:14:\"street_address\";N;s:6:\"suburb\";N;s:4:\"city\";N;s:8:\"postcode\";N;s:5:\"state\";N;s:7:\"zone_id\";N;s:7:\"country\";a:4:{s:2:\"id\";N;s:5:\"title\";N;s:10:\"iso_code_2\";N;s:10:\"iso_code_3\";N;}s:10:\"country_id\";N;s:9:\"format_id\";N;}s:14:\"create_account\";b:0;s:15:\"shippingEnabled\";b:1;}payment|b:0;billto|N;sendto|N;' where sesskey = 'a1487fd9968d54d2919d4ca98e768278'

     

    Any clues ?


  6. ok ....

     

    have whittered it down to this piece of code in database.php

     

    //START SHP

    if(stristr($query, ' '.TABLE_PRODUCTS.' ') && !strstr($query, ' shp.products_id ') && isset($_SESSION['hidden_products']))

    {

    if(strlen($_SESSION['hidden_products']) > 1)

    {

    $prefix = "";

    if(stristr($query, " ".TABLE_PRODUCTS." p"))

    {

    $prefix = "p.";

    }

     

    $shp = " where ".$prefix."products_id not in(".mysql_real_escape_string($_SESSION['hidden_products']).")";

     

    if(stristr($query, " where "))

    {

    $query = str_ireplace(" where ", $shp." and ", $query);

    }

    else

    {

    $query .= $shp;

    }

    }

    }

     

    if(stristr($query, ' '.TABLE_CATEGORIES.' ') && !strstr($query, ' shp.categories_id ') && isset($_SESSION['hidden_categories']))

    {

    if(strlen($_SESSION['hidden_categories']) > 1)

    {

    $prefix = "";

    if(stristr($query, " ".TABLE_CATEGORIES." c"))

    {

    $prefix = "c.";

    }

     

    $shp = " where ".$prefix."categories_id not in(".mysql_real_escape_string($_SESSION['hidden_categories']).")";

     

    if(stristr($query, " where "))

    {

    $query = str_ireplace(" where ", $shp." and ", $query);

    }

    else

    {

    $query .= $shp;

    }

    }

    }

    //END SHP

     

    this is what is causing the database error


  7. I am also receiving the error

     

    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 categories_id not in(36, 36)' at line 1
    
    describe categories status where categories_id not in(36, 36)

     

    not sure what it corresponds to but it only appears in my /shop/index.php page

     

    help ?


  8. Hi

    Just started to implement this contribution - just wondering - is there another way to search for the customers like a text box to write there surname in, instead of the drop down menu.

     

    I have about 10000 customers in my database, so scrolling through all the b ' s to get to a name is a bit of a chore !!

     

    thanks


  9. My goodness this contribution is buggy

     

    customers are phoning up saying that the page details aren't updating,

    ie no billing or shipping information is being shown, even though every box has got a green tick against it.

     

    is there any way to force this to load the shpping / billing so the customer can actually 'checkout'


  10. Hiya

     

    99.9% of our customers are from England, is there anyway to make the default state (zone) area default to england

     

    The default country is set as the UK

     

    so instead of having - please select on the drop down, have England there instead ?

     

    Thanks

    ron

     

     

    Hi

    I didn't mean the country as default (it already is) - I mean the State / Region / County.

     

    it shows as please select - as the Default country is UK - can it not be set to england as default instead of "please select" ?


  11. Default Payment

     

    Is there any way of making a certain payment default (radio button)

     

    I notice it has this on payment_method.php

     

    if ($paymentMethod == ''){
    $paymentMethod = ONEPAGE_DEFAULT_PAYMENT;

     

    most of our transactions are credit card, so will would like this automatically selected.


  12. Hi Ron,

     

    First are you using the same discount coupon system opc uses?

     

    you can either remove the code for the coupons in checkout.php includes/classes/onepage_checkout.php for the coupons

     

    it will load but you wont be able to use the coupon system you have

     

    analysis of your errors

    firstly this is not defined MODULE_ORDER_TOTAL_DISCOUNT_COUPON_STATUS which makes me wonder you dont have same coupon system and gift voucher installed

     

    to get rid of that error

    add in includes/application_top.php before the ?> at bootom of the file

    define('MODULE_ORDER_TOTAL_DISCOUNT_COUPON_STATUS','false');

    define('NO_COUNT_ZERO_WEIGHT','false');

     

    rest are conflicting with sage pay and order total modules, simply search for them in the 2 files i managed above if you see any defines for them remove them, conflict solved

     

    Steve

     

     

    THANKS STEVE


  13. Strange ...

     

    I have placed the 2 files (1.2 & 1.1 versions checkout.php)

    beside each other and done a compare, and I have located the small piece of code that stops it loading in firefox

     

    <?
     if(ONEPAGE_CHECKOUT_LOADER_POPUP == 'True')
     {
     ?>
     $('#ajaxMessages').dialog({
    		shadow: true,
    		modal: true,
    		width: 400,
    	  height: 100,
    	  open: function (event, ui){
    			$(this).parent().children().children('.ui-dialog-title').hide();
    			$(this).parent().children().children('.ui-dialog-titlebar').hide();
    			$(this).parent().children().children('.ui-dialog-titlebar-close').hide();
           }
    		});
    <?
     }
     ?>

     

    Havn't a clue what that code does, but by removing it I can view the site in Firefox ?????


  14. Hi Help needed

     

    Ive installed the latest version 1.2

    and am having loads of problems when I reach checkout.php

     

    I am using firefox, and when i try to checkout - checkout.php doesnt load - just a blank page

     

    I have put an error report and this is what I get

     

    Notice: Undefined variable: payment in /home/******/public_html/******/includes/classes/onepage_checkout.php  on line 1326
    
    Notice: Use of undefined constant MODULE_ORDER_TOTAL_DISCOUNT_COUPON_STATUS - assumed 'MODULE_ORDER_TOTAL_DISCOUNT_COUPON_STATUS' in /home/******/public_html/******/checkout.php on line 50
    
    Notice: Use of undefined constant MODULE_ORDER_TOTAL_DISCOUNT_COUPON_STATUS - assumed 'MODULE_ORDER_TOTAL_DISCOUNT_COUPON_STATUS' in /home/******/public_html/******/includes/classes/onepage_checkout.php on line 115
    
    Notice: Use of undefined constant MODULE_ORDER_TOTAL_DISCOUNT_COUPON_STATUS - assumed 'MODULE_ORDER_TOTAL_DISCOUNT_COUPON_STATUS' in /home/******/public_html/******/includes/classes/onepage_checkout.php on line 191
    
    Notice: Use of undefined constant MODULE_ORDER_TOTAL_DISCOUNT_COUPON_STATUS - assumed 'MODULE_ORDER_TOTAL_DISCOUNT_COUPON_STATUS' in /home/******/public_html/******/includes/classes/onepage_checkout.php on line 203
    
    Notice: Use of undefined constant MODULE_ORDER_TOTAL_DISCOUNT_COUPON_STATUS - assumed 'MODULE_ORDER_TOTAL_DISCOUNT_COUPON_STATUS' in /home/******/public_html/******/includes/classes/onepage_checkout.php on line 203
    
    Notice: Use of undefined constant MODULE_ORDER_TOTAL_DISCOUNT_COUPON_STATUS - assumed 'MODULE_ORDER_TOTAL_DISCOUNT_COUPON_STATUS' in /home/******/public_html/******/includes/classes/onepage_checkout.php on line 254
    
    Notice: Use of undefined constant NO_COUNT_ZERO_WEIGHT - assumed 'NO_COUNT_ZERO_WEIGHT' in /home/******/public_html/******/includes/classes/shopping_cart.php on line 541
    
    Notice: Use of undefined constant NO_COUNT_ZERO_WEIGHT - assumed 'NO_COUNT_ZERO_WEIGHT' in /home/******/public_html/******/includes/classes/shopping_cart.php on line 541
    
    Notice: Constant TEXT_CCVAL_ERROR_INVALID_DATE already defined in /home/******/public_html/******/includes/languages/english/modules/payment/sagepay_form.php on line 18
    
    Notice: Constant TEXT_CCVAL_ERROR_INVALID_NUMBER already defined in /home/******/public_html/******/includes/languages/english/modules/payment/sagepay_form.php on line 19
    
    Notice: Constant TEXT_CCVAL_ERROR_UNKNOWN_CARD already defined in /home/******/public_html/******/includes/languages/english/modules/payment/sagepay_form.php on line 20
    
    Notice: Constant MODULE_ORDER_TOTAL_COUPON_TEXT_ERROR already defined in /home/******/public_html/******/includes/languages/english/modules/order_total/ot_coupon.php on line 32
    
    Notice: Constant SHIPPING_NOT_INCLUDED already defined in /home/******/public_html/******/includes/languages/english/modules/order_total/ot_gv.php on line 16
    
    Notice: Constant TAX_NOT_INCLUDED already defined in /home/******/public_html/******/includes/languages/english/modules/order_total/ot_gv.php on line 17
    
    Notice: Use of undefined constant MODULE_ORDER_TOTAL_GV_REDEEM_BOX - assumed 'MODULE_ORDER_TOTAL_GV_REDEEM_BOX' in /home/******/public_html/******/includes/modules/order_total/ot_gv.php on line 30

     

     

    Strangely - when I use Internet Explorer - I dont have a problem - it loads fine as does Chrome .

     

    Also when i use the 1.1 version that works fine - and loads in firefox.

     

    Help PLEASE - I have reinstalled this about 6 times and its always the same blank page

    how do I get rid of these errors, so that the page loads in firefox

     

    thanks

    ron


  15. There is some post a lot further back i think someone has got paypal ipn to work.

     

    Also does anyone else have the problem if you dont select shipping/payment click continue you get the popup warning you click ok to select shipping but page goes to the processing part and then get an error ?

     

     

    I havnt installed this yet, but i went to itwebexperts demo on their site - and there demo does exactly this...

     

    dont put anything in any boxes on checkout - press the last continue button, up pops the box saying no 1st name etc , then goes straight

    to this error

     

    Fatal error: Call to a member function pre_confirmation_check() on a non-object in /home/itweb1/public_html/onepagecheckout/includes/classes/onepage_checkout.php on line 734

     

    emailed them last week, but no answer !!


  16. Hi

    Excellent contribution - I was wondering though....

     

    we use drop down states for the shipping,

     

    basically we get th pull down

     

    	  echo tep_draw_pull_down_menu('state', $zones_array);
      } else {
    	echo tep_draw_input_field('state');
      }
    } else {
    	echo tep_draw_input_field('state');

     

    and change to

     

     

    echo tep_draw_pull_down_menu('state', $zones_array);
      } else {
    	echo tep_draw_input_field('state');
      }
    } else {
    	  // FORM NOT PROCESSED YET
      $zone_id = 0;
      $check_query = tep_db_query("select count(*) as total from " . TABLE_ZONES . " where zone_country_id = '" . (int)STORE_COUNTRY . "'");
      $check = tep_db_fetch_array($check_query);
      $entry_state_has_zones = ($check['total'] > 0);
      if ($entry_state_has_zones == true) {
    	$zones_array = array();
    	$zones_array[] = array('id' => PULL_DOWN_DEFAULT, 'text' => PULL_DOWN_DEFAULT);
    	$zones_query = tep_db_query("select zone_name from " . TABLE_ZONES . " where zone_country_id = '" . (int)STORE_COUNTRY . "' order by zone_name");
    	while ($zones_values = tep_db_fetch_array($zones_query)) {
    	  $zones_array[] = array('id' => $zones_values['zone_name'], 'text' => $zones_values['zone_name']);
    	}
    	echo tep_draw_pull_down_menu('state', $zones_array);
      } else {
    	echo tep_draw_input_field('state'); }
    }

     

     

    however in checkout_shipping & checkout_billing

     

    it only shows this

     

     echo tep_draw_pull_down_menu('state', $zones_array,'',$disabled_ship." ".'onchange="toggleShipping_fields(\'state\',\'ship_state\');"');
      } else {
    	echo tep_draw_input_field('state',$state,$disabled_ship." ".'onKeyUp="toggleShipping_fields(\'state\',\'ship_state\');"');
      }
    } else {
      echo tep_draw_input_field('state',$state,$disabled_ship." ".'onKeyUp="toggleShipping_fields(\'state\',\'ship_state\');"');
    }
    
    if (tep_not_null(ENTRY_STATE_TEXT)) echo ' <span class="inputRequirement">' . ENTRY_STATE_TEXT;

     

     

    how do I alter this code so the state becomes a drop down with the zones listed


  17. Hi

     

    I have recently upgraded to version rc2, and use with fast easy checkout

    ms2.2 has always worked - but since upgrading discount coupons has stopped working totally

     

    I have been through the code about 5 times, and checked everythin is in place.

     

    the coupon box shows on checkout_shipping (this is where it needs to go with fec) but the discount doesn't show on checkout_confirmation.

     

    can anyone shed any light on this - as to what the problem could be

×