Hi all, new here but thought I'd just post this in case it helps someone. I installed a snitz forum recently but started getting errors when doing various tasks, the error read:
The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data.
This was using the access database option, long story short in my case the error came from insert/update statements where an IP was being written but the port number was being appended ie 000.000.000.000:0000 which was too large for the IP data fields which had 15 size limits. The workaround was fairly dirty in that I just increased the size of the fields to 30 on all tables, hopefully this wont present any other problems? Either way just thought I'd mention it on here, maybe save someone else the time I spent working it out!
Hi ojhilt, this is a known issue and should be addressed in a future release. your 'quick and dirty' fix should work fine and not cause you any problems
As an alternative, this temporary fix will trim the port number from the IP address.
Search is your friend “I was having a mildly paranoid day, mostly due to the fact that the mad priest lady from over the river had taken to nailing weasels to my front door again.”
Topic Locked
Posted - 13 June 2007 : 13:15:00
