Change mysql database collation from latin1_swedish_ci to utf8_general_ci

Posted on February 17, 2011 by ewanvrooyen

If you created your site in with a specific collation language and need to change it  you can use this great tool to change all the fields:

Download Phoca Changing Collation Tool

Unzip the zip file and copy the folder ‘tool_phoca_changing_collation’ into your server (localhost) root. Run the index.php script included in the ‘Collation’ folder. Add the following information into the form:

* Database hostname (e.g. localhost)
* Database username
* Database password
* Database name
* Database collation (add here the collation you want to have for the database, all tables and all columns in all tables.

Please, run this script only if you know what you do. If you have an extensive database, you must change the script execution time in your php settings, because 30 seconds to execute this script can be not enough.

Share
Posted in Joomla, MySQL - phpMyAdmin, wamp server, Website Hosting | Tagged , , , | Leave a comment

SH404SEF – Joomfish: Secondary Language homepage link does not translate

Posted on February 16, 2011 by ewanvrooyen

If you have a problem with Joomfish, where you click on the language picker to choose the secondary language (Not default language) and the pages translate, but when you click on the homepage menu link and the page reverts to the default language.

Open modules/mod_mainmenu/helper.php and change:

Code:
$tmp->url = JURI::base();

to:
Code:
$tmp->url = str_replace(array($tmp->route.'/', $tmp->route), '', JRoute::_( $tmp->url ));

Share
Posted in Joomla, SF404SEF | Tagged , | 4 Comments

How can I change my MySQL database collation?

Posted on February 16, 2011 by ewanvrooyen

Usually when you are using foreign characters or multilingual sites (Joomfish for Joomla) you should change your MySQL collation in order to solve problems with encodings. The most common case is to change your MySQL collation from latin1_swedish_ci to utf8_general_ci.

This can be done by using phpMyAdmin:

1. Enter your cPanel and click on the phpMyAdmin icon in the Databases box.
2. Select the database you wish to manage from the drop-down menu on the left
3. Click on the Operations tab in the top menu of your phpMyAdmin
4. At the bottom of the page you will see the collation option. You can now select a collation from the drop down menu and click on the Go button.

Please note that after your change the collation of a database only the new tables will be created with the new collation. All other tables remain with the collation, they were initially created.

Share
Posted in Joomla, MySQL - phpMyAdmin, Website Hosting | Leave a comment

Enable mod_rewrite in windows, WAMP, XAMPP

Posted on February 16, 2011 by ewanvrooyen

Wamp and XAMPP doesn’t come with default rewrite rule enabled, For enabling the rewrite rules in both of them you need to make changes in httpd.conf so that apache can work with rewrite rules.

For enabling the rewrite rules follow these rules:

1) Find httpd.conf (\wamp\bin\apache\Apache2.2.11\conf something along those lines
2) Uncomment the line LoadModule rewrite_module modules/mod_rewrite.so
3) Find the line with DocumentRoot “C:/path/to/my/root”, There you will find contents like
<Directory>
</Directory>

Make sure the content inside these two braces looks like

<Directory>
Options All
AllowOverride All
</Directory>

4) Restart the Apache server and you should be good to go.

Share
Posted in Joomla, wamp server, Website Hosting | Tagged , , | Leave a comment

joomla remove title from homepage

Posted on February 11, 2011 by ewanvrooyen

To remove the title from being displayed on the front page of your joomla site, you need to change a parameter setting in the front page component.

1. Log into backend > Menus > Main Menu > Home (one with the default star) > Look on the right hand side > Parameters (System) > Show page title > change to NO

Save

Share
Posted in Joomla | Leave a comment

JCE: Advanced Link – change root directory for images and documents

Posted on February 10, 2011 by ewanvrooyen

Change the root directory for images and documents when you click on the advanced links tab.

Change the ‘File Directory Path’ in Components->JCE Administration->JCE Group Manager > Default > Edit Paramaters > File Directory Path = images/change_this

Share
Posted in JCE, Joomla | Leave a comment

Your Bay Your Say

Posted on February 9, 2011 by ewanvrooyen

North Wales Housing (NWH) has launched an exciting new initiative offering local people the chance to choose how funding is allocated to local causes.

Under the innovative ‘Participatory Budget’ scheme, residents representing community groups, clubs, organisations as well as individuals from the Colwyn Bay and Old Colwyn areas, are invited to submit their ideas, describing a project that they feel would benefit from a cash boost.

With £6,000 available, NWH is keen to allocate the funding across a number of projects with values ranging from £100 to up to £750. From leaky scout hut roofs, to a garden make over at the over 60’s club, to building an allotment for local children to grow their own vegetables, this initiative could offer an ideal kick start to lift a project off the ground.

To download an application form or for further information, please email support@pb-wales.org.ukThis e-mail address is being protected from spambots. You need JavaScript enabled to view it or call Amie Cavanagh on 01492563251. Please note deadline for entry is 31st January.

Once all nominations have been received, a public vote will be held on 28th February at Eirias Park Leisure Centre to which all local residents will be invited to attend. The projects to receive the highest number of votes will gain funding and work will begin at the schemes shortly afterwards.

Cher Williamson of North Wales Housing said: “NWH is the first housing association in Wales to embrace and implement the participatory budget incentive and we are really proud of early involvement.

“We launched this initially in the Cae Bold area where it was a huge success and most of the projects are now well underway. This time, in Colwyn, we have been match funded by the Welsh Assembly and therefore have a bigger pot of money that can be used to support more local projects.

“We’re definitely open to any ideas – the only criteria being that it must be of benefit to the local community. This is a really exciting initiative for us and we look forward to receiving a broad range of proposals that will all be put to the public vote””

Visit: http://www.nwha.org.uk/en/latest-news-and-events/your-bay-your-say for more information.

Share
Posted in NWH News | Tagged , , | Leave a comment

Convert all caps to normal text in word doc

Posted on February 9, 2011 by ewanvrooyen

1. Select the text you want to convert from ALL CAPS to normal text

2. Shift + F3

Share
Posted in Uncategorized | Leave a comment

JCE editor | TinyMCE – fsockopen()…ssl.google.com:443 error

Posted on February 8, 2011 by ewanvrooyen

If you get the following error when trying to do a spell check in Joomla article and you are using wamp server.

+++
Error response: <br />
<b>Warning</b>: fsockopen() [<a href='function.fsockopen'>function.fsockopen</a>]: unable to connect to ssl://www.google.com:443 (Unable to find the socket transport &quot;ssl&quot; – did you forget to enable it when you configured PHP?) in <b>C:\wamp\www\nwha-fido\plugins\editors\jce\tiny_mce\plugin
+++

Go to Wamp icon > PHP > PHP Extensions > Enable “php_openssl”

Restart all services. It should work.

Share
Posted in Joomla, wamp server, Website Hosting | Tagged , , , | Leave a comment

WAMP Server – MySQL – Resetting the Root Password (Windows)

Posted on February 8, 2011 by ewanvrooyen

1. Log on to your system as Administrator.

2. Click on the Wamp server icon > MySQL > MySQL Console

3. Enter password: LEAVE BLANK AND HIT ENTER

4. mysql> UPDATE mysql.user SET Password=PASSWORD(‘MyNewPass’) WHERE User=’root’; ENTER
Query OK

5. mysql>FLUSH PRIVILEGES; ENTER
mysql>quit ENTER
mysql>bye

6. Edit phpmyadmin file called “config.inc.php” enter ‘MyNewPass’ ($cfg['Servers'][$i]['password'] = ‘MyNewPass‘;)

7. Restart all services

8. Clear all cookies – I got the No password error and it was because of the cookies. (ERROR 1045: Access denied for user: ‘root@localhost’ (Using password: NO))

Share
Posted in wamp server, Website Hosting | Tagged , | 1 Comment