Getting rid of  à from Mysql Searchs.

Getting rid of  à from Mysql Searchs.


I was returning a search from a MySQL database and in my results I'm getting these signs around £ signs 'Â Ã' .

The way to get rid of this was to change the collation of this table in MySQL. It was latin and after changing it to Utf8_unicode_ci .

stop editPlus overtyping

Today when I turned started to use my EditPlus software I found I could not use the return button as I could before. Insted of creating a new line it would just drop to the line below. Also when editing it would overtype.

I could not find any information on this from google searches. So after solving this problem have created this blog in the hope you will find it and save you some time.

The searches I made in Google where.

Edit plus overtyping

stop editplus overtyping

editPlus return button not working

editPlus turn off overtyping


I could not find anything of use here or in the softwares documentation so had to cover every option I could in the menu.

What you need to do it is turn off the 'auto indent' under the 'Document' menu item on the top menu.


Hope this helps you out.

Joomla - Customizing Mini Ad Spot css

I was commissioned to create a menu item that would display a few adverts - that would be

a image for a company > each one on different coloured backgrounds and they would need

to display randomly.

On this version of Joomla I already had Flexbanner - which is a VERY flexible advertising

manager this would do what I needed except for the last part. I couldn't seem to

randomise the adverts. If you know an answer to this let me know.

After checking out a few Advertising problems and finding problems with them, in a few

instances 'security' issues seemed to be weak - I found Mi

ni Ad Spot


This does exaclty what I needed only I needed to write a little css hack so that the

backgrounds displayed properly.

Here's what I need to change. NOTE! YOULL NEED TO GET RID OF SPACES AROUND THE < or >'s


>> Download the module to you harddrive

>> OPEN modules/mod_miniadspot/tmpl/default.php

>> on line 72, 76 , 81

FIND


< div style="float:left; display: inline; " >

CHANGE TO

< div class="miniad" style="float:left; display: inline; " >



!! note: now you could either just paste the ccs below into your template.css in the template your using. However if like me you use more than 1 template on your site you'll need to call it up from inside the module.


OPEN

modules/mod_miniadspot/mod_miniadspot.xml


FIND:

helper.php

ADD UNDERNEATH:


< filename >css/style.css


CREATE a new folder in modules/mod_miniadspot/ called 'css'

CREATE a new file named 'style.css'

paste this code or similar into it.



UPLOAD THESE FILES

Getting permission problems with noixACL - Joomla Extension help

if you've noixACL installed on your Joomla CMS installation then you may end up banging your head against a wall when you go back into your admin area and find that you can't add articles etc. At this time you'll probably search the settings and try and sort it out. If you manage to sort this out on a perminant basis then let me know because my solution is to

>> choose 'Access Control' from the components drop down.

>> goto 'adapters'

>> then turn off the adapter for the item that your working on

>> then turn it on again.

yeah it's not ideal but a temporary solution until I work it out properly.

Setting your Facebook up receive twitter updates.

Here's the deal, So you have a website that when you write a new article it then automatically sends the title and and a Short url to Twitter, which then also sends the same status update to your facebook fanpage. Saving you time, energy and money.

Well with Joomla it's easy, all you need is AutoTweet - This will status your Twitter account. This is installed onto your Joomla installation

Next you'll need to add 'Twitter Fan Page Sync' this is done from your Facebook Fanpage. You can get this app here Twitter Fan Page Sync

Have Fun!

Parse error: syntax error, unexpected T_CONST, expecting T_OLD_FUNCTION or T_FUNCTION or T_VAR or '}' in *plugins/system/autotweet.php on line 26

I got this error message when using the Plugin Autotweet on a new installation of Joomla! 1.5

Parse error: syntax error, unexpected T_CONST, expecting T_OLD_FUNCTION or T_FUNCTION or T_VAR or '}' in *plugins/system/autotweet.php on line 26

The problem had occured because I had not set up my webspace to be using PHP 5.

The Solution:

open up the file htaccess.txt in your editor.

add the following line to the top

SetEnv DEFAULT_PHP_VERSION 5

now save as .htaccess

and upload.

THATS IT !!!!

hope this works for you.

Database transfer has put ’ , ‘ , “, Â, ”, –, …, ’ in my text.

Here's how I got rid of these from my database.

On this project I am working with Joomla 1.5 but the following instrunctions are fairly Generic and could be used with other mysql database problems with a little adaption.
The theory of the mysql find and replace is this

UPDATE tablename SET fieldname = replace(fieldname,"valuetofind","valuetoreplacewith");

Note: in this scenario I need to replace with apostrophe's ( ' ) . when doing this they need to be escaped. ie \'

Here are the commands I ran in my phpMyAdmin area.

UPDATE jos_content SET introtext = replace(introtext,"’","\'");

UPDATE jos_content SET introtext = replace(introtext,"‘","\'");

UPDATE jos_content SET introtext = replace(introtext,"“","\"");


UPDATE jos_content SET introtext = replace(introtext,"Â"," ");

UPDATE jos_content SET introtext = replace(introtext,"”","\"");

UPDATE jos_content SET introtext = replace(introtext,"–","-");

UPDATE jos_content SET introtext = replace(introtext,"…",";");


I also had to check the titles of the articles to do this replace 'introtext' with 'title'



Building Websites with Joomla! 1.5: The best-selling Joomla! tutorial guide updated for the latest 1.5 release