Page 27 of 35 FirstFirst ... 172526272829 ... LastLast
Results 261 to 270 of 345
  1. #261
    Join Date
    Apr 2009
    Posts
    416
    Plugin Contributions
    2

    Default Re: Big Royal Mail 3.0

    If all looks good I'll post another update with the SQL correction.
    Mark Brittain
    http:\\innerlightcrystals.co.uk\sales\

  2. #262
    Join Date
    Mar 2006
    Posts
    63
    Plugin Contributions
    0

    Default Re: Big Royal Mail 3.0

    Nothing is falling over, which is good.
    Last edited by Gwiazda; 21 Jun 2020 at 10:49 AM.

  3. #263
    Join Date
    Dec 2006
    Posts
    27
    Plugin Contributions
    0

    Default Re: Big Royal Mail 3.0

    I have looked at Royal Mail International Standard - Small Parcel and Printed Papers have World Zone 3 could this be added please?

  4. #264
    Join Date
    Apr 2009
    Posts
    416
    Plugin Contributions
    2

    Default Re: Big Royal Mail 3.0

    Quote Originally Posted by cotswold View Post
    I have looked at Royal Mail International Standard - Small Parcel and Printed Papers have World Zone 3 could this be added please?
    The latest version (Big Royal Mail - Version: 3.4.0b) has the new rates and the zones.
    Mark Brittain
    http:\\innerlightcrystals.co.uk\sales\

  5. #265
    Join Date
    Jul 2009
    Posts
    10
    Plugin Contributions
    0

    Default Re: Big Royal Mail 3.0

    For some reason the SQL injector doesn't like UpdateFrom3.2.sql, resulting in this error log

    PHP Code:
    PHP Fatal error1064:You have an error in your SQL syntaxcheck the manual that corresponds to your MySQL server version for the right syntax to use near 'True''False'), ', now() FROM configuration WHERE configuration_key LIKE 'MODUL' at line 1 :: INSERT IGNORE INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) SELECT 'Attribute Exact Match', CONCAT( LEFT( configuration_key , LOCATE( '_STATUS', configuration_key)), 'ATTRIBUTE_MATCH' ), 'False', 'Used to only display this shipping method if the attribute shipping is and exact match', '6', '0', 'zen_cfg_select_option(array('True''False'), ', now() FROM configuration WHERE configuration_key LIKE 'MODULE_SHIPPING_RM%_STATUS'; ==> (as called by) /var/sites/n/nipon-scope.com/public_html/nol_login/sqlpatch.php on line 294 <== in /var/sites/n/nipon-scope.com/public_html/includes/classes/db/mysql/query_factory.php on line 170. 
    All the other .sql patches execute fine though.


    PS. also the language files seem to have a typo
    Code:
    Used to only display this shipping method if the attribute shipping is and exact match
    Last edited by yueli7; 12 Jul 2020 at 07:25 AM.

  6. #266
    Join Date
    Apr 2009
    Posts
    416
    Plugin Contributions
    2

    Default Re: Big Royal Mail 3.0

    To correct the sql file (UpdateFrom3.2.sql). On line 27 change
    PHP Code:
    'Used to only display this shipping method if the attribute shipping is and exact match''6''0''zen_cfg_select_option(array('True', 'False'), 'now() 
    1)Remove and
    2)Put 'zen_cfg_select_option(array('True', 'False'), in double quotes not single
    to
    PHP Code:
    'Used to only display this shipping method if the attribute shipping is exact match''6''0'"zen_cfg_select_option(array('True', 'False'), "now() 
    Haden't spotted the typo. It is through all the modules. I'll get it changed and release a new released.
    Last edited by brittainmark; 12 Jul 2020 at 08:48 AM.
    Mark Brittain
    http:\\innerlightcrystals.co.uk\sales\

  7. #267
    Join Date
    Jul 2009
    Posts
    10
    Plugin Contributions
    0

    Default Re: Big Royal Mail 3.0

    Ok I've used the double quotes and it went through. How come it was fine in single quotes for seemingly everyone else?

    Btw it's supposed to say all the missing semicolon errors?

    Code:
     Query incomplete: missing closing semicolon.
     Query incomplete: missing closing semicolon.
     Query incomplete: missing closing semicolon.
     Success: 1 statement(s) processed.

  8. #268
    Join Date
    Jul 2009
    Posts
    10
    Plugin Contributions
    0

    Default Re: Big Royal Mail 3.0

    How would I go about adding RM 24/48 shipping? I don't see it as one of the options

    https://www.royalmail.com/business/s...yal-mail-24-48

  9. #269
    Join Date
    Apr 2009
    Posts
    416
    Plugin Contributions
    2

    Default Re: Big Royal Mail 3.0

    The missing semicolon could be caused by one of the queries being multi lined. ( i have never seen that error before).
    As for
    Quote Originally Posted by yueli7 View Post
    How would I go about adding RM 24/48 shipping? I don't see it as one of the options
    https://www.royalmail.com/business/s...yal-mail-24-48
    do you mean parcel force express 24 and 48. They are included in the zipfile. All you have to do is install them (rmpfexpress24 and rmpfexpress48). I would double check the rates as they change without notice. I do not know of any other 24 or 48 hour services from royal mail.
    Mark Brittain
    http:\\innerlightcrystals.co.uk\sales\

  10. #270
    Join Date
    Jul 2009
    Posts
    10
    Plugin Contributions
    0

    Default Re: Big Royal Mail 3.0

    Do you think everyone will need double quotes now, or is it specific to my SQL set up?

    I think the Query incomplete: missing closing semicolon is when it parses comments in the .sql, which is weird if only I get this notice.

    Quote Originally Posted by brittainmark View Post
    do you mean parcel force express 24 and 48. They are included in the zipfile. All you have to do is install them (rmpfexpress24 and rmpfexpress48). I would double check the rates as they change without notice. I do not know of any other 24 or 48 hour services from royal mail.
    No the RM 24 and RM 48 services are for Business Parcels Account holders, which are different to the Parcelforce 24/48 services (details in link)

    I've made a copy of 2 of the module/language files and renamed the code inside to add reflect RM24/48. They're showing up fine in admin. Do I need any sql patches or is that it? (I can add my own prices)

 

 
Page 27 of 35 FirstFirst ... 172526272829 ... LastLast

Similar Threads

  1. v154 Big / Basic Royal Mail??
    By Man from Mars in forum Addon Shipping Modules
    Replies: 1
    Last Post: 19 Apr 2016, 02:07 PM
  2. big royal mail module
    By Sushigal in forum Addon Shipping Modules
    Replies: 3
    Last Post: 25 Nov 2009, 04:58 PM
  3. Big Royal mail
    By ben harry in forum Addon Shipping Modules
    Replies: 2
    Last Post: 20 Jul 2008, 01:11 PM
  4. Big Royal Mail - Big Error - Shipping Abroad
    By bleazy in forum Addon Shipping Modules
    Replies: 0
    Last Post: 14 Jul 2008, 03:01 PM
  5. Warning: Big Royal Mail
    By Rookie gone MAD! in forum Addon Shipping Modules
    Replies: 2
    Last Post: 11 Sep 2007, 08:33 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR