ccQuery
Version
0.1.0
Rating
Compatibility
Votes
Favoured
14
License
GPLv2 or later
Non-Commercial
Type
Views
36392
Date Added
25 April 2009
Add, Edit and Delete Records with ease from Administration panel. Query Executer, Table Browser, Table Definition Viewer and lot more...All features without any kind of third party tools or scripts.
If you want a simple tool that allows you to browse your database to see file structures etc ccQuery is perfect.
As other users have pointed out however the actual update functions don't work. The SQL created when you try to update is wrong (at least for MySQL 5 and above (it may be a hangover from earlier versions). 2 Stars for now but if the developers deliver all of the advertised features it would get a 5.
As other users have pointed out however the actual update functions don't work. The SQL created when you try to update is wrong (at least for MySQL 5 and above (it may be a hangover from earlier versions). 2 Stars for now but if the developers deliver all of the advertised features it would get a 5.
The current 0.1 version of this extension is a good data and schema browser but I can't trust it to update data. It's not that it corrupts the data, but if you are on the browse screen and try to edit a record, the values are rarely stored back into the database. I'm not sure if it has something to do with the type of fields in the table or what, but something causes it not to update some times. If you want to delete a record by clicking on the red X in the browse window, it will only delete the record maybe 10% of the time. Most times, it's successful on the first row you try to delete, but after that you can't delete any more rows.
They say that Selects, Inserts, Updates, and Deletes can all be executed from the Query window, but the only thing that works is select statements.
This extension doesn't do half of the features that it says it does.
They say that Selects, Inserts, Updates, and Deletes can all be executed from the Query window, but the only thing that works is select statements.
This extension doesn't do half of the features that it says it does.
It's very nice for querying, but won't update (as advertised), and won't produce errors when it fails to update, to tell me what's wrong. I've checked and rechecked my syntax, and the query is correct; just nothing happens.
I've googled and searched the publisher's site, receiving no answers to the issue.
Also doesn't discriminate who uses it; anyone on the backend can use this component out of the box. When installing it I entered a block of code to kick out anyone who isn't a Super Administrator to keep people from doing major damage to the DB.
I've googled and searched the publisher's site, receiving no answers to the issue.
Also doesn't discriminate who uses it; anyone on the backend can use this component out of the box. When installing it I entered a block of code to kick out anyone who isn't a Super Administrator to keep people from doing major damage to the DB.
First of all, this neat little extension does what you want. Easy access to all your tables, present them and make data entry or modifying easy.
My drawback is that it didn't update my records in a correct way. In fact it didn't update at all. Maybe it was due to some of my self built tables but nevertheless, I had to look for an alternative.
My drawback is that it didn't update my records in a correct way. In fact it didn't update at all. Maybe it was due to some of my self built tables but nevertheless, I had to look for an alternative.
