EasySQL for Joomla, if you without phpMyAdmin
Version
1.27 (last update on Jan 10, 2009)
Rating
Compatibility
Votes
Favoured
59
License
GPLv2 or later
Non-Commercial
Type
Views
132032
Date Added
21 August 2007
Features:
* (NEW) replace table prefix (REPLACE PREFIX `jos_` TO `newprefix_`)
* execution any queries to MySQL;
* execution of several queries for time;
* restore database sql-dump;
* data acquisition of the table selected from the list;
* displayed query results; horizontal scrolling the wide table;
* croping long strings in cells of the table (option);
* creating, editing and deleting records;
* export to csv-file;
* support multilang-interface (inside: EN, RU, FR, ES).
* support Joomla 1.0.x and 1.5.x in native mode
PS: to change delimiter (comma)
for englih and J1.5 see com_easysql/lang/en-gb.php
define('_ES_CSV_DELIMITER', ';');
to
define('_ES_CSV_DELIMITER', ',');
I was in a need to do a small change in a lot of article titles without updating modified date and time. I thought this extension should have been perfect for the job, but it deleted all HTML code in the content. Take backups and use the edit record -button carefully and/or test the results first.
This was easy to install, and intuitive enough to get going looking at data using SELECT and being able to pick Joomla files from a drop-down list, having done some SQL many years ago. It enabled me to manually update individual records too. However, I had hundreds of records to update and I wanted to use SQL for a mass update.
To my dismay, UPDATE was not listed as a valid command, but having read someone else's comment that a command worked even when not in the list, I had a go. The error messages it came back with suggested strongly to me it had not worked, and I spent some while trying to find the syntax that would work in conjunction with an SQL guide. The error messages distracted me for quite a while from noticing that actually it had successfully updated the records I wanted, in the way I wanted.
Ultimately then I'm extremely pleased with it, and it enabled me to solve a problem updating a Joomla core file that otherwise would have been very daunting to solve. It's only the confusion of error messages displaying despite having actually done what you wanted it to do that stops me giving it 5 stars.
To my dismay, UPDATE was not listed as a valid command, but having read someone else's comment that a command worked even when not in the list, I had a go. The error messages it came back with suggested strongly to me it had not worked, and I spent some while trying to find the syntax that would work in conjunction with an SQL guide. The error messages distracted me for quite a while from noticing that actually it had successfully updated the records I wanted, in the way I wanted.
Ultimately then I'm extremely pleased with it, and it enabled me to solve a problem updating a Joomla core file that otherwise would have been very daunting to solve. It's only the confusion of error messages displaying despite having actually done what you wanted it to do that stops me giving it 5 stars.
Looked at myphpadmin-based plugins and hit a problem. My shared hosting set up limits PHP uploads to 2meg. This made it impossible to upload myPHPadmin-based plug ins.
I tried this tiny plug in and amazed how functional it is at such a light package. Makes it a breeze to focus on Joomla's items. Helps create SQL through pull-downs full of most common commands.
Very "Pro-sumer" :) Thank you. Honored to be able to use this cute little plug in.
I tried this tiny plug in and amazed how functional it is at such a light package. Makes it a breeze to focus on Joomla's items. Helps create SQL through pull-downs full of most common commands.
Very "Pro-sumer" :) Thank you. Honored to be able to use this cute little plug in.
One feature alone make this an oustanding plugin. There is an option to rename your database prefix. I just used the default one when i installed Joomla, this is a bad thing. It leaves you more oopen to SQL Injection attacks. This is because hackers will know what the joomla default table prefix is.
This plugin stop me having to do this the old fashioned way.
thanks
This plugin stop me having to do this the old fashioned way.
thanks
Very good extension for quick and easy manipulation of tables, e.g. prices in VirtueMart. Also complex queries can be executed.
One drawback is deletion of HTML's code. This leads to deletion of hyperlinks in column defined as 'mediumtext'.
This may a an omission in the extension unless i'm doing something wrong !
One drawback is deletion of HTML's code. This leads to deletion of hyperlinks in column defined as 'mediumtext'.
This may a an omission in the extension unless i'm doing something wrong !
I too was a bit skittish with everything being in Russian on the home page, but this is an excellent tool.
My only gripe is the default semi-colon delimiter instead of using a comma for CSV's, but that's easily fixed (see the earlier reviews on changing the variable for that).
Thanks!
My only gripe is the default semi-colon delimiter instead of using a comma for CSV's, but that's easily fixed (see the earlier reviews on changing the variable for that).
Thanks!
Must have!
You can add a hundred articles with this script!
You can add a hundred articles with this script!
This is a great little component for simple management of the mysql database. It got me out of a tricky little spot on a site where I don't have access to myPHPAdmin and I didn't want to go through the hassle of setting it up myself.
Beautiful!
Allows me to give clients and staff access to their database tables without giving them control panel access to my servers.
Allows me to give clients and staff access to their database tables without giving them control panel access to my servers.
We sell Support to our users for each of our components, and oftentimes this involves logging into the user's website and modifying tables on their database. EasySQL has made that process as simple as asking the user for Super Admin access. Bravo for such a wonderful tool.
A very handy tool, especially when providing support to clients - you only have to ask for access to Joomla administrator, without needing separate database access. Nowhere near as powerful or complex as phpMyAdmin, but the essential features are there and it is dead easy to use.
This has been the single most useful extension I've installed on my site.
Whenever I'm developing, it's painful for me to maintain a phpMyAdmin page open alongside an admin page...it just IS...especially when you're running 2 different admin panels for 2 sites on the same database.
With this extension, I can query all the tables in the database across both sites - I can manually execute queries as well - to insert items, alter tables, etc.
On top of that, I'm sometimes behind a firewall that blocks port 8585 (which is what my phpMyAdmin runs out of on my web server) - so I don't get access to phpMyAdmin (painful, yes)...
With this extension, I don't need to. I can run everything simply and efficiently, all from the comfort of my Joomla! Admin console.
Whenever I'm developing, it's painful for me to maintain a phpMyAdmin page open alongside an admin page...it just IS...especially when you're running 2 different admin panels for 2 sites on the same database.
With this extension, I can query all the tables in the database across both sites - I can manually execute queries as well - to insert items, alter tables, etc.
On top of that, I'm sometimes behind a firewall that blocks port 8585 (which is what my phpMyAdmin runs out of on my web server) - so I don't get access to phpMyAdmin (painful, yes)...
With this extension, I don't need to. I can run everything simply and efficiently, all from the comfort of my Joomla! Admin console.
This component works fine but i need to change a line to make CSV export compatible with queries using quotes.
In administrator\components\com_easysql\admin.easysql.php
I change
$sql = mosGetParam( $_POST, 'easysql_query', null );
to
$sql = stripslashes(mosGetParam( $_POST, 'easysql_query', null ));
In administrator\components\com_easysql\admin.easysql.php
I change
$sql = mosGetParam( $_POST, 'easysql_query', null );
to
$sql = stripslashes(mosGetParam( $_POST, 'easysql_query', null ));
I this tool is really easy to install and use. I had trouble with data fields that content lists with returns in them like:
path=1
user=3
cont=4
and so on. The "to CSV" button did not use a text delimiter to contain field data like this. So I modified line 125 in admin.easysql.php to read:
$csv_values .= '"'.$val.'"'.$comma;
it was:
$csv_values .= $val.$comma;
Great Component.
path=1
user=3
cont=4
and so on. The "to CSV" button did not use a text delimiter to contain field data like this. So I modified line 125 in admin.easysql.php to read:
$csv_values .= '"'.$val.'"'.$comma;
it was:
$csv_values .= $val.$comma;
Great Component.
Page 1 of 2