Any one had this happen?
Column name was called 'auto_log' and after it started giving errors I found the name changed to 'a' .
I hope it's not a hacker.
MySql Column name randomly renamed
Well, it's MySQL, so my first thought is "corrupted database", but I thought it was over that now.
I think a lot of that stuff in MySQL is file name based, so maybe something/someone changed that file name somehow?
NogDog;11050291 wrote:I think a lot of that stuff in MySQL is file name based, so maybe something/someone changed that file name somehow?
Table names are file name, but not column names. Database names are folder names. Generally renaming one of these files causes LOTS of issues and the table (under either name) is unusable. My first thought is that there was a bad command run. If you have general logging turned on you can grep it for all ALTERs run, but generally having this logging turned on it not a good idea (turns into HUGE log files very quickly).
Given that, I would think someone ran a bad command, or something somewhere is open to injection. Take a look at running https://www.owasp.org/index.php/OWASP_Zed_Attack_Proxy_Project and/or http://wapiti.sourceforge.net/ against the site. It may expose some issues you didn't know existed.
11 days later
I think you have not code your php well and it has such vulnerability which changed your database column name as this you mentioned.