Announcement

#1 2011-04-03 17:34:57

Petter
Member
2011-04-03
30

Error after upgrade to 2.2 - HELP!

Hi, the upgrade to 2.2 was NO success!
When i try to go to the admin panel, i got this message:

Fatal error: Cannot redeclare order_by_name() (previously declared in /customers/bortne-mathisen.com/bortne-mathisen.com/httpd.www/galleri/include/functions_html.inc.php:504) in /customers/bortne-mathisen.com/bortne-mathisen.com/httpd.www/galleri/admin/include/functions.php on line 2163

And the main page show this error message:

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

SELECT
    c.*,
    user_representative_picture_id,
    nb_images,
    date_last,
    max_date_last,
    count_images,
    count_categories
  FROM piwigo_categories c
    INNER JOIN piwigo_user_cache_categories ucc ON id = cat_id AND user_id = 1
  WHERE id_uppercat is NULL
   
  ORDER BY rank
; in /customers/bortne-mathisen.com/bortne-mathisen.com/httpd.www/galleri/include/dblayer/functions_mysql.inc.php on line 656
Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /customers/bortne-mathisen.com/bortne-mathisen.com/httpd.www/galleri/include/dblayer/functions_mysql.inc.php on line 155 Warning: Cannot modify header information - headers already sent by (output started at /customers/bortne-mathisen.com/bortne-mathisen.com/httpd.www/galleri/include/dblayer/functions_mysql.inc.php:655) in /customers/bortne-mathisen.com/bortne-mathisen.com/httpd.www/galleri/include/page_header.php on line 98


What can i do??

Hope you can help.

Best regards
Petter

Offline

 

#2 2011-04-03 17:43:25

lisaviolet
Member
san diego, california
2011-01-03
334

Re: Error after upgrade to 2.2 - HELP!

What I had to do (with help from the developers) was go through and start putting my plugins on inactive status.  Not all of the plugins are Piwigo 2.2 ready.

Offline

 

#3 2011-04-03 17:51:16

plg
Piwigo Team
Nantes, France, Europe
2002-04-05
13570

Re: Error after upgrade to 2.2 - HELP!

Your data model is not up to date, so you should run http://www.bortne-mathisen.com/galleri/upgrade.php but this page does not show anything :-/

Is the file upgrade.php available in your filesystem? Do you have anything in your web server error log?

Offline

 

#4 2011-04-04 12:23:52

Petter
Member
2011-04-03
30

Re: Error after upgrade to 2.2 - HELP!

I'm not sure, i check later, after work.
Will i lose all the pictures, if i have to upload piwigo from scratch?
Can i upload only the upgrade.php?

Best regards
Petter

Offline

 

#5 2011-04-04 12:28:36

plg
Piwigo Team
Nantes, France, Europe
2002-04-05
13570

Re: Error after upgrade to 2.2 - HELP!

Petter, as soon as you have a recent copy of your database and the folders "galleries" and "upload", you won't loose anything.

First make sure upgrade.php is available. Then check your web server error log file.

Offline

 

#6 2011-04-04 18:38:15

Petter
Member
2011-04-03
30

Re: Error after upgrade to 2.2 - HELP!

Hi, i have the upgrade.php file in the folder, so that looks ok.
Error logging for php was turned off, so i dont have any. (turned on now)
I have copy of "Galleries" and "Upload", but my backup tool have not included the piwigo_ tables. :o( Fixed now.

So what is the next step?

Best regards
Petter

Last edited by Petter (2011-04-04 22:14:50)

Offline

 

#7 2011-04-04 22:22:44

Petter
Member
2011-04-03
30

Re: Error after upgrade to 2.2 - HELP!

Hi, i tried to open the upgrade.php file i the browser, but only get this message:

Fatal error: Cannot redeclare order_by_name() (previously declared in /customers/bortne-mathisen.com/bortne-mathisen.com/httpd.www/galleri/include/functions_html.inc.php:504) in /customers/bortne-mathisen.com/bortne-mathisen.com/httpd.www/galleri/admin/include/functions.php on line 2163

Offline

 

#8 2011-04-04 22:29:43

plg
Piwigo Team
Nantes, France, Europe
2002-04-05
13570

Re: Error after upgrade to 2.2 - HELP!

I have the feeling that Piwigo 2.2.0 files are not correctly transfered. Can you download the package, extract files on your computer and transfer them on your web server with you FTP client?

Offline

 

#9 2011-04-05 13:08:27

Petter
Member
2011-04-03
30

Re: Error after upgrade to 2.2 - HELP!

Ok, i will try that.
Thanks for all help, so far. :o)

Best regards
Petter

Offline

 

#10 2011-04-05 22:16:26

Petter
Member
2011-04-03
30

Re: Error after upgrade to 2.2 - HELP!

Hi, i have now transferred the files, and things are going little better. :-)
I can now login to the admin panel, and pictures and albums are visible.

But, i got this big error message on top of every page:

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

SELECT
    c.*,
    user_representative_picture_id,
    nb_images,
    date_last,
    max_date_last,
    count_images,
    count_categories
  FROM piwigo_categories c
    INNER JOIN piwigo_user_cache_categories ucc ON id = cat_id AND user_id = 1
  WHERE id_uppercat = 1
   
  ORDER BY rank
; in /customers/bortne-mathisen.com/bortne-mathisen.com/httpd.www/galleri/include/dblayer/functions_mysql.inc.php on line 654

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /customers/bortne-mathisen.com/bortne-mathisen.com/httpd.www/galleri/include/dblayer/functions_mysql.inc.php on line 153 Warning: Cannot modify header information - headers already sent by (output started at /customers/bortne-mathisen.com/bortne-mathisen.com/httpd.www/galleri/include/dblayer/functions_mysql.inc.php:653) in /customers/bortne-mathisen.com/bortne-mathisen.com/httpd.www/galleri/include/page_header.php on line 98

How can i fix that?
PS: I have deactivated all of the plugins, so that they don’t make any trouble.

Best regards
Petter

Offline

 

#11 2011-04-05 22:31:20

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

Re: Error after upgrade to 2.2 - HELP!


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

 

#12 2011-04-06 08:58:13

Petter
Member
2011-04-03
30

Re: Error after upgrade to 2.2 - HELP!

Thousand million thanks for all the support, now it works 100%.
Let's hope the next upgrade is easier. :-)

Best regards
Petter

Offline

 

Board footer

Powered by FluxBB

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