My cats database error

[pleco_breeder]

I've tried several times to add info for my L100 tank, and consistently get the following error message after clicking "Save and Publish".

SQL ERROR [ mysql4 ]

Data truncated for column 'size_sl' at row 1 [1265]


Larry

[Jools]

Hi Larry,

You don't have any aquaria records to add to? Are you trying to create a new record? If so, which link are you using to get an initial "add aquaria" page and once you've filled it out, would it be possible to post a screenshot of the data you have typed in immediately prior to clicking submit?

Cheers,

Jools

[MatsP]

size_sl is part of the BREEDING record, so probably not involving "My Aquaria".

I'm still not entirely sure what is going on here, so a bit of "I go to <some place>, click on the link <something>, and enter <stuff> in field <name of field> then ..." would definitely help.

Edit: Realized that size_sl is actually part of "My Cats", not "My Blog". So, with that knowledge, I tried entering some random things in the size field, and happy to report I have just reproduced the problem. If I type "90mm" into the "size field" of the "My Cats" editing page, it fails. I will look into this tomorrow - shouldn't be difficult to fix, really.

--
Mats

[pleco_breeder]

Sorry,

Probably should've noted that it was an attempt to add to the "my cats" list but was running a bit late and getting very frustrated.

Larry

[MatsP]

R750 should fix this particular problem. I'm looking at other places that do similar things.

--
Mats

[Jools]

Larry,

I've put this fix online. Can you confirm it's fixed?

Cheers,

Jools

[pleco_breeder]

The fix worked perfectly. Data posted.

Thanks,

Larry

[MatsP]

R753 contains updates to "blog", validating all numeric inputs on the page with (more) correct error messages.

I will try to do the my_aquaria in the same vein tomorrow, as there are some coding improvements in the code, and it should really be the same everywhere.

[Probably should be added to the Data Sub pages too?]


--
Mats

[MatsP]

I've now implemented the more complete checking for my_cats and my_aquaria as well.

In R755.

--
Mats

[Jools]

That's online now too.

Cheers,

Jools