Unable to save new order mails

[sally01]

Could anybody help with this error message

Unable to save new order mails
The error was - Data truncated.

If we go into an order and switch to the mail tab we get this message.

[Mike Hughes]

It sounds like it might be a database problem. Best to log a support request with Actinic.

Mike

[TraceyG]

Hi Sally,

It sounds like it might be a database problem

Mike is right. The error suggests that a field in the database has too much data in it so it we would need to get the database to find out where the problem is. I suggest you raise a support ticket here, or call in if you have a support contract.

[Legion]

Hi

I've found if you back order over 12 times (I've set up a subscription service for comics and the max number is 12), you get the data truncated message. I did contact actinic and I'm still waiting for a fix to the problem.

[Chris Leavold]

Unable to download new orders - string data right truncated

Hi, This problem seems to crop up in varoius places in the forum and has apparently been an issue for a very long time.

We find that about 10% of orders are never received by us due to this error.

Could someone here tell me exactly what I need to do correct in order to receive 100% of our orders or should I raise a ticket?

Thanks,
Chris

[TraceyG]

Hi Leo,

Could someone here tell me exactly what I need to do correct in order to receive 100% of our orders or should I raise a ticket?

Rais a ticket as there is no easy way of finding out the exact problem without having your database.