Database is correct but Admin object is showing OLD data

Thumper · Post by **Thumper** » Mon Sep 30, 2019 4:10 pm

I am using the most recent version if WYSIWYG, v15.1.0

Yesterday I deleted several (8) logins from my MySQL database via the Admin object on my website. Subsequently I also made some changes to my User Roles in the Admin object. When I recompiled and uploaded all files for the entire site, the Admin object on my website is showing the OLD data prior to my deletions of some of the previous users. There are three new users that are NOT showing in the Admin object on my website but they can log in because the database is correct (see next paragraph).

It correctly made the changes in the User Roles in the pick list. When I check the data file via phpAdmin, ALL the data is correct in the database showing the three NEW users and NOT SHOWING the deleted users. All the data connections are correct (NO ERRORS) and the database is the same as it was since I began using it in WYSIWYG in July 2018. Yet, it is showing data from the time period up through September 20, 2019!

The long and short of my issue is that I cannot administer the new, or any subsequent users, in the database. WHY is it showing incorrectly when it has worked flawlessly for the past 14 months? This is not good for my business if I can't administer my user's permissions after they verify via email.

Post by **Pablo** » Mon Sep 30, 2019 5:09 pm

The admin tool directly accesses the database, there is no local cache.
Maybe your browser is displaying the page from cache?

Thumper · Post by **Thumper** » Mon Sep 30, 2019 6:36 pm

I had originally thought that, although it worked fine several hours before, so I cleared my cache. Additionally I tried it on my iPad, my iPhone, my laptop and my wife's computer and they ALL showed the previous data...NOT the correct, up-to-date data!

Going to clear my cache AGAIN and see what happens. BTW, I had never used the database on either my iPad, iPhone or laptop previous to trying this a few moments ago.

Thumper · Post by **Thumper** » Mon Sep 30, 2019 7:42 pm

Still occurring. Cache has been cleared three times, different devices used and still the issue. Yet it worked earlier today. No settings were changed other than adding one new user role and deleting one old user role, so why is this occurring if it should be reading right from the database...which is correct and up-to-date!

Post by **Pablo** » Mon Sep 30, 2019 8:04 pm

Note that the script does not suddenly start behaving differently. The script can only display data that it reads from the database, it does not make up the values on its own.
Maybe there is something wrong on the server side?

Thumper · Post by **Thumper** » Mon Sep 30, 2019 8:17 pm

I understand all that, and as I stated, the data in the database is all correct and had been working perfectly through yesterday evening. No changes have been made to ANY settings. The ONLY change was adding one and deleting one user role.

If there were an issue on the server side I would be getting a database connect error in the admin interface and I also would not be able to bring up the database in phpAdmin, and the data would be incorrect.

I just had a new client sign up through email verification and he is showing properly in the database but he and the two new clients from yesterday are not showing up. Additionally, all the former clients I deleted are still showing. If it's reading directly from the database, and there is no caching issue, how are they even showing up?

I was hoping you could help me triage this but I guess not. I have been a paid user of WYSIWYG WebBuilder for the past 7 1/2 years (since v8.x) with no issues. I was hoping for a little more support in helping to triage what the problem could be.

Post by **Pablo** » Mon Sep 30, 2019 8:45 pm

The admin script does not make up the data on its own. The data is coming from the database.
If what you see in the admin is different than what is in the database, then the server must provide the wrong data somehow, I cannot think of anything else.

I can ensure you that no data is cached by the script.
You (or anyone else) can verify this yourself by looking at the script. Anyone with a little PHP knowledge can see there is nothing in the script that can cause this behavior.

I really wish I could do something to help you, but in my opinion something goes wrong on the server side.

www.wysiwygwebbuilder.com

Database is correct but Admin object is showing OLD data

Database is correct but Admin object is showing OLD data

Re: Database is correct but Admin object is showing OLD data

Re: Database is correct but Admin object is showing OLD data

Re: Database is correct but Admin object is showing OLD data

Re: Database is correct but Admin object is showing OLD data

Re: Database is correct but Admin object is showing OLD data

Re: Database is correct but Admin object is showing OLD data