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
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
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
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
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
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
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
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
Ok, i will try that.
Thanks for all help, so far. :o)
Best regards
Petter
Offline
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
clic on
http://www.bortne-mathisen.com/galleri/upgrade.php
the update isn't finish
Offline
Thousand million thanks for all the support, now it works 100%.
Let's hope the next upgrade is easier. :-)
Best regards
Petter
Offline