Database viewer 
Author: Karel C.
Visited 1758,
Followers 2,
Shared 0
OK. Bought the Database Viewer, installed it. I can now view the records. Great !
I activated the edit controls. Looks like I can only add records. I cannot save edited records (application responds 'can't perform query') nor delete records ('cannot delete record').
Any idea why ?
Thanks,
Posted on the
Author
http://www.colka.be/inschrijven/lijst.php
Hello Karel,
In the first instance please check the permissions that you have on the MySQL database on the server.
You can do this through your (webhost) online control panel.
In particular, please check that the user operating the database has been granted 'UPDATE' and 'DELETE' privileges.
Please let us know how you get on.
Kind regards,
Paul
Author
Hi Paul,
My web service provider is ONE.COM. They provide phpMyAdmin as user interface. I can only have one user on a SQL DB. The GRANT command tells me that this user ('colka_be') has all privileges. Using the user interface (as user 'colka_be'), I can add, update and delete records.
There is no section in the ONE.COM phpMyAdmin that allows me to define additional users or redefine privileges. I assume it is a version customized by ONE.COM.
So at first sight privileges is not the issue.
Thanks for your help,
Karel
Hi Karel.
As this seems to be some kind of issue related to the One.com DB, I'd recommend you contact them directly explaining your problem to them.
Should they fail to help you and should they redirect you to us again, please feel free to continue on this topic.
Let me know
Author
Hi Stefano,
Well, they say that if I cannot tell them what queries are involved, they cannot help me. Bit easy. Anyway, I still think it has to do with X5: I can do adds, edits, deletes with my user when I use the phpmyadmin interface. Which suggests the user has the appropriate privileges. Have a look at page www.colka.be/inschrijven/lijst.php and feel free to delete a record, or update one.
Regards,
Karel
Author
This is what the show command tells me:
SHOW GRANTS FOR colka_be
Grants for colka_be@%GRANT USAGE ON *.* TO 'colka_be'@'%' IDENTIFIED BY PASSWORD '*30A169F330C82327E0723D800F51A0B1A667B7'
GRANT ALL PRIVILEGES ON `colka\_be`.* TO 'colka_be'@'%'
Hi Karel.
I need to ask you, was the DB and tables made through the software or were those there before?
This surely is a problem of the DB settings. In fact, if the tables really weren't made by the software, this would explain the issue.
Should this be so, please let me know
Author
Hi Stefano,
The contract with one.com is for 1 DB name only. colka_be, predefined. I created a new table in that DB using Website X5. The problem is the same. I cannot update or delete records. So the issue might be at the level of the settings of the database itself. Unfortunately I cannot change any settings of the DB. If you can tell me what is important about those settings, I might go back to one.com and ask them. (although they were not very cooperative last time).
thanks for your help,
Karel
Author
Well, I think I should clear this issue. Looks like there is no easy solution. I will just drop the delete and edit buttons. Would have been nice to have it but not essential.
Thanks for your help, Paul & Stefano !