Announcement

#1 2010-11-27 16:12:53

nileson
Member
2010-11-27
9

[resolved] HELP PLEASE upgrade failure

I have just tried to upgrade to 2.1.5, and now my website looks like this:
www.lj-photo.dk


Warning:  [mysql error 1146] Table 'lj_photo_dk.piwigo_themes' doesn't exist

SELECT
    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
; in /customers/lj-photo.dk/lj-photo.dk/httpd.www/include/dblayer/functions_mysql.inc.php on line 656


Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /customers/lj-photo.dk/lj-photo.dk/httpd.www/include/dblayer/functions_mysql.inc.php on line 155

Warning: array_merge() [function.array-merge]: Argument #2 is not an array in /customers/lj-photo.dk/lj-photo.dk/httpd.www/include/functions_user.inc.php on line 330

Warning: Invalid argument supplied for foreach() in /customers/lj-photo.dk/lj-photo.dk/httpd.www/include/functions_user.inc.php on line 332

Notice: Undefined index: id in /customers/lj-photo.dk/lj-photo.dk/httpd.www/include/functions_user.inc.php on line 361

Notice: Undefined index: status in /customers/lj-photo.dk/lj-photo.dk/httpd.www/include/functions_user.inc.php on line 361


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 /customers/lj-photo.dk/lj-photo.dk/httpd.www/include/dblayer/functions_mysql.inc.php on line 656


Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /customers/lj-photo.dk/lj-photo.dk/httpd.www/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 /customers/lj-photo.dk/lj-photo.dk/httpd.www/include/dblayer/functions_mysql.inc.php on line 656


Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /customers/lj-photo.dk/lj-photo.dk/httpd.www/include/dblayer/functions_mysql.inc.php on line 202

Notice: Undefined index: level in /customers/lj-photo.dk/lj-photo.dk/httpd.www/include/functions_user.inc.php on line 369


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 (107)
    AND level> in /customers/lj-photo.dk/lj-photo.dk/httpd.www/include/dblayer/functions_mysql.inc.php on line 656


Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /customers/lj-photo.dk/lj-photo.dk/httpd.www/include/dblayer/functions_mysql.inc.php on line 202

Notice: Undefined index: level in /customers/lj-photo.dk/lj-photo.dk/httpd.www/include/functions_user.inc.php on line 689


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 'WHERE c.id NOT IN (107)
  GROUP BY c.id, c.global_rank' at line 8
SELECT c.id AS cat_id, global_rank,
  MAX(date_available) AS date_last, COUNT(date_available) AS 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<=
  WHERE c.id NOT IN (107)
  GROUP BY c.id, c.global_rank in /customers/lj-photo.dk/lj-photo.dk/httpd.www/include/dblayer/functions_mysql.inc.php on line 656


Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /customers/lj-photo.dk/lj-photo.dk/httpd.www/include/dblayer/functions_mysql.inc.php on line 155

Notice: Undefined index: status in /customers/lj-photo.dk/lj-photo.dk/httpd.www/include/functions_user.inc.php on line 390

Notice: Undefined index: id in /customers/lj-photo.dk/lj-photo.dk/httpd.www/include/functions_user.inc.php on line 417


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 /customers/lj-photo.dk/lj-photo.dk/httpd.www/include/dblayer/functions_mysql.inc.php on line 656


Notice: Undefined index: id in /customers/lj-photo.dk/lj-photo.dk/httpd.www/include/functions_user.inc.php on line 436


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 /customers/lj-photo.dk/lj-photo.dk/httpd.www/include/dblayer/functions_mysql.inc.php on line 656


Notice: Undefined index: id in /customers/lj-photo.dk/lj-photo.dk/httpd.www/include/functions_user.inc.php on line 444


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',1290870715,'107',613,'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',1290870715,'107',613,'NOT IN','0') in /customers/lj-photo.dk/lj-photo.dk/httpd.www/include/dblayer/functions_mysql.inc.php on line 656


Notice: Undefined index: nb_image_line in /customers/lj-photo.dk/lj-photo.dk/httpd.www/include/functions_user.inc.php on line 246

Notice: Undefined index: nb_line_page in /customers/lj-photo.dk/lj-photo.dk/httpd.www/include/functions_user.inc.php on line 246


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

UPDATE piwigo_user_infos
  SET theme = 'Sylvia'
  WHERE user_id = '2' in /customers/lj-photo.dk/lj-photo.dk/httpd.www/include/dblayer/functions_mysql.inc.php on line 656


Notice: Undefined index: language in /customers/lj-photo.dk/lj-photo.dk/httpd.www/include/common.inc.php on line 129

Notice: Undefined index: language in /customers/lj-photo.dk/lj-photo.dk/httpd.www/include/common.inc.php on line 133

Notice: Undefined index: adviser in /customers/lj-photo.dk/lj-photo.dk/httpd.www/include/functions_user.inc.php on line 1329

Warning: Cannot modify header information - headers already sent by (output started at /customers/lj-photo.dk/lj-photo.dk/httpd.www/include/dblayer/functions_mysql.inc.php:655) in /customers/lj-photo.dk/lj-photo.dk/httpd.www/include/functions_html.inc.php on line 483

Du har ikke tilladelse til at besøge denne side
Identifikation Hjem

Last edited by nileson (2010-11-27 16:49:01)

Offline

 

#2 2010-11-27 16:49:01

ddtddt
Piwigo Team
Quetigny - France
2007-07-27
7222

Re: [resolved] HELP PLEASE upgrade failure

Hi :-)

the update isn't finished

clic on

http://www.lj-photo.dk/upgrade.php


You love Piwigo so don't hesitate to participate, learn more on the "Contribute to Piwigo" page. If you don't have much time for contribution, you can also help the project with a donation.

Offline

 

#3 2010-11-27 17:09:15

nileson
Member
2010-11-27
9

Re: [resolved] HELP PLEASE upgrade failure

Thanks a lot.
I was getting pretty nervous ;-)

Offline

 

#4 2010-11-27 17:23:52

ddtddt
Piwigo Team
Quetigny - France
2007-07-27
7222

Re: [resolved] HELP PLEASE upgrade failure

:-)

Can you pass topic to resolved (link in the first post)


You love Piwigo so don't hesitate to participate, learn more on the "Contribute to Piwigo" page. If you don't have much time for contribution, you can also help the project with a donation.

Offline

 

Board footer

Powered by FluxBB

github twitter newsletter Donate Piwigo.org © 2002-2024 · Contact