hi there i have the same error - i cannot help myself
plz advice - i have it with the session
Well to be precise: my friends i have serious problems with the Joomla 1.6 Beta 1 and 2
The installment runs well on the system: but if i want to log in i get the serious error:
Code: Select all
INSERT INTO `jos_session` (`session_id`, `client_id`, `guest`, `time`, `data`, `userid`, `username`, `usertype`) VALUES
('2e13a6979686d297d8b0225e9dc09626', 0, 1, '1275497933', NULL, 0, '', '');
well what can i do here: i tried several versions - Joomla 1.6 Beta 1 and 2.
Everytime it is the same.
i tried to
fix the db
1. repair the table from Cpanel.
2. From command line:
Quote:
mysql> use databasename;
mysql> REPAIR TABLE jos_session;
Well, repairing table did not play the trick then some one advided me that i
can delete the table and create it by firing the below sql query to create the table:
Code: Select all
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;
see more for the fix here:
http://www.fasthostinghelp.com/joomla-e ... c4554d731e&
Error while accessing Joomla Site:
Well i did not do this untill now. The db-dumps look a bit different.
See more infos: this is the original
Code: Select all
-- table `jos_session`
--
DROP TABLE IF EXISTS `jos_session`;
CREATE TABLE IF NOT EXISTS `jos_session` (
`session_id` varchar(32) NOT NULL default '',
`client_id` tinyint(3) unsigned NOT NULL default '0',
`guest` tinyint(4) unsigned default '1',
`time` varchar(14) default '',
`data` varchar(20480) default NULL,
`userid` int(11) default '0',
`username` varchar(150) default '',
`usertype` varchar(50) default '',
PRIMARY KEY (`session_id`),
KEY `whosonline` (`guest`,`usertype`),
KEY `userid` (`userid`),
KEY `time` (`time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Data for Tabelle `jos_session`
--
does it have to do with
the mysql db - settings!? i do not know!?`see more here:
20.25. The INFORMATION_SCHEMA GLOBAL_VARIABLES and SESSION_VARIABLES Tables
The GLOBAL_VARIABLES and SESSION_VARIABLES tables provide information about server status variables. Their contents correspond to the information produced by the SHOW GLOBAL VARIABLES and SHOW SESSION VARIABLES statements (see Section 12.4.5.41, “SHOW VARIABLES Syntax”).
INFORMATION_SCHEMA Name SHOW Name Remarks
VARIABLE_NAME Variable_name
VARIABLE_VALUE Value
Notes:
The GLOBAL_VARIABLES and SESSION_VARIABLES tables were added in MySQL 5.1.12.
Beginning with MySQL 5.1.19, the VARIABLE_VALUE column for each of these tables is defined as VARCHAR(20480). Previously, this column had the data type LONGTEXT; this was changed in order to make these tables consistent with the GLOBAL_STATUS and SESSION_STATUS tables, whose definitions had been changed in that version (see Section 20.24, “The INFORMATION_SCHEMA GLOBAL_STATUS and SESSION_STATUS Tables”).
You do not have the required permissions to view the files attached to this post.