TOPIC:

We are receiving a data transfer error on both our club sites, club 2526 and club 720929.

The error has rendered all our basic email templates inaccessible, which is a bummer because we love using them!




Please advise best course of action.

Thanks in advance,

Cb

I will look into this tonight.

Wow thank you, Steve!

Ok, you are using the email templates functionality as a save email function... not really the intention. Email templates are emails that you expect to send out repeatedly, not once. Many of the saved "templates" that I am seeing look like one-off emails.

Basically, you filled up the allotted space for email templates in the database, and corrupted one of the saved items as a result (one for each club) . That is why you are getting the error message.

I have to say that I never expected someone to use up the space allotment for this.

At this point, I will make it so that you can load them, but you will have to wait a bit to edit, so you do not blow through the allocation again.

I need to sort out whether I want to increase the allocation or force clubs to get rid of old templates. In your case, from what I have seen, I am not particularly convinced that you are going to re-use these "templates" in the future, so I am not immediately inclined to want to increase the allocation as that would have other impacts to our database. (but I can be convinced otherwise)

Thanks for your response. I do use these.email responses repeatedly and change recipient.

They are instructions that I am constantly resending. I can pare them down if needed but it is very convenient to resend from agenda or send to multiple recipients.

How many email templates can I save?

Ok, after a lot of tinkering on my end, I was able to salvage all of your templates except for one for each club. You should expect one to be gone and cannot be retrieved again. I did try to salvage those truncated ones, but I could not get the underlying html and data encoding properly repaired and I finally just gave up on them.

It is not a matter of number of templates, it is a matter of the overall size of all of them combined. They are all saved as one "chunk" of data along with their titles (and any other properties) in the database. So you could save a few very large ones or a lot of very small ones. The combined size of all the data for all the templates for a particular club cannot exceed 65530 bytes. The editor does keep track of characters in the bottom right.

At this point you can load what is left, but I am going to have to do something for the system as a whole to prevent future problems with this. As you say, you like the email templates feature, so maybe other people do also. We could have the same issue occurring with other clubs. No good feature goes unpunished, I guess...

Let me do a review of whether other clubs are getting close to using up their space allocation, also. If so, I may just take the easy way out and bump up the allocation for email templates. If I don't do that, I will still have to put some sort of warning in the JavaScript to tell you that you are over the limit. (I will likely put that warning in.)

BTW, if I bumped the allocation, then you would have roughly 16,777,200 bytes for storing templates. Quite a bit, but it also potentially chews up quite a bit of space in the db as that also applies for every other club using the system.

Wow, thank you so much for taking time to check this out for us! I'm all about productivity and do all I can to keep our officers using the site to manage our clubs well. There are several features that remind me of CRM type programs so I guess I can get carried away with building little processes to simplify our work flows.

Thank you again for your prompt help. I would love to see the space allocation increase, but I may be trying to get too much out of the site. I wouldn't even try to manage two clubs without FTH. Thanks for making it easier to do!

Well, it looks like you are in luck... It looks like quite a few other clubs are using the email templates feature, also.

Club numbers and data size for email templates -- note top 2, those are probably borked also... These are just the top users, lots of other clubs using them.

Ok, I went ahead and bumped up the allocation for each club to store email templates.

Size check added to the Javascript.

Please let me know when I can close this thread.