Piwigo Bugtracker

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0000776Piwigoauthenticationpublic2007.11.17 13:322007.11.20 17:30
Reportermicke42 
Assigned To 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
Platformespace gratuit chez freeOSlinux je supposeOS Version
Product Version1.7.0 
Target VersionFixed in Version1.7.1 
Summary0000776: erreur sql lors de l'ouverture de la page d'index
DescriptionLors 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.
Additional InformationSELECT 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
TagsNo tags attached.
browserMozilla
Database engine and version5.0.45
PHP versionPHP 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


Copyright © 2000 - 2015 MantisBT Team
Contact
Powered by Mantis Bugtracker