Piwigo.org

Guims · 2005-01-15 10:24:43

Hi !
I install the new phpwg version
install works fine but when i log myself, i redirect to index of the gallery but i'm not logged !
i can't see admin, ...
thanks for your help !

Last edited by Guims (2005-01-15 10:26:57)

plg · 2005-01-15 10:38:25

just after the redirection to category.php, you should have an "id" in your URL. Do you have it ?

After the first redirect, are you sure you're not recognized ?

Can you turn on show_queries parameter in include/config.inc.php and tell us what is shown ?

Guims · 2005-01-15 11:10:45

z0rglub wrote:
just after the redirection to category.php, you should have an "id" in your URL. Do you have it ?

yes I have one

z0rglub wrote:
Can you turn on show_queries parameter in include/config.inc.php and tell us what is shown ?

Here is it :

Code:

[1] 

SELECT param,value
 FROM phpwebgallery_config
;
(this query time : 0.000 s)
(total SQL time  : 0.000 s)

[2] 

SELECT user_id,expiration,NOW() AS now
  FROM phpwebgallery_sessions
  WHERE id = '5qoP05okN4'
;
(this query time : 0.000 s)
(total SQL time  : 0.001 s)

[3] 

SELECT u.*, uf.*
  FROM phpwebgallery_users AS u LEFT JOIN phpwebgallery_user_forbidden AS uf
    ON id = user_id
  WHERE u.id = 2
;
(this query time : 0.000 s)
(total SQL time  : 0.001 s)

[4] 
SELECT SUM(nb_images) AS total FROM phpwebgallery_categories;
(this query time : 0.000 s)
(total SQL time  : 0.001 s)

[5] 

SELECT name,id,date_last,nb_images,global_rank
  FROM phpwebgallery_categories
  WHERE 1 = 1
    AND (id_uppercat is NULL)
;
(this query time : 0.000 s)
(total SQL time  : 0.001 s)

[6] 

SELECT id, name, date_last
  FROM phpwebgallery_categories
  WHERE id_uppercat is NULL
  ORDER BY rank
;
(this query time : 0.000 s)
(total SQL time  : 0.001 s)

Guims · 2005-01-15 11:15:27

I tried several times to see the sql_queries and before the message I told you before,
there's this one during a few seconds :

Code:

Warning: Cannot modify header information - headers already sent by 
(output started at /home/www/guims.freeownhost.com/Galerie/include/functions.inc.php:516) 
in /home/www/guims.freeownhost.com/Galerie/include/functions_session.inc.php 
on line 99

Last edited by Guims (2005-01-15 11:17:08)

plg · 2005-01-15 11:17:06

Guims wrote:
z0rglub wrote:
just after the redirection to category.php, you should have an "id" in your URL. Do you have it ?
yes I have one

Can you check you have a cookie created with this id ? (with Firefox, tools > Options > Privacy > Stored Cookies)

Guims wrote:

Code:

[2] 

SELECT user_id,expiration,NOW() AS now
  FROM phpwebgallery_sessions
  WHERE id = '5qoP05okN4'
;
(this query time : 0.000 s)
(total SQL time  : 0.001 s)

[3] 

SELECT u.*, uf.*
  FROM phpwebgallery_users AS u LEFT JOIN phpwebgallery_user_forbidden AS uf
    ON id = user_id
  WHERE u.id = 2
;
(this query time : 0.000 s)
(total SQL time  : 0.001 s)

(user_id = 2 means guest user)

This makes me think session 5qoP05okN4 has not been created... Can you find it in table sessions ? What is the user associated to it ?

plg · 2005-01-15 11:20:10

Guims wrote:
I tried several times to see the sql_queries and before the message I told you before,
there's this one during a few seconds :
Code:
Warning: Cannot modify header information - headers already sent by 
(output started at /home/www/guims.freeownhost.com/Galerie/include/functions.inc.php:516) 
in /home/www/guims.freeownhost.com/Galerie/include/functions_session.inc.php 
on line 99

normal behaviour, turn off show_queries :-)

Guims · 2005-01-15 11:24:19

z0rglub wrote:
This makes me think session 5qoP05okN4 has not been created... Can you find it in table sessions ? What is the user associated to it ?

I saw others (10!) but not this one...

I don't see cookies...

Last edited by Guims (2005-01-15 11:28:57)

Guims · 2005-01-15 11:33:46

AAAAAAHHHHHHHHHH !!!!!!!!!!!
It works with IE !!!!!!!!!
What do you think?

plg · 2005-01-15 11:48:30

Even if you can't create cookies, you should be connected, but using your session ID in the URL.

It works with IE !!!!!!!!!

with IE, the session exists in the database ??? there should be no link between browser and database :-/

1. turn on show_query
2. in include/functions.inc.php, in function redirect, set $refresh to 20
3. on the redirection page after connection, copy/paste queries shown (and potential errors)

Guims · 2005-01-15 12:01:13

Code:

[1] 

SELECT param,value
 FROM phpwebgallery_config
;
(this query time : 0.000 s)
(total SQL time  : 0.000 s)

[2] 

SELECT user_id,expiration,NOW() AS now
  FROM phpwebgallery_sessions
  WHERE id = '5qoP05okN4'
;
(this query time : 0.000 s)
(total SQL time  : 0.001 s)

[3] 

SELECT u.*, uf.*
  FROM phpwebgallery_users AS u LEFT JOIN phpwebgallery_user_forbidden AS uf
    ON id = user_id
  WHERE u.id = 2
;
(this query time : 0.000 s)
(total SQL time  : 0.001 s)

[4] 

SELECT id, password
  FROM phpwebgallery_users
  WHERE username = 'Guillaume'
;
(this query time : 0.000 s)
(total SQL time  : 0.001 s)

[5] 

SELECT id
  FROM phpwebgallery_sessions
  WHERE id = 'mJ678vkfII'
;
(this query time : 0.000 s)
(total SQL time  : 0.001 s)

[6] 

INSERT INTO phpwebgallery_sessions
  (id,user_id,expiration)
  VALUES
  ('mJ678vkfII',1,
   ADDDATE(NOW(), INTERVAL 3600 SECOND))
;
(this query time : 0.001 s)
(total SQL time  : 0.002 s)


Warning: Cannot modify header information - headers already sent by 
(output started at /home/www/guims.freeownhost.com/Galerie/include/functions.inc.php:516) 
in /home/www/guims.freeownhost.com/Galerie/include/functions_session.inc.php on line 99

plg · 2005-01-15 12:03:15

and does session mJ678vkfII exist now in your database ? What is the expiration datetime ?

Guims · 2005-01-15 12:06:27

z0rglub wrote:
and does session mJ678vkfII exist now in your database ? What is the expiration datetime ?

yes and it's 2005-01-15 05:57:09 ...........
not normal isn's it ???

plg · 2005-01-15 12:10:21

indeed, there is a bug somewhere in MySQL. What is your MySQL version ?

Code:

select version();

Guims · 2005-01-15 12:17:54

MySQL 4.0.22_Debian-6

plg · 2005-01-15 12:28:37

before thinking it can be a bug from MySQL :

Code:

SELECT NOW(), ADDDATE(NOW(), INTERVAL 3600 SECOND) AS 1_hour_future;

Byt the way, which distribution are you using ? Sarge ? Ubuntu warty ? SID ?

Piwigo.org

Announcement

#1 2005-01-15 10:24:43

[1.4.0 RC1] log problem

#2 2005-01-15 10:38:25

Re: [1.4.0 RC1] log problem

#3 2005-01-15 11:10:45

Re: [1.4.0 RC1] log problem

z0rglub wrote:

z0rglub wrote:

Code:

#4 2005-01-15 11:15:27

Re: [1.4.0 RC1] log problem

Code:

#5 2005-01-15 11:17:06

Re: [1.4.0 RC1] log problem

Guims wrote:

z0rglub wrote:

Guims wrote:

Code:

#6 2005-01-15 11:20:10

Re: [1.4.0 RC1] log problem

Guims wrote:

Code:

#7 2005-01-15 11:24:19

Re: [1.4.0 RC1] log problem

z0rglub wrote:

#8 2005-01-15 11:33:46

Re: [1.4.0 RC1] log problem

#9 2005-01-15 11:48:30

Re: [1.4.0 RC1] log problem

#10 2005-01-15 12:01:13

Re: [1.4.0 RC1] log problem

Code:

#11 2005-01-15 12:03:15

Re: [1.4.0 RC1] log problem

#12 2005-01-15 12:06:27

Re: [1.4.0 RC1] log problem

z0rglub wrote:

#13 2005-01-15 12:10:21

Re: [1.4.0 RC1] log problem

Code:

#14 2005-01-15 12:17:54

Re: [1.4.0 RC1] log problem

#15 2005-01-15 12:28:37

Re: [1.4.0 RC1] log problem

Code:

Board footer