Can no longer write to MySQL database

[heywood7]

We have been experiencing database issues since the 20th of April. We use the database to manage our member information for our organization. Our online tool allows for our members to log in and update their information. This tool has been in use for years without issue. The last member update was made on April 19th. Beginning April 20th, members could no longer edit their accounts. As an admin, I can still edit the database via PHPmyAdmin, but the web tool no longer works.

The member tool still pulls in each member's information for viewing, but the edits don't stick. It’s like the Write access was stripped. There are no errors (that I see) when the changes are submitted. They simply don’t take.

To verify that we didn't do anything to break the tool, I unarchived web files from a week prior and uploaded them over the existing files. This also did not work. We are at a loss. There are no new plugins or themes.

Is anyone else experiencing problems editing their MySQL databases?

[alemcherry]

If you can phpMyAdmin, there is nothing wrong with the database. phpMyAdmin is just another php/mysql script like the one you are using.

To solve the problem with your script, check the configuration file and see if the mysql user it is using has the right to right the data to the database being used. Using the default mysql user or creating a new one with full rights should solve the problem. If not, you will need to do advanced fixes like editing the script and echoing the error message after database query. If you don't know PHP, get a freelancer to help you.

[Bob Barr]

Relational database management system that runs as a server providing multi-user access to a number of databases and every database manage mysql server.

I think everybody knows what a relational database is. Do you have any information that might assist heywood7 with his issue?