Big Royal Mail 3.0

[mgk]

That's great, works a treat. All the GB and Northern Ireland weights sorted and on display. Thanks for getting back to us.

Just one more thing, cannot get International prices to display ?

[brittainmark]

looks like it is working fine on your site. just change the country in the drop-down. I selected a book and went to the cart then change the country to France and pressed update and the international rates were shown.

[mgk]

Excellent, forgot about the dropdown country selector. Doh! Sending you a pm.

[brittainmark]

excellent, don't forget to hide the invalid shipping again. I will have to think about adding another error message to say about the added packing weights as i keep forgetting they are there.

[CunningStunt2]

I'm trying to install this on a site im building and having problems with Install3.2.sql

Followed the instructions in the docs and installed first and second class for small and medium parcel, then when I try to install the sql file, either by uploading the file or copying the data into the box, I get an error 500 message, no logs are being generated by zencart.

[CunningStunt2]

I managed to find some logs relating to my problem, not zen cart logs.

[17-May-2021 22:29:00 UTC] PHP Recoverable fatal error:  Object of class queryFactoryResult could not be converted to string in /home/thegluep/devstore.thegluepeople.co.uk/***ADMIN***/sqlpatch.php on line 753
[18-May-2021 08:46:38 UTC] PHP Recoverable fatal error:  Object of class queryFactoryResult could not be converted to string in /home/thegluep/devstore.thegluepeople.co.uk/***ADMIN***/sqlpatch.php on line 785

[brittainmark]

I managed to find some logs relating to my problem, not zen cart logs.

[17-May-2021 22:29:00 UTC] PHP Recoverable fatal error:  Object of class queryFactoryResult could not be converted to string in /home/thegluep/devstore.thegluepeople.co.uk/***ADMIN***/sqlpatch.php on line 753
[18-May-2021 08:46:38 UTC] PHP Recoverable fatal error:  Object of class queryFactoryResult could not be converted to string in /home/thegluep/devstore.thegluepeople.co.uk/***ADMIN***/sqlpatch.php on line 785

I have had this before. It is when Mysql is issuing a warning because something is being depreciated in the future. I thought I had brought them all up to date. I'll check it out and get back to you

[brittainmark]

Issue with select @variable:= being depreciated in a future version. Have replaced with select INTO @variable. New version on git hub https://github.com/brittainmark/BigRoyalMail Need to check out 1.3.8 of zen cart to see if this also works there. Then will release a new version to zen cart.

[CunningStunt2]

That's worked, I can see the attributes now, thank you!
Also I did notice a spelling mistake on 'special delivery' in the attributes list.

[CunningStunt2]

Is it possible to use attributes to add an extra option, or possibly replace Special Delivery / Parcel Force with the Table rate?

A lot of the products we sell cannot be sent using Royal Mail as they are restricted, flammable adhesives, aerosols, etc so I need to be able to restrict all Royal Mail shipping options and use the Table Rate, which is set up with the price our hazardous carrier charges.

In the past we have sent everything on carriers just because it was easier, but having royal mail options set up for non-hazardous products will hopefully result in increased sales as the carriage charges will not be so high for smaller orders.