Bonjour,
j'ai fait lune mise à jour de la version 2.0.10 vers 2.1.1. J'héberge mon site chez FREE http://saintlegergym.free.fr/photos/

dans un premier temps, j'avais comme message d'erreur que la table "theme" n'existait pas. J'ai exporté la table depuis un autre site (déjà sous version 2.1.1) mais j'ai maintenant une autre erreur.
Suite à la lecture dans votre forum, j'ai désactivé tous les plugins.

Merci par avance de votre aide.
Christian

******************************************************

Warning:  [mysql error 1054] Unknown column 'ui.theme' in 'on clause'

SELECT
    COUNT(1) AS counter,
    ui.*,
    uc.*,
    t.name AS theme_name
  FROM piwigo_user_infos AS ui
    LEFT JOIN piwigo_user_cache AS uc ON ui.user_id = uc.user_id
    LEFT JOIN piwigo_themes AS t ON t.id = ui.theme
  WHERE ui.user_id = '1'
  GROUP BY ui.user_id
; in /mnt/102/sdb/a/9/saintlegergym/photos/include/dblayer/functions_mysql.inc.php on line 642


Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/102/sdb/a/9/saintlegergym/photos/include/dblayer/functions_mysql.inc.php on line 155



Warning:  [mysql error 1054] Unknown column 'theme' in 'field list'

UPDATE piwigo_user_infos
  SET theme = 'Sylvia'
  WHERE user_id = '2' in /mnt/102/sdb/a/9/saintlegergym/photos/include/dblayer/functions_mysql.inc.php on line 642



Warning:  [mysql error 1054] Unknown column 'theme' in 'field list'

INSERT INTO piwigo_user_infos
  (nb_image_line,nb_line_page,adviser,language,maxwidth,maxheight,expand,show_nb_comments,show_nb_hits,recent_period,template,enabled_high,level,theme,user_id,status,registration_date)
  VALUES('5','3','false','fr_FR','800','600','false','false','false','7','yoga/clear','true','8','Sylvia','1','webmaster','2010-05-31 14:16:34') in /mnt/102/sdb/a/9/saintlegergym/photos/include/dblayer/functions_mysql.inc.php on line 642



Warning:  [mysql error 1054] Unknown column 'ui.theme' in 'on clause'

SELECT
    COUNT(1) AS counter,
    ui.*,
    uc.*,
    t.name AS theme_name
  FROM piwigo_user_infos AS ui
    LEFT JOIN piwigo_user_cache AS uc ON ui.user_id = uc.user_id
    LEFT JOIN piwigo_themes AS t ON t.id = ui.theme
  WHERE ui.user_id = '1'
  GROUP BY ui.user_id
; in /mnt/102/sdb/a/9/saintlegergym/photos/include/dblayer/functions_mysql.inc.php on line 642


Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/102/sdb/a/9/saintlegergym/photos/include/dblayer/functions_mysql.inc.php on line 155

Warning: array_merge() [function.array-merge]: Argument #2 is not an array in /mnt/102/sdb/a/9/saintlegergym/photos/include/functions_user.inc.php on line 316

Warning: Invalid argument supplied for foreach() in /mnt/102/sdb/a/9/saintlegergym/photos/include/functions_user.inc.php on line 318



Warning:  [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

SELECT cat_id
  FROM piwigo_user_access
  WHERE user_id =
; in /mnt/102/sdb/a/9/saintlegergym/photos/include/dblayer/functions_mysql.inc.php on line 642


Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/102/sdb/a/9/saintlegergym/photos/include/dblayer/functions_mysql.inc.php on line 202



Warning:  [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

SELECT cat_id
  FROM piwigo_user_group AS ug INNER JOIN piwigo_group_access AS ga
    ON ug.group_id = ga.group_id
  WHERE ug.user_id =
; in /mnt/102/sdb/a/9/saintlegergym/photos/include/dblayer/functions_mysql.inc.php on line 642


Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/102/sdb/a/9/saintlegergym/photos/include/dblayer/functions_mysql.inc.php on line 202



Warning:  [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

SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level> in /mnt/102/sdb/a/9/saintlegergym/photos/include/dblayer/functions_mysql.inc.php on line 642


Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/102/sdb/a/9/saintlegergym/photos/include/dblayer/functions_mysql.inc.php on line 202



Warning:  [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 'GROUP BY c.id, c.global_rank' at line 8
SELECT c.id cat_id, global_rank,
  MAX(date_available) date_last, COUNT(date_available) nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=
  GROUP BY c.id, c.global_rank in /mnt/102/sdb/a/9/saintlegergym/photos/include/dblayer/functions_mysql.inc.php on line 642


Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/102/sdb/a/9/saintlegergym/photos/include/dblayer/functions_mysql.inc.php on line 155



Warning:  [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 piwigo_user_cache_categories
  WHERE user_id =  in /mnt/102/sdb/a/9/saintlegergym/photos/include/dblayer/functions_mysql.inc.php on line 642



Warning:  [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 piwigo_user_cache
  WHERE user_id =  in /mnt/102/sdb/a/9/saintlegergym/photos/include/dblayer/functions_mysql.inc.php on line 642



Warning:  [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',1275308195,'0',1031,'NOT IN','0')' at line 5

INSERT INTO piwigo_user_cache
  (user_id, need_update, cache_update_time, forbidden_categories, nb_total_images,
    image_access_type, image_access_list)
  VALUES
  (,'false',1275308195,'0',1031,'NOT IN','0') in /mnt/102/sdb/a/9/saintlegergym/photos/include/dblayer/functions_mysql.inc.php on line 642
***********************************************************************


Warning: Cannot modify header information - headers already sent by (output started at /mnt/102/sdb/a/9/saintlegergym/photos/include/dblayer/functions_mysql.inc.php:641) in /mnt/102/sdb/a/9/saintlegergym/photos/include/functions_html.inc.php on line 483
Vous n'êtes pas autorisé à accéder à la page demandée
Identification Accueil