Below is the sql query you might want to execute.
DROP TABLE IF EXISTS `frei_chat`;
CREATE TABLE IF NOT EXISTS `frei_chat` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`from` int(11) NOT NULL,
`from_name` varchar(30) NOT NULL,
`to` int(11) NOT NULL,
`to_name` varchar(30) NOT NULL,
`message` text NOT NULL,
`sent` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`recd` int(10) unsigned NOT NULL DEFAULT '0',
`time` varchar(15) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
DROP TABLE IF EXISTS `frei_session`;
CREATE TABLE IF NOT EXISTS `frei_session` (
`id` int(100) NOT NULL AUTO_INCREMENT,
`username` varchar(255) DEFAULT NULL,
`time` int(100) NOT NULL,
`session_id` varchar(100) NOT NULL,
`permanent_id` int(100) NOT NULL,
`status` tinyint(4) NOT NULL,
`guest` tinyint(3) NOT NULL,
`status_mesg` varchar(50) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `permanent_id` (`permanent_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=78 ;
Install the joomla module.
Then do the necessary changes in arg.php file.
The blank page is because of some error, you should check the error log for details.
Below is the sql query you might want to execute.
<code>
DROP TABLE IF EXISTS `frei_chat`;
CREATE TABLE IF NOT EXISTS `frei_chat` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`from` int(11) NOT NULL,
`from_name` varchar(30) NOT NULL,
`to` int(11) NOT NULL,
`to_name` varchar(30) NOT NULL,
`message` text NOT NULL,
`sent` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`recd` int(10) unsigned NOT NULL DEFAULT '0',
`time` varchar(15) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
DROP TABLE IF EXISTS `frei_session`;
CREATE TABLE IF NOT EXISTS `frei_session` (
`id` int(100) NOT NULL AUTO_INCREMENT,
`username` varchar(255) DEFAULT NULL,
`time` int(100) NOT NULL,
`session_id` varchar(100) NOT NULL,
`permanent_id` int(100) NOT NULL,
`status` tinyint(4) NOT NULL,
`guest` tinyint(3) NOT NULL,
`status_mesg` varchar(50) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `permanent_id` (`permanent_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=78 ;
</code>
Install the joomla module.
Then do the necessary changes in arg.php file.
The blank page is because of some error, you should check the error log for details.
Necessity is the mother of all inventions!