WebSite X5Help Center

 
William J.
William J.
User

Database viewer  en

Author: William J.
Visited 2243, 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
5 ANSWERS
Andre E
Andre E
Moderator

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 

Read more
Posted on the from Andre E
John S.
John S.
User

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.

Read more
Posted on the from John S.
Klaus W.
Klaus W.
User

Hi John,

this is the structure of my user table which works fine. Compare it with your's:

Read more
Posted on the from Klaus W.
Klaus W.
Klaus W.
User

... sorry ... 'Hi William' :-)

Read more
Posted on the from Klaus W.
William J.
William J.
User
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

Read more
Posted on the from William J.