Showing posts with label joomla. Show all posts
Showing posts with label joomla. Show all posts

Tuesday, February 23, 2010

How to fix jos_session problem in Joomla


ON the Run SQL query/queries on database Copy and paste this code and click Go


DROP TABLE IF EXISTS `jos_session`;
CREATE TABLE IF NOT EXISTS `jos_session` (
`username` varchar(50) default '',
`time` varchar(14) default '',
`session_id` varchar(200) NOT NULL default '0',
`guest` tinyint(4) default '1',
`userid` int(11) default '0',
`usertype` varchar(50) default '',
`gid` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`session_id`),
KEY `whosonline` (`guest`,`usertype`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


So this sql query will drop the existing jos_session which is using an engine MEMORY
and create a new one with an engine MyISAM. Engine Memory may either good for fast retreival
of data but really consumes much memory in DB. So instead of using engine MEMORY for jos_session
table, we changed it to MyIsam. Well it works great for me. ;)

Monday, February 22, 2010

how to remove "Joomla SEF URLs by Artio" in artio joomsef version 3.5.5


To remove "Joomla SEF URLs by Artio" in your page, download this necessary file using ftp

/components/com_sef/joomsef.php

then use an editor to open the file then comment line 1771 and 1772

line 1771 and 1772 looks like this

if (JRequest::$cosi('fo'.'rmat') != 'r'.'aw')
$doc->$cache($cacheBuf . base64_decode($cacheBuf2), 'component');


So this will look like this now

/*

if (JRequest::$cosi('fo'.'rmat') != 'r'.'aw')
$doc->$cache($cacheBuf . base64_decode($cacheBuf2), 'component');
*/


or


// if (JRequest::$cosi('fo'.'rmat') != 'r'.'aw')
// $doc->$cache($cacheBuf . base64_decode($cacheBuf2), 'component');


So, what joomsef did is, they encoded the link into base 64 format then decoded
it when displayed in the page.


so this is it! Good luck.