Database viewer 
Author: William J.
Visited 1786,
Followers 1,
Shared 0
Hi
I seem to be having an issue with the database viewer. I can see the database and I can click on a user and make changes but when I click to add a new user the box appears and I can enter the data ok but when I click create it returns the alert "error can't perform query"
I can enter new users via phpmyadmin and they will show in the viewer.
Everything works apart from being able to add the new user from the viewer.
Posted on the
Hello William,
Check first if database vieweris up to date.
Goto step 4 on any page, click top right manage button for the objects management screen, refresh.
Then select update needed on the left.
If it needs updating then do so, upload and check again.
Also check if your host is at PHP 7.1
Maybe it is because the table has no key defined.
If one of the fields holds a value that should be unique, then define this as key.
Else you could add a field with automatic numbering and as key.
Hi John,
this is the structure of my user table which works fine. Compare it with your's:
... sorry ... 'Hi William' :-)
Author
Thanks for the help folks.
It would appear that the issue is with my hosting company. They are going through a major overhaul and I have logged the issue with them.
cheers