Data truncated for column?

Your problem is that at the moment your incoming_Cid column defined as CHAR(1) when it should be CHAR(34). To fix this just issue this command to change your columns’ length from 1 to 34 Here is SQLFiddle demo

Variable warning set but not used

none shows up twice in this code snippet: And then: If, for example, you later had: or or something to that effect, we would say none is “used”, but as the code is, you have: “none” set but not used; exactly what the compiler said. In the pastebin link I see your problem: You wrote this: You meant to write this: … Read more

libpng warning: iCCP: known incorrect sRGB profile

Libpng-1.6 is more stringent about checking ICC profiles than previous versions. You can ignore the warning. To get rid of it, remove the iCCP chunk from the PNG image. Some applications treat warnings as errors; if you are using such an application you do have to remove the chunk. You can do that with any … Read more

libpng warning: iCCP: known incorrect sRGB profile

Libpng-1.6 is more stringent about checking ICC profiles than previous versions. You can ignore the warning. To get rid of it, remove the iCCP chunk from the PNG image. Some applications treat warnings as errors; if you are using such an application you do have to remove the chunk. You can do that with any … Read more