Excluding Unpublished Categories in Search

Extensions -> Plugin Manager -> Search Content.

Can be configured in here.

Place Here Module

New find: http://extensions.joomla.org/extensions/news-display/content-embed/498

This can be an alternative solution for when client want to edit custom modules. An article, category, or section is defined in the module configuration and it will display within a custom module on a website. This allows logged in users to edit the module as if it were an article.

Bridging Moodle and Joomla

http://joomdle.com/index.php?option=com_content&view=article&id=59&Itemid=99&lang=en

No upgrade for Joomla version 1.5.16 to 1.5.17

The shortest release ever of a Joomla version to 1.5.16 and quickly onto 1.5.17 .. and for those that upgraded in the record of about 2 days of realease it currently says

" IMPORTANT NOTE: The upgrade packages for 1.5.16 are temporarily unavailable. You can upgrade using the Full Package file below. Follow the upgrade instructions, but use the full package file. Thank you."

Sometimes it pays to wait and see if there are any bugs instead of quickly upgrading ones joomla sites to the latest version asap.

Fix for when Photoshop will not open

Was looking for a fix for my PS which will close immediately when I try to open it. It appears others have this problem as well, and its usually fixed by deleting the prefs.psp file. .............. So try this first as works with all versions of Photoshop the older and its easy to do search and delete :)

Else try this alternative method to remove prefs: (Works with PS Elements also)

Step 1. Hold down the Alt + Ctrl + Shift keys as you click on the icon to open Photoshop. When asked if you want to delete the settings file, say yes.

Step 2. Reset the preferences as above.

Step 3. Close Elements and let the file regenerate.

Bridging a Website to Media Wiki

Step A : Installing and Configuring the Joomla plugin.

Download and install the Joomla plugin

1. Install zip file using standard Joomla install
2. Publish the plugin and configure the plugin as below. Set
   • Directory path: The complete path to your mediawiki folder, eg) /home1/spfschoo/public_html/MEDIAWIKI/
     
   • Cookie domain: Leave Blank
     
   • Cookie prefix: The name of your database with a a '_' on the end. Eg) if the database is named "spfschoo_mdw1" then put "spfschoo_mdw1_" in this section.
     
   • Cookie path: I kept this as root "/".
3. Change the code in file joomla root/plugins/user/mediawikilogin.php on line 35
   1. Line 35: $salt = 'Give some variable name here'; //CHANGE THE VARIABLE NAME TO $salt= 'wiki' or something

Step B : Installing and Configuring the MediaWiki Extension.

Download the extensions from Mediawiki extension

1. First download the MediaWiki extension authjoomla2.php
2. To install the mediawiki extension, copy and paste the authjoomla2.php file to wikiroot/extensions/AuthJoomla2/authJoomla2.php
   Note: I had to create the AuthJoomla2 folder and put the file in there. It wouldn't work otherwise.
   
3. Next, download localsettings.php from Mediawiki extension
4. Open localsettings.php and copy all the code [Press Ctrl-C] and paste[Press Ctrl-V] it into the end of your wiki/LocalSettings.php file
5. Now, make these changes in your MediaWiki LocalSettings.php:
   • $wgAuthJoomla_security_key = 'CHANGE THIS VARIABLE NAME'; //The variable should have the same value of $salt in Line 35 in Step A -> Step 3
   • $wgAuthJoomla_UseExtDatabase = true;
   • Change the database settings
     $wgAuthJoomla_MySQL_Host = 'localhost'; // Joomla MySQL Host Name.
     $wgAuthJoomla_MySQL_Username = 'spfschoo_jml10'; // Joomla Site MySQL Username.
     $wgAuthJoomla_MySQL_Password = 'GmZ5AOGhxL'; // Joomla Site MySQL Password.
     $wgAuthJoomla_MySQL_Database = 'spfschoo_jml10'; // Joomla Site MySQL Database Name
     Note: these can all be found in the 'configuration.php' file in the website folder.
     
   • $wgAuthJoomla_domain = 'http://www.YOURWEBSITE.com/'; //location of your Joomla index.php file
     Note: Don't forget the tail '/' after '.com'
     
6. Save LocalSettings.php

Uploading Docman PDF files with JCE Editor

This was quite a simple fix, all that needed to be changed was the directory that the file manager was set to. This was done in the following steps:

1. Download jce_filemanager_152.zip, and install it via the JCE plugin installer (not the Joomla install/uninstall). Note: You must have a jce subscription to download this!
   
2. Go to JCE -> Groups -> YourGroup.
3. Select the 'Plugin Parameters', and then the 'File Manager' section.
4. Under the 'Standard' tab, in the 'File Directory Path' type the directory path to the Docman pdf folder. The default is root/dmdocuments.
5. File Manager should now go to dmdocuments, while link and image managers stay with the the default (images/stories).
   

No Save or Cancel buttons in Joomla editor

When viewed in Internet Explorer, the Front end editor buttons Save and Cancel are not visible.

When a user clicks to submit an article, if they are using Google Chrome, or Firefox, the Save and Cancel buttons appear.

Solution in this forum:
#http://forum.joomla.org/viewtopic.php?f=473&t=441283&start=0

Recovering Admin Password In Joomla

Change the Password in the Database

If the admin user is still defined, the simplest option is to change the password in the database to a known value. This requires that you have access to the MySQL database using phpMyAdmin.

1. Navigate to phpMyAdmin and select the database for the Joomla! site in the left-hand drop-down list box. This will show the database tables on the left side of the screen.
2. Click on the table "jos_users" in the list of tables.
3. Click on the "Browse" button in the top toolbar. This will show all of the users that are set up for this site.
4. Find the user whose password you want to change and press the Edit icon for this row.
5. A form will display that allows you to edit the password field. Copy the value

   d2064d358136996bd22421584a7cb33e:trd7TvKHx6dMeoMmBVxYmg0vuXEA4199
   

   into the password field and press the Go button. phpMyAdmin should display the message "Affected rows: 1". At this point, the password should be changed to "secret".
6. Log in with this user and password and change the password of this user to a secure value. Check all of the users using the User Manager to make sure they are legitimate. If you have been hacked, you may want to change all of the passwords on the site.

Add a New Super Administrator User

If changing the password won't work, or you aren't sure which user is a member of the Super Administrator group, you can use this method to create a new user.

1. Navigate to phpMyAdmin and select the database for the Joomla! site in the left-hand drop-down list box. This will show the database tables on the left side of the screen.
2. Press the "SQL" button in the toolbar to run a SQL query on the selected database. This will display a field called "Run SQL query/queries on database ".
3. Delete any text in this field and paste in the following and press the Go button.

INSERT INTO `jos_users`
(`id`, `name`, `username`, `email`, `password`, `usertype`, `block`, `sendEmail`,
`gid`, `registerDate`, `lastvisitDate`)
VALUES (NULL, 'Administrator2', 'admin2', 'your-email@yourdomain.com',
'd2064d358136996bd22421584a7cb33e:trd7TvKHx6dMeoMmBVxYmg0vuXEA4199',
'Super Administrator', 0, 1, 25, '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `jos_core_acl_aro` VALUES (NULL, 'users', LAST_INSERT_ID(), 0, 'Administrator', 0);
INSERT INTO `jos_core_acl_groups_aro_map` VALUES (25, '', LAST_INSERT_ID());

At this point, you should be able to log into the back end of Joomla! with the username of "admin2" and password of "secret". After logging in, go to the User Manager and change the password to a secure value and the e-mail to a valid e-mail address. If there is a chance you have been "hacked", be sure to check that all users are legitimate, especially any members of the Super Administrator group.

The examples above change the password to "secret". Two other possible values are shown below:

- password = "this is the MD5 and salted hashed password"
------------------------------------------------------
- admin  = 433903e0a9d6a712e00251e44d29bf87:UJ0b9J5fufL3FKfCc0TLsYJBh2PFULvT
- secret = d2064d358136996bd22421584a7cb33e:trd7TvKHx6dMeoMmBVxYmg0vuXEA4199
- OU812  = 5e3128b27a2c1f8eb53689f511c4ca9e:J584KAEv9d8VKwRGhb8ve7GdKoG7isMm

Source: http://docs.joomla.org/How_do_you_recover_your_admin_password%3F

---

Rohan's Blog:
I tried changing the password of the administrator via the above method. The password changed fine, but unfortunately there were problems with permissions.

This was fixed by creating a temporary Super Admin via the method above. Once the new user was created, I logged into the backend of the Joomla site to guarantee that it was successful.

I then deleted the user which wasn't working in phpMyAdmin, and then added the same user back via User Manager in Joomla.
After testing that the new user worked, I then deleted the temporary Super Admin account and was able to use the remade Super Admin account.

Google Docs Backup

I like Google Docs service very much. At the same time I don't trust anyone... here come two unofficial ways how to backup Google Docs documents:

•http://1st-soft.net/gdd/

and:


•http://code.google.com/p/gdatacopier/


Update:
Checkout also Gladinet Cloud Desktop at http://www.gladinet.com. Its free and makes it easy to Backup Google Docs. You can mount your Google Docs folder as a local drive in explorer and move files back and forth between Google Docs and your desktop. You can also create scheduled backups to Google Docs or to a Redundant Array of Cloud Storage.