0020317: increase "processed" column size to INT to avoid it failing on 6million+

ID	Project	Category	View Status	Date Submitted	Last Update

0020317	phpList 3 application	Campaign Send Process	public	07-01-21 15:39	15-01-21 08:53

Reporter	michiel	Assigned To
Priority	normal	Severity	minor	Reproducibility	have not tried
Status	resolved	Resolution	fixed
Product Version	3.5.5-RC1
Target Version	3.5.9

Summary	0020317: increase "processed" column size to INT to avoid it failing on 6million+
Description	avoid error error 1264 while doing query Out of range value for column 'processed' at row 1 intiem - Sql error update phplist_message set processed = processed + 1
Tags	No tags attached.

mariana 13-01-21 15:10 administrator ~0063693	The fix for this was included in 3.6.0. I am marking this as resolved.

michiel 13-01-21 15:40 administrator ~0063694	Hmm, there's an issue on the upgrade. https://github.com/phpList/phplist3/issues/728#issuecomment-758591071 I did not expect this to go out on 3.6.0 already, but expected 3.6.1 and up. So the upgrade doesn't work on 3.6.0 I will review this and find a solution.

michiel 13-01-21 17:35 administrator ~0063696	It's fine. It will activate once we get to 3.6.1

mariana 15-01-21 08:53 administrator ~0063700	I didn't know that this was not ready yet. Thankfully not a lot of users have reported. Great to have a fix.