[Answered] Issue Updating Database

[Earl]

Server Stevie

Username: rotation

 

I've been working through getting the database to work by changing passwords and clearing db users. That took care of my issue with seeing the website. However, when I use my program (Easy Member Pro) to do some updates, it does not save the changes. It sees the pages fine, allows me to make changes, but they don't save. I can save user parameters, and those get copied over to the database just fine. This is a different place in the program, so it would seem the passwords are all okay?

 

It appears that it can read the database, but not modify the content for the pages. I've been using this program for several years, and have never seen any issue. I tried restoring an older setup - no difference. I also upgraded to the last version from scratch, and it behaved the same.

 

It seems that something changed between my updates the first couple of days in October, and my updates starting Oct 31.

 

There is probably something easy I'm missing. Any ideas? Here are some of the steps I've done with the server: Thanks in advance for any hints on what to check next!

 

Reset CPanel pw

Cleared (deleted) database and db user

Used SQL wizard to create database and user

Did a restore on my database from a backup

Verified phpMyAdmin shows the database

Verified user has Full Priviledges in mySQL

Logged out and reset password from link provided in other post - from scratch one more time

Updated DB user and program connection passwords

Same behavior

[wolstech]

That something that happened was the repair and update. My software did this too...some things would save, others wouldn't. Database restores didn't help.

 

Long story short, the software is probably incompatible with the new version of MySQL (or more likely it can't run in strict mode). Solution is to replace the software with something else (unless you're capable of debugging it).