When editing the e-mail template i get this:

[craven]

Hi Guys,

I get the following error when editing the e-mail template:

Incorrect integer value: '' for column 'email_from_account_id' at row 1

I have searched the forums quite extensively and cannot find a solution.
Any1 that can help ?

Thank You!

[Ben]

Hmmmm... that doesn't sound good.

Would you mind trying the following? Go to the Edit Form -> Emails tab and click on the "Configure Form Email Fields" button. On that page, register a new email address in your form (just select any old field), then delete it.

Lastly, go edit your email template again and see if the error message still persists.

- Ben

[craven]

Hmmmm... that doesn't sound good.

Would you mind trying the following? Go to the Edit Form -> Emails tab and click on the "Configure Form Email Fields" button. On that page, register a new email address in your form (just select any old field), then delete it.

Lastly, go edit your email template again and see if the error message still persists.

- Ben

Hi Ben,

thank you for your speedy reply and your hard work on this great tool!

I have added the e-mail form field successfully and deleted it succesfully, but when i go back and try again it gives me the same error. (interestingly enough if i change the column to a varchar just to see what data it wants to write to the coloumn it doesnt give the error but shows blank in the coloumn.)

Another thing i have seen, is that there is no way to send the e-mail to all the clients assigned to the form like in formtools 1.5, unless you add them 1 by 1 under the recipients tab ?

Thanks for all the help so far ill definitly hit the donate button ;p

[craven]

bump

[Xpider]

If you have direct access to your db (i.e. phpmyAdmin) you can
try fixing/optimizing/checking for corrupted or washed tables.

The db is innodb based so the repair feature wont work, but a quick search
on google will yield results on accomplishing this.

Hope this helps .

[craven]

Hi,

Thanks for the response, i found the problem in a previous post.. it was because of strict_mode being active. it is working now again

Thanks.

[Ben]

Ahhh.... strict mode again. Okay, I REALLY must look into this.

Thanks guys.

- Ben