Adding service in Create Order gives collation error

[DarcieG]

I was testing Create Order from within the admin backend and added a "service" type item. The service was added, but this error appeared at the bottom of the admin page:

1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_german2_ci,IMPLICIT) for operation '='

select ab.*,z.zone_id from customers_basket_address ab left join zones z on z.zone_name =ab.billing_state where ab.customers_id = '1' and orders_id=0

Submitting after this to complete the order will not proceed. Page contains above error.

[Rameshranagn (ramesh-rangan)]

Hi,

We are checking this bug and will get back to you shortly.

With Thanks,
Ramesh.P

[Rameshranagn (ramesh-rangan)]

Hi,

Sorry for late reply.

Please update our latest release 1.5beta and try.

You can get it from here: https://code.launchpad.net/openfreeway/1.5

Hope this helps you.

Cheers,
Ramesh.P