WebSite X5Help Center

 
William J.
William J.
User

Database viewer  en

Autor: William J.
Besucht 2257, Followers 1, Geteilt 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.

Gepostet am
5 ANTWORTEN
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 

Mehr lesen
Gepostet am von 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.

Mehr lesen
Gepostet am von 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:

Mehr lesen
Gepostet am von Klaus W.
Klaus W.
Klaus W.
User

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

Mehr lesen
Gepostet am von Klaus W.
William J.
William J.
User
Autor

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

Mehr lesen
Gepostet am von William J.