Home » Extensions » DB Replacer
NoNumber!

Joomla!® Websites & Extensions
development  -  support  -  consultancy

DB Replacer
search and replace in your Joomla! database
Joomla! 1.5
Joomla! 1.7
Joomla! 2.5
component
version 1.3.3
Download

With DB Replacer you can search and replace stuff directly in your Joomla! database.

If you use DB Replacer, please post a rating and a review at the Joomla! Extensions Directory.

Description

DB Replacer enables you to search and replace in any table in your database.

It even supports searching with case sensitivity and using regular expressions.

Sometimes you need to replace something in all your articles. That takes hours doing it the conventional way: open article, change, save article, open next article, etc...

With DB Replacer this takes a few seconds.

DB Replacer gives you a preview of what is going to be replaced, so you know what you are doing before actually replacing anything.



WARNING: DB Replacer replaces stuff right in your database in the places you tell it too. This can - if you replace the wrong stuff - break your site. So be careful and only use this if you know what you are doing.



PS: I know, I know, there is next to no documentation besides what you see here. Sorry... still have to write more on this. If you have any questions, please just ask me via the forum.

Specs

Specifications

DB Replacer is a Joomla extension compatible with Joomla 1.5, Joomla 1.7 and Joomla 2.5.

The extension consists of:

  • a component

Requirements

DB Replacer will only work correctly if your setup meets these requirements:

  • Up-to-date version of Joomla!
  • PHP 5.3+
  • PHP mbstring (Multibyte String) functions should be enabled
  • MySQL 5+

Using PHP 5.2 (or lower)?
PHP 5.2 is old and support for it has stopped with the release of PHP 5.2.16 (16-Dec-2010). This means that PHP 5.2 cannot be considered stable or secure anymore.
If your host will not or cannot provide you with an up-to-date version of PHP, then you have reason enough to look for a decent host.
PHP 5.2 mainly has problems with installation of the zip packages. The extensions might work without problems for you once installed, but I can not give any guarantees on that.
>> For more detailed information, read: No more php 5.2 support - move on to php 5.3

I can not provide support for setups that do not meet the above requirements.

The core Joomla files should of course not be altered in any way.

Installation

The easiest way to install/update is via the NoNumber! Extension Manager.

If you have problems installing DB Replacer, please try the manual installation process as described here:
docs.joomla.org/Installing_an_extension

Otherwise, please report this on the forum or let me know via the contact form.

Updating

If you want to update to the latest version, you do not have to uninstall first.

The easiest way to install/update is via the NoNumber! Extension Manager.

You can also update simply by installing the package via the Joomla core installation process.

Downgrading

If for some reason you need to downgrade, it is best to uninstall the extension first.

Also, you will have to uninstall the NoNumber! Framework plugin (system) (and the NoNumber Elements plugin if you have it installed).

After that you can simply install the older version zip file.

Please note that I cannot not provide support on older versions!

Open Source License

DB Replacer is an Open Source Joomla extension. It is in compliance with the GNU/GPL license:
Licence: GNU/GPL GNU General Public License, version 2

Joomla is also Open Source.

Support

Need more help?

Before requesting help, make sure your installation and setup meet the requirements (see the Specs) and your extensions are up-to-date.

If you need more help, please take a look in the NoNumber! Forum.
If you can't find your answer there, please post your question. I am very willing to help!

You can also contact me via the contact form or via chat (if I'm online).

Changelog

Changelog

+ = Added ! = Removed ^ = Changed # = Fixed

03-Feb-2012 : v1.3.3
+ Added translations: pl-PL, sl-SI
^ Cleaned code syntax (no longer guaranteed support for php 5.2.x and lower)
# Fixed issue with installer not removing the folder/zip from the tmp
# Fixed issue with javascript error about nn!TogglerSet
08-Oct-2011 : v1.3.2
+ Added permission rules to settings
+ Added translations: sv-SE
# Fixed security issue in !NoNumber! Framework plugin

09-Oct-2011 : v1.3.1
# Fixed issue with missing link in components menu (with v2.6.0)

08-Oct-2011 : v1.3.0
^ Improved installer
^ Moved translation language files to main package (no more language packs)
^ Cleaned up some code (like no more use of DS)

16-Sep-2011 : v1.2.0
+ Added UTF-8 selection for Regular Expression searches (thanks Georgios Papadakis)
^ Changed !NoNumber! Elements plugin to !NoNumber! Framework
^ Moved common language strings to !NoNumber! Framework files
# Fixed some minor styling issues

26-Jul-2011 : v1.1.3
# Fixed issue with DB Replacer not working (Joomla 1.7)

27-Jun-2011 : v1.1.2
# Fixed issue with install problems (Joomla 1.5)

18-Jun-2011 : v1.1.1
# Fixed issue with install problems (Joomla 1.7)

18-Jun-2011 : v1.1.0
+ Joomla 1.7 compatible!
# Fixed issue with DB Replacer not working with mootools upgrade

17-Mar-2011 : v1.0.4
^ Changed language files to be J1.6 ready
# Fixed issue with some security extensions causing DB Replacer to not work

11-Feb-2011 : v1.0.3
^ Changed extension icon / logo
# Fixed some minor javascript problems

13-Dec-2010 : v1.0.2
# Fixed installer

13-Dec-2010 : v1.0.1
# Fixed some issues with loading of language strings
# Cleaned up some code

25-Nov-2010 : v1.0.0
+ Added checks to see if !NoNumber! Elements plugin is installed/enabled
^ Fixed and updated all language strings

16-Nov-2010 : v0.2.0
^ Made !MooTools 1.2 compatible

14-Oct-2010 : v0.1.5
# Fixed issue with (non-regex) searches containing single quotes
# Fixed issue with searches containing '#' characters

23-Aug-2010 : v0.1.4
# Fixed issue with preview only matching first row
# Fixed issue with replacements not being done if search was not equal to entire value

16-Aug-2010 : v0.1.3
+ Added ability to search !NULL values
+ Added ability to replace entire value (search for *)
# Fixed issue with !HTML tags being stripped from search and replace
# Fixed issue with non-greedy regular expressions not working (.*?)
# Fixed issues with other special regular expression characters

24-Jul-2010 : v0.1.2
+ Added display of version number in component screen
^ Changed way version and license information are displayed (now via ajax)
^ Changed way versions and licenses are checked (no more base64)

07-Jul-2010 : v0.1.1
+ Added extra !WHERE field to limit search
^ Changed some layout
# Fixed issue with enters not displaying in preview
# Fixed issue with leading and trailing spaces in search/replace
# Fixed issue with special characters not being displayed correctly
# Fixed some issues with regular expressions

29-Jun-2010 : v0.1.0
+ First beta release

Commercial License

DB Replacer is completely free and you DON'T need a Commercial License Code to use it.

However, if you use my extensions on websites that you make money from, I would appreciate it if you purchase a License Code.
The License Code will remove the license message from the extensions administrator screens.

Note: If you don't want to pay for the License Code and want to continue to use the extension for free, please do. You will just have to ignore the license message in the administrator.

Note: If you have donated before and feel you should get some reduction on the price, please contact me about it... we'll sort it out :)

more information...

 

>> Purchase Commercial License Code >>

 

Here you can see the difference between the use of the extensions without and with Commercial License Code.

WITHOUT Commercial License CodeWITH Commercial License Code
Full version download yes YES yes YES
Full functionality yes YES yes YES
Message in administrator license_invalid license_valid
Encrypted no NO no NO
Free updates yes YES yes YES
Free support yes YES yes YES
Free RSS news subscription yes YES yes YES
Free holiday to Barbados no NO no NO

Download

Downloads

DB Replacer is compatible with Joomla 1.5, Joomla 1.7 and Joomla 2.5

NOTE: DB Replacer needs PHP 5.3+. Please see the specs for more requirements.

  • Are you going to use this extension on a commercial website? Please consider buying a License Code

More downloads...

Please clear your browsers cache after updating an extension.

NOTE: Joomla 1.6 is no longer supported. Joomla 1.6 reached end-of-life in August 2011. If you have a site running on Joomla 1.6 you are urged to upgrade to Joomla! 2.5. DB Replacer will probably still work on Joomla 1.6, but any issues specific to Joomla 1.6 will not be fixed.

Tip!

Are you using multiple NoNumber! extensions?
Install the NoNumber! Extension Manager to easily keep them up-to-date.

Languages

This extension comes with the following languages:

  • [pt-BR] Brazilian Portuguese
  • [bg-BG] Bulgarian
  • [ca-ES] Catalan
  • [nl-NL] Dutch
  • [en-GB] English
  • [fr-FR] French
  • [de-DE] German
  • [el-GR] Greek
  • [hu-HU] Hungarian
  • [it-IT] Italian
  • [ja-JP] Japanese
  • [lt-LT] Lithuanian
  • [nb-NO] Norwegian
  • [pl-PL] Polish
  • [ru-RU] Russian
  • [sl-SI] Slovenian
  • [es-ES] Spanish
  • [sv-SE] Swedish
  • [th-TH] Thai
  • [uk-UA] Ukrainian

No language pack for your language?

I welcome you to help out and get involved with translations for NoNumber! extensions.

I am using Transifex for the translations of all NoNumber! extensions. So I kindly ask you to join Transifex.

There is a translation team/group set up especially for Joomla projects: OpenTranslators.

To join, see the different steps on the right under: Translator Guide: http://opentranslators.org/en/how-to

You can find all the NoNumber! projects here: https://www.transifex.net/projects/tag/nonumber/

All language files will be updated and packed with every new release of the individual extensions.

OpenTranslators

 
Open Source Training | Online Joomla! Training and Support
MaxCDN | Content Delivery Network | Accelerate your site to the max
hosting joomla
Copyright © 2009-2012 - NoNumber! - All Rights Reserved - Terms of Service - Privacy Policy

NoNumber.nl is not affiliated with or endorsed by the Joomla Project or Open Source Matters.
The Joomla name and logo are used under a limited license granted by Open Source Matters the trademark holder in the United States and other countries.