The Sessions ID is passed

[Thorsten]

Hi,

thanks, I'll look for a fix in the next days...

bye
Thorsten

[Thorsten]

Hi,

please test RC3!

bye
Thorsten

[algarotti]

Hi,

>please test RC3!

There is the same problem, here are the debug messages:



before login with a browser reload:

DELETE FROM faqadminsessions WHERE TIME < '1081240080'

1 Queries executed




after login:


DELETE FROM faqadminsessions WHERE TIME < '1081240219'
SELECT id, name, realname, email, pass FROM faquser WHERE name = 'admin' AND pass = '88a93408a0dfb56cff34d324e40933ce'
SELECT uin FROM faqadminsessions WHERE UIN='a36c8ba13d3dc1709a6fac96c8ccb7bd'
INSERT INTO faqadminsessions (uin, user, pass, ip, time) VALUES ('a36c8ba13d3dc1709a6fac96c8ccb7bd', 'admin', '88a93408a0dfb56cff34d324e40933ce', '193.54.112.111', '1081242019')
SELECT sid FROM faqsessions ORDER BY sid DESC
SELECT id FROM faqdata ORDER BY id DESC
SELECT id FROM faqcomments ORDER BY id DESC

7 Queries executed




after click on Edit Record (for example):

the message is always : The Sessions ID is passed.

DELETE FROM faqadminsessions WHERE TIME < '1081240244'
SELECT user, pass FROM faqadminsessions WHERE uin = 'a36c8ba13d3dc1709a6fac96c8ccb7bd'
UPDATE faqadminsessions SET time = '1081242044' WHERE uin = 'a36c8ba13d3dc1709a6fac96c8ccb7bd'
SELECT id, name, realname, email, pass FROM faquser WHERE name = 'admin' AND pass = '88a93408a0dfb56'
INSERT INTO faqadminlog (ID,TIME,USER,TEXT,IP) VALUES ('','1081242044','','Session expired
UIN: a36c8ba13d3dc1709a6fac96c8ccb7bd
User: admin','193.54.112.111')

5 Queries executed


bye

Serge

[Thorsten]

Hi Serge,

does your MySQL table faqadminsessions look like this:

Code: Select all

CREATE TABLE `faqadminsessions` (
  `uin` varchar(50) binary NOT NULL default '',
  `user` tinytext NOT NULL,
  `pass` varchar(64) binary NOT NULL default '',
  `ip` text NOT NULL,
  `time` int(11) NOT NULL default '0'
) TYPE=MyISAM;

bye
Thorsten

[algarotti]

[Hi Thorsten


I think you have find the problem !

>does your MySQL table faqadminsessions look like this:
>`pass` varchar(64) binary NOT NULL default '',

I have : !!!!

`pass` varchar(15) binary NOT NULL default '',

The others fields are correct.

I dont understand why I have this 15 !!

I dont known very much mysql. I use phpMyadmin to admin mysql. Do I have just to make a change from 15 to 64 with the menu change of phpmyadmin.


thank you very much for your help

Serge

[Thorsten]

Hi,

okay, this was hard to resolve.

You can change it in phpMyAdmin oder just use in the SQL form of phpMyAdmin this query:

Code: Select all

ALTER TABLE faqadminsessions CHANGE pass pass VARCHAR(64) BINARY NOT NULL

bye
Thorsten

[algarotti]

[quote="Thorsten"]Hi,

IT'S WORK !!!!!!!!!!

>okay, this was hard to resolve.

thank you again very much for your help.

I don't understand why the value was not correct because I never modify the table ! May be, it was in the past, with trying some old beta version...


Best regards

[Thorsten]

Hi Serge,

okay.

RC3 will be final then.

bye
Thorsten

[AndrewB]

I just upgraded from 1.4.2 RC1 to 1.4.2 RC2 and now each page I try to access in the Admin section takes me back to the login screen with this message "The Sessions ID is passed." I will check my password field in the table.

This was an original 1.4.0 system that I upgraded to various 1.4.x releases

[Thorsten]

Hi Andrew,

can you please post a SQL dump of the table structure?

bye
Thorsten

[AndrewB]

faqadminsessions table?

It seems to be an empty table.

[Thorsten]

Hi,

no, the structure of all tables but not the data.

bye
Thorsten

[AndrewB]

is this what you want?

Code: Select all

-- phpMyAdmin SQL Dump
-- version 2.6.0-pl1
-- http://www.phpmyadmin.net
-- 
-- Host: 208.179.130.30
-- Generation Time: Oct 04, 2004 at 11:11 AM
-- Server version: 4.0.21
-- PHP Version: 4.3.8
-- 
-- Database: `cafedeu_faq`
-- 

-- --------------------------------------------------------

-- 
-- Table structure for table `4faqadminlog`
-- 

CREATE TABLE `4faqadminlog` (
  `id` int(11) NOT NULL auto_increment,
  `time` int(11) NOT NULL default '0',
  `user` int(11) NOT NULL default '0',
  `text` text NOT NULL,
  `ip` text NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=195 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `4faqadminsessions`
-- 

CREATE TABLE `4faqadminsessions` (
  `uin` varchar(50) binary NOT NULL default '',
  `user` tinytext NOT NULL,
  `pass` varchar(64) binary NOT NULL default '',
  `ip` text NOT NULL,
  `time` int(11) NOT NULL default '0'
) TYPE=MyISAM;

-- --------------------------------------------------------

-- 
-- Table structure for table `4faqcategories`
-- 

CREATE TABLE `4faqcategories` (
  `id` int(11) NOT NULL auto_increment,
  `lang` varchar(5) NOT NULL default '',
  `parent_id` int(11) NOT NULL default '0',
  `name` varchar(255) NOT NULL default '',
  `description` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`,`lang`)
) TYPE=MyISAM AUTO_INCREMENT=373398 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `4faqchanges`
-- 

CREATE TABLE `4faqchanges` (
  `id` int(11) NOT NULL auto_increment,
  `beitrag` int(11) NOT NULL default '0',
  `lang` varchar(5) NOT NULL default '',
  `user` int(11) NOT NULL default '0',
  `datum` int(11) NOT NULL default '0',
  `what` text NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=27 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `4faqcomments`
-- 

CREATE TABLE `4faqcomments` (
  `id_comment` int(11) NOT NULL auto_increment,
  `id` int(11) NOT NULL default '0',
  `user` varchar(255) NOT NULL default '',
  `email` varchar(255) NOT NULL default '',
  `comment` text NOT NULL,
  `datum` int(15) NOT NULL default '0',
  `helped` text NOT NULL,
  PRIMARY KEY  (`id_comment`)
) TYPE=MyISAM AUTO_INCREMENT=8 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `4faqdata`
-- 

CREATE TABLE `4faqdata` (
  `id` int(11) NOT NULL auto_increment,
  `lang` varchar(5) NOT NULL default '',
  `active` char(3) NOT NULL default '',
  `rubrik` text NOT NULL,
  `keywords` text NOT NULL,
  `thema` text NOT NULL,
  `content` text NOT NULL,
  `author` varchar(255) NOT NULL default '',
  `email` varchar(255) NOT NULL default '',
  `comment` enum('y','n') NOT NULL default 'y',
  `datum` varchar(15) NOT NULL default '',
  PRIMARY KEY  (`id`,`lang`),
  FULLTEXT KEY `keywords` (`keywords`,`thema`,`content`)
) TYPE=MyISAM AUTO_INCREMENT=14 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `4faqfragen`
-- 

CREATE TABLE `4faqfragen` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `ask_username` varchar(100) NOT NULL default '',
  `ask_usermail` varchar(100) NOT NULL default '',
  `ask_rubrik` varchar(100) NOT NULL default '',
  `ask_content` text NOT NULL,
  `ask_date` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `4faqnews`
-- 

CREATE TABLE `4faqnews` (
  `id` int(11) NOT NULL auto_increment,
  `header` varchar(255) NOT NULL default '',
  `artikel` text NOT NULL,
  `datum` varchar(14) NOT NULL default '',
  `link` varchar(255) NOT NULL default '',
  `linktitel` varchar(255) NOT NULL default '',
  `target` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `4faqsessions`
-- 

CREATE TABLE `4faqsessions` (
  `sid` int(11) NOT NULL auto_increment,
  `ip` text NOT NULL,
  `time` int(11) NOT NULL default '0',
  PRIMARY KEY  (`sid`)
) TYPE=MyISAM AUTO_INCREMENT=188 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `4faquser`
-- 

CREATE TABLE `4faquser` (
  `id` int(2) NOT NULL auto_increment,
  `name` text NOT NULL,
  `pass` varchar(64) binary NOT NULL default '',
  `realname` varchar(255) NOT NULL default '',
  `email` varchar(255) NOT NULL default '',
  `rights` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=11 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `4faqvisits`
-- 

CREATE TABLE `4faqvisits` (
  `id` int(11) NOT NULL auto_increment,
  `lang` varchar(5) NOT NULL default '',
  `visits` int(11) NOT NULL default '0',
  `last_visit` int(15) NOT NULL default '0',
  PRIMARY KEY  (`id`,`lang`)
) TYPE=MyISAM AUTO_INCREMENT=14 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `4faqvoting`
-- 

CREATE TABLE `4faqvoting` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `artikel` int(11) unsigned NOT NULL default '0',
  `vote` int(11) unsigned NOT NULL default '0',
  `user` int(11) unsigned NOT NULL default '0',
  `datum` varchar(20) NOT NULL default '',
  `ip` varchar(15) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=4 ;
        

[Thorsten]

Hi,

you didn't update your FAQ, some column names are wrong. The 'user' columns are now called 'usr'. The Updater should rename the columns.

bye
Thorsten

[AndrewB]

Hmm. I ran the Update.php file and all steps seemed to be OK.

I could try uploading the file again and run it again.