Hi,
I am getting this error which only has just appeared to happen. I have the module on auto update.
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 '//IETF//DTD HTML 2.0//EN"> in:
[update configuration set configuration_value = "
Not Acceptable
An appropriate representation of the requested resource /postage.php could not be found on this server.
Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.
" where configuration_key = "MODULE_SHIPPING_OZPOST_EXPIRE"]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
Outdoorking
www.outdoorking.com.au
I am getting message "unable to connect to ozpost server" in backend of my webshop.
Is the server down at the moment? Couple of customers have phoned saying they can't select their shipping methods.
Thank you
Sandy
Ozpost currently uses TWO different servers on two different networks (with a 3rd being trialled).
The chances of BOTH servers not responding at the exact same time is so unlikely that it is hardly worth considering.
A far more likely possibility would be a networking issue somewhere between your store and our server(s). Such issues are usually of a very temporary nature and usually resolve themselves within minutes.
Cheers
Rod
Curious. According to the log files, your store hasn't connected to the ozpost servers since 14/9 (5 days ago).
If the error goes away with the auto-update disabled then I would suggest you do so until I can figure out what the heck is going on.
With this disabled you will still be notified of updates (when available) but they won't try to install themselves until you toggle the auto-update setting back on again.
I'm not sure what to make of this at the moment. Everything *seems* OK at the moment according to my tests, but to have two error reports in the same day is very unusual and needs further investigation.
Cheers
Rod
RodG,
I think it might have something to do with the host as it all seems to be ok now. This has been the first time that I have had this happen over the past 2 years and will be checking with my host tomorrow as I have had a second customer complaining that they can't get through the checkout but in saying that several other people have placed orders today.
Thanks for your help and once I have found out what the issue is I will let you know.
Outdoorking
www.outdoorking.com.au
I updated ozpost to latest version today and thanks Rod for all the new updates. v3.1.1
After doing the update, the server error message in zencart backend is no longer showing and I am on auto updates!
I updated the information fields in zencar ozpost.
All seems fine except if I place a test order in my live zencart store and select Sydney postcode 2000 for delivery address, no Fastway option is listed in the postage options in checkout. for the same test order, if I select postcode 4000 or 3000 for deliveryaddress, the Fastway courier option is included in postage option list in checkout.
The Fastway franchise code I use in backend OzPost module options, is for Brisbane depot.
I will check it out again tomorrow, but have mulled this over a bit and can't figure it out.
Thanks Rod, your program is wonderful and I am pleased to have taken out the 3 years option. The OzPost module is a must for our online store and is much appreciated.
I'm not sure what to make of this. I've just performed a check on your site to a postcode 2000 Sydney and retrieved a valid Fastway response (screenshot attached).
If the problem occurs again please check that the suburb field gets filled in correctly (the module uses javascript to pre-fill this field to avoid typing errors).
If for any reason the suburb field gets left blank the 2000 postcode will default to BARANGAROO (the first in the alphabetical list of names), and Fastway reject this as a valid destination.
There may be other causes of the problem, but this is the most likely cause.
Let me know of your findings.
Cheers
Rod
Last edited by RodG; 26 Oct 2011 at 10:42 AM.
The latest update (3.1.2) has added support to make this type of customising a LOT easier.
Rather than scouring the main code to make the changes, they can now be performed with the define() syntax, as used in the language files.
For more info regarding this please view the /includes/modules/shipping/ozpost.php code for comments and instructions right near the start of the file.
Cheers
Rod
bugfix: Fixed Problem with javascript and IE9
cleanup: Supressed invalid destination error on first run where postcode may be undefined
Added: support for AUS as a currency code.
Added: Check that $aus_rate is > 0 to avoid divide by zero error.
Added: Override system for easy customisation of shipping method descriptions.
Bookmarks