2019-02-03, 12:44 AM
Hi, I must apologize if I cannot provide all the info as I don't have access to it all at the moment.
Im posting regarding a client of mine that uses your platform and I was tasked with making some fixes to a table on the MySQL Database.
So what happened was after he migrated to MyBB his messages had some leftover syntax with the links and also some javascript code in there too that he wanted removed on over 30000 posts (out of 65000 total) so I built a couple of queries to handle simple replacements of some strings and then I built a function to handle the various links code which had various tags and varied quite a lot...
The function seemed to work fine and did what I needed it to do, I called it via a query... I discovered that my client didn't really know what he was doing with anything so I ran the update for him on the database using some credentials he gave me, these credentials where not root level nor did I have access to much accept table updates just saying just in case this caused the problem....
so the actual problem was after the update the website was inaccessible, the Error 1045 and a little bit of information saying the username@localhost or password was incorrect!!??
I know that this requires I go over the user file and check everything but my question is....
Why would a simple table update on the Database cause this platform to completely fail.
Additional notes, a restore on the database immediately fixed the problem, but the messages are now still mixed with all the html, javascript etc and my client isn't happy.
Im posting regarding a client of mine that uses your platform and I was tasked with making some fixes to a table on the MySQL Database.
So what happened was after he migrated to MyBB his messages had some leftover syntax with the links and also some javascript code in there too that he wanted removed on over 30000 posts (out of 65000 total) so I built a couple of queries to handle simple replacements of some strings and then I built a function to handle the various links code which had various tags and varied quite a lot...
The function seemed to work fine and did what I needed it to do, I called it via a query... I discovered that my client didn't really know what he was doing with anything so I ran the update for him on the database using some credentials he gave me, these credentials where not root level nor did I have access to much accept table updates just saying just in case this caused the problem....
so the actual problem was after the update the website was inaccessible, the Error 1045 and a little bit of information saying the username@localhost or password was incorrect!!??
I know that this requires I go over the user file and check everything but my question is....
Why would a simple table update on the Database cause this platform to completely fail.
Additional notes, a restore on the database immediately fixed the problem, but the messages are now still mixed with all the html, javascript etc and my client isn't happy.