Piwigo Bugtracker

Viewing Issue Advanced Details Jump to Notes ] Issue History ] Print ]
ID Category Severity Reproducibility Date Submitted Last Update
0000776 [Piwigo] authentication minor always 2007.11.17 13:32 2007.11.20 17:30
Reporter micke42 View Status public  
Assigned To
Priority normal Resolution fixed Platform espace gratuit chez free
Status closed   OS linux je suppose
Projection none   OS Version
ETA none Fixed in Version 1.7.1 Product Version 1.7.0
  Target Version Product Build
Summary 0000776: erreur sql lors de l'ouverture de la page d'index
Description Lors l'ouverture de la page d'index j'ai des erreurs sql (voir additionnal info).
Une fois connecté avec un utilisateur ses erreurs disparaissent et répaparaissent aussitôt une fois que je me déconnecte.
Steps To Reproduce
Additional Information SELECT cat_id
  FROM phpwebgallery_user_access
  WHERE user_id =
;
[mysql error 1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3


Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /mnt/161/sda/1/4/sophieetriccardo/phpwebgallery/include/functions.inc.php on line 884

SELECT cat_id
  FROM phpwebgallery_user_group AS ug INNER JOIN phpwebgallery_group_access AS ga
    ON ug.group_id = ga.group_id
  WHERE ug.user_id =
;
[mysql error 1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 4


Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /mnt/161/sda/1/4/sophieetriccardo/phpwebgallery/include/functions.inc.php on line 884

DELETE FROM phpwebgallery_user_cache_categories
  WHERE user_id =
;
[mysql error 1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 2

DELETE FROM phpwebgallery_user_cache
  WHERE user_id =
;
[mysql error 1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 2

INSERT INTO phpwebgallery_user_cache
  (user_id, need_update, forbidden_categories, nb_total_images)
  VALUES
  (,'false','1,2,3,4,5,6,7',0)
;
[mysql error 1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''false','1,2,3,4,5,6,7',0)' at line 4


Warning: Cannot modify header information - headers already sent by (output started at /mnt/161/sda/1/4/sophieetriccardo/phpwebgallery/include/functions.inc.php:867) in /mnt/161/sda/1/4/sophieetriccardo/phpwebgallery/include/page_header.php on line 102
Tags No tags attached.
browser Mozilla
Database engine and version 5.0.45
PHP version PHP Version 4.4.3-dev
Web server
Attached Files

- Relationships
related to 0000693closedrub guest & default users can to be deleted 

-  Notes
(0002024)
VDigital (reporter)
2007.11.20 17:25

Suppression du user guest : Faire une recherche sur le forum.
Pb corrigé en 1.7.1 et 1.8

- Issue History
Date Modified Username Field Change
2007.11.17 13:32 micke42 New Issue
2007.11.17 13:32 micke42 browser => Mozilla
2007.11.17 13:32 micke42 MySQL version => 5.0.45
2007.11.17 13:32 micke42 PHP version => PHP Version 4.4.3-dev
2007.11.20 17:25 VDigital Note Added: 0002024
2007.11.20 17:25 VDigital Status new => closed
2007.11.20 17:25 VDigital Resolution open => fixed
2007.11.20 17:25 VDigital Fixed in Version => 1.7.1
2007.11.20 17:30 VDigital Status closed => confirmed
2007.11.20 17:30 VDigital Relationship added related to 0000693
2007.11.20 17:30 VDigital Status confirmed => closed


Mantis 1.1.6[^]
Copyright © 2000 - 2008 Mantis Group
Contact
Powered by Mantis Bugtracker