I have been hacked

My PHPR apps and data bases are hosted with Godaddy. I have never had a problem in years until just recently. I cannot modify records, even when using PHPmyadmin. Tech support found two php files in the root of my account which he said were the problem files. He renamed those but the problem still exists. I tried reloading the apps but no help. My guess is that there is something corrupted in SQL.
Has anyone seen this and were you able to clean it? I do not have a backup of the data but the records look OK.
Any help would be appreciated.

Hi CJS,
It sounds like your mysql database is set to read only. This link may help: http://stackoverflow.com/questions/18401120/how-do-i-set-mysql-temporarily-to-read-only-through-the-command-line
Even if it is read only. You should be able to backup your mysql locally with PHPmyadmin. I would then restore back locally and then test locally to see if this fixed it.
Paul

My PHPR apps and data bases are hosted with Godaddy. I have never had a problem in years until just recently. I cannot modify records, even when using PHPmyadmin. Tech support found two php files in the root of my account which he said were the problem files. He renamed those but the problem still exists. I tried reloading the apps but no help. My guess is that there is something corrupted in SQL.
Has anyone seen this and were you able to clean it? I do not have a backup of the data but the records look OK.
Any help would be appreciated.

Hi CJS:
As Paul said you should be able to use PHPmyadmin to export a copy of your database. You can then test it locally and if need be create a new database on Godaddy and run the import in PHPmyadmin.
On a side note, I've hosted a variety of websites over the last decade on 7 or 8 different webhosts and the only one I have been hacked on (twice) were hosted on Godaddy. The speed, etc. of their webservers are good, but they seem to be lacking on the security side.

My PHPR apps and data bases are hosted with Godaddy. I have never had a problem in years until just recently. I cannot modify records, even when using PHPmyadmin. Tech support found two php files in the root of my account which he said were the problem files. He renamed those but the problem still exists. I tried reloading the apps but no help. My guess is that there is something corrupted in SQL.
Has anyone seen this and were you able to clean it? I do not have a backup of the data but the records look OK.
Any help would be appreciated.

hosted my phprunner apps in dreamhost since 2010 and i never had a problem

Hi CJS,
It sounds like your mysql database is set to read only. This link may help: http://stackoverflow.com/questions/18401120/how-do-i-set-mysql-temporarily-to-read-only-through-the-command-line
Even if it is read only. You should be able to backup your mysql locally with PHPmyadmin. I would then restore back locally and then test locally to see if this fixed it.
Paul

Using PHPmyadmin I was able to insert a record so it does not appear it is set to read only. I tried adding a record from the live app and it still does not work. The read only flag is set to "OFF".
I have reloaded the app but still no good. Any more thoughts?

Using PHPmyadmin I was able to insert a record so it does not appear it is set to read only. I tried adding a record from the live app and it still does not work. The read only flag is set to "OFF".
I have reloaded the app but still no good. Any more thoughts?

Is the credentials in your PHPRunner project the same as what you used for your PHPmyadmin login? I would try adding a new user to the database, giving them full privileges and adjust your PHPRunner project to the new credentials. Could be an indexing issue from PHPRunner, is it happening to all of your tables or just one of them? If just one, take a look at your indexes set in your PHPRunner app. Sorry I don't have a better answer, I am sure you are tired of messing with it by now.

Is the credentials in your PHPRunner project the same as what you used for your PHPmyadmin login? I would try adding a new user to the database, giving them full privileges and adjust your PHPRunner project to the new credentials. Could be an indexing issue from PHPRunner, is it happening to all of your tables or just one of them? If just one, take a look at your indexes set in your PHPRunner app. Sorry I don't have a better answer, I am sure you are tired of messing with it by now.

First and foremost always run a backup in a timely manner. I would export entire database to a new one first . Then In PHPrunner project I would redo Security Settings entirely by renaming them if you are using dynamic security. If not using dynamic security or using dynamic security , I would delete the output file on server ( backup first ) delete the build output file on your hard drive, Then redo any security settings , Then Build and upload. If godaddy renamed some files , then they are probably corrupted as they no nothing or very little about PHPrunner.