Posts Tagged with "database"

How to find and replace text database table

Monday, October 22, 2012


Often we need to update text in column of a database table. It can be time consuming if there are thusands of rows to be updated. Follwing query will update text based on Like condition: Syntax: Example: Backup of database is recommended just to be on safe side.

Continue reading...

Saving default component settings in Joomla 1.6 and 1.7 component installation

Sunday, October 2, 2011


When developing a component for Joomla 1.6 / 1.7 I came accross the issue that it does not save defaut values in database. So users had to open component configuration and save to have the settings take effect. Looking into components folder in #__component_name show ‘{}’ meaning no parameters at all. Solueiton was to use postflight […]

Continue reading...

Module installing database table in Joomla 1.5

Friday, March 5, 2010


By default Joomla module do not come with the functionality of creating table or running any queries with install. With a little bit of code and a parameters flag database queries can be run on first run of module when it is published. Step 1: Add a parameter flag in xml file. and in your […]

Continue reading...

How to reset Joomla Super Admin password

Tuesday, November 24, 2009


To reset password you must have access to Joomla database. Most of the hosting providers come with some sort of control panel or PhpMyAdmin. Also make a backup of your database in case you have to revert back to original database. Find users table, e.g. jos_users. Note you table names may vary depending on the […]

Continue reading...