Is there a limit to the number of entries you can upload to a newsletter member database? I tried uploading 2,240 email addresses and it all seemed to be going well until i had to refresh the list to update the members fields. Error appeared in red 'error loading page' - then the whole site crashed.
I went and emptied the members fields via phpMyAdmin. All started working properly again.
Then I divided my list into 10 smaller files. I got to file 7 and the same problem as above happened again... 'error loading page'
From what you have described I'd be inclined to check the data in that 7th file. I have found that in similar circumstances there will be some issue with the data on a particular record. There maybe one or more characters such spaces, special characters, non printable characters or simply that the format has some issue in it.
Thanks for your reply. That unfortunately wasn't the answer as it then began acting the same way no matter which of my 10 smaller files I tried to upload. I eventually found that if i just uploaded the entire csv file, hit confirm but then NOT refresh using the link given but instead using the ?flush... it worked. By hitting confirm the entries were being added to the database successfully it was just when i was hitting 'refresh' when the problems started. It took me ages to figure out and wrecked my head!! It's a cheesy fix but there must be something wrong in the code and I don't have time to figure it out.
I do have another question that you may be able to help me with though... now that i have my 2240 email addresses, i just sent my first newsletter. It's taking FOREVER to send to all recipients. Know of any way of speeding this up. The newsletter is a tiny text file with only 2 sentences. Hate to imagine if i had any more content!
My client won't be happy sending newsletters like this if it takes over 40min to send.
Briohny, Usually this would be desired as many hosts will shut your smtp access down if you send things too rapidly. As for the way silverstripe is processing the e-mails and if you could speed it up I'd have to dig in a bit deeper to see. 40min for over 2000 recipients sounds good to me.