If all looks good I'll post another update with the SQL correction.
If all looks good I'll post another update with the SQL correction.
Mark Brittain
http:\\innerlightcrystals.co.uk\sales\
Nothing is falling over, which is good.
Last edited by Gwiazda; 21 Jun 2020 at 10:49 AM.
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\
For some reason the SQL injector doesn't like UpdateFrom3.2.sql, resulting in this error log
All the other .sql patches execute fine though.PHP Code:
PHP Fatal 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 '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.
PS. also the language files seem to have a typoCode: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.
To correct the sql file (UpdateFrom3.2.sql). On line 27 change1)Remove andPHP 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()
2)Put 'zen_cfg_select_option(array('True', 'False'), in double quotes not single
toHaden't spotted the typo. It is through all the modules. I'll get it changed and release a new released.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()
Last edited by brittainmark; 12 Jul 2020 at 08:48 AM.
Mark Brittain
http:\\innerlightcrystals.co.uk\sales\
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.
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
The missing semicolon could be caused by one of the queries being multi lined. ( i have never seen that error before).
As for 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\
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.
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)
Bookmarks