Rolling back to earlier version of Virtuemart added  keys to database entries

heres what I ran in MySQL to sort this

UPDATE jos_vm_product SET product_s_desc = replace(product_s_desc,"Â"," ");


UPDATE jos_vm_product SET product_desc = replace(product_desc,"Â"," ");

UPDATE jos_vm_product_reviews SET comment = replace(comment,"Â"," ");

UPDATE jos_vm_category SET category_description = replace(category_description,"Â"," ");


If you are having problems with other values you could try these also



UPDATE jos_vm_product SET product_s_desc = replace(product_s_desc,"’","\'");

UPDATE jos_vm_product SET product_s_desc = replace(product_s_desc,"‘","\'");

UPDATE jos_vm_product SET product_s_desc = replace(product_s_desc,"“","\"");


UPDATE jos_vm_product SET product_s_desc = replace(product_s_desc,"Â"," ");

UPDATE jos_vm_product SET product_s_desc = replace(product_s_desc,"”","\"");

UPDATE jos_vm_product SET product_s_desc = replace(product_s_desc,"–","-");

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



UPDATE jos_vm_product SET product_desc = replace(product_desc,"’","\'");

UPDATE jos_vm_product SET product_desc = replace(product_desc,"‘","\'");

UPDATE jos_vm_product SET product_desc = replace(product_desc,"“","\"");


UPDATE jos_vm_product SET product_desc = replace(product_desc,"Â"," ");

UPDATE jos_vm_product SET product_desc = replace(product_desc,"”","\"");

UPDATE jos_vm_product SET product_desc = replace(product_desc,"–","-");

UPDATE jos_vm_product SET product_desc = replace(product_desc,"…",";");



UPDATE jos_vm_product_reviews SET comment = replace(comment,"’","\'");

UPDATE jos_vm_product_reviews SET comment = replace(comment,"‘","\'");

UPDATE jos_vm_product_reviews SET comment = replace(comment,"“","\"");


UPDATE jos_vm_product_reviews SET comment = replace(comment,"Â"," ");

UPDATE jos_vm_product_reviews SET comment = replace(comment,"”","\"");

UPDATE jos_vm_product_reviews SET comment = replace(comment,"–","-");

UPDATE jos_vm_product_reviews SET comment = replace(comment,"…",";");




UPDATE jos_vm_category SET category_description = replace(category_description,"’","\'");

UPDATE jos_vm_category SET category_description = replace(category_description,"‘","\'");

UPDATE jos_vm_category SET category_description = replace(category_description,"“","\"");


UPDATE jos_vm_category SET category_description = replace(category_description,"Â"," ");

UPDATE jos_vm_category SET category_description = replace(category_description,"”","\"");

UPDATE jos_vm_category SET category_description = replace(category_description,"–","-");

UPDATE jos_vm_category SET category_description = replace(category_description,"…",";");

Joomla - getting rid of the 'Error loading Modules:' error message

For some reason I'd started getting his message on my websites

Error loading Modules:

to get rid of it I need to open up the mysql database for the website in MyPHPadmin and I deleted all the unused Modules from the table 'jos_modules'

the error message is now gone :))


Just incase i've deleted something I needed heres the entries I deleted.

mod_popular
mod_latest
mod_quickicon
mod_feed
mod_autocanonical
mod_vmproductslideshow
mod_gtranslate
mod_metamod
mod_smartbookmarker


the delete instructions

DELETE FROM `database`.`jos_modules`

WHERE `jos_modules`.`id` = 3;
DELETE FROM `database``.`jos_modules`

WHERE `jos_modules`.`id` = 4;
DELETE FROM `database``.`jos_modules`

WHERE `jos_modules`.`id` = 9;
DELETE FROM `database``.`jos_modules`

WHERE `jos_modules`.`id` = 42;
DELETE FROM `database``.`jos_modules`

WHERE `jos_modules`.`id` = 61;
DELETE FROM `database``.`jos_modules`

WHERE `jos_modules`.`id` = 95;
DELETE FROM `database``.`jos_modules`

WHERE `jos_modules`.`id` = 125;
DELETE FROM `database``.`jos_modules`

WHERE `jos_modules`.`id` = 143;
DELETE FROM `database``.`jos_modules`

WHERE `jos_modules`.`id` = 133;
DELETE FROM `database``.`jos_modules`

WHERE `jos_modules`.`id` = 135;

and i've kept a backup at backup/july/jos_modules.sql

joomla ja_purity template get rid of #ja-wrapper min-width

I'm using the ja_purity template in Joomla on one our sites and it's been mentioned by those with big screens ( rich gits, lol! ) that there's too much white space. So what I need to do is limit the size the page displays at. Which I've used this css

#ja-wrapper {
max-width: 1200px ;
min-width: 800px ;
}

and put it into template.css in the css folder. IT DIDNT WORK THOUGH.

as it was being overrun by
#ja-wrapper {
max-width: 100% ;
}

which apparently was being generated on line 50 of the index.php of the template. Which I couldn't find !
Theres an easy way to fix this though and thats to use !important after the css I've added. This tells the system to override other css.

#ja-wrapper {
max-width: 1200px !important;
min-width: 800px !important;
}

uninstall jzip - a quick how to

First of all if by chance you've found this by searching for a ' Jzip review ' then DO NOT DOWNLOAD THIS SOFTWARE as it takes over your internet search bars with their own that place Google Ads at the top.

If like me you have installed it and want to get rid of it heres what you need to do.

> first of all use the uninstall on the start menu

> then search for 'run' on the start menu and open.

> type in regedit.exe

> click on 'ctrl f' and type in 'jzip'

> delete each entry and then click on 'F3' which searches for the next one. delete all instances.

> click on 'ctrl f' and type in 'dts.search' and delete all keys for this too,

RESTART

and we're done :)

note to self - turning back on the mega menu

just a quick note to myself!

i've turned off the Joomla Maxi Menu for Ocean Blue Clothing - when I need to turn it back on I'll need to put [cols3] back in the menu title and turn the mod_maximenu module back on and turn off mod_mainmenu.

Got it. Oh and hi to the future me, hope things are good :)

Google Chrome CSS - Unfixing the fix

After following one of our own link on our Polzeath Surf Report it brought me to our Shortboards page that looked like this in Google Chrome ( not my default browser but I do tend to switch around to give me an oversight on how others view the web )

'I thought I'd fixed this one' - and half expected when looking at the code that my fix would be gone and I'd somehow loaded an old page in. However the fix was still there.

@media screen and (-webkit-min-device-pixel-ratio:0) {

#maincolumn, #maincolumn_full {
float: left;
}

}


Getting rid of the 'float: left;' sorted the problem and it now displays the same as other browsers. Which means that Google Chrome had sorted out whatever the difference was that made the page look different from other browsers.

Joomla Contact form not working but 'send confirmation post' is

I haven't solved this as of yet but have found this post as a lead

http://forum.joomla.org/viewtopic.php?f=431&t=272340

I think i'm going to try changing the configuration files for the email settings.

I'll let you know how i get on